# Assigning unique IDs within column cateogry

**URL:** <https://community.glideapps.com/t/assigning-unique-ids-within-column-cateogry/63415>\
**Category:** Ask for Help\
**Created:** [July 2, 2023, 11:38pm UTC](https://community.glideapps.com/t/assigning-unique-ids-within-column-cateogry/63415 "2023-07-02T23:38:58Z")\
**Posts on this page:** 1\
**Showing post:** 7

<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:** [July 3, 2023, 12:39pm UTC](https://community.glideapps.com/t/assigning-unique-ids-within-column-cateogry/63415/7 "2023-07-03T12:39:08Z")

</div>

Try this:

- Add a RowID column to your table.
- Create a multiple relation column that matches the shelter name with itself
- Create a Lookup column targets the RowID column via that relation. This will give you an array of RowIDs
- Use the Find Element Index column to find the index of the RowID in the array of RowIDs
- Use that in a template column to assign the ID to each dog.

Here is what that might look like:

 ![CleanShot 2023-07-03 at 20.34.34@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bbfe65d49867b0e0167a4bd42a09e6a8c899f1b9.jpeg)

Note that array indexes are zero based. If you want to start at 1, you could use a math column to add 1 to the index.

---

_[View the full topic](https://community.glideapps.com/t/assigning-unique-ids-within-column-cateogry/63415)._