Thanks for the reply Mark.
I thought about your example carefully and tried it out on my builder account. The part that is not adding up for me is:
> but the set of records which is returned meets the criteria of the Custom Rule.
I have tried many things but can't see any way to have a custom rule that evaluates the keys for individual records on a report page.
Maybe I'm missing or misunderstanding something, but for example:
I add EOTI access to an EOTI specific role, and their custom view permission is to only view records where the "Valid Key" formula field is checked. This works for viewing the specific record, but how that does work with reports? On the report page, the access key of each individual record could not be evaluated for the record to have anything to check and validate it against. I also tried to do it with report formulas, but no luck either.
I suppose the only solution is to assign a secure link to records based on a common field, like your example, and create an ask the user report with the resulting secure key to filter... but I'm not sure. I wish Quickbase provided at least one example of this feature as applied to reports.