Discussions

  • 1.  Approval Button/ Process

    Posted 24 days ago
    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
    ------------------------------


  • 2.  RE: Approval Button/ Process

    Posted 24 days ago

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