Forum Discussion

RyanWall's avatar
RyanWall
Qrew Member
6 years ago

A formula URL Button to check a box and Update a Date Field

Hi, I am creating an application to track the progress of a customers onboarding. At the bottom of my form I have a button to check a box and mark the customer as successful or unsuccessfully onboa...
App builders
Formulas and functions
KevinSlider's avatar
KevinSlider
Qrew Trainee
Hello Ryan, 
Because you are using an api call to check the box, it will not trigger the condition for the form rule that is set to "when the condition becomes true". I am not recommending that you uncheck that setting. Lets modify the button. Replace ### with the field ID of the Date field.  This should set the date of Today in the date field. 

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&apptoken=65m6uecaabu4w5qz7dbnim3jy" &
    "&_fid_72=1" &
    "&_fid_###=" & Today() &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=er&rid=" & [Record ID#]),

Let me know if this helps.

RyanWall's avatar
RyanWall
Qrew Member
6 years ago
Hey,

This has worked perfectly - just what I needed!
Thanks for your help!