If statement to show a message based on another text value

[PhilGlew]

Hi there, 

I know this is probably straightforward, but, I need a formula to show one message IF the value of another text field shows one location or another.

Example - I have a text box showing "Worthing" as the user's usual office location. I want my next text label to say "You're good to go" IF this equals Worthing, but to display "Are you sure this is where you want to book a desk?" along with Yes or No buttons, ONLY if the first text box displays a location/value other than Worthing.

Many thanks

Phil

[Irfan]

Hi @PhilGlew ,

Label Text:

If(Len(TextInput2.Text)>0,
If(Upper(TextInput2.Text)="WORTHING","You are good to go","Are you sure this is where you want to book a desk?")
)

It first checks that textbox is not empty, it then converts the characters into upper for the values entered in the checkbox and finally displays the message based on the text. Changing the case to upper makes sure that user can enter his data in any case - it will still be checked in the formula.

Toggle Visible

If(Len(TextInput2.Text)>0,
If(Upper(TextInput2.Text)="WORTHING",true,false
),false
)

It first checks thta textbox is not empty, it then converts the characters into upper for the values entred in the checkbox and shows the toogle based on the text in the text box

-Irfan