Hi, everybdy. How to make a validation rule to ensure that a column can only be filled with text? If it's filled with numbers or other punctuation marks, it will be invalid.
Thank you.
Need your help Masters @Suvrutt_Gurjar @Kirk_Masden @Steve @MultiTech
Solved! Go to Solution.
Please take a look at the shared solution and modify it suitably.
Solved: Remove Special Characters - Google Cloud Community
What you are looking for may not be very easily possible in AppSheet.
However, for properly spelling out the requirement, you may want to elaborate what you mean by punctuation marks- what is acceptable and what not.
For example, is it purely alphabetical or will some special characters such as "_" or "-" will do?
Edit: Anyway, please take a look at the following solution and suitably modify it.
Solved: Remove Special Characters - Google Cloud Community
"I'm sorry, let me clarify. I mean the column can only be filled with alphabets. So if numbers is entered, a message will appear saying, 'The data you're inputting is invalid.'"
Please take a look at the shared solution and modify it suitably.
Solved: Remove Special Characters - Google Cloud Community
I've tried and modified but not working anyway
But I tried using Contains function, it work properly 😁 thanks for the sharing @Suvrutt_Gurjar
Great.
Could you share your expression that worked for you? The sharing will help any future readers of the post thread.
User | Count |
---|---|
35 | |
11 | |
3 | |
3 | |
2 |