Looking to find a list of value in column C after a FILTER

AppSheet AppSheet Q&A
1

Hello, I’m working on an app where users can select a list of items. Every time one item from the list is selected, it is removed from the list to avoid it getting selected twice.
I’ve been able to create a function that limits the items, but unfortunately, I only get the key value of the row but not the item, which is column C.
The list is stored in a virtual column as a “list”, and I’ve verified that it would show up in the dropdown; the issue is that instead of the items, I get the list of keys.
What I tried is that given I have the row number of the items, I try with a select to create a second column with the list of items in column C, but I get errors.

Any suggestion is welcome. I’ve checked out several suggestions @Steve already but failed.

2

I didn’t fully understand how you are trying to do this. But have you tried making the said column C as Label for that table.

1 Like
3

As first sight, you may be wanting to pull the “item_name” column instead of the key one just to make selection easy. But that’s what Label does

Add row labels - AppSheet Help
4 Likes
4

This sounds like a list subtraction problem.

How does your app get a list of all items?

How does your app get a list of already-chosen items?

all - already-chosen = still-available

3 Likes
5

Hi @Steve interesting, I will check if the list subtraction works, I was actually doing the subtraction on the Google Sheets side, generating new dynamic tables for each team, yet that was just a workaround not easy to scale with many teams. I will play around with it and let you know. Thanks.

1 Like
6

Hi @Steve , thanks for directing me in the right direction, I’ve been able to do the expected function and get rid of the Google Sheets calculations.

1 Like