Skip to main content
Question

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

  • August 12, 2019
  • 0 replies
  • 61 views
Forum|alt.badge.img+4
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
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • August 12, 2019
    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>"

    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Terms & ConditionsAccessibility statement