Good morning, all. I have my first app almost working pretty well, its been a fun learning experience with plenty more to go. This morning, I am hoping to build in some sort of duplicate testing to make sure that things don't get entered twice. I looked at this article:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-Prevent-Duplicate-Records/m-p/322114
In that article, they give this an as example:
Not(In([_THIS], SELECT(Table[Column_Name_for_THIS_Column], [TableID] <> [_ThisRow].[TableID])))
I am trying to understand this expression and adapt it for my uses but am having some trouble with syntax.
My data has a dynamically generated UNIQUEID() for the key on each record created. Each record also has a First Name, Middle Name, and Last Name field, as well as date of both.
I have a virtual column in AppSheet called Full Name that concatenates the three name fields.
I am hoping to adapt this script to check the virtual column Full Name as the user is typing, so that if the first,middle, and last name comes up as a match, a message is displayed onscreen that the name already exists in the data.
So, breaking down the example above, we have the entry is valid if
The value is NOT in the selected table and column. I Think that is the only part that is clicking. I'm not sure i understand what comes after the comma, [Table ID]<>[_ThisRow].[TableID]
Still looking at tutorials and reading the expression guide on some of these things, but if you have a better way of explaining the above sample expression, i'm all ears.
Also, can a virtual table be used to hunt for duplicates? If not, i need to figure out some other way to make these comparisons.
Thanks
LinkedIn
Twitter
