Forum Discussion

EmberKrumwied's avatar
EmberKrumwied
Qrew Officer
3 days ago
Solved

Button formula to force a "reset" of snapshot field.

I have a parent table - Customers - there is a field for Sales tax rate. This rate can change periodically, so in my Charges table (that looks up the Customer) I am looking up the sales tax rate from...
formulas
  • EmberKrumwied's avatar
    EmberKrumwied
    3 days ago

    Thanks Mark. I decided to go with a editable text field that gets populated when the record is created, but then is editable on the fly.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 days ago

Yes you can make a URL formula button to do that.

not tested for syntax errors but try this

var text DeSelectCustomer = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#] 

& "&_fid_99=" // replace the 99 with the fid of the [related customer]

var text ReSelectCustomer = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#] 

& "&_fid_99=" & [Related Customer]

var text RefreshPage =  URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

$DeSelectCustomer
& "&rdr=" & URLEncode($ReSelectCustomer)
& URLEncode("&rdr=" & URLEncode($RefreshPage))

 

EmberKrumwied's avatar
EmberKrumwied
Qrew Officer
3 days ago

Thanks Mark. I decided to go with a editable text field that gets populated when the record is created, but then is editable on the fly.