# Need Help Implementing Feature

**URL:** <https://community.glideapps.com/t/need-help-implementing-feature/73041>\
**Category:** Ask for Help\
**Created:** [May 3, 2024, 2:48pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041 "2024-05-03T14:48:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dustin\_Slaughter1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dustin_slaughter1/32/65980_2.png) [@Dustin\_Slaughter1](https://community.glideapps.com/u/Dustin_Slaughter1)\
**Post date:** [May 3, 2024, 2:48pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041/1 "2024-05-03T14:48:21Z")

</div>

So my company has 2 different divisions.

Division 1 - Job Numbers are 2000TL and up, (example)  
Division 2 - Job Numbers are 50000TL and up (example)

When making a new Job Number, i will select which division the job number will be created for.  
ant it will keep track of auto-incrementing the job numbers as a new one is added… The problem is, i dont want to create 2 tables to track jobs, just want to one table.

How can i implement this?

Example: Next Job Numbers Avaiable

2011TL was last used, so 2012TL is next IF for Division 1  
50064TL was last used , so 50065TL is next, if Division 2

---

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 3, 2024, 4:59pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041/2 "2024-05-03T16:59:08Z")

</div>

Are the letters (TL) fixed? You could create one table called ‘Factories’ with just two lines for the two factories. Columns in here would be the base number (static) and a field which increments based on a lookup count back to a table of items - ie shows the total number of items in factory x plus one (the next item number). You could use a template to add on your prefix and suffix.

When you create your new item in the items table use a relation/lookup through an action (eg on form submit) to take the ‘next’ number on the factory table and add it to the field on the items table.

---

<div class="post-metadata">

**Author:** ![Dustin\_Slaughter1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dustin_slaughter1/32/65980_2.png) [@Dustin\_Slaughter1](https://community.glideapps.com/u/Dustin_Slaughter1)\
**Post date:** [May 3, 2024, 5:27pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041/3 "2024-05-03T17:27:05Z")

</div>

Wow. Duh.  
Each employee has the capability of writing a labor ticket. And have their own assigned Ticket number.

Each ticket they create in increases by one.

I can use this same concept, exactly how you explained, is exactly how im already doing for that.  
Cant believe i didnt think of that! Thank you so much

---

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 3, 2024, 6:53pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041/4 "2024-05-03T18:53:52Z")

</div>

glad it worked for you! Would you flag my answer as the solution?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 10, 2024, 6:53pm UTC](https://community.glideapps.com/t/need-help-implementing-feature/73041/5 "2024-05-10T18:53:57Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.