Discussions

Expand all | Collapse all

Refresh the record before edit through formula URL

  • 1.  Refresh the record before edit through formula URL

    Posted 06-07-2017 14:03
    Hi Team,

    I have a formula URL field and want to refresh the page first then, do actual work and I have around 3-4 nested URL in this.

    I have also tried the Xavier answer from the below link but no luck for me.

    https://community.quickbase.com/quickbase/topics/url-formula-to-edit-a-record-and-refresh-the-page">https://community.quickbase.com/quickbase/topics/url-formula-to-edit-a-record-and-refresh-the-page">https://community.quickbase.com/quickbase/topics/url-formula-to-edit-a-record-and-refresh-the-page

    Thank you,

    Gaurav


  • 2.  RE: Refresh the record before edit through formula URL

    Posted 06-08-2017 05:16
    the refresh is your end point, the api_edit is a step.  You can't go to the end, and then step back.  It will either need to be two clicks.

    A long round-a-bout way would be to have the first click do half the approval, then refresh, then if it meets the other criteria, have a webhook do the rest of the edit.


  • 3.  RE: Refresh the record before edit through formula URL

    Posted 06-08-2017 05:25
    It will make sense for me.

    I have two parts one just approves the record and second part is actual do the calculation.

    So, you mean if we click the first time then, it will only do approve then, we need to create a webhook that will do the second part on based on the criteria.