# User ID being written to a User Specific Column

**URL:** <https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418>\
**Category:** Ask for Help\
**Created:** [July 3, 2023, 4:32am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418 "2023-07-03T04:32:03Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\
**Post date:** [July 3, 2023, 4:32am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/1 "2023-07-03T04:32:03Z")

</div>

And then I need to group those users, but it won’t show them - private or something? (I’m using unique ID in case they want to change their email address)

![Screenshot 2023-07-03 at 4.30.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c03e6fe7a0c3cbdd6aa8e471c690459e68e48f4e.png)

---

<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, 7:44am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/2 "2023-07-03T07:44:20Z")

</div>

User Specific column values are unique to each user, meaning that each user sees their own value for any given row, which is not visible to any other user.

Just guessing by the name of your column (“Interested”), probably what you want instead is a plain text column (not user specific) with a comma separated list of UserIDs.

---

<div class="post-metadata">

**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\
**Post date:** [July 3, 2023, 9:54am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/3 "2023-07-03T09:54:11Z")

</div>

Yes that sounds like the answer! My next question is how to get user IDs written into a column with commas? thank you

---

<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, 9:57am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/4 "2023-07-03T09:57:26Z")

</div>

I’m going to recycle a previous answer here 🙂

> [@Row Owners and Roles - follow up](https://community.glideapps.com/t/row-owners-and-roles-follow-up/63004/10):
>
> I guess it depends on your exact flow, but it could be as simple as a Choice component with multi-select enabled. If that doesn’t work for your use case, then you may need some variation of the [Trebuchet method](https://community.glideapps.com/t/the-trebuchet-method/48325).

---

<div class="post-metadata">

**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\
**Post date:** [July 3, 2023, 10:05am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/5 "2023-07-03T10:05:53Z")

</div>

Thanks for the thoughts but i’m not sure either of those options fix the problem. The user is not presented with a choice, so a select or multi select doesn’t fit, and the trebuchet concept only allows for one data point, whereas this problem requires the tracking of a few.

I’m aiming for a user to click a button and then be logged as an interested person of someone else’s listing (including when). this information will then be used to create a match when the owner of that listing then shows an interest in one of prior users listings. I hope this is making 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:** [July 3, 2023, 10:11am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/6 "2023-07-03T10:11:44Z")

</div>

Okay, I think Trebuchet should work fine for that. The desired end result is a comma separated list of UserIDs in a single column, yes? That’s exactly what Trebuchet will give you.

> [@Rollo\_Wenlock](#):
>
> I’m aiming for a user to click a button and then be logged as an interested person of someone else’s listing (including when).

This is where you would apply Trebuchet. When the user clicks the button, their UserID is added to the list of UserIDs.

Once you have the list, the next step would be to coerce that into an array with a Split Text column, and then you can use that array to create a multiple relation to your Users table (or wherever).

---

<div class="post-metadata">

**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\
**Post date:** [July 3, 2023, 11:00am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/7 "2023-07-03T11:00:36Z")

</div>

Thanks for the reply. Correct me if i’m wrong, but trebuchet wouldn’t log when the user clicked ‘interested’?

---

<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, 11:31am UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/8 "2023-07-03T11:31:18Z")

</div>

No, it wouldn’t.

If you also need that, then I can think of two options:

The first option would be to create a separate table with columns for UserID, ListingID, and DateTime, and add one row per user per listing. Simple, but can eat up your row count.

The second option would be to add a column to your Listings table that holds a JSON structure containing a collection of all interested parties. It would look something like this:

```auto
[
  {
    "DateTime": "[datetime]",
     "UserID": "User1ID"
  },
  {
    "DateTime": "[datetime]",
    "UserID": "User2ID"
  }
]

```

You’d then need to use JavaScript to manipulate the JSON. This solution is a lot more complex, but doesn’t add anything to your row count.

---

<div class="post-metadata">

**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\
**Post date:** [July 3, 2023, 9:30pm UTC](https://community.glideapps.com/t/user-id-being-written-to-a-user-specific-column/63418/9 "2023-07-03T21:30:13Z")

</div>

Starts to wander in to ‘code’ territory 🙂

Thanks for your thoughts on this problem.