Forum Discussion

StevenNelson's avatar
StevenNelson
Qrew Member
9 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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
8 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)