Forum Discussion
JackWoods
Qrew Trainee
Got you - I forgot about the table rules
I wrote the quick formula below - how do I make the formula rule not do anything if true? Or do I need to format this in another way? Thank you.
If(Contains([Salesforce Project Link], "Salesforce"),"N/A", "Please Use a True Salesforce Project Link")
------------------------------
Jack Woods
------------------------------
I wrote the quick formula below - how do I make the formula rule not do anything if true? Or do I need to format this in another way? Thank you.
If(Contains([Salesforce Project Link], "Salesforce"),"N/A", "Please Use a True Salesforce Project Link")
------------------------------
Jack Woods
------------------------------
MarkShnier__You
4 years agoQrew Legend
Custom Data Rules will block the save if the message results in anything besides null. So you cannot have the result be "N/A" as that will block the save.
So this is what you want.
If(not Contains([Salesforce Project Link], "Salesforce"), "Please Use a True Salesforce Project Link")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So this is what you want.
If(not Contains([Salesforce Project Link], "Salesforce"), "Please Use a True Salesforce Project Link")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JackWoods4 years agoQrew Traineethank you - I was trying "Does Not Contain" and "NoContain"
this one worked
------------------------------
Jack Woods
------------------------------
Related Content
- 9 months ago