May 13, 2020 10:24 AM
I want to allocate a list of numbers (product limited editions) to users. They will pick one by one their selected number and I want this number not to be avaliable anymore after the selection.
Do you know how to do that ?
Thanks a lot
Solved! Go to Solution.
May 13, 2020 11:06 AM
Hi @Arnaud_Pezeron,
Depending on your Base setup, I would prefer that you have the Users linked from a separate table, which will create a new field in your Items table called Users. Once a user selects an item, the User field will be populated with the name of the user. You can then create a view called “Available Items” where you filter out User field with the argument “Not Empty”. So you will not see any item that has already been chosen.
If I understand correctly Users are choosing the items from a Form? Link the Items to this specific view and this should help you out.
BR,
Mo
May 13, 2020 11:06 AM
Hi @Arnaud_Pezeron,
Depending on your Base setup, I would prefer that you have the Users linked from a separate table, which will create a new field in your Items table called Users. Once a user selects an item, the User field will be populated with the name of the user. You can then create a view called “Available Items” where you filter out User field with the argument “Not Empty”. So you will not see any item that has already been chosen.
If I understand correctly Users are choosing the items from a Form? Link the Items to this specific view and this should help you out.
BR,
Mo
May 13, 2020 12:00 PM
Hi @Mohamed_Swellam ,
that’s definitely a good approach, let me try it and come back to you with the feedback :+1:t2:
Thanks for your support.
Best
Arnaud
May 13, 2020 12:07 PM
Dear @Mohamed_Swellam
so easy thanks to you :grinning_face_with_big_eyes: :+1:t2:
Great thanks