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 ...
Forum Discussion
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
------------------------------
if you ammend that to perhaps:
ToUserList([Follow], User())
Then I believe that will keep the current and add the current user.
------------------------------
Ryan Stanford
------------------------------
It does not like the User() portion of that formula. It says it is expecting a UserList. See image below:
Any ideas on what else to try/tweak?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
Any ideas on what else to try/tweak?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
- Anyone have any suggestions on this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------- MarkShnier__You
Qrew Legend
What is not working with how your formula is set up how?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Just an FYI but doing it in this way you are limited to 20 users being in that field at once. When you go past that limit the field becomes blank.
If that is not an issue then continue down that path. If you ever see yourself needing 20+ userrs watching something this may not be the right way.
I would try 2 things. First try setting a variable up as the User() and use that instead of User() in the URL.
Var User myUser = User();
Sorry if this is not accurate to the formula in the picture but I'm not writing it out from there. I just copied it from the first post.
URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_60=" & URLEncode(ToUserList([Watchers], $myUser)) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid())
If that does not work and still complains about the user error I would try creating a formula user field and have it be simply User() and then try adding that to the URL instead.
URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_60=" & URLEncode(ToUserList([Watchers], [MyUserField])) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid())
Edit: You know the problem may actually be with trying to stuff a user list into another user list... You may need to somehow breakdown the current Watchers/Followers list into individual entries and then add them all to and updated user list before sending that api call. - MarkShnier__You
Well yes it is always helpful to tell us what's not working when you have a syntax error. :)
Try this change
& "&_fid_60=" & UserToEmail(ToUserList(User())) &
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- This change -> UserToEmail(ToUserList(User())) causes the same error but in the other direction. Instead of saying "expecting UserList and found like" it says "expecting User and found User List"
The solution of created a separate formula - user field and assigning it =User() also has the "expecting UserList and found User" error
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------- MarkShnier__YouI tested your original formula which is essentially this
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_20=" & UserToEmail(User()) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid())
and it worked just fine,
Can you post the error message you get when you save your original formula? Not the syntax error checker in the formula box but the error message that you get when you go to Save the formula,.
ie this formula here
URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_60=" & UserToEmail(User()) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid())
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
