Create incrementing number for Parent

Question

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
------------------------------

markshnier__you · Answer

Here are some links to check out.https://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=blogviewerYou can contact me directly if you would like some help setting this up.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

michaelhall · Answer

Thanks Mark. I will integrate this into my table and see if I can customize the parameters
To work the way we need it to. If not I will email you back.
&nbsp;
Thanks again
&nbsp;

&nbsp;
&nbsp;&nbsp;&nbsp; 
&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Michael L. Hall | Excavation |&nbsp; Survey Mgr | RPM xConstruction, LLC
&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONFIDENTIALITY NOTICE - The information contained in this transmission, including attachments, may be (1) subject to the Attorney-Client Privilege, (2) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you are notified that you may not disclose, print, 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;copy or disseminate this information. If you have received this transmission in error, please reply and notify the sender (only) and delete the message. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unauthorized interception of this e-mail may be a violation of criminal law. 
&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;

Forum Discussion

Create incrementing number for Parent

Related Content

Roundup whole number

Pipeline to Concatenate Text and Increment Numbers

Calculating number of days between two date fields

AI Smart Builder for Creating Apps and Streamlining Pipelines

Add hyphens to phone number field