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
If you are writing a value to the User Profile row, you should be able to access that value directly from anywhere.
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
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.
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
It depends on the use case. But there is nothing wrong with doing it this way.
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
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.
AH got it. Single row helper table is created by creating new table with only 1 row right ?
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
Correct.
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
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
I cant do single value → First → whole row in this case right?
Regards,
Dilip
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.
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
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
Regards,
Dilip
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.
Hi Darren,
I did this, No value is getting written to the first row
Please find the Screenshot below
Regards,
Dilip
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.
Hi Darren,
Did the first part.
Didnt quite understand this.
You mean configure like this?
Sorry if I am asking basic questions.
Thank you.
Regards,
Dilip
Yes, that’s correct. And then write the value to the appropriate column.
1 Like
