Forum Discussion
ChrisNewsome
Qrew Captain
The http:// did work. It's already killed 27 in the last hour. thanks as always!
Any ideas how I could prevent it at all? I think my automation might end up running hundreds of times this week. I would love to make a form rule or something but that didn't work either.
------------------------------
Thanks,
Chris Newsome
------------------------------
Any ideas how I could prevent it at all? I think my automation might end up running hundreds of times this week. I would love to make a form rule or something but that didn't work either.
------------------------------
Thanks,
Chris Newsome
------------------------------
RyanStanford1
4 years agoQrew Captain
You should be able to add some data validation either to the form or to the table itself. Make sure the fields have valid data, ei: Name doesn't contain "http://" and whatever other criteria you're looking for. Is the form/webpage your own, or is it a code page within QB?
------------------------------
Ryan Stanford
------------------------------
------------------------------
Ryan Stanford
------------------------------
- ChrisNewsome4 years agoQrew CaptainIt basically fills in the "new customer" form in our app. Under form rules, I can't use "contain", it's either <,>, or =. Is there another place/method I could do this? Can I restrict the name from having that code?
------------------------------
Thanks,
Chris Newsome
------------------------------- RyanStanford14 years agoQrew CaptainYes, if you go to the advanced settings of the table in QB... I'd imagine you have it named "Customers" or something to that effect. There's a section towards the bottom regarding Custom Data Rules.
https://help.quickbase.com/user-assistance/custom_data_rules.html is the QB Documentation regarding it.
I'm not sure if it'll work via API, or if it's strictly from a native QB form, but it's worth a shot.
------------------------------
Ryan Stanford
------------------------------- MarkShnier__You4 years agoQrew ChampionCustom Data Rules operate at the database level. So API's will need to comply or they will error out and fail. This would be what you want.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------