Daily Counter per client

[Alejandro_Lamo1]

Hello France here I am again

I am building an app that is based on delivery.

The requirement is that each client that is asking to pick up a package in his location has to have a counter that is set up at the beginning of the day, at the end of the day it comes to be reset, then the next day the first request starts with 1.

The problem is that I'm building a table where all of the requests are recorded, I don't want to build a table for each client.

Do you have any suggestions to set up the counter for each client each day in the same table?

Best regards take care

[Marc_Dillon]

https://community.appsheet.com/t/serial-numbers-if-you-must/19325

[Alejandro_Lamo1]

Thanks very much for your quick response.Thanks very much for your quick response.I’m going to take a look at it and trade I’m not that good so it will take me some time..I will keep you posted.Best regards

[Joseph_Seddik]

1. Use a slice with a Row Filter Condition as: TODAY()
2. Use the following expression in the App Formula of the Counter column:
   
   COUNT(
     FILTER(Slice, [Customer] = [_ThisRow].[Customer])
     - LIST([_ThisRow])
   ) + 1

[Alejandro_Lamo1]

Excellent!!I will trade, I’m not very good at options yet but I’ll do my best I’ll keep you posted

.Best regards