Skip to main content

Lookup for unselected records

  • June 24, 2021
  • 1 reply
  • 10 views
P
  • P_C
  • New Participant

Hi Everyone,

I have a base for auditing which asks if certain documents are present by linking to document records in another table. I’d like to then be able to collate a list of the missing documents (those not selected) for part of the feedback. Is there any way to do this? I’ve been going mad trying to figure it out!

This topic has been closed for replies.

1 reply

Justin_Barrett
Forum|alt.badge.img+21

A formula can’t do this kind of “what’s missing” check. Only a script can look at the entire collection of records in the target table, find which ones are missing from a link field, and present that list to you somehow.

Terms & ConditionsAccessibility statement