Forum Discussion

DawnQuitschau's avatar
DawnQuitschau
Qrew Member
4 years ago

Button on Report Row to Set a Value in a Field

While in a report, is it possible to set the value of a field based on a button click?  For example, one of my users is tasked with reviewing field values and prioritizing each record. Rather than tra...
APIs and custom code
Formulas and functions
Pipelines
DawnQuitschau's avatar
DawnQuitschau
Qrew Member
4 years ago
Does the pipeline solution require the user to be in grid edit (you mentioned "grid at save")?  If so, I would just have them set the priority via the Priority drop-down using grid edit.  I was hoping to offer them a quicker solution with the buttons - was hoping for some type of in-place update, where the Priority field was populated immediately with the click of a button.  I'd like to give the page refresh a try and would appreciate help with the formula.

------------------------------
Dawn Quitschau
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
OK, try this as a formula URL button

var text URL = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid= & [Record ID#]
& " &apptoken=xxxxxxxxxxxx" //optional if you have app tokens enabled.
& "&_fid_99=High"; // stuff HIGH into the field id # 99 

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

$URL
& "&rdr=" & URLEncode($RefreshPage)

// after doing a URL we need to land the user somewhere.  In this case we are refreshing the page.

​

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • DawnQuitschau's avatar
    DawnQuitschau
    Qrew Member
    4 years ago
    I got it working, Mark.  Thanks!  :)

    ------------------------------
    Dawn Quitschau
    ------------------------------