Find Missing From List


So I have 2 Sheets, 1 called “Cards” which is a list of playing cards, and the other for example called “Cards 2”, I want to make a form to add from a choice component of the list of playing cards, that’s easy to do but my idea I want to have the list be dynamic based on the cards that haven’t already been added to the list. Is this possible?

On your Cards sheet, I would create a relation to link the card name to the the card name in the Cards 2 sheet. I’m assuming that the Cards 2 sheet is where you store the selected cards from the form. In the form, then you can simply filter your choice component where the relation column you created is empty and it should only show the cards that were not already selected.

I’ll try it now thanks :slight_smile:

1 Like