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, 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>"
This will provide the desired checkboxes to be check in that record, but not load the selected record in a new tab.
------------------------------
Jovan Vucovich
------------------------------
