Forum Discussion

JovanVucovich's avatar
JovanVucovich
Qrew Member
3 years ago

URL Formula Button that will check multiple check boxes and return to selected record in a new tab

I currently have a button that I will successfully open a new tab of that record and have a single desired field checked.

But, I am wanting for this button to perform this same new tab action of the selected record except check 2 different checkbox fields (Field ID 15 and Field ID 140).
I am able to get this formula to work with checking both boxes, but it does not successfully load the new tab.
It will give me a page showing XML file not having any style information.
The document tree is shows for the error:

<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>3436</rid>
<num_fields_changed>2</num_fields_changed>
<update_id>1645813465811</update_id>
</qdbapi>


The formula I am attempting to use:

"<a class='Vibrant Success' style=\"width:200px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=dk26yixbnr8hncc57zxdnchx2mgc &_fid_15=1&rdr=" &
"&apptoken=dk26yixbnr8hncc57zxdnchx2mgc &_fid_140=1&rdr="&
URLEncode(URLRoot() & "db/bq7w9bprg" & "?a=dr&rid=" & [Record ID#])& "'target=_blank'" & "'>Re-Work Accepted</a>"


To clarify,
This will provide the desired checkboxes to be check in that record, but not load the selected record in a new tab.

------------------------------
Jovan Vucovich
------------------------------
APIs and custom code
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    This should fix the button to check two checkboxes and open the record in a new tab

    "<a class='Vibrant Success' style=\"width:200px; text-align: center;\" href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]
    & "&apptoken=dk26yixbnr8hncc57zxdnchx2mgc"
    & "&_fid_15=1"
    & "&_fid_140=1"
    & "&rdr=" 
    & URLEncode(URLRoot() & "db/bq7w9bprg" & "?a=dr&rid=" & [Record ID#]
    & "'target=_blank'" & "'>Re-Work Accepted</a>")

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JovanVucovich's avatar
      JovanVucovich
      Qrew Member
      3 years ago
      I ended up getting it to work in a similar way shortly after making this post..
      One of those, it comes to you after you ask for help kind of situations.

      I combined the Field ID request before the "rdr="

      instead of:
      ...
      & "&_fid_15=1"
      & "&_fid_140=1"
      & "&rdr=" 
      ...

      I wrote it as:

      ...
      & "&_fid_15=1&_fid_140=1&rdr="
      ...


      Thank you very much for your response.
      Makes me feel better to see that I figured it out to the same concept that you replied with.

      ------------------------------
      Jovan Vucovich
      ------------------------------