Forum Discussion

Qrew Trainee

4 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

Qrew Trainee

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

Qrew Legend

4 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
mark.shnier@gmail.com
------------------------------

PeterKrasznekew
Qrew Trainee
4 years ago
It is a List-User field.

I was playing around with some things and think it now works using the "Contains" formula. Tentatively optimistic but I'll test with some other user roles and see if it works when selecting multiple people in the List-User field.

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

------------------------------
Peter Krasznekewicz
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  That is strange.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------