Predetermined mask for fields?

[ThinhDinh]

I assume you want to display it like that in your app as well and not just for the Sheet, so my proposal is as below:

• Build a custom form:

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…

• Have a number entry to force the users to enter 13 digits. I think you can calculate a string’s length using Glide’s calculated column, so only when they do enter 13 digits will you allow them to submit.

• Have 4 columns to slice the input into 4 parts, then finally add a template column to add those 4 parts plus the 3 spaces in (XXX XX XX XX).