Good day, I am creating an app that will allow the user to type in information of tenants that live an estate. I need to add some constraints on the fields like “Name” needs to be all CAPS and “Surname” is the same thing, then on fields like ID number and Cell number I need to limit the amount of numbers to “X” value and it needs to be more than “Y” value to be a valid field.
Is this possible to do? I have tried using the “UPPER” expression but that seems to only convert data to CAPS that was already in the Sheet that was not CAPS.
LinkedIn
Twitter
