Populate List-User Field Using Formula URL
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
------------------------------
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
------------------------------
