I have a table with ‘Name’ and ‘Partner’ fields. I need a view showing records where Partner is empty or not referenced.
extractItems(dataSet, criteria);
How can this be set up?
hey, try using a filter like: if({partner}=‘’,1,0) to only show records without a partner. works fine in airtable view. might need slight tweaks if youre linking recods. cheers!
Based on my experience managing similar setups in Airtable, one effective solution involves creating a helper formula field that verifies whether the Partner field is empty. Rather than directly filtering the linked records, setting up a formula such as IF(LEN({Partner}) = 0, ‘Not Linked’, ‘Linked’) simplifies creating a view. You can then filter based on the helper field being equal to ‘Not Linked’. This method avoids complications inherent in filtering directly on linked records and has consistently worked in my projects for accurately displaying only the records that meet the criteria.
I had a similar requirement in a project recently and found a satisfactory solution by constructing a helper formula that leverages the IS_BLANK function on the Partner field. Essentially, I created a new field that returns a specific flag when the Partner field is empty. This allowed me to apply a straightforward view filter on the flag rather than having to work directly with the linked records. The approach turned out to be quite efficient and reliable for omitting records where there’s an active link.