LinkedIn
Twitter
Hello everyone
I'm having trouble making a Lot or Serial formula for a product.
Here is the table that wants to issue Lot or Serial numbers of products. There will be columns as follows:
1.ID_LOT
2.DATE
3. MODEL ( full name )
4.CLAN
5. LOT NO ( column that issued the product number )
6.QTY
7.BARCODE
8. MODEL SHORT (VIRTUAL COLUMN)
There will be 3 columns that are used to issue product numbers, which are these 3 columns.
2.DATE
5. LOT NO ( column that issued the product number )
8. MODEL SHORT (VIRTUAL COLUMN)
and i want it to display like this like
GE50C22010001 Sort model, year, month, 4 digits run code 00010002, but want it to run per model.
For example Ge50c model, clicked to run 2 times, if + new must be GE50C22010003 Need to run per month and per model
And the model that doesn't have data has to go up RDC22020001, RDC22020005 or if there is data, then run the next number.
If starting a new month, you have to run a new number, for example:
GE50C22010001
GE50C22010002
change a new month
GE50C22020001
GE50C22020002
(model name, year, only the last 2 digits, 2 month numbers, 4 running numbers
But now using this formula But it must be words But what model would you like to have time to choose? The number runs accordingly.
CONCATENATE("09S", RIGHT("00"&RIGHT(YEAR(TODAY()), 2), 2),
RIGHT("00"&RIGHT(MONTH([date]),2), 2),
RIGHT("000"&(COUNT(FILTER("09S", MONTH(TODAY())=MONTH(TODAY())))[_RowNumber])
, 3)
)
# "09s " is the model name, but I need it when selecting what model? The product number is up according to that model.
But the formula used is It's only one model. but want to use column selection instead
The desired example is like this.
You could try the following in the Initial Value of the column lot.
Please carefully observe the col names of the expression and the sample table I used.
CONCATENATE([name],
RIGHT("00"&RIGHT(YEAR([creation date]), 2), 2),
RIGHT("00"&RIGHT(MONTH([creation date]),2), 2),
RIGHT("000"&(COUNT(FILTER("Product Names",AND([name]=[_THISROW].[name], MONTH([creation date])=MONTH([_THISROW].[creation date]))[_RowNumber])) + 1), 3)
)
