Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
The other syntax is this to execute sequential URL calls
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
You define the formula variables and need to end with one that displays a record or a report.
But Chayce, yours could probably be made more generic for the situation where you want to refresh whatever page you are on. That way it would be more flexible to be used on a record or a report or an embedded child table on a form and be superior to mine for that situation. Is there a change to yours possible which would do that?
$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))
You define the formula variables and need to end with one that displays a record or a report.
But Chayce, yours could probably be made more generic for the situation where you want to refresh whatever page you are on. That way it would be more flexible to be used on a record or a report or an embedded child table on a form and be superior to mine for that situation. Is there a change to yours possible which would do that?
- ChayceDuncan27 years agoQrew CadetCoach - your point is actually the reason I've converted most of my buttons to work like that, to cover that exact scenario of reloading the page rather than having to define the redirect all the time. The simple change is to swap out window.location.replace with location.reload() - so the updated formula from my example above would be:
"javascript: {" &
"$.get('" & $DeliveryDateInOS & "');" &
"$.get('" & $PickUpDateInOS & "');" &
"$.get('" & $ProcessRec & "');" &
"location.reload();" &
"}"
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base - QuickBaseCoachD7 years agoQrew CaptainThx for posting that. The other advantage of the javascript method is that if you get really deep with nesting the URL gets exponentially longer due to the nested URLEncodes and eventually it gets over 2,000 characters and some Browsers like IE have limits on URL length.
- ChayceDuncan27 years agoQrew CadetAgreed. The other potential avenue too in situations like this, javascript enables you to interpret the responses - so if you were doing several add records instead of edits - you can add in some $.get(...).then(function(res){...}) in one or all of your requests and you could log out or play around with the new records that are created.
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base