#  COMPUTER INVENTORY APP

**URL:** <https://community.glideapps.com/t/computer-inventory-app/58677>\
**Category:** Ask for Help\
**Created:** [March 2, 2023, 2:50pm UTC](https://community.glideapps.com/t/computer-inventory-app/58677 "2023-03-02T14:50:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_S\_Gomes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_s_gomes/32/55123_2.png) [@Daniel\_S\_Gomes](https://community.glideapps.com/u/Daniel_S_Gomes)\
**Post date:** [March 2, 2023, 2:50pm UTC](https://community.glideapps.com/t/computer-inventory-app/58677/1 "2023-03-02T14:50:32Z")

</div>

I’m creating an IT equipment inventory APP in GLIDE and I’m not able to move forward with two needs.  
Here’s my scenario:

I have a spreadsheet yesterday where all my equipment is registered.

I have a Glide table for each column in the worksheet.

That is, when adding a new piece of equipment to the spreadsheet, the glide lists the data registered in the glip tables.

1- In the registration information of a new equipment, in the table where the data are, there are two fields: OWNER and IMAGE.  
I need that, at the time of castration of this item, it is identified that company A was selected and in the image field, the image of this company is added.

2- I am creating an inventory with the following serial number:  
COMPANY A: 1 to 200

COMPANY B: 201 to 400.

COMPANY C: 401 to 600.  
How do I create an automatic serial number increment based on company selection?

Thank you very much in advance!!!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [March 2, 2023, 3:13pm UTC](https://community.glideapps.com/t/computer-inventory-app/58677/2 "2023-03-02T15:13:09Z")

</div>

Here’s one way to do automatic increment:

> [@open\_mailbox\_with\_raised\_flag Create a Referral Code System with CUSTOM and UNIQUE User Codes](https://community.glideapps.com/t/create-a-referral-code-system-with-custom-and-unique-user-codes/37944):
>
> wave Hey all! In this video, I demonstrate how to generate short, pretty and unique codes per user to be used as IDs or invite codes and how to use these codes to create a referral system for your app. This tutorial is great for creating: Invite codes Unique User IDs that are prettier than Row IDs Order IDs Item IDs …etc. popcorn Enjoy! [[Glide: Create a Referral Code System with CUSTOM and UNIQUE User Codes] ](https://www.youtube.com/watch?v=CkBk6m_9Wxk)