Hello,
I have a table and a user should only be allowed to enter 30 entries, and if they want to add more they need to delete old ones first.
Is there any way to limit the number of rows a user can enter?
Thanks,
Stephen
Solved! Go to Solution.
Use this for a valid_If in a column
COUNT(Select(TableName[RowName],[CreatedBy]=UserEmail())) <=30
Tablename[CreatedBy] Should have a initial value of UserEmail()
Use this for a valid_If in a column
COUNT(Select(TableName[RowName],[CreatedBy]=UserEmail())) <=30
Tablename[CreatedBy] Should have a initial value of UserEmail()
Thank you Simon. That worked great.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |