# Single Value column - Row Owner **URL:** \ **Category:** Ask for Help\ **Created:** [July 4, 2023, 2:12pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490 "2023-07-04T14:12:27Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 2:12pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/1 "2023-07-04T14:12:27Z")
I have a single value column in a table that holds an email address. How can I enable this as a row owner? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 4, 2023, 2:14pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/2 "2023-07-04T14:14:19Z")
You can not use any computed columns as a row owner. > [@thinking Row Owners vs. User Specific Columns](https://community.glideapps.com/t/row-owners-vs-user-specific-columns/58205/3): > > Correct. This is because computed columns (eg. lookup columns) are evaluated on the client device after all data has been downloaded. And by that time it’s too late to apply row owners. Yes, if a user changes their email address then they would lose access to all owned rows. You’d need to update all rows with their new email address. But, how often do your users change their email address? (I haven’t changed mine in 30+ years man_shrugging) ---
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 2:15pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/3 "2023-07-04T14:15:44Z")
Is there an alternative solution to achieve this? Can I take the single value and add to a standard column somehow? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 4, 2023, 2:16pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/4 "2023-07-04T14:16:15Z")
Can you describe your data structure? Why do you need to have a row owner in place? ---
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 2:17pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/5 "2023-07-04T14:17:47Z")
I have a notes table and chat table. Notes table stores the saved notes from a user. Chat table is used to ask questions about the notes table. I need the users who are asking questions to only be able to retrieve answers from notes created/owned by them in the notes table. ---
**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 4, 2023, 2:22pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/6 "2023-07-04T14:22:13Z")
You should add the users email address when the note is created. If you’re using a standard form to create the note, you can pass the email address as a special value with the form. > **[Glide • User's email address](https://www.glideapps.com/docs/reference/values/users-email-address)** > > Submit the user's email address automatically. ---
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 2:51pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/7 "2023-07-04T14:51:10Z")
When a user saves a note , it adds the email to the notes column already. Thats fine , i can use this as the row owner. But on my chat table , Im using open AI to ask a question about the Notes table & retrieving the owners email of the note in the response from OpenAI , then splitting that email into a single value column on the chat table ---
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 2:53pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/8 "2023-07-04T14:53:39Z")
Example from the chat table : Chat Prompt | PromptTemplate | Chat Response | SplitResponse | Answer | RowID | Email The Chat response contains the answer from the Notes table and is then split into the following 3 rows ---
**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 4, 2023, 2:55pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/9 "2023-07-04T14:55:32Z")
> [@Emmett\_M](#): > > But on my chat table , Im using open AI to ask a question about the Notes table & retrieving the owners email of the note in the response from OpenAI , then splitting that email into a single value column on the chat table Are you creating a new row in your Chat table as a part of this flow? If yes, you can take that Single Value and write it into a non-computed column when the row is created. A couple of screen shots might be helpful at this point, as I feel like we aren’t quite getting the full picture. ---
**Author:** ![Emmett\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmett_m/32/60683_2.png) [@Emmett\_M](https://community.glideapps.com/u/Emmett_M)\ **Post date:** [July 4, 2023, 3:04pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/10 "2023-07-04T15:04:12Z")
I think I got it. The container with the form submissions has “additional columns” that I can set to users email address , then make that the row owner in the Chat table ---
**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 4, 2023, 3:07pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/11 "2023-07-04T15:07:21Z")
yep, that sounds right 👍 ---
**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:** [July 5, 2023, 3:08pm UTC](https://community.glideapps.com/t/single-value-column-row-owner/63490/12 "2023-07-05T15:08:17Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.