Data validation best practices

[Robert_Petitto]

Best you can do at this point is to create what we like to call “custom forms”

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

You can then use “match regex” columns on any of those user specific “form” fields to validate data. The result of those regex columns can serve as conditions as to whether the user can see a button to submit the form.