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

That worked beautifully! Thank you!!

You are welcome.

Hey Laura,

I used this same idea to mark a check box as checked and it works great. But I had a dynamic form rule tied to that checkbox that when it was checked another field would change to Released that doesn't work now unless I also go in and edit the record. Can I add that 2nd command to the formula you gave me to both mark the box as checked and change the status field to "Released"?

Form rules will only work when you make changes from inside the form. You can either add it to your URL like below or if that gets too large of a formula for you later on you could consider using an Action or Automation to do some of this. 

You should be able to just add another field onto the end of the url and it would work the same way you said you added the checkbox. Did that not work for you? What issues did you have with it? 

I don't have the updated URL with the checkbox but It would just be like this but with the 3 question marks replaced by the right field ID. All I did was add "&_fid_7=" & URLEncode("Shipped") to the end while changing it a bit.

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

Per Austin's comment, who was able to respond faster than me, yes.

"<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_X=1"  //this is your checkbox field
& "&_fid_X=" & URLEncode("Released")  //this is your other field normally updated by Form Rule

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

Thank again Laura and to you Austin as well. I tried adding what you suggested and it doesn't like the released part (in bold and italic below). Here is what I ended up with.

*** Note- I had copied the original formula for making the field as shipped to check a check box "marking it as paid" which worked perfect. Just wanted to add the action of changing the 2nd field to "Release"

"<a class='Vibrant Success' title='Mark as Paid!' 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_9=" & URLEncode("YES") & "&_fid_7= & URLEncode("Released")

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

<a class='Vibrant Success' title='Mark as Paid!' 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_9=" & URLEncode("YES")
& "&_fid_7=" & URLEncode("Released")

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

You are missing the double-quote after the fid_7=

Ha, it's always something so simple. Thanks again!!