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
------------------------------
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
------------------------------
