Forum Discussion

PeterKrasznekew's avatar
PeterKrasznekew
Qrew Trainee
5 years ago

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

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...
APIs and custom code
PeterKrasznekew's avatar
PeterKrasznekew
Qrew Trainee
5 years ago
Mark,

   Thanks for the help on this. So I created a new List - User field, however, when I go to input the "if" statement listed below I'm getting the error "Column: 0 > Expecting userlist but found text" at the end of the formula. Do I need to define the users beyond just adding the "User()" field?

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



Thank you.

------------------------------
Peter Krasznekewicz
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
What kind of field is [Assign to List]

Sounds like this is just a down and dirty multiple-choice text field and of course QuickBase has no idea if you have a John Smith on the drop-down list which user that actually is.

Can you have a [Assign to List] be a list user field type?


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------