Adding serial numbers for different products

[Gokulakrishnan_]

I have a form set up and i want a sequential numbering formula to make sure the following happens.
17/12 /2021 - Product A - A00001
17/12 /2021 - Product B - B00001
18/12 /2021 - Product A - A00002
19/12 /2021 - Product A - A00003
20/12 /2021 - Product B - B00002

[SkrOYC]

Here is a good topic about it

Serial Numbers, If You Must Tips & Tricks 💡

Danger Ahead! In general, sequential numeric identifiers (i.e., serial numbers) are risky in AppSheet: if two users happen to add rows at the same time, both rows could be assigned the same serial number, which could lead to confusion (at the least) or data loss (at the worst). For this reason, serial numbers are strongly discouraged! Basic Serial Numbers One way to implement serial numbers is with a normal (not virtual) column named (e.g.) Serial of type Number and an Initial value expression …

[Gokulakrishnan_]

this will be only used by one user. (MAX(MyTable[Serial]) + 1), how do i change this to accommodate what i want?

[MultiTech]

CONCATENATE(
  right([Product Name], 1), 
  right(
    concatenate(
      "0000", 
      MAX(MyTable[Serial]) + 1
    ), 
    5
  )
)

• That first part (with the right(product name) bit…) is only there to get the “A” “B” or whatever value from the product name.
  • You might find better ways to get that

[Gokulakrishnan_]

the issue im getting with this is
17/12 /2021 - Product A - A00001
17/12 /2021 - Product B - B00002
18/12 /2021 - Product A - A00003
19/12 /2021 - Product A - A00004
20/12 /2021 - Product B - B00005

[SkrOYC · Accepted solution]

COUNT(
  FILTER(
    "YOURTABLE",
    [PRODUCTNAMECOLUMN]=[_THISROW].[PRODUCTNAMECOLUMN]
  )
)+1

Put this instead of the MAX()