Rich Text Formula Field for Approve / Reject button and redirection

I suggest that you walk before you try to run.

Make a URL formula field called Approve, not a rich test formula field.

var text approve =  URLRoot() & "db/" & [_DBID_] & "?a=API_EditRecord&apptoken=XXXXXX&rid=" & URLEncode ([Record ID#])

& "&_fid_xx=" & URLEncode("Approved")

& "&_fid_xx=" & URLEncode(Now())

& "&_fid_xx=" & URLEncode(User())

var text EditOtherRecord = 

URLRoot() & "db/xxxxx?a= API_EditRecord&apptoken=xxxxxxrid=" & URLEncode ([Related Store Item])

& "&_fid_xx=" & URLEncode([# of Features Requested]);

var text DisplaySomeRecord = 

URLRoot() & "db/xxxxx?a=dr&rid=" & [Record ID#]);

$approve URLONE 
& "&rdr=" & URLEncode($EditOtherRecord URLTWO)
& URLEncode("&rdr=" & URLEncode($DisplaySomeRecord URLTHREE))

Thanks for the info. The formula is accepting, however, it's appearing as the entire link on the form versus the button(s). 
Also, when I click the link I get taken to an error:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<qdbapi>
<action>API_EditRecord</action>
<errcode>2</errcode>
<errtext>Invalid input</errtext>
<errdetail>
You must provide a valid choice for the field named "Decision" with field id 12.
</errdetail>


<rid>1</rid>
<num_fields_changed>0</num_fields_changed>
<update_id/>

</qdbapi>

Correction -  My mistake, the value for field id 12 was incorrect. I corrected it, the link works to update the three fields now. However, the value in the "other record" is not populating based on the value in the original.

This part:

var text EditOtherRecord = 

URLRoot() & "db/xxxxx?a= API_EditRecord&apptoken=xxxxxx&rid=" & URLEncode ([Related Store Item])

& "&_fid_xx=" & URLEncode([# of Features Requested]);

doesn't seem to be functioning. I've confirmed that there is a value in the [# of Features Requested] field.

Really making progress here - much appreciated!

I've got all components functioning now for the approval. Is there a way to also include the rejection within the same url formula field? 

So still with the concept of walking before you run, can you get a reject button working?  Then post back.

Agreed, thanks for the assistance.

Here is what I have for the reject button:

var text reject =  URLRoot() & "db/" & [_DBID_] & "?a=API_EditRecord&apptoken=xxxxx&rid=" & URLEncode ([Record ID#])

& "&_fid_xx=" & URLEncode("Reject")

& "&_fid_xx=" & URLEncode(Now())

& "&_fid_xx=" & URLEncode(User());

var text DisplaySomeRecord = 

URLRoot() & "db/xxxxx?a=dr&rid=" & ([Record ID#]);

$reject 
& URLEncode("&rdr=" & URLEncode($DisplaySomeRecord))

This works, but redirects to an xml page:

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>1</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1545343689363</update_id>


</qdbapi>

The generic format of the nesting is like this

$URLONE 
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))
& URLEncode(URLEncode("&rdr=" & URLEncode($URLFOUR)))
& URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLFIVE))))
& URLEncode(URLEncode(URLEncode(URLEncode("&rdr=" & URLEncode($URLSIX)))))


and you slice as much off that salami as you like

So in your case it would be

$reject 
& "&rdr=" & URLEncode($DisplaySomeRecord)

That is some great tutelage and knowledge, my good sir. Much obliged and appreciated

Thanks to your help, I'm super close to where I want to be! Here is my code for the rich text field that I created, all is well, except for the last redirect for the approved button. I highlighted in bold, QB is throwing an "expected text" syntax error.

I tried to follow your convention above, but have been scratching my head over it for an hour now..



var text approve =  URLRoot() & "db/" &  [_DBID_] & "?a=API_EditRecord&apptoken=xxxxx&rid=" & URLEncode ([Record ID#])
& "&_fid_12=" & URLEncode("Approved")
& "&_fid_13=" & URLEncode(Now())
& "&_fid_14=" & URLEncode(User())
& "&rdr=" & URLEncode(URLRoot() & "db/xxxxx?a=API_EditRecord&apptoken=xxxxxxx&rid=" & URLEncode ([Related Store Item])
& "&_fid_14=" & URLEncode([# of Features Requested]));
& URLEncode("&rdr=" & URLEncode(URLRoot() & "db/xxxxx?a=dr&rid=" & ([Record ID#]));

var text reject =   URLRoot() & "db/" & [_DBID_] & "?a=API_EditRecord&apptoken=xxxxxxx&rid=" & URLEncode ([Record ID#])
& "&_fid_12=" & URLEncode("Rejected")
& "&_fid_13=" & URLEncode(Now())
& "&_fid_14=" & URLEncode(User())
& "&rdr=" & URLEncode(URLRoot() & "db/xxxxxx?a=dr&rid=" & ([Record ID#]));

var text cancel =    URLRoot() & "db/" & [_DBID_] & "?a=API_EditRecord&apptoken=xxxxxxx&rid=" & URLEncode ([Record ID#])
& "&_fid_12=" & URLEncode("Cancelled")
& "&_fid_13=" & URLEncode(Now())
& "&_fid_14=" & URLEncode(User())
& "&z=" & Rurl();


//Colors of the buttons. The second color is the mouseover color.
var text buttoncolor= "@#76c043@#367c2b@";
var text buttoncolortwo= "@#c04e43@#89362e@";


var text buttoncolorthree= "@#efab49 @#a96a0f@";

var text buttonone= $approve & $buttoncolor & "Approve";
var text buttontwo= $reject & $buttoncolortwo & "Reject";
var text buttonthree= $cancel & $buttoncolorthree & "Cancel";

var bool ShowButtonOne = If(Now()>[Date Created], true, false);

// ========================Begin Pattern========================

var text onclickone =  "\" onclick=\"LinkAway('";
var text onclicktwo = "', false); return false;\"";

//Button bar
If($ShowButtonOne=true,
"<div style=\"position:relative; width: 330px; height: 25px; \">" & 
If($buttonone<>"", "<a href=\""  & Left($buttonone, "@") & $onclickone & Left($buttonone, "@") & $onclicktwo & "\" style=\"color:white;text-decoration: none; \"> <span style=\"position: absolute; display: table-cell; text-align:center; width:160px; height:25px; border-radius: 5px; background-color:" & Part($buttonone,2, "@") & ";  font-weight: bold; \" onMouseOver=\"this.style.backgroundColor='" & Part($buttonone,3, "@") & "'\" onMouseOut=\"this.style.backgroundColor='" & Part($buttonone,2, "@") & "'\"><span style=\"position:relative; top:25%;\">" & Right($buttonone, "@") & "</span></span></a>","") & 
If($buttontwo<>"","<a href=\""  & Left($buttontwo, "@") & $onclickone & Left($buttontwo, "@") & $onclicktwo & "\" style=\"color:white;text-decoration: none;\"> <span style=\"position: absolute; display: table-cell; text-align:center; width:160px; height:25px; border-radius: 5px; background-color:" & Part($buttontwo,2, "@") & ";  left: 170px; font-weight: bold; \" onMouseOver=\"this.style.backgroundColor='" & Part($buttontwo,3, "@") & "'\" onMouseOut=\"this.style.backgroundColor='" & Part($buttontwo,2, "@") & "'\"><span style=\"position:relative; top:25%;\">" & Right($buttontwo, "@") & "</span></span></a>","") & 
//If($buttonthree<>"" and [Status]<>"On Hold","<a href=\""  & Left($buttonthree, "@") & $onclickone & Left($buttonthree, "@") & $onclicktwo & "\" style=\"color:white;text-decoration: none;\"> <span style=\"position: absolute; display: table-cell; text-align:center; width:130px; height:25px; border-radius: 5px; background-color:" & Part($buttonthree,2, "@") & ";left: 280px; font-weight: bold; \" onMouseOver=\"this.style.backgroundColor='" & Part($buttonthree,3, "@") & "'\" onMouseOut=\"this.style.backgroundColor='" & Part($buttonthree,2, "@") & "'\"><span style=\"position:relative; top:25%;\">" & Right($buttonthree, "@") & "</span></span></a>","") & 
"</div>", ""
)

Sorry but that�s a little too complicated for me to spend the time on to try to debug the syntax remotely.