Hello,
I have a table that has a column named โStatusโ. The value for that column may only be โOpenโ or โClosedโ.
There should be no more that one record in an โOpenโ state.
How do I make it so that a user can only add a new record when all other records are in a โClosedโ state?
Thanks in advance
Stel
Solved! Go to Solution.
It sounds that you are basically looking for preventing duplicate occurrences in the [Status] column for one of the enum options Please take a look at the following articleโs last section on avoiding duplicates.
In your case I believe since you wish one of the enum options only to be non duplicate, you could revise the expression something like below
IF([Order Status]=โOpenโ,
ISBLANK(
FILTER(
"Table Name",
โOpenโ= [Status]
) - LIST([_THISROW])
),
TRUE
)
It sounds that you are basically looking for preventing duplicate occurrences in the [Status] column for one of the enum options Please take a look at the following articleโs last section on avoiding duplicates.
In your case I believe since you wish one of the enum options only to be non duplicate, you could revise the expression something like below
IF([Order Status]=โOpenโ,
ISBLANK(
FILTER(
"Table Name",
โOpenโ= [Status]
) - LIST([_THISROW])
),
TRUE
)
Thanks. That worked well.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |