"Required If" Form Fields

Suggestion: To add the ability to only make a field required based on a formula. For example, the form only requires the “Phone number” field if the “Contact to me using:” select list is set to “Phone”.

Why? Some tables require the data to be accurate and valid. Whether it’s external users that need to submit data or internal doc users. The external case I think is clear. The internal doc user case is when I’ll have users enter new rows into forms instead of directly into tables. This way there’s some level of validation. But virtually on everyone of these forms there are fields that are required in some case and not in others. It all depends on other field values. Would be amazing to have that capability.

Thanks for listening!

1 Like

yes and it would be amazing to hide those fields that the user doesn’t need to fill in until they trigger it with a required if

2 Likes

That will be amazing!

That would be great! There is already a workaround: Write a validation formula for a formula field that if Phone is selected in the Contact_Via field, the phone format is required and if Email is selected, the email format is required.

If(
thisRow.Contact_Via = “Phone”,
RegexMatch(CurrentValue, “^(?\d{3})?[-.\s]?\d{3}[-.\s]?\d{4}$”),
RegexMatch(CurrentValue, “[1]+@[\w.-]+.\w+$”)
)


  1. \w.- ↩︎