Skip to main content
Question

Editing an approval flow to reset the approval list

  • April 5, 2018
  • 0 replies
  • 47 views
Still a QB amateur here. I have a table of records which goes through a certain approval process. Once it is saved, there is a status column which flags it as 'Active'. There will be some users who will be editing the record using a URL formula button. Once the button is clicked and the record is in edit mode, I want all the exisiting approvals to be cancelled and force to restart the process again. Thank you for your help.
    This topic has been closed for replies.

    • MCFNeil
    • Quickbase Alumni
    • April 5, 2018
    You can explore using 'dynamic form rules' to clear the existing data.
    Or, you can look at having the data cleared with a button push.

    I'm curious why you would want to clear the data anyway...
    • ManojKumar
    • Author
    • Quickbase Alumni
    • April 5, 2018

    Thanks, Matthew. I want to keep the data but clear the approval list. The record will be a set standard and I would want it to go to approvals again every time there is a change being made.

    • ManojKumar
    • Author
    • Quickbase Alumni
    • April 5, 2018
    I used this formula - URLRoot() & "db/" & Dbid() & "?a=GenCopyRecord&rid=" & ToText([Record ID#])  to create a new record. I would like to change the value of a particular field automatically using the Formula URL id. Any suggestions for that?
    • MCFNeil
    • Quickbase Alumni
    • April 8, 2018
    If you want to clear the contents of a field, you will need to know the field ID and insert a 'null' value.

    You can do this with a "API_EditRecord" formula url.  

    An example is:

    Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=xxxxxxxxx&_fid_157=0&_fid_153=OFF
    Terms & ConditionsAccessibility statement