Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

table/field and dependicies

Topic Labels: Base design
112 1
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Chaney
5 - Automation Enthusiast
5 - Automation Enthusiast

I'm a pretty novice Airtable user, and I'm currently on the free level.

I have created a contact management table. My main table is labeled Contact Log. It then has 15 other tables that I use, such as notes, email address, phone number, pending action (multiple-select field), follow-up needed (check box selection), etc.

Is it possible to create a new table, perhaps called "Follow Up," that shows only the data from my Contact Log table where Follow Up Needed " is checked?

I know I can filter and sort my initial table. But would ideally like a whole new table with that data.

I also have a few other tables id like to create based on criteria being met. But I'm sure I can duplicate the process after seeing it how it's done the first time.

Thanks

1 Reply 1
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @David_Chaney!

Even if it is possible, it doesn't seem to be the best way to tackle your issue for multiple reasons (e.g. You'd need to create an automation for it, you'd have duplicated data on both of your tables, amongst others).

The best way to go for it would be to create a new view on your Contacts table. You mentioned you'd rather have a different table for it... are you familiar with views? The experience will be pretty similar to that of a different table! Furthermore, you can have as many views as you'd like to show data from one table in different ways (e.g. showing or hiding specific fields) and with specific filters. 

Please check out this article for more on Airtable Views.

Other than that, I do feel that the database architecture could be improved! If you'd like to go through your base together I'd love to share some insights and best practices. Feel free to grab a slot on my calendar using this link.

Mike, Consultant @ Automatic Nation