Preventing adding more info

[Jbryan]

Hello i wana ask how to prevent adding more than 6 duplicates Data in appshet?

[Suvrutt_Gurjar · Accepted solution]

Assuming you wish to prevent an entry of more than 6 identical values in a specific column called say [Column Name] of a table "Table Name", please  try the following expression in the Valid_if setting of the column.

COUNT(
FILTER(
"Table Name",
([_THIS] = [Column Name])
)
- LIST([_THISROW])
)<=5

Please replace "Table Name" and [Column Name] with the actual names you have.

Please test well. Please be aware that such duplicate preventing expressions may fail in a multi user environment if multiple users are trying to add/ update simultaneously.

[Suvrutt_Gurjar · Accepted solution]

Assuming you wish to prevent an entry of more than 6 identical values in a specific column called say [Column Name] of a table "Table Name", please  try the following expression in the Valid_if setting of the column.

COUNT(
FILTER(
"Table Name",
([_THIS] = [Column Name])
)
- LIST([_THISROW])
)<=5

Please replace "Table Name" and [Column Name] with the actual names you have.

Please test well. Please be aware that such duplicate preventing expressions may fail in a multi user environment if multiple users are trying to add/ update simultaneously.

[Jbryan]

Thankyou so much for the big help

[Jbryan]

Sir I have another question. Its possible to have User role in viewing the apps like only this specific person can only add and edit in the apps?

[Suvrutt_Gurjar · Accepted solution]

Yes, please take a look at the following help articles.

Control add, update, and delete operations - AppSheet Help

Security filters: The Essentials - AppSheet Help

[Jbryan]

Sir what if i sending one or many person email in notification.
in may column in enumlist if i choose two person in this column the person will receive notification. What formula or expression should I use? Thankyou so much