How to base the initial value of a column on a counter

[B_Reyes]

Hello!

One of my inventory app's column contains our items' barcodes.

I would like to make that for each record made, that column will have an initial value based on the previous record's barcode value (eg. if previous record has a barcode of 00000123456, then the barcode column of the new record must have an initial value of 00000123457). 

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2357309-lookup

https://help.appsheet.com/en/articles/2357310-maxrow

https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216

[B_Reyes]

Thank you! 

I tweaked the formula from "How do I get a column value from the last row of the spreadsheet?" (from the third link @Marc_Dillon provided), converting it to a numeric value (using the VALUE function) and adding 1 so it can be a counter. Then, the prefix of 0's can be concatenated with the resulting value.

[dbaum]

See also  Serial Numbers, If You Must - Google Cloud Community . 

[B_Reyes]

Thank you this works too!