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

3 Replies

Related Content

Looking for State abbreviation to full spelling formula

Relationships functional question

Nz Function - Formula Help

Do unused tables related to currently used tables cause functionality problems?

Odd question looking for guidance

Recent Discussions

Calendar Reports not Loading

Pipelines and Filters

"Button" Data Refresh Quirk

Year Formula help

Passing fields from Child to Parent