Restricting Same day, same customer

NCD
Silver 2
Silver 2

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

๐Ÿ˜•

Solved Solved
0 9 207
1 ACCEPTED SOLUTION

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

ISBLANK(
FILTER(
"Aไฟฎ็†ไพ้ ผ",
([ๅ—ไป˜ๆ—ฅ้กงๅฎข]=CONCATENATE(TODAY() & " (" & [_THISROW].[id_M้กงๅฎข].[ๆฐๅ]ใ€€& ")") )
)
- LIST([_THISROW])

)

View solution in original post

9 REPLIES 9
Top Labels in this Space