This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Adding serial numbers for different products

Posted on 12-16-2021 12:41 PM
Gokulakrishnan_
New Member
Reply posted on --/--/---- --:-- AM

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

Solved Solved
0 5 251
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
SkrOYC
Gold 5
Gold 5
In response to Gokulakrishnan_
Reply posted on --/--/---- --:-- AM 
COUNT(
  FILTER(
    "YOURTABLE",
    [PRODUCTNAMECOLUMN]=[_THISROW].[PRODUCTNAMECOLUMN]
  )
)+1

Put this instead of the MAX()

View solution in original post

Jump to Solution
5 REPLIES 5
Top Labels in this Space