I would like to have a drop down to choose from. One a predefined text and the other to be entered in the format “xx-xxx-xxxx”. Is this possible?
Would you please open your case more deeply, thanks.
I currently have a form that sends data to google sheets. For a particular field however, I would like to give the user two options. Option one would be to enter say, 121231234, and have it auto format as 12-123-1234, while the second option would be to choose the word UNKNOWN. Is this possible?
Auto-formatting is not possible directly. The best you could do is capture the user’s input in one column, then format it in another.
You can do that with an Event action. First check that user is entering 9 digits, no space etc. with the Valid_If. Then create an Event action where you format the string as you wish. If you now trigger that Even action when saving the record, it will convert the format.