# Adding Row ID as Role From another Table?

**URL:** <https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925>\
**Category:** Ask for Help\
**Created:** [June 19, 2023, 11:32am UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925 "2023-06-19T11:32:30Z")\
**Posts on this page:** 6\
**Page:** 3

<div class="post-metadata">

**Author:** ![mondrew](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mondrew/32/60553_2.png) [@mondrew](https://community.glideapps.com/u/mondrew)\
**Post date:** [June 25, 2023, 2:01pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/42 "2023-06-25T14:01:11Z")

</div>

Darren, you’re absolutely right… there is something simple I’m missing… I’m sure of it.  
🙂 I’d be happy to give you access. Can you DM me your email?  
Andrew

---

<div class="post-metadata">

**Author:** ![mondrew](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mondrew/32/60553_2.png) [@mondrew](https://community.glideapps.com/u/mondrew)\
**Post date:** [June 25, 2023, 2:31pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/43 "2023-06-25T14:31:39Z")

</div>

Darren found the issue in two seconds. (Thanks Darren!) I created a Users table as a BigTable, which isn’t supported. Meaning, a user table cannot be a BigTable.

I created a new User table as a normal Glide Table and it works as expected.  
Whew. Thank you!

- Andrew

---

<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 25, 2023, 2:37pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/44 "2023-06-25T14:37:14Z")

</div>

That one was a bit tricky. Normally you can spot a Big Table by the distinctive icon next to the table name. But in this case that was obliterated by the blue icon that indicates it’s the Users table.

![CleanShot 2023-06-25 at 22.33.11@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/364474c38336ad26e11c4ed423075c5553b688ea.png)

But the second thing you can use to identify a Big Table is the row count next to the table name. It took me an extra second to spot that 😉

Anyway, I’d say this is a bug in the sense that Glide should not have let you select that table in the first place. I’ve reported that.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 25, 2023, 2:42pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/45 "2023-06-25T14:42:04Z")

</div>

Hey Andrew glad you got it sorted and thanks for sharing what you found! Thank you Darren and to all the experts always willing to lend a hand.

@Darren_Murphy it would also be nice if there was some type of Big Table designation somewhere above headers in editor 😉

---

<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 25, 2023, 2:45pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/46 "2023-06-25T14:45:46Z")

</div>

Not a bad idea.  
I’ve gotten into the habit of prefixing my Big Table names with BT, which essentially achieves that 🙂

 ![CleanShot 2023-06-25 at 22.44.36@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/7938d14bf9e7402d2f0c51fb40ee6d08bdf290f2.png)

hehe… you could also do something like this:

![CleanShot 2023-06-25 at 22.47.46@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d3f5887cb2f7d41258405b3dd645122f9fdf9ca.png)

😃

---

<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 26, 2023, 2:46pm UTC](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925/47 "2023-06-26T14:46:12Z")

</div>

Closed on June 26, 2023, 2:46pm UTC

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

[Previous page](https://community.glideapps.com/t/adding-row-id-as-role-from-another-table/62925.md?page=2)
