Based on Video:
To delay the output set the inputbox “DelayOutput property to true”
Formulas:
Get the value of a number
If(
Value(input1.Text) >= 100 And Value(input1.Text) < 200,
“yes”,
“no”
)
If((1=1 Or 2=2) And 3=3, “yes”, “no”)
Check the Number of Characters entered
Len(input1.Text)
If(Len(input1.Text)> 3 , “yes”, “no”)
If(IsMatch(inputBox.Text, Email), “yes”, “no”)
IsMatch(textInput.Text, User().Email, MatchOptions.Complete & MatchOptions.IgnoreCase) //MatchOptions.Complete = exact match
If(Lower(User().Email) = Lower(textInput.Text), “yes”, “No”)
PhoneNumber Match:
(334) 567-6666
If(IsMatch(inputBox.Text,LeftParen & Digit & Digit & Digit & RightParen & Space & Digit & Digit & Digit &Hyphen&Digit&Digit&Digit&Digit),”yes”,”no”)
(334) 567-6666 Or (334)567-6666 with no space
If(
IsMatch(
inputBox.Text,
LeftParen & Digit & Digit & Digit & RightParen & Space & Digit & Digit & Digit & Hyphen & Digit & Digit & Digit & Digit
) Or IsMatch(
inputBox.Text,
LeftParen & Digit & Digit & Digit & RightParen & Digit & Digit & Digit & Hyphen & Digit & Digit & Digit & Digit
),
“yes”,
“no”
)
If(IsMatch(textInput.Text, “Abc”, Contains & IgnoreCase), “yes”, “No”)
Hide a button if text box and dropdown is blank
If(IsBlank(textInput.Text) Or IsBlank(Dropdown1.Selected.Value), Disabled, Edit)
Disable a button if dropdown is Other and text box is empty
- Reset the text box each time user reselect the dropdown: onSelect = Reset(textInput)
- hide the text input , Visible property = Dropdown1.Selected.Value = “Other” // no ifs, it returns true or false
- set the button DisplayMode=
If(
IsBlank(Dropdown1.Selected.Value )
Or (textInput.Visible And IsBlank(textInput.Text)),
Disabled,
Edit
)
To type an emoji
in the text box press the window key and a dot
Dates:
“is the date older than 18 years? ” & If(
DatePicker1.SelectedDate < DateAdd(Today(), -18, Years),
“yes”,
“no”
)
“Is the date within the next 30 days? ” &
If(
DatePicker1.SelectedDate >= Today()
And
DatePicker1.SelectedDate < DateAdd(Today(),30,Days),
“yes”,
“no”
)
“Did they choose a weekday? ” &
If(
Weekday(DatePicker1.SelectedDate, Monday) < 6,
“yes”,
“no”
)