Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

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

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...
App builders
Formulas and functions
BrianCafferelli's avatar
BrianCafferelli
Quickbase Staff
8 years ago
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.
RayseRamsey's avatar
RayseRamsey
Qrew Member
5 years ago
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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you post your current code?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Wallace__DHS_Ye's avatar
      Wallace__DHS_Ye
      Qrew Trainee
      5 years 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)
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years 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
        ------------------------------