Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoYou should not be editing the same record twice or you will not be able to refresh to the page as easily,
So calculate the URL like
var text URLAPPROVECOMPLETE = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed"
"&_fid_274=1";
var text URLAPPROVECOMPLETEISSUES = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed With Issues"
"&_fid_274=1";
var text URL =If(
[Has Service] and [Is Verified] and [NoIssues],$URLAPPROVECOMPLETE,
[Has Service] and [Is Verified] and not [NoIssues], $URLAPPROVECOMPLETEISSUES)
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload();" &
"});" & "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So calculate the URL like
var text URLAPPROVECOMPLETE = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed"
"&_fid_274=1";
var text URLAPPROVECOMPLETEISSUES = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
"&rid=" & [Record ID#] &
"&_fid_18=Completed With Issues"
"&_fid_274=1";
var text URL =If(
[Has Service] and [Is Verified] and [NoIssues],$URLAPPROVECOMPLETE,
[Has Service] and [Is Verified] and not [NoIssues], $URLAPPROVECOMPLETEISSUES)
"javascript:" & "$.get('" & $url & "', function(){" & "location.reload();" &
"});" & "void(0);"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
also if it is not appearing as a button , then check the checkbox to show as button.
Display as a button on forms and reports
and select a colour
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - PaulPeterson16 years agoQrew Assistant Captain
Thank you!
I'll create a test field since the project owner changed direction on the field but I do want to test the button.
I appreciate your help!
Regarding the button appearance, the display as button was checked.
------------------------------
Paul Peterson
------------------------------- PaulPeterson16 years agoQrew Assistant Captainohhh, didn't see the on form and reports. I'll double check
------------------------------
Paul Peterson
------------------------------