Forum Discussion

ChrisSwirtz1's avatar
ChrisSwirtz1
Qrew Trainee
6 years ago

Trying to create a button that when clicked from a report, it changes a status filed within the record to ""shipped

What is wrong with my formula to make this work? URLRoot() & "db/" & [_DBID_SALES]& ?a=API_EditRecord&rid=URLEncode  ([Record ID#]) &apptoken=ngp9gddypa5axcmecxe9zzxre2&_fid_7=Shipped
APIs and custom code
Forms
Formulas and functions
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
Use a formula-rich-text field with the following formula:

"<a class='Vibrant Success' title='Mark as Shipped!' style='text-align:center; text-decoration:none' href='javascript:void(window.location.href = \""&

URLRoot() & "db/" & [_DBID_SALES] & "?a=API_EditRecord&apptoken=ngp9gddypa5axcmecxe9zzxre2&rid=" & URLEncode([Record ID#])
& "&_fid_7=" & URLEncode("Shipped")

& "&rdr="&"\"+escape(window.location.href)"
& ")'>Mark as Shipped</a>"

ChrisSwirtz1's avatar
ChrisSwirtz1
Qrew Trainee
6 years ago
That worked beautifully! Thank you!!