Skip to main content
Question

Clearing a user field with a URL Button

  • August 22, 2023
  • 0 replies
  • 168 views
GeorgeBramhall2
Forum|alt.badge.img+11

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • August 23, 2023

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement