# Create more than one guid per row

**URL:** <https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368>\
**Category:** Ask for Help\
**Created:** [August 1, 2024, 8:52pm UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368 "2024-08-01T20:52:37Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 1, 2024, 8:52pm UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/1 "2024-08-01T20:52:37Z")

</div>

I need 4 different guid on a single row. One will of course be rowid but how to create the others?

One solution I suppose could be to use a template column and exchange 1 to A, 2 to B, 3 to C

But would they still be unique within the app?  
And I suppose a bit error prone if the number isn’t found in the guid

Or would it be better to just put A, B, C in front of rowid?

Or is there a way to create a guid?

---

<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:** [August 1, 2024, 9:04pm UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/2 "2024-08-01T21:04:21Z")

</div>

Have you tried the unique ID option?

> **[Unique Identifier | Glide Docs](https://www.glideapps.com/docs/reference/values/unique-identifier)**
>
> Submit a unique ID automatically.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 1, 2024, 10:10pm UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/3 "2024-08-01T22:10:32Z")

</div>

@Jeff_Hager well - these can be used when you do an action. This won’t work for me

I have four “objects” on one line. I need to reference between the objects so when I do put the different “objects” in their respectively tables then the references are in place. That’s why I need the extra guid’s

---

<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:** [August 1, 2024, 10:40pm UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/4 "2024-08-01T22:40:00Z")

</div>

Can you explain the process a little bit? How is each object added to a row?

---

<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:** [August 2, 2024, 5:59am UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/5 "2024-08-02T05:59:33Z")

</div>

Assuming that you are using a native form to add new rows, what you could do is:

- create 4 text columns in the User Profile row to use as temporary storage.
- when your Form is opened, insert a Set Column Values step just before and use that to set new unique values in each of the 4 columns
- use those values with the form submission (User Profile Values) to populate the columns in the new row that’s being added.

If you’re using a Custom Form, then it’s essentially the same, except that you would use the Unique Values in an Add Row step.

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [August 2, 2024, 6:34am UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/6 "2024-08-02T06:34:09Z")

</div>

@Darren_Murphy I have a JSON object with a varying number of lines  
On each row (row 1…50) in a table “data-import” I pull the data from the JSON object by use of Query JSON columns. Some data belongs to “object” house, som data belongs to “object” garden, some to the “object” flowers. I will put the data afterwards to three tables by use of call API - house, garden, flowers. But I need to refer the garden to the house, and need to refer the flower to the garden.

On each row I only have access the the rowid as GUID which is to be used as the key between the related tables.

I would like to get a globally unique key for each row (independent of whether it is found in house, garden, flowers.

_So how do I create three guid’s on each row in “data-import” table_

The setup I have today gives me a key (rowid) which is unique within each table

The JSON object doesn’t have single unique key for each line-object

**Example**  
{  
“lines”: [  
{“house”: “myHouse”, “garden”: “myGarden”, “myFlower”: “grass”},  
{“house”: “yourHouse”, “garden”: “yourGarden”, “yourFlower”: “corn”}’  
]  
}

Makes sense?

---

<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:** [August 2, 2024, 8:59am UTC](https://community.glideapps.com/t/create-more-than-one-guid-per-row/75368/7 "2024-08-02T08:59:52Z")

</div>

Okay, so it’s more complicated than you first described.

If I’m understanding correctly, you essentially have a hierarchy where flowers belong to a garden, and a garden belongs to a house, yes?

If that’s correct, I think I would take a slightly different approach. Rather than trying to pre-generate the UUIDs I would just use the RowIDs that the Glide API returns. So the flow would be something like this:

- Add a House record, and capture the RowID that the API returns
- Add a Garden record, and set the HouseID to the value captured at the previous step. Capture the returned Garden RowID record.
- Add a Flower record, and set the GardenID to the previously captured Garden RowID value.

Would an approach like that work for you?
