# Increment values in a column of data by 1

**URL:** <https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003>\
**Category:** Ask for Help\
**Created:** [June 21, 2023, 8:35am UTC](https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003 "2023-06-21T08:35:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![KenT](https://avatars.discourse-cdn.com/v4/letter/k/b782af/32.png) [@KenT](https://community.glideapps.com/u/KenT)\
**Post date:** [June 21, 2023, 8:35am UTC](https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003/1 "2023-06-21T08:35:09Z")

</div>

I have simple tables of data to work with in an App, as a non-coder! The first column (1) is a GUID generated by the app, thats only used very occasionally. Second column (2) is a visible identifier seen by users and is context specific.

For a controls data table example: Column 2 (named Control ID) , Row 1 = ‘Con 01’  
Column 2 (named Control ID) , Row 2 = ‘Con 02’  
Column 2 (named Control ID) , Row 3 = ‘Con 03’

For a risks data table example: Column 2 (named Risk ID) , Row 1 = 'Ris01  
Column 2 (named Risk ID) , Row 2 = 'Ris 03  
Column 2 (named Risk ID) , Row 3 = 'Ris 03

These visible IDs should generate as the data tables are opened for new entries to be added to the table.

Any suggestions for how to do this?

thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 21, 2023, 8:42am UTC](https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003/2 "2023-06-21T08:42:42Z")

</div>

The below might help:

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

---

<div class="post-metadata">

**Author:** ![KenT](https://avatars.discourse-cdn.com/v4/letter/k/b782af/32.png) [@KenT](https://community.glideapps.com/u/KenT)\
**Post date:** [June 21, 2023, 10:28am UTC](https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003/3 "2023-06-21T10:28:25Z")

</div>

Most useful, thank you. Realise now the limitations I have in the App platform to add relationships and such. I’m on a long learning curve!

---

<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:** [June 22, 2023, 10:30am UTC](https://community.glideapps.com/t/increment-values-in-a-column-of-data-by-1/63003/4 "2023-06-22T10:30:41Z")

</div>

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