I am new to AppSheet and not a programmer. Our company deploys nurses and PCAs to work in homes of clients who need personalized home care.
I have used a Google Form to get daily updates on the status of the employees but because their input is often inconsistent (name, phone #) it creates problems when we try to evaluate the responses to the daily schedule.
I used AppSheet to generate an App but it does not honor the regular expression that restricts the phone numbers to 10 numeric digits.
How can I get around this?