Limit URL field to specific Sites? Possible?
Hey Community, We are using Quickbase to to manage larger customer projects in our true CRM, which is Salesforce. I created a hyperlink field in Quickbase so our users and quickly jump from Program...
Forum Discussion
Hi Jack:
A couple of things come to mind.
1. In each table you can add "Custom Data Rule" (from the table click "Settings" and then "Advanced settings") that when a field is updated and it either contains other urls or does not contain a salesforce URL that it will prevent the manual editing of the form.
2. Another option if you are running a pipeline or some other API process is to set up a pipeline and should anyone add something that doesn't contain salesforce, have the pipeline edit that field and remove the link.
We cover things like this in our daily, open Q&A webinars, "Office Hours" held M-F at 1pm Eastern. https://quickbase.com/webinars/
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
A couple of things come to mind.
1. In each table you can add "Custom Data Rule" (from the table click "Settings" and then "Advanced settings") that when a field is updated and it either contains other urls or does not contain a salesforce URL that it will prevent the manual editing of the form.
2. Another option if you are running a pipeline or some other API process is to set up a pipeline and should anyone add something that doesn't contain salesforce, have the pipeline edit that field and remove the link.
We cover things like this in our daily, open Q&A webinars, "Office Hours" held M-F at 1pm Eastern. https://quickbase.com/webinars/
------------------------------
Kirk Trachy , Senior Solutions Consultant
QuickBase | 603-674-5454 M | ktrachy@quickbase.com
------------------------------
- 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
------------------------------- 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
------------------------------- thank you - I was trying "Does Not Contain" and "NoContain"
this one worked
------------------------------
Jack Woods
------------------------------
