Help with Filtering Formula Showing Repeated Results Across Rows

[sutha_balasubramaniam]

Hi,
I’m working with multiple tables:

• Table 1: Product list (e.g., apple, banana, orange, onion, leeks, potato, greens, beans)
• Table 2: Category mapping (e.g., apple → fruit, onion → vegetable, etc.)
• Table 3: Filter logic with columns for category, product, and count

I’m using a formula like:
table2.filter(category == “fruit”) or table2.filter(category == “fruit”).name
The issue is: these formulas returns the correct list of products, but the full list appears in every row, like this:

• Row 1: apple, banana, orange
• Row 2: apple, banana, orange
• Row 3: apple, banana, orange

What I want instead is:

• Row 1: apple
• Row 2: banana
• Row 3: orange

How can I adjust the formula so that each row shows only one item from the filtered list, rather than repeating the entire list in every row?

Thanks!

[Daniel_Stieber]

Hey @sutha_balasubramaniam , welcome to the community!

a possible approach for this case:

Have a second column (you can hide it) that has a contnious number from 1 to x,
then in the formula you at a .nth(CONTINOUS NUMBER).

That way, you only get one item and it counts down every item based on your contionus number

| Fruit                      | RowNumber |
|----------------------------|-----------|
| yourformula.Nth(RowNumber) | 1         |
| yourformula.Nth(RowNumber) | 2         |
| yourformula.Nth(RowNumber) | 3         |

Let me know if that works for you!

[sutha_balasubramaniam]

Thanks for sharing your approach with the continuous numbering technique. Regarding my current challenge, I’ve successfully implemented filtering between two linked views, but I’m facing an issue when trying to get a dropdown list from another table - it’s showing all unfiltered values instead of just the filtered ones visible in the linked views.

What I specifically need is:

1. A dropdown that only displays values currently visible in certain linked views

2. The ability to exclude some linked views from contributing to the dropdown list

Would you have any suggestions for how to implement this selective filtering for the dropdown while maintaining the existing linked view filtering? Perhaps there’s a way to reference only specific views as the data source for the dropdown?

[Daniel_Stieber]

Hey @sutha_balasubramaniam ,

when you configure a select list, you can write a formula to populate it (top right “F” button at the options list). In the formula you can use listcombine and get the rows from the filtered views. In the end, you can add “unique” to get rid of duplicates, in case some of the views show same rows.

Maybe that is a way to go for you here?

[sutha_balasubramaniam]

Thanks, Still I can’t get it. See these images:

Item table category is a select list from table category.

I copied the item table and filtered the category: category = Fruit and category = Veg

Count table name is a select list to ‘View of Item-Fruit’ or ‘View of Item-Veg’, via the if(,). ‘If(category = Fruit, View of Item-Fruit, if(Category=Veg, View of Item-Veg,’Please choose category’)).

This approach is showing all item and not the filtered item.

Any sugestion:

[Daniel_Stieber]

Can you share that demo doc with daniel.w.stieber@gmail.com, then I can have a look in detail

[Daniel_Stieber]

Hey @sutha_balasubramaniam thanks for sharing the doc.

I’m still not 100% sure what your goal is, but I’ve added two columns that hopefully get you closer.

Two things I saw in your count.name that might not be what you want:

• You currently have a relationship column, instead of a select list column. These are similar but not the same. In this use case, it feels more simple to go with a select list and use a function there, then to use the relationship and a filter.
• You currently used “value for new rows” instead of filtering the available options, which is also something else.

As I understand, you want that the selectable options in the column name are based on the views you created above. So there should only be the fruits and vegetables you have selected in the two views. This is what I created in the “All items from views” column. It is a select list that combines the items of the two views. Super simple.

Next you want the ability to exclude some linked views. That is now available in the “All Items by Category” column. It shows only the items from the category you have selected in that row, and is based on the two views.

This formula goes through every item and looks if the category matches. If you just have two categories, you could also use a simple if or switch instead of the whole listcombine part, but since in your real scenario there might be more, I tried this approach. Its easy to add more views and stay flexible.

Does that get you closer?

[sutha_balasubramaniam]

Thank you for everything. The items grouped by category are exactly what I was looking for. However, do you know if there’s a way to configure this without creating a separate view, or is there another way to achieve this type of result?

[Daniel_Stieber]

Hey @sutha_balasubramaniam

yeah sure! I think we overcomplicated it a bit since I was not 100% sure what you wanted to achieve.

I made you to more pages showing a simple approach. One without any views, just referencing the table, and another one without views but available checkbox. Something I’d thought you want to achieve with the views in the first place.

[sutha_balasubramaniam]

I can’t thank you enough. This is exactly what I’ve been searching for for months. I should have asked this question much earlier. I really appreciate your help, thank you so much!

[Daniel_Stieber]

Great to hear - good luck with your doc ! Yeah the community is definitely always worth a try with these kind of questions