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)
        ------------------------------