Hello. Part of the app I am building requires me to check that a client receives no more than one token a day. I have built a column that combines the client ID with the today’s date =CONCATENATE([ID], DATE(TODAY())) so I have a unique text in that column that indicates that the token was consumed today. What I thinking is to use the editable field in a column to check if CONCATENATE([ID], DATE(TODAY())) exists, If it already exists the field is not editable and no token will be issued. If it does NOT exist that it is OK to click YES and and issue the token.
In short is there a quick way to check if a text CONCATENATE([ID], DATE(TODAY())) exists in a column and return a TRUE or FALSE? Thanks