Conditional logic in forms

[Stefan_Huber]

Morning Shaheed!

Maybe this helps you in the meantime - it’s possible to implement some conditional logic with forumulas.

"Required If" Form Fields

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+$”) ) \w.- ︎

You can actually implement this functionality right now by adding a validation formula directly to the field. In Coda, you write a formula like: IF(condition, true, false)

This means that the field only accepts a value if the condition returns true. For example, you can check that if a status equals “Exit”, then the associated date field can’t be empty or not in the future - even if the date field isn’t marked as “necessary”.