Forum Discussion

StevenNelson's avatar
StevenNelson
Qrew Member
5 hours ago

URL formula to Add Current User to Userlist

I have a table with a userlist, I want to have a button that the current user viewing records can click to add themselves to a userlist field.   Having trouble remembering how I have done it before.

formulas

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 hours ago

    Try this

    var text MyUserList  = Totext([userlist2]); // insert your List User field here

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

    var text AddCurrentUser = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] 
    & "&_fid_99=" & $NewUserList;   // change 99 to the userlist field.

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

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

     

  • Denin's avatar
    Denin
    Qrew Assistant Captain
    4 hours ago

    I posted the formula but my reply disappeared. Maybe it's in a mod queue.

    Anyway, you can also find the formula on the Exchange if you have access to that:

    https://{your-realm}.quickbase.com/nav/main/action/exchange/qb/library/assign-a-record-to-me-button