+5
Concerns;
Customer requires to make auto number of Product Serial No with specific rule such as;
YYMnnnn
YY means 2digits of year
M means a month such as A as Jan, B as Feb…
The date could be production date.
Is it possible with no customization?
Regards;
+24
Hi
You should be able to set verification on the field using the UI desinger that uses a regular expression created on the regular expression screen found under Studio when using a Studio licensed user to make sure the entry matches the format you need.
If this needs to not rely on user input then you would need to look more at using a business rule that updates the serial number based off of the entries in the relevant fields. You would likely need to use some of the user_def fields to hold the year and month so that the business rule can then select them and combine for the serial number. I would suggest using the product ID to populate the numerical part in this case to ensure the numbers are unique.
+5
Hi Lee
Thank you for your reply.
I will share this with my designer.
Regards
Yasuda
Ifs partner in Japan
+5
Hi
By the way,
What is PRODUCT ID?
Regards
Yasuda
+24
Hi
Product_ID is the out of the box name for the field that stores the system generated unique key for each product record. You may have altered this to display with a different name in the front end but the database field will still be product_id.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.