# Need help in fetching user specific column value

**URL:** <https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052>\
**Category:** Ask for Help\
**Created:** [July 22, 2024, 5:18am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052 "2024-07-22T05:18:47Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 5:18am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/1 "2024-07-22T05:18:47Z")

</div>

Hi Guys,

I have a user specific column which stores a name of the user selected from the UI.

I will be using this value in my query column in my DB. Since the values in User column are randomly written in the rows,

Alternatively I have same issue if I write it to User table.  
It gets written against the user name who’s logged in. Since the row placement will be random how can I get this value?

**Currently I have configured an action which writes the selected name into user specific column in user table under column with name “SelectedName”**

\*\*I need it to be fetched to another table with name “Detail” \*\*

**when I do Singlecolumnvalue type column no option available fetches the value from user table.**

**How can I solve this issue?**

thank you in advance.

Regards,  
Dilip

---

<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 22, 2024, 5:36am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/2 "2024-07-22T05:36:44Z")

</div>

If you are writing a value to the User Profile row, you should be able to access that value directly from anywhere.

![CleanShot 2024-07-22 at 13.35.43@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43ca3707a0613868d3ddb2b1da6cac9f0d0d9416.png)

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 6:18am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/3 "2024-07-22T06:18:30Z")

</div>

Hi @Darren_Murphy thank you for your reply.

Yeah I am able to access it.

My Problem:

Since its a user specific column in user table.

The Name written is against the row which contain particular user.

I want to access this Name written in the row in user column to be accessible in another table called “Detail”

In Detail I have q query column where I want to use this “Name” written in User table.

To fetch the selectedName from user table to “Detail” table I use single value column.

Which asks for get from First, Last etc, which really is where I am confused.

How do I ensure that it can be put as input to my query column?

Regards,  
Dilip

---

<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 22, 2024, 6:21am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/4 "2024-07-22T06:21:53Z")

</div>

You don’t need a single value column, just refer to it directly in your Query column.  
Of course, because it is user specific, then it is only accessible to the user that wrote it.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 6:27am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/5 "2024-07-22T06:27:28Z")

</div>

Oh ok My bad, Thank you @Darren_Murphy

Just for my understanding is there a way I can avoid writing value to user column? as a good practice?

Or this is something which is ok to do?

Regards,  
Dilip

---

<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 22, 2024, 6:31am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/6 "2024-07-22T06:31:36Z")

</div>

It depends on the use case. But there is nothing wrong with doing it this way.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 6:39am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/7 "2024-07-22T06:39:08Z")

</div>

ok. Say if I had to do it in table other than user table.

Lets say I want user specific column to get the value in my “Detail” table.

how can I make it write the value to first row of the column and to randomly to some row?

Regards,  
Dilip

---

<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 22, 2024, 6:43am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/8 "2024-07-22T06:43:49Z")

</div>

One way is to use a single row helper table, then there is only one row to write to.  
Otherwise, you could use Single Value → First → Whole Row to establish a link to the first row, then write the value through that link.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 6:48am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/9 "2024-07-22T06:48:03Z")

</div>

AH got it. Single row helper table is created by creating new table with only 1 row right ?

> [@Darren\_Murphy](#):
>
> you could use Single Value → First → Whole Row to establish a link to the first row, then write the value through that link.

This might not work right ?

Because when I write a value to my “Detail” table UserSpecific column with name “Name” it will randomly write the value into Name column right?

Am I doing something wrong?

Regards,  
Dilip

---

<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 22, 2024, 7:20am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/10 "2024-07-22T07:20:13Z")

</div>

> [@Dilip\_Adiga](#):
>
> AH got it. Single row helper table is created by creating new table with only 1 row right ?

Correct.

> [@Dilip\_Adiga](#):
>
> Because when I write a value to my “Detail” table UserSpecific column with name “Name” it will randomly write the value into Name column right?

I don’t understand what you mean.  
The value will be written into whichever column you direct your Set Column Values action at. There should be nothing random about it at all.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 7:30am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/11 "2024-07-22T07:30:17Z")

</div>

> [@Darren\_Murphy](#):
>
> I don’t understand what you mean.  
> The value will be written into whichever column you direct your Set Column Values action at. There should be nothing random about it at all.

I mean If I am writing it to a table other than user table.

let us say I am writing it to a table with name “Detail”

In this table there is a column which is of type user specific with its name “Name”

When I am writing the value in here it writes to column — Correct

but it writes to rows right, its not writing to the first row , its writes to some random rows.

Is there a way I can make it write to first row of the column only?

Regards,  
Dilip

---

<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 22, 2024, 7:45am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/12 "2024-07-22T07:45:39Z")

</div>

> [@Dilip\_Adiga](#):
>
> but it writes to rows right, its not writing to the first row , its writes to some random rows.
> 
> Is there a way I can make it write to first row of the column only?

👇

> [@Darren\_Murphy](#):
>
> Otherwise, you could use Single Value → First → Whole Row to establish a link to the first row, then write the value through that link.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 8:41am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/13 "2024-07-22T08:41:06Z")

</div>

Thank you for your reply @Darren_Murphy

I configured the action to write to column with name

It writes the name in the Row which has the name.

As the action is configured to set value to “This Row”

PFA Screenshot

 ![Screenshot 2024-07-22 at 2.07.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/256c5e372584760d9fdb45acb90e24a8541efab5.png)

I cant do single value → First → whole row in this case right?

Regards,  
Dilip

---

<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 22, 2024, 8:51am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/14 "2024-07-22T08:51:32Z")

</div>

> [@Dilip\_Adiga](#):
>
> I configured the action to write to column with name
> 
> It writes the name in the Row which has the name.

I don’t understand what you are doing, or which table you are writing to.  
Please show me how your action is configured.

Bottom line - you can target any row that you want to (in the absence of row owners). It’s just a matter of configuring things correctly.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 9:11am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/15 "2024-07-22T09:11:10Z")

</div>

Hi @Darren_Murphy

Basically I have an action that sets the value to the user column in table A as shown in the screenshot below

 ![Screenshot 2024-07-22 at 2.36.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/321e2f9425eacbd788abfcf53d29b165699eb3f8.png)

In Table A it is just not writing the value to Row 1

It is writing to corresponding row, not the first row

Please find the screenshot below of table and which row it is writing to in user column

 ![Screenshot 2024-07-22 at 2.40.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08c841e453f6c125b92bd9a869b68297f06ca56d.png)

Regards,  
Dilip

---

<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 22, 2024, 9:15am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/16 "2024-07-22T09:15:10Z")

</div>

Okay, so you are using “This item”, so it will write to whichever row the screen is attached to.

If you want to write to the first row in the attached table, you need to target that row.  
You can use the Single Value-\>First-\>Whole Row approach that I mentioned earlier, or you could create a Single Relation to the first row. Then instead of using This Item, use either the Single Value or Relation as the target row. Either way will work.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 9:27am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/17 "2024-07-22T09:27:15Z")

</div>

Hi Darren,

> [@Darren\_Murphy](#):
>
> You can use the Single Value-\>First-\>Whole Row approach that I mentioned earlier,

I did this, No value is getting written to the first row

Please find the Screenshot below

 ![Screenshot 2024-07-22 at 2.56.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b0f9dad817d6d814d73402f35b04b7deec69cbe.png)

Regards,  
Dilip

---

<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 22, 2024, 9:31am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/18 "2024-07-22T09:31:02Z")

</div>

That’s wrong.

You need to select First-\>RAFCamp-\>Whole Row

Then you need to change your action so that it uses that as the target for the Set Column Values.

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [July 22, 2024, 9:45am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/19 "2024-07-22T09:45:40Z")

</div>

Hi Darren,

Did the first part.

> [@Darren\_Murphy](#):
>
> You need to select First-\>RAFCamp-\>Whole Row

 ![Screenshot 2024-07-22 at 3.13.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/7/77aedbc2cedad7cef8a889b21e5bbaa6a7559cc8.png)

> [@Darren\_Murphy](#):
>
> Then you need to change your action so that it uses that as the target for the Set Column Values.

Didnt quite understand this.

You mean configure like this?

 ![Screenshot 2024-07-22 at 3.15.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8ba80b61f655514f21fffafb5fa3d335b398d185.png)

Sorry if I am asking basic questions.

Thank you.

Regards,  
Dilip

---

<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 22, 2024, 9:47am UTC](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052/20 "2024-07-22T09:47:11Z")

</div>

> [@Dilip\_Adiga](#):
>
> You mean configure like this?
> 
> ![Screenshot 2024-07-22 at 3.15.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8ba80b61f655514f21fffafb5fa3d335b398d185.png)

Yes, that’s correct. And then write the value to the appropriate column.

[Next page](https://community.glideapps.com/t/need-help-in-fetching-user-specific-column-value/75052.md?page=2)