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.
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.