Limit access to a formula URL button from a "List - User" field

Question

Hello,

I am trying to set up view restrictions for buttons based on the input of an assigned to field. I am able to get the formula to work for a single user field but I was wondering if it is possible to have that same functionality for a list-user field where more than one person might be assigned. Thank you.

If([Assign to 2]=User(),
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_18=In Progress" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()))

------------------------------
Peter Krasznekewicz
------------------------------

MarkShnierYou · Answer

Maybe what you want to use in the Includes function
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=180&rl=djn

If(
Includes([My List User Field], ToUserList(User()),

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_18=In Progress" & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()))

I believe that you need to convert the User() field to b a List User type for that function to work, hence the use of ToUserList(User())

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community