Filtering Airtable Data into Glide App

[jay139]

Hello,

I am currently syncing my airtable data with glide. Right now, the whole selected database is being synced. I can unlink tables that are irrelevant. For the required tables, not ALL records are needed.

Is there a way to filter out which records can be synced? For example, we have 3 status options: Pending Arrival, In Warehouse, Released. I want to sync records that do not have status marked as “Released”.

Additionally, all record’s will eventually be marked “released”. When status is changed to “Released”, I would like the row to be deleted off of Glide’s data.

The main reason for this is because we are hitting the 25K row limit but almost 80% of these rows are from records that have been “Released”. We can store these rows in Airtable for record keeping but do not need it in Glide.

[ThinhDinh]

Airtable sync by VIEW!

Hello A workaround is to create a brand new Airtable base - then add a table in that new base which is a sync’d view using the view from the original table you need. If you need to add records, you will need a separate sync set up back to the original base as you can not add records to a sync’d base (yet) Hope this helps Andrew

I’m not well-versed with Airtable, but here’s a comment I found.

It doesn’t solve your need to have filtered live data, but I wonder if things have change on Airtable since the linked comment.