Javascript Prompt + Edit record for Decline button

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.

Thank you Dan,

Going forward i will put the logic into Javascript and use AJAX calls in the script.

I have the same situation, would either of you help me out please?

Hey Akmal,

What are you stuck on?

If([On-Hold]<>true,URLRoot()&"db/"&Dbid()&"?a=API_EditRecord&rid="&[Task ID]&"&apptoken=be4************zk5nh"&"&_fid_179="&URLEncode(true)& "&rdr="&URLEncode("https://milehighgraphics.quickbase.com/db/bji*****3"),"javascript:alert('THIS TASK HAS ALREADY BEEN STARTED')")

//This is my url code to edit record but I need to include the prompt//

Thank you for taking the time to help me.

I know this is old but, is it possible to have it return to where ever it was press and not on the changed record?