listing unmatched records

Hey ​@AndyLecap,

You can create a new view in your Member table and add the following filter condition:
 

Booking is empty. Where the “Booking” is the field from the Member table that links to the Booking table.

Hey ​@AndyLecap!

​​​​@BuildForAT mentioned above, you can get that solved by applying a filter to any view within your Members table. (More on Airtable views here)

Mike, Consultant @ Automatic Nation

Another way is to use a count field in the Members table. If the count is 0, it means the member hasn't made any bookings.

Taha, Airtable Advisor

Thank you.  What I have realised is that there is no relationship between the two tables.  The Bookings table data is imported from a separate booking app.  In both tables I have made the persons full name the index field.  Before I can enact any of your suggestions, do I need to create a relationship between these two fields? if so how?

You will need to link the members from the Booking table to your Member table.

Also, note that linked records cannot be used as primary fields. One approach is to create a formula field that displays the linked record (Member field), and use that formula field as the primary field.

Taha, Airtable Advisor

Thank you tahajiru. In the Bookings table I have created a new field called Aelod (it is Welsh and means Member) using the settings below. So Do I have to go through each record and manually fill in the field, there is one value for each record?

Yes, that’s right! You would need to create a relationship between the two tables.

In your Booking table, you would need to create a new linked record field. The field type is named “Link to another record” Then, select the Member table and create the field. You may want to disable “Allow linking to multiple records”

May I ask how many records you have in each table? Because if you don’t have many you could manually link the Members to the Booking.

Otherwise, you could create an automation to do so like this:

If you need help setting any of this up just email me directly at build.for.airtable@gmail.com.

I have 2662 records, so I will need to create an automation as ​@BuildForAT suggests.  The link is created but there is no data showing.  I realise that AirTables relationships are not the same as in other databases such as Access and SQL Server, which have a much more elegant way of doing it, in my opinion.

It looks like ​@tahajiru has a much better solution. Thank you!

Where you can just edit the Member Name field you already have in the Booking table and change that to a “Link to another record” field.

Thank you ​@BuildForAT YES I now understand ​@tahajiru solution.  I need to make the personName field and personName cannot be the primary field.  Also, I created a copy of the table before I tried this as I discovered there a few names not in the members table 🤔