Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
5 years ago

How to Add CurrentUser to User List field

I have searched the API, formulas and community and don't see anything. Wondering if there is an API function for adding the current user to a User List through a URL Formula?

The idea is to expose a button on a report that says Subscribe on it. When the User clicks the button their username is added to the User List field. The report is displayed on the App Home page, where each record is a separate topic of interest.

We won't have a lot of Subscribers so a User List is ok. We want to experience to exclude opening the record and adding the User name to the list.

This doesn't work:
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=User()&apptoken=



URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=[??WHAT DO IT PUT HERE??]&apptoken=

Thoughts?

------------------------------
Jim Harrison

------------------------------
Button
Formulas and functions

11 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    var text MyUserList = Totext([userlist2]); // insert your List User field here

    var text NewUserList = List(";",$MyUserList, totext(User()));

    var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_99=" & $NewUserList;

    var Text DoIt =

    "javascript:" &
    "$.get('" &
    $URL &
    "',function(){" &
    "location.reload(true);" &
    "});"
    & "void(0);";

    if(not contains($MyUserList, Totext(User())),$DoIt) // only add the Current user iF not already subscribed

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JimHarrison's avatar
      JimHarrison
      Qrew Champion
      5 years ago
      Works like a button!

      [Subscribe Button]

      var text SubscribersUL = ToText([Subscribers]);
      var text UserListUpd = List(";",$SubscribersUL, ToText(User()));
      var text btnName = If([Subscribed]>0,"Subscribed","+ Subscribe");
      var text urlOne = If([Subscribed]>0,"",URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_<<[Subscribers_fid]>>=" & $UserListUpd & "&apptoken=<<app_token>>");
      var text urlTwo = URLRoot() & "db/<<app Home page dbid>>";
      var text url = $urlOne & "&rdr=" & URLEncode($urlTwo);
      var text style = If([Subscribed]>0,[styleGrey],[styleAdd]);
      var bool popup = false;
      var text target = If($popup = true, "target = _Blank ", "");
      var text title = "Add name to [Subscribers] User List";
      //*****DO NOT EDIT BELOW THIS LINE*****
      //HTML
      "<a title=\"" & $title & "\"style =\"" & $style & "\"" & $target & "href=" & If([Subscribed]=1,$urlTwo,$url) & ">" & $btnName & "</a>"

      Thank you Coach!!

      ------------------------------
      Jim Harrison
      ------------------------------
      • JosephMahon's avatar
        JosephMahon
        Qrew Member
        2 years ago

        I know this thread is old, but how could you remove a user from the list.  For example, remove the current user from the list. 



        ------------------------------
        Joseph Mahon
        ------------------------------