What is Subform Auto-Numbering?
For now, the subform does not support adding a serial number field directly, but we can achieve automatic numbering within subforms by leveraging functions. This approach allows the system to generate unique identifiers for each row of subform data, which can also be referenced elsewhere as needed.
Where Can You Use It?
This solution is applicable in various scenarios, such as Product Management, Contract Management, and Equipment Inspection. These identifiers help maintain structure and traceability within the subform records.
What Does It Look Like?
When you add data to the subform, it can automatically generate a number.
How to Set It Up?
Here we take the Inventory Management form as an example.
Step 1 Creating a Form
Create an inventory management form that includes the following fields:
Field Name | Field Type |
Entry Date | Date&Time |
Random Code Set | Single Line |
Inventory Details | SubForm |
No. | SubForm-Single Line |
Random ID | SubForm-Single Line |
Item Name | SubForm-Single Line |
Quantity | SubForm-Number |
Step 2 Setting the Formula
1. Select the Random ID field. Go to Field Properties > Initial Value, and choose the Formula from the drop-down list. Click Edit.
2. In the formula editor, input the function for generating the random ID:
UUID()
3. Set the formula for the Random ID Set field and No. field in the same way:
For Random ID Set:
CONCATENATE(Inventory Details.Random ID)
For No.:
(SEARCH(Inventory Details.Random ID,Random ID Set)-1)/36+1
Step 3 Hiding Field & Assigning Values to Hidden Fields
If needed, you can hide the Random ID and Random ID Set fields by unchecking the View permission, making the form more aesthetically pleasing.
To ensure accuracy, you still should enable Always Recalculate for these two fields: click the target field, go to Form Properties > Hidden Field Default Value, and select Always Recalculate from the drop-down list.
These are the complete steps to seamlessly add serial numbers to your subforms. Dive into the process and give it a try!
I have finished reading. 🏆
👉I can't wait to Try for myself.
👉I need more HELP in Discord Forum.