Auto numbering assets...

AppSheet AppSheet Q&A
, ,
1

Hi,

I am looking for a solution for my problem if possible?

What I am trying to achieve is auto numbering an asset in my lists. An example of the data is below.

I want to count the asset type and when I add another record it automatically assigns the next number as in the example below?

Any help will be greatly appreciated.

Asset Type Asset Name
Calorifier CAL 1
WHB WHB 1
WC WC 1
SINK SINK 1
SINK SINK 2
Calorifier CAL 2
SINK SINK 3
WHB WHB 2
Calorifier CAL 3
2

Welcome to the community!

You just have to count how many entries of the same type is already in the table and increment this count. For example:

COUNT(
FILTER(tableName, [Asset Type] = [_ThisRow].[Asset Type])

  • LIST([_ThisRow])
    ) + 1
3

Hi Joseph,

Thanks for your suggested resolution.

The formula is giving me the same number for each asset as I add more
rather than each asset being consecutively numbered.

Kind Regards,

James Gaunt

4

Serial Numbers, If You Must - Google Cloud Community