Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
2 years ago

Clearing a user field with a URL Button

I have a user field in table that I would like to clear directly with a URL formula field. I know I could use a button and a pipeline to accomplish using the {{CLEAR}} in the pipeline, but then the user needs to refresh to see the result. Does anyone know how to write this formula? Here is a Link to a similar question in discussions



------------------------------
George Bramhall
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    There is nothing unusual about clearing a User field with a URL formula button.  It's the same as other field types.

    var text ClearUserField = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_134="; // set the fid for your user field.
     
    var text RefreshPage =  URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
     
     
    $ClearUserField
    & "&rdr=" & URLEncode($RefreshPage)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------