Forum Discussion

PeterKrasznekew's avatar
PeterKrasznekew
Qrew Trainee
3 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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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's avatar
PeterKrasznekew
Qrew Trainee
3 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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    That is strange.

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