PREVENT SAME MONTH DATE

AppSheet AppSheet Q&A
1

PLEASE HOW DO I PREVENT SAME MONTH DATE IN DATA FILED

I WANT PREVENT DATE FROM THE SAME MONTH
I WANT PREVENT DATE FROM THE SAME MONTH425Ă—295 17.6 KB

2

Valid if formula for date field:

NOT(IN([_THISROW].[Date], ThisTableName[Date]))
3

Hi @Markus_Malessa ,

I believe this expression will not allow the user to edit the same row again , should the user wish to edit the saved row for some other column. This is so because for a saved record, the valid_if will always fail by detecting the date as already present the in the table.

I think one needs to use an approach mentioned in the article below at the end on avoiding duplicates. Again even this approach will at times fail in a multi user environment.

List expressions - AppSheet Help

So the expression in this case can be something like

ISBLANK(
FILTER(
“Table NAme”,
([_THIS] = [Date])
)

  • LIST([_THISROW])
    )

The expression basically ignores the current record’s date in the valid_If expression by using [_THISROW] . This allows editing of a saved record also.

4

You are correct, this would prevent editing this particular row. You don’t even know how often I forget that detail until I can’t edit a row.

5

Scratch my previous response and go with @Suvrutt_Gurjar suggestion. My suggested solution would prevent making further edits to the current row because the valid if would fail every time you tried making an edit to a row.

6

One solution is to use EOMONTH(TODAY()) with the key column.

7

YOU ARE JUST BRILLIANT …THANK SO MUCH

8

THANK SO MUCH :face_blowing_a_kiss:

9

THANK SO MUCH ALEKSI …AM ALWALYS GREATFUL

10

THX SO MUCH THAT IS BRILLIANT :face_blowing_a_kiss:

11

Sorry sir.. Please this formula is preventing other users to save their work kindly help