Restrict selection box

[#1]

Hi all,

Is possible to restrict a selection box based on the logged in user?

For example we have a selection box with multiple values (i.e. Site 1, Site 2 etc), however if a certain user opens the document I only want them to be able to select "Site 1".

Thanks in advance for any advice.

Anthony

[sunny_talwar]

Have you thought about section access? If you don't want to do this, you may be able to use an if statement to do this:

If(WildMatch(OSUser(), '*User1'), If(Match([Site ID], 'Site 1'), [Site ID]), [Site ID])

[#3]

Hi,

Thanks for the quick response. Where would I apply such a If statement?

[sunny_talwar · Accepted solution]

As a list box expression

[#5]

Thanks for the advice, it worked perfectly.