Restricting Same day, same customer

[NCD]

What would be an efficient valid if expression for,

If there's already a record that has; DATE=TODAY() and the same Customer_id, cannot create a this record

😕

[Suvrutt_Gurjar]

Please create a concatenated VC or real column ( if the new customer is being added through form) called say [DatenID] with an expression something like CONCATENATE([Date], "-",[Customer_id])

Then your valid_if in [Customer_id] column ( or any other column of the form as this will basically prevent addition of the record thru' svalid_if error) can be something like 

ISBLANK(
FILTER(
"Table Name",
([DatenID]= CONCATENATE(TODAY(), "-",[Customer_id])
)
- LIST([_THISROW])
)

Edit:  If you have many records already prepopulated in the table , then you will need to manually populate the  [DatenID] column for those existing records for at least today's records if you wish [DatenID] to be a real column. With VC that will not be a problem.

[NCD]

Did above but gives me a shows me the invalid value error message for new customers being added through form and customers that has not yet created a record 

[Suvrutt_Gurjar]

Pleas share details of your implementation such as expression, real column or VC etc. and relevant screenshots.

[NCD]

In my customer_id's Valid if;

ISBLANK(
FILTER(
"A修理依頼",
([受付日顧客]=CONCATENATE(TODAY() & " (" & [id_M顧客].[氏名]　& ")") )
)
- LIST([_THISROW])

)

in my Invalid value error;

"Cannot create same day, same customer"

but just in Japanese.

my version of [DatenID] is a VC;

CONCATENATE(TODAY() & " (" & [id_M顧客].[氏名]　& ")")

[Suvrutt_Gurjar]

What is the key column of your table?

[NCD]

[id] which is UNIQUEID()

[NCD]

made a TEST app, to make sure nothing else on my end was making this go wrong.

But seems like its the same.

You're able to create a Customer just for the first time, and every time since it'll give me an Invalid value error.

[Suvrutt_Gurjar · Accepted solution]

Please try below. I have highlighted the slight ( but important )change.

ISBLANK(
FILTER(
"A修理依頼",
([受付日顧客]=CONCATENATE(TODAY() & " (" & [_THISROW].[id_M顧客].[氏名]　& ")") )
)
- LIST([_THISROW])

)

[NCD]

ahhh, I see!

Yes it worked, Thank you very much!! 🙂