Forum Discussion

JessicaStevens's avatar
JessicaStevens
Qrew Member
3 years ago

Approval Button/ Process

Hello, 

I have tried to find the answer for this but seem to come up short as I can't find a solution to exactly what i am trying to do. 

Here is the breakdown of what i am trying to accomplish:
- I have a CRM with different tables. 
- I want to show profiles from table A on table B when a status is changed to a certain option (I set up an import for this but don't know if that is the best solution)
- The purpose of table B is for someone to be able to approve or decline the profile so I'd like to just have easy buttons for the approver to press. 
- When the approver presses approve or decline the status changes respectively on both tables


Here is this formula I have for the approve/decline buttons but I can't seem to get it to work correctly:

var text bgcolor = "#34A853";
var text txtcolor = "white";
var text style = "style=\"text-decoration: none; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 20px; color: " & $txtcolor & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";
var text url =

URLRoot() & "db/" & [Record ID#]& "?a=API_editRecord" &
"&_fid_22=" & [Status] &
"&apptoken=*myapptoken*" &
"&_fid_22=Appointment Approved" & "&_fid_22=" & [Status]& "&rdr="&URLEncode("Url to table B");

"<a " & $style & " href=\"" & $url & "\">Approve</a>"

Here is a screenshot of what that looks like





------------------------------
Jessica Stevens
------------------------------

1 Reply

  • try this
    URLRoot() & "db/" & dbid() & "?a=API_editRecord&rid=" & [Record ID] &

    "&apptoken=*myapptoken*" &
    "&_fid_22=" & URLEncode("Appointment Approved")
    & "&rdr="&URLEncode("Url to table B");



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------