# Automatically Create Item Code if Slider is Engaged?

**URL:** <https://community.glideapps.com/t/automatically-create-item-code-if-slider-is-engaged/4089>\
**Category:** Ask for Help\
**Created:** [January 29, 2020, 10:58pm UTC](https://community.glideapps.com/t/automatically-create-item-code-if-slider-is-engaged/4089 "2020-01-29T22:58:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RyanThomas](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@RyanThomas](https://community.glideapps.com/u/RyanThomas)\
**Post date:** [January 29, 2020, 10:58pm UTC](https://community.glideapps.com/t/automatically-create-item-code-if-slider-is-engaged/4089/1 "2020-01-29T22:58:12Z")

</div>

Here is my app.

[https://lrgvy.glideapp.io](https://lrgvy.glideapp.io)

Here is my sheet as well:

> **[Master Inventory File - Glide](https://docs.google.com/spreadsheets/d/1L2ABRea28zJ5T2QQjD1IiL1SvrBrTXqs0rBamDKMYN8/edit?usp=sharing)**
>
> Shop Items Kanbans
> 
> PRINT AT 65% SIZE.
> I-CODE #:101867
> DESCRIPTION,2" PACKING TAPE
> ORDER QTY,6
> PART NUMBER,TK-011
> MANUFACTURER,TAPE KING
> VENDOR,AMAZON
> AISLE,SHELF,Tracked in Inventory
> 12,I
> NOTES
> Order Qty,Ordered Date,Received Date

Basically I am just trying to make an easy to access database for all the items that we either sell or use in our shop.

For the items we sell, the Item Code, or I-Code, is created in another system and we have to reference it here. For items we use in the shop, we wanted to create our own Shop I-Code for reference.

I have figured out how to display either the shop I-code or the regular I-code depending on whether or not it is a sales item.

The issue I’m running into though is how can we easily know what to enter for the Shop I-Code, since that has to be generated by us, I would love for them to just be sequential order…Does anyone have any ideas on how to achieve this?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 7, 2020, 6:51am UTC](https://community.glideapps.com/t/automatically-create-item-code-if-slider-is-engaged/4089/2 "2020-02-07T06:51:26Z")

</div>

There’s a bunch of scripts out there that should do what you want. Here’s something to get you started.

> <https://stackoverflow.com/questions/55323579/is-there-a-way-to-auto-increment-id-code-of-qa-on-google-sheets>