Desperately need conditional greater than less than filters for displaying data from Airtable

Use case: real estate listings

We really need the ability to only display homes to users that they can qualify for. For example, if they can only qualify for a monthly payment of $2000, they should not see homes over $2000/mo. Really really need the option to filter for this!

If I understand correctly, you can work that logic on the airtable side.

  • Add a formula field, let’s name that field ‘validation’

IF ({montlyPayment}>2000, ‘showThis’, ‘hideThis’)

Then on your filters use that condition to limit or show content when field {validation} = ‘showThis’

Unfortunately, it needs to be tied to the logged in user’s monthly payment qualification amount, so that won’t work.