How to add to my url formula button that changes a checkbox to "true" but also saves the record?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have created a formula url button for the user to be able to "Submit this Week's Priorities:"

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]

                & "&_fid_32=1"

& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])

This works perfectly in the form whether or not it is in Edit mode where the button triggers the change to a checkbox field and then a notification is triggered. It also redirects to that current record which I want. However, if it is in Edit mode and there is a modification to one of the fields, you have to use the native "Save" button first before the action will occur (still works fine). I'm just wondering what I could add to this formula to trigger the record to also save any other edits without having to use the native "Save" button.
Photo of Dawn Rene

Dawn Rene

  • 526 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Brian Cafferelli

Brian Cafferelli, Quick Base Technical Marketing Manager

  • 1,698 Points 1k badge 2x thumb
Official Response
Hi Dawn, yes you can do this by going to the table's settings, clicking Advanced settings, and then checking the box marked Save parent record automatically when a child record is created.

With this box checked, when clicking any link or button on the edit record page, Quick Base will automatically save your changes.