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

[SkrOYC]

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:

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…

As I have shown in that topic, there are workarounds. But it’s not intuitive for a new user that even if the field with the valid_if is uneditable it won’t be able to save a form just for that valid_if rule.
Just to name some examples of date-dependant valid_if:

1. You have a Slice that just shows the records made between a week ago and today and you use that Slice as a Valid_If dropdown list. Once the record you have selected from that Slice is out of the Slice, maybe a week in the future, you won’t be able to edit the record because now the field doesn’t meet the validation rule you made.
2. You want to allow the users to add a Date that’s between today and 5 days in the future. Then they added one record with today’s date. Once the user have added the record and you want to edit another field of the record tomorrow, you won’t be able to save it because the validation rule says that the date field have a date that is not between today and 5 days in the future.

One that’s not date-dependant:

1. There is a list of Items that you can select. You have a Valid_If that lists all the items that are available. Once the items are market as unavailable (maybe that column is a Y/N type) and you want to edit the record, you won’t be able to save the record because the validation rule says you need to select just the items marked as available=true.

The idea is to have a toggle to add different Valid_If for Adds and Edits inside the editor.

Something like
“Valid If for edits
Does the column needs a different validation rule if the record is being edited?”
And if we toggle it on, to be allowed to add an expression accordingly, right under the actual Valid If

PS: If you want to post one of the workarounds you use for this, please check the post mentioned above