I have a table of records called Meetings and a table called MeetingParticipants, which is a join table between Meetings and Users. How would I restrict visibility to Meetings to Meeting Participants?
I've used this formula as a calculation for viewing privileges on Meeting records and and first I thought it worked.
not IsEmpty ( FilterValues ( $$currentUserID ; List ( MeetingParticipant::__fkUserID) ) )
($$currentUserID is obtained on first run)
But this creates a very strange state that I don't understand. Even though I can see the correct set of records, the moment I enter find mode everything disappears.
In find mode all non global fields go blank so that you can enter find criteria into them. Why shouldn't everything go blank in find mode?
Are you using that expression as a lock expression inside Manage | Security? Some developers have had better luck using a global field instead of a global variable. But I don't quite see the problem from what you describe.
Retrieving data ...