Forum Discussion

GeorgeBramhall2's avatar
Qrew Cadet
9 months 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

1 Reply

  • 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();
    & "&rdr=" & URLEncode($RefreshPage)

    Mark Shnier (Your Quickbase Coach)