PREVENT DUPLICATE

Hi is there anyone who can help me

i have a table

Name
Date
Time in
Time out

i want to prevent duplicate entry based on the value of table name and date

0 4 111
4 REPLIES 4

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-Prevent-Duplicate-Records/m-p/426296#M638...

You can create a VC with your fields concatenated to apply this duplicate valid-if technique.

I think you could use a "computed key".

It will concatenate the info of the selected columns and create a key column with it, which is automatically considered unique and AppSheet prevents duplicates

What is a key? - AppSheet Help

How to use computed key sorry im new here

Read the doc @SkrOYC included.

Top Labels in this Space