Forum Discussion
LauraThacker
Qrew Captain
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>"
"<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
5 years agoQrew Trainee
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>"
*** 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>"