I would like to auto generate a subtable field based on two other field with a running number , the result should be like this:
{LAST 4 DIGIT OF ORDER NO.}{MMDD OF TODAY}-{RUNNING NUMBER}
Eg.
54040518-1
54040518-2
54040518-3
54040519-1
54040519-2
54040520-1
What is the easiest way to achieve this?
I trie test out what you are trying to achieve with the built-in function. But, it seems that the built-in “auto generate” field is limited to 1 reference field. You can only select either “key field” or “date field” as the reference for creating different running numbers.
Can you provide some more context to the Main table and this subtable?
Maybe there’s other workaround.
However, if this kind of number format is a “strict” requirement.
Probably no easy way to use the existing built-in field to achieve.
Hi,
You can create multiple fields for recording/generating the separate numbers, and in your target field, you can apply formulas to combine the string to return the serial number in your desired formatting.
A great solution, but is there anyway to refer to the previous record, and +1 to it, instead of creating a field # for the numbers?
here’s a screenshot of what i want to achieve,
I want to generate the inventory Code automatically.
The running numbers should restart to 1 everytime the date changes
Only if your referenced number (I assume it’s product no.) is a selection field (selection from other sheet/linked field is acceptable as well,) then you can use auto-generate field to generate the number based on this selection field. Auto Generated Field Values
