Forum Discussion
Zaya__OSSE-Cont
7 years agoQrew Trainee
Sorry to resurrect an old post but this is the closest post I've found that's similar to the problem I'm struggling with.
I have a text field that's supposed to have all numbers except for dashes. I need to do IsNumeric type of validation. While Mark's formula is working great, my field can start with 0 so I can't use it. And changing the field to numeric is not an option at this point due to other dependencies. I've tried many different approaches with no luck. Any help would be greatly appreciated.
I have a text field that's supposed to have all numbers except for dashes. I need to do IsNumeric type of validation. While Mark's formula is working great, my field can start with 0 so I can't use it. And changing the field to numeric is not an option at this point due to other dependencies. I've tried many different approaches with no luck. Any help would be greatly appreciated.
AustinK
7 years agoQrew Commander
When I needed to verify something was a number(mine had 2 dashes between the numbers) I made a formula checkbox that would trigger if it was not a good number. I removed the dashes with a Part formula and then put all 3 parts back together in a variable. Then I tested to see if the number was above or below a certain number. My number was similar to a phone number so I checked if it was more than 0000000000 and less than 9999999999. If it returned true then it was a number. If it returned false it was not and I could abort the save.
The main issue with this approach is that for form rules to take effect the person needs to enter the data in the field and then click outside of the field to another one. If they do not do this then the form rule fails and the save happens.
I came to the conclusion that the best way to do this is with JavaScript. You can actually validate data with that and prevent people from entering the wrong thing. It's a nightmare doing it native in QuickBase imo.
The main issue with this approach is that for form rules to take effect the person needs to enter the data in the field and then click outside of the field to another one. If they do not do this then the form rule fails and the save happens.
I came to the conclusion that the best way to do this is with JavaScript. You can actually validate data with that and prevent people from entering the wrong thing. It's a nightmare doing it native in QuickBase imo.