Is it possible to calculate a value to display in a table based on how data in a table is filtered by an inline filter? The inline filter would be based on linked records. The calculated value would change depending on the linked record chosen in the filter. This would be using Airtable as the dat…

Gotcha, So, in that case, you’d have to create a field in the Product table for every discount rate. If you did that, you could then create multiple views in Stacker showing the discounted field in the table associated with that view’s name. Hope that helps too. :+1:

Hey Jack, Off the cuff, I would say that the calculation wouldn’t be made until the product is connected to the stockist, therefore neither Airtable or Stacker would know what discount to make visible … However, if your discount is connected to a category of stockists, then you could create a calc…

Thanks @MrLunt , this is a great suggestion, I will play around and see if it helps. It might get me closer to a solution. The challenge I have is the the logged in user would be an internal staff member, who manages multiple external stockists. External stockists do not log in. So I can’t use the u…

Calculating and displaying a value based on which inline filter option is selected

Ask the Community How do I?

JackF August 19, 2024, 9:12am 5

Yes - that is what I ended up doing. Not quite what I was aiming for but I can make it work this way. Thanks a lot for your help!

1 Like

Topic		Replies	Views
Use Airtable Formulas to Filter & Countdown Automations	1	442	November 11, 2021
Show records for the next 6 months How do I?	1	454	July 6, 2022
I've added a new record in Airtable and it doesn't appear in Stacker. Even when I am in admin mode Ask the Community troubleshooting	2	410	March 2, 2021
Can't lookup stacker fields How do I?	2	357	August 29, 2023
Can users filter a list? Editing Layout	1	455	March 2, 2021

Calculating and displaying a value based on which inline filter option is selected

Related topics