The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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