Only count when created not when edited

[Daniel_Arguello]

Good day

I have the following restriction for product name records, which must be unique
“NOT (IN ([_ THIS], SELECT (products [Product Code], [Product ID] <> [_ThisRow]. [PRODUCT ID])))”
The problem is when they want to edit or update a product, it does not allow it since it retells the restricted column.

I would like to know how it can be done so that it only counts when the product is created and not when it is being edited.

Thanks

[SkrOYC]

Different Valid_If for Adds and Edits Tips & Tricks 💡

I’m posting this here to help anyone with this problem but I’ll make a Feature Request about it. You have made a really good and strong Valid_if expression so that just certain criteria should be checked before saving a new record. It works great for that porpuse! BUT, then you realize that you can’t successfully edit the same record if the criteria is not made. I’ll give an example: You have a Date column and you want the users to be able to just add records that are between 5 days ago an…

Different Valid_If for each case: Add new record to a table and Edit an old record Feature Requests

Sometimes you have a good validation rule that makes sense if the record is being made for the first time, like making sure a date is inside a certain range or, basically, any data that is date-dependant. The problem is that if you are going to edit that record sometime in the future you will not be able to save it if the validation rule is checking the data against your date-dependant rule. I made an example here if you are instered: As I have shown in that topic, there are workarounds. But…

[Suvrutt_Gurjar]

Also please take a look at the last section on avoiding duplicates in the article below.

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.