RESET NUMBER

[FATHUR]

I made a 3 digit letter number using the formula " RIGHT(Concatenate("000",[_RowNumber]-1),3) " my question, how to get the number back to 000 at the beginning of every month?

[Austin_QREW]

Hi @FATHUR 

I usually create an action that sets the values of some columns in this row back to blank. 

Check out the example below:

Let me know if this helps!

Thanks,

Austin from AppSheet Training

[Joseph_Seddik]

Welcome to the community!

Your question is missing information. How would you increment the number after resetting? How are you going to manage the rownumber component you are using in the expression?

[Ryan_Mortimer]

You can simply have a table that holds a "Static Value", then you can virtually increment from that point and reset every month (avoiding duplicates using a bit of a tricky write function too)

If your 3 letters change every month, you can include that for your concatenate too.