Populate List-User Field Using Formula URL

Question

Hello and happy Friday!I have an application with records that users will be reviewing. I have created a Formula - URL (as a button) on each record that the user can click and be assigned to that record. The formula-URL field populates a User field that marks them as the "owner" or "lead" of that record. I would like to create a similar functionality for those that do not wish to "own" that record but would like to "watch" or "follow" this record. I have tried following the same general method with a List - User field (multiple people could elect to be a watcher) but with the formula I have currently the last person to click the "follow" button replaces the previous.For example: If Jack and Jill want to keep tabs on a record they would click the "follow" button when it appears on their dashboard as a new item. Say Jack sees it first and clicks "follow", the formula adds Jack's name to the List - User field. If Jill then comes in and clicks the "follow" button, it replaces Jack's name with Jill's instead of adding Jill's name to the List - User field. Here is my formula: URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_60=" & UserToEmail(User()) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid())Do I need to change something up in my formula to make this work?------------------------------Thanks in advance,Jennifer Paschal------------------------------

RyanStanford1 · Answer

I haven't tested this... but what you might be able to do is where you set the _fid_60 to UserToEmail(User()), you're overwriting the current value.

if you ammend that to perhaps:

ToUserList([Follow], User())

Then I believe that will keep the current and add the current user.

------------------------------
Ryan Stanford
------------------------------

Sign up

Login to the community