Conditional formula-URL fields
I have a long string of code in a formula-URL field that results in a URL that is too long for the browser to execute (I verified this). So I want to break the code up into two fields, where part of t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe only way you can trigger a subsequent action from Quick Base is by using an Automation.
A formula URL cannot be triggered by changes to records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
A formula URL cannot be triggered by changes to records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark,
I meant to ask one more question. I can use an automation as you suggested below, but once processing is complete, I’d like to refresh the report or home page the user was looking at. I didn’t see any actions in an automation that does that. Can a pipeline call the home page, run a code page, or run a report, and be triggered when the automation finishes processing?
Thank you,
Paul
I meant to ask one more question. I can use an automation as you suggested below, but once processing is complete, I’d like to refresh the report or home page the user was looking at. I didn’t see any actions in an automation that does that. Can a pipeline call the home page, run a code page, or run a report, and be triggered when the automation finishes processing?
Thank you,
Paul
- MarkShnier__YouYep, we know how to go crazy on New Years Eve. It's ok, I'm three beers in and it's still 3 hours to the ball drop.
In a word. No. That would take an actual JavaScript Code Page.There is syntax we use however to execute a single URL and then delay the refresh for X seconds. You chose X long enough to allow the Automation time to complete. Typically that's a second or two.
Here is the syntax for a 2000 millisecond delay. (2 seconds)
var text URL = ... a singe API goes here.
// slow refresh
"javascript:" &
"$.get('" &
$URL &
"',setTimeout(function(){" &
"location.reload(true);" &
"},2000));"
& "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you, will try it. Like everyone else stuck at home sheltering in place instead of going to parties. Sigh...But happy new year!Paul
- Mark,
Can the slow refresh code be easily changed for a compound URL instead of a single URL? If so, how would that work?
Happy New Year!
Paul- MarkShnier__YouNo, that syntax only works with a single URL with no redirects. What are the URLs doing that you need executed and do they need to be executed in sequence?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------