Help

Block/grey elments when they are allocated to one user

Topic Labels: Formulas
Solved
Jump to Solution
1019 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Arnaud_Pezeron
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

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

See Solution in Thread

3 Replies 3
Mohamed_Swella1
13 - Mars
13 - Mars

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

Arnaud_Pezeron
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Arnaud_Pezeron
5 - Automation Enthusiast
5 - Automation Enthusiast

Dear @Mohamed_Swellam
so easy thanks to you :grinning_face_with_big_eyes: :+1:t2:
Great thanks