AnsweredAssumed Answered

Record-Level Access Script

Question asked by artsmerch on Aug 29, 2012
Latest reply on Aug 29, 2012 by comment

So I'm trying to set up a security access so the sales department can only see pieces available for sale only. I have a column that designates sold with S and A for available. I need to script the security so that it finds and shows only the A pieces and hides or doesn't show the S pieces.

I'm thinking an if statement but I'm not sure. I've written the following but this doesn't work. Help is much appreciated. Thank you!

 

Go to Layout ["Gallery Price List"]

Go to Record/Request/Page [First]

Loop

If [Art Database::Status = "A"]

Show Record

Else

Do Not Show

End If

Go to Record/Request/Page [Exit After Last, Next]

End Loop

Outcomes