Hello, I am in need of some help if anyone has a solution. I have an Airtable synced CMS, and I'm looking to filter records with a search field using these conditions: Number typed in search, records filter where the typed number is ≥ the records 'start number' & ≤ the records "end number".

For example if one record has start number column with value of 100, & end number value of 500, I want to filter to that record when I search number: 200

I have been stuck on this all week, cloud flare workers, plugins, and more - nothing will filter my framer (Airtable managed) CMS collection in this way.

Working example on Bubble.io: https://lockhartslist.com/serial_numbers

Thank you.

Hello, I am in need of some help if anyone has a solution. I have an Airtable synced CMS, and I'm looking to filter records with a search field using these conditions: Number typed in search, records filter where the typed number is ≥ the records 'start number' & ≤ the records "end number".

For example if one record has start number column with value of 100, & end number value of 500, I want to filter to that record when I search number: 200

I have been stuck on this all week, cloud flare workers, plugins, and more - nothing will filter my framer (Airtable managed) CMS collection in this way.

Working example on Bubble.io: https://lockhartslist.com/serial_numbers

Thank you.