Forum Discussion

NirajShah's avatar
NirajShah
Qrew Cadet
7 years ago

Rich Text Formula Field for Approve / Reject button and redirection

I'm trying to setup a rich text formula field that will allow the user to "approve" or "reject" a case. When the user chooses "approve", I'd like the button to add values to three fields on the curren...
APIs and custom code
Formulas and functions
Quickbase Automations
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
I suggest that you walk before you try to run.

Make a URL formula field called Approve, not a rich test formula field.


var text approve =  URLRoot() & "db/" & [_DBID_] & "?a=API_EditRecord&apptoken=XXXXXX&rid=" & URLEncode ([Record ID#])

& "&_fid_xx=" & URLEncode("Approved")

& "&_fid_xx=" & URLEncode(Now())

& "&_fid_xx=" & URLEncode(User())


var text EditOtherRecord = 

URLRoot() & "db/xxxxx?a= API_EditRecord&apptoken=xxxxxxrid=" & URLEncode ([Related Store Item])

& "&_fid_xx=" & URLEncode([# of Features Requested]);


var text DisplaySomeRecord = 

URLRoot() & "db/xxxxx?a=dr&rid=" & [Record ID#]);

$approve URLONE 
& "&rdr=" & URLEncode($EditOtherRecord URLTWO)
& URLEncode("&rdr=" & URLEncode($DisplaySomeRecord URLTHREE))
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
me again

i meant to say

$approve 
& "&rdr=" & URLEncode($EditOtherRecord)
& URLEncode("&rdr=" & URLEncode($DisplaySomeRecord))