Hi ! What I’m trying to do is a basic relational DB behavior, but I can’t find my way in AirTable. Here is the idea…
I have 3 tables interacting for this problem :
Relationships through “Link to” fields :
In the Appointments table, when I link to an invoice, I obviously want to see only the invoices linked to the correct client. (The incomplete invoices are created beforehand)
Therefore, in the Appointments table, I want to filter the Invoice choices only to the invoices linked to the client of that appointment.
As I understand it, a filtering based on a view won’t be of help, since I can’t create a view for every client in my base…
Ideas ? Tips ? Help ? Is it even possible in AirTable ? Would be a serious limitation for my use cases, and I might regret MS Access for the very first time since I signed up for AirTable !
Thx for anything !
Unfortunately & sadly, this is not a feature that is natively built into Airtable. :frowning: In my personal opinion, this is one of the key missing features from Airtable.
However, there is one known workaround/hack to make this work, which is outlined here:
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
Just took me a few days to code my own Node.js two-way sync AirTable <-> GoogleCalendar.
Wow, impressive! There is also a 2-way sync Airtable to Google Calendar product here: https://www.zzbots.com/store/etsxGGrfvx5BtXmnt
Heya ! After careful reading and study, I understand the workaround. Smart, tricky, beautifully creative, but unfortunately it requires an alteration of the base, and I can already see down the road a time when I have forgotten all about it and mess things up myself.
My logic here : when the workaround creates more complexity than the initial problem it solves, don’t implement it. I will probably rethink my relationships between tables, or accept this limitation until AirTable releases a straightforward solution. Not migrating from old-school DB management for nothing !
So, still waiting for a cleaner solution which probably won’t come…
I’m thinking about limiting the relations to :
Appointments <— Many-to-One —> Invoices <— Many-to-One —> Client
This would be better for data integrity, but requires lookup fields and limits the flexibility for everyday appointment management.
I agree with this logic! Be sure to email firstname.lastname@example.org and let them know how important this feature is to you. It’s a standard feature of all other database systems, so it’s extremely disappointing that Airtable doesn’t have it.