Forum Discussion
_anomDiebolt_
12 years agoQrew Elite
If you have an rdr parameter in your formula you are doing it wrong. Using an rdr parameter is an outdated mechanism to string together two GET requests in sequence and it has considerable shortcomings. Always use script.
The following record has a formula definition that will cause a user defined page of JavaScript to be loaded and executed. Put all of your logic and AJAX calls in the script.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=241
Pass as few variables as possible (eg QBU_rid) to the script using the formula language. You are better off recalculating or making an AJAX request to get the inputs your script needs to complete that required action rather than make your formulas more unreadable by passing variables (such as QBU_rid). I tested this script and it does exactly what you request.
The following record has a formula definition that will cause a user defined page of JavaScript to be loaded and executed. Put all of your logic and AJAX calls in the script.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=241
Pass as few variables as possible (eg QBU_rid) to the script using the formula language. You are better off recalculating or making an AJAX request to get the inputs your script needs to complete that required action rather than make your formulas more unreadable by passing variables (such as QBU_rid). I tested this script and it does exactly what you request.
- CarlosCarlos8 years agoQrew Assistant CaptainDan, does this require IOL? I can't seem to get the button (in a formula Text or Formula URL Field) or the API to work
- CarlosCarlos8 years agoQrew Assistant CaptainNevermind. Got it to work!
- EOMDevelepors7 years agoQrew CaptainHow can I implement this to edit a record id of a different table in my app?
Thanks - EOMDevelepors7 years agoQrew CaptainI mean a record of a different table in my app? (the record id will be [maximum record id#])
Thanks