Discussions

Expand all | Collapse all

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

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

    Posted 11-21-2017 16:22
    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.


  • 2.  RE: How to add to my url formula button that changes a checkbox to ""true"" but also saves the record?

    Posted 11-21-2017 16:31
    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.


  • 3.  RE: How to add to my url formula button that changes a checkbox to ""true"" but also saves the record?

    Posted 11-21-2017 16:38
    Well, what do you know...that worked! And I didn't think it would because it's not actually saving a parent record - it's all within one table record form.  Thanks!!!!