Forum Discussion

Wallace__DHS_Ye's avatar
Wallace__DHS_Ye
Qrew Trainee
6 years ago

How to add to my url formula button that changes a checkbox to ""true"

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: I am in the Jobs table (_DBID_JOBS) when I ...
APIs and custom code
Buttons
Formulas and functions
WallaceYeboah's avatar
WallaceYeboah
Qrew Member
6 years ago
Thanks for the response Ivan. The formula still seems to not be working

Here is the updated formula:

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

I get this error when I test

<qdbapi>
<action>API_EditRecord</action>
<errcode>102</errcode>
<errtext>
Invalid request - we cannot understand the URL you specified.
</errtext>
</qdbapi>


------------------------------
Wallace Yeboah
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
The first line of the formula is missing telling the AP:I which record to edit.  Perhaps you want this

URLRoot() & "db/" & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] 
& "&_fid_1146=1"
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&rid=" & [Maximum Related Job])


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------