Refresh the record before edit through formula URL

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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

Thank you,

Gaurav
Photo of Gaurav Sharma, Certified Builder and Expert

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
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.
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.