You’re offline. This is a read only version of the page.
The formula is:
If (IsBlank (Ddl_Gem) Or (IsBlank (Ddl_1) Or IsBlank (Txt_S1)), false, true, Navigate (Scr_InsertUpdate, Fade));
Notification ("Fill in the field", NotificationType.Error);
ResetForm (Form4)
But if the fields are filled in, the error is still displayed.
Please I need your help
hi randy,
I solved the problem i choose this way:
If (IsBlank (Ddl_Gem) , Notify("Field required", NotificationType.Error);
If (IsBlank (Ddl_1), Notify("Field required", NotificationType.Error);
Navigate (Scr_InsertUpdate, Fade));
I used this formula for each fields and i solved the issue.
tnx
@Anonymous
So then if it is not navigating to Scr_InsertUpdate then one of the three conditions is blank.
Can you provide some screenshots or formulas, or screenshots of formulas or something to show what is going on?
yes
@Anonymous
This would indicate that the criteria in the formula is only being met for the error condition.
The formula, as written, will perform a Notify if ANY of the three controls is blank. Is that the condition you are looking for?
Hi Randy,
I have tried with your formula but can't get to screen 2
@Anonymous
Whose formula are you referring to? Mine or eka24's?
With your formula the button not navigate to screen 2 evenif the fields are filled
@Anonymous
You are referencing the control in your IsBlank's. You need to reference the Property of that control to determine if it is blank. The control will never be blank, but its properties can.
So, I will assume that the first 2 controls are dropdowns (with Value columns) and the last is a TextInput control. In this case, and your formula would be:
Share
Report
All responses (
Answers (
If(
IsBlank(Ddl_Gem.Selected.Value) || IsBlank(Ddl_1.Selected.Value) || IsBlank(Txt_S1.Text),
Notify("Fill in the field", NotificationType.Error),
Navigate(Scr_InsertUpdate, Fade)
);
ResetForm(Form4)
I hope this is helpful for you.
The formula has been updated;
If(IsBlank (Ddl_Gem) Or (IsBlank (Ddl_1) Or IsBlank (Txt_S1),
Notification ("Fill in the field", NotificationType.Error),
Navigate (Scr_InsertUpdate, Fade));
ResetForm (Form4)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
HI Eka,
the formula is in the on select property on the next button on screen 1
When the fields of screen 1 are all filled in and I press the button, the error continues to be displayed.
it allows me to navigate but brings the error message to screen 2.
tnx
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
