Forum Discussion

Wallace__DHS_Ye's avatar
Wallace__DHS_Ye
Qrew Trainee
5 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
5 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
5 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
mark.shnier@gmail.com
------------------------------
  • WallaceYeboah's avatar
    WallaceYeboah
    Qrew Member
    5 years ago
    Thanks Mark. I just tried that formula, still no luck. I keep receiving the same error message when I test

    ------------------------------
    Wallace Yeboah
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      too many "db/"  ...

      URLRoot() & "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
      mark.shnier@gmail.com
      ------------------------------
      • WallaceYeboah's avatar
        WallaceYeboah
        Qrew Member
        5 years ago
        Great catch Mark! However, I am now being faced with this new error:

        <action>API_EditRecord</action>
        <errcode>24</errcode>
        <errtext>Invalid Application Token</errtext>
        <errdetail>An Application Token must be supplied.</errdetail>
        </qdbapi>

        I'm guessing I need to provide a token of some kind, however I am unsure where to place that in the formula.


        ------------------------------
        Wallace Yeboah
        ------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    5 years ago
    You are doubling up on the "db/"

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord....."

    ------------------------------
    Ivan Weiss
    ------------------------------