# Do you use Row ID or Unique Identifier for things like "Order ID" and "User ID"?

**URL:** https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322
**Category:** Ask for Help
**Created:** [January 4, 2023, 1:11pm UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322 "2023-01-04T13:11:48Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Golden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golden/32/45026_2.png) [@Golden](https://community.glideapps.com/u/Golden)
#### Post date: [January 4, 2023, 1:11pm UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/1 "2023-01-04T13:11:48Z")

</div>

I’m trying to understand why I **wouldn’t** use Row ID for all unique identifiers 🤔

The answer is probably nuanced, but hearing people’s personal examples/use cases will help me understand pros/cons of using Row ID as unique identifiers.

The benefit I see of Row ID is they are …

1. easier to implement
2. more _secure_ (or reliable) since it can’t be modified

Thoughts?

Much appreciated.

---

<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: [January 4, 2023, 1:15pm UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/2 "2023-01-04T13:15:31Z")

</div>

I use (and would advise) using RowID for probably 95% of use cases.

The only time I’ll use a Unique Identifier is in a situation where a RowID can’t be used, or isn’t appropriate.

An example of this is when I’m creating a parent record and want to create one or more multiple related child records at the same time. In this situation, the ParentID (RowID) won’t be available to use with the child records, so I’ll use a Unique Identifier instead.

---

<div class="post-metadata">

### Author: ![Golden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golden/32/45026_2.png) [@Golden](https://community.glideapps.com/u/Golden)
#### Post date: [January 4, 2023, 1:17pm UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/3 "2023-01-04T13:17:08Z")

</div>

Makes sense, and I should mention that we’re using exclusively Glide Tables. Makes even more sense since we’re not using GSheets.

Thanks for your thoughts Darren!

---

<div class="post-metadata">

### Author: ![kabookie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kabookie/32/10994_2.png) [@kabookie](https://community.glideapps.com/u/kabookie)
#### Post date: [January 4, 2023, 4:27pm UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/4 "2023-01-04T16:27:38Z")

</div>

@Robert_Petitto recently posted a great video on the subject

[![](https://img.youtube.com/vi/JPgZeDSPQMw/maxresdefault.jpg "Glide: Secure Your Data with Row Owners and Public Profiles") ](https://www.youtube.com/watch?v=JPgZeDSPQMw)

---

<div class="post-metadata">

### Author: ![apaschea](https://avatars.discourse-cdn.com/v4/letter/a/ecc23a/32.png) [@apaschea](https://community.glideapps.com/u/apaschea)
#### Post date: [January 5, 2023, 3:04am UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/5 "2023-01-05T03:04:42Z")

</div>

I ran into an issue using user rowID instead of emails when applying row owners. I have a few tables that are interconnected: installations, inventory, removals, add ons.

I used user rowid in the “roles” section to be able to connect these tables but this means every user is considered private and I’m limited to 100 or so users.

But the problem with using emails is that users can’t change their emails, as it will disconnect any data that uses their previous email (those email fields in other tables are static)

Hope that made sense.

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [January 5, 2023, 6:58am UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/6 "2023-01-05T06:58:49Z")

</div>

> [@apaschea](#):
>
> I used user rowid in the “roles” section

“Roles” are really just a way to group users into an ownership group. Using RowID as the data source for roles guarantees that you will create groups of one, exactly like using an email address. So you might as well apply row ownership to the email column rather than roles to the RowID column.

> [@apaschea](#):
>
> But the problem with using emails is that users can’t change their emails

It’s clear what you are trying to do: associate the app account to a UserID instead of the user’s email address so your users can change their email address and still have access to their account. As far as I know, this is not possible: for now, access to an app is tied to a unique email address and cannot be tied to another piece of data such as a UserID, phone number or other email address.

---

<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: [January 6, 2023, 6:59am UTC](https://community.glideapps.com/t/do-you-use-row-id-or-unique-identifier-for-things-like-order-id-and-user-id/56322/7 "2023-01-06T06:59:04Z")

</div>

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