Solved: Generating unique code that restart every month - Page 2

Yogi_Hayate · 03-21-2022 02:53 AM

Hi Everybody,

I am looking the best way to generate my ID sequentially, I would make my [_rownumber] restart and start over to one (1) every month.

I had tried to write my code in my [ID Column] Formula like this, However, the rows keeps continue even the months has changed.

CONCATENATE("SPK",
"/",
"PTG",
"/",
LEFT(DATE([Tgl_Ptg_Bhn]),2),
"/",
LEFT(MONTH([Tgl_Ptg_Bhn]),3),
"/",
RIGHT(YEAR([Tgl_Ptg_Bhn]),2),
"/",
[_RowNumber])

How to automate [_RowNumber] to start over every month?

Suvrutt_Gurjar

@Yogi_Hayate ,

[_ROWNUMBER] is a system assigned number that is dependent on the row number of the backend spreadsheet. So the app creator cannot change it.

Unless the app is a purely single user app, you may wish to take a look at the following posts and articles before implementing any sequential number generating system. AppSheet does not recommend using sequential number generating in its apps.

https://help.appsheet.com/en/articles/1726585-sequential-keys

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Serial-Numbers-If-You-Must/m-p/286300

View solution in original post