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

9 Replies

Sort By
  • 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
      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"?