Skip to main content
Question

Create incrementing number for Parent

  • July 17, 2020
  • 0 replies
  • 31 views

I am attempting to create a special format incrementing number but I am not sure where to begin.
In my parent record I have a field called "Paving bid number" which I need to increment as 20-100, 20-101, 20-102 ect.
This is based on the year 2020 and the increments start with 100 for the first record of the year with the 20 changing to 21 next year and so on. I have noticed some people use a table to define the years 2020, 2021, 2022 ect.

I am not sure where to start with these type of parameters any help is appreciated.

Thanks
Michael

------------------------------
Michael
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • July 18, 2020
Here are some links to check out.
https://community.quickbase.com/blogs/matthew-brisch1/2020/01/22/auto-numbering-in-quick-base

https://community.quickbase.com/browse/blogs/blogviewer?BlogKey=ef9eca41-cd5f-4711-bf42-f9d9f26c6c7a&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=blogviewer

You can contact me directly if you would like some help setting this up.



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