please kindly help me i have security filter on ...how do i prevent duplication so the two users cant enter the same records.your idea is welcome
Hi @operation
Add a column that you can name "User", with initial value USEREMAIL() and uncheck the SHOW property.
Your security filter expression will be:
[User]=USEREMAIL()
Here is an example that allows either admin role or useremail:
For reference: Security filters: The Essentials - AppSheet Help
THANK YOU...I HAVE DONE THIS ALREADY BUT THIS DIDNT PREVENT THE DUPLICATION
Das Verhindern von Duplikaten in AppSheet sehr einfach. Sie benötigen lediglich eine Validierungsformel im Feld "Gültig wenn" für die Spalte, in der Sie Duplikate verhindern möchten.
Not(In([_THIS], SELECT(Tabelle[Column_Name_for_THIS_Column], [Tabellen-ID] <> [_ThisRow].[ TableID])))
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |