Looking for best practice to achieve below functionality

Question

How we can generate a 5 digit auto incremented sequence for a field in a particular table.
For Example:
Row 1 : 00001
Row 2 : 00002

------------------------------
Rajeev Shukla
------------------------------

markshnier__you · Answer

The best practice is to use the [Record ID#] field and make a formula from it.

Try this as a formula text field.

PadLeft(ToText([Record ID#]), 5, "0")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

rajeevshukla · Answer

Thanks Mark ,This looks promising ,But we can not use&nbsp; [Record ID#]&nbsp; field as we are going to reset this sequence in end of every year .&nbsp;Idealy, we want to update one field&nbsp; ProjectID&nbsp; whenever a record is added in that Table&nbsp; .#1 Format Will be (Field1-CCYY-Sequence&nbsp;of 5 Digit)CC- Country CodeYY- Year(Last two digit of year i.e 2020 it will 20)Field1 - Another column in the same Table.For Example Project ID&nbsp; : 2536-US20-00025 (Complete Format we need ).We will reset the sequence at end every year.Please provide you suggestion on the same&nbsp;Thanks,​------------------------------Rajeev Shukla------------------------------

markshnier__you · Answer

Here are some posts on that topichttps://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=d30c143b-d701-410b-b933-bc4874f403b6&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=digestviewerhttps://community.quickbase.com/blogs/matthew-brisch1/2020/01/22/auto-numbering-in-quick-basehttps://community.quickbase.com/browse/blogs/blogviewer?BlogKey=ef9eca41-cd5f-4711-bf42-f9d9f26c6c7a&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=blogviewer------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Looking for best practice to achieve below functionality

Related Content

A way to look up a previous Record ID's [Date Created] Field

Looking for State abbreviation to full spelling formula

Nz Function - Formula Help

Jinja Date functions

Mobile App Functionality