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 05-20-2020 19:36
    Hi, I am trying to add to my URL formula button that currently performs a print action. What I need is to have the print button activate a checkbox which states that the "print" action has been completed. I am fairly new to QB, so if you can please explain in detail. 

    Thank you for the help!

    ------------------------------
    Rayse Ramsey
    ------------------------------



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

    Posted 05-20-2020 19:44
    Can you post your current code?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



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

    Posted 20 days ago
    I am trying to create a url button that will take a user to the related form and check off a checkbox. My current formula is not working for some reason:

    URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job] & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Maximum Related Job] &"apptoken=b5migf_nhwb_uwejxvbfjbg42bcg4aecdf5rk4b"
    &"&_fid_1146=1"

    ------------------------------
    Wallace (DHS)
    ------------------------------



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

    Posted 20 days ago
    Please post this as a new question and explain what table you are on when you click the button, what table has the checkbox,  and where you want to land the user after you click the button.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  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!!!!