I would like to have a drop down to choose fr...

(Sangkel Gollab) #1

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?

(Aleksi Alkio) #2

Would you please open your case more deeply, thanks.

(Sangkel Gollab) #3

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?

(Steven Coile) #4

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.

(Aleksi Alkio) #5

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.