Dear Gliders
First timer using the action “set column value”
I am doing a office-tasks tracker app , with a table “RECORDS” that, records,
office-tasks , and adds the start time ( with the action “add row” )
My problem is that when i finish the task, i need to put the END time-stamp
For this I use “set column value” but the time stamp data is always written to the FIRST ROW of my table. How come?
I checked the GLIDE DOCS and it says
“The Set Column Values action allows you to change another row’s values.
It can change values in the current row or a row linked by a Relation and you can use any kind of value. Learn more about value types here.”
Well, to me , it looks like “Set column values” action only changes the first row! not the current, or the last .
I have made a workaround by displaying all he open jobs with a collection, then the user clicks the open ones (= no END timestamp) and then Set Column Values works fine, because “this item” is exactly the row .
Could you please help , how to properly use SET COLUMN VALUE ? Why the first row of my table is being always targeted? Is there any way i can redirect the value to another row? or any row i would like for that matter?
Bets regards
That’s expected behavior. By default you will be connected to the first row of the table.
If you want to change the value in a row other than the first row you want to create a SINGLE relation and use that relation for the ‘row’ in your set column values.
I try to think of ways to prepare the value ahead of time.
E.g. Now+30 in a math column would give me 30 days from the current time… I could use that when I submit something
Can you show us where you are putting the button that contains the action?
Thank you Eric for the advice. I need to start learning relations then! Could you please advise any guided- through example on the web to learn on how to create a single relation and use that relation to point to the row in your set column values? Again, thank you very much!
Hello ThinhDinh
The “choice” box allows the user to pick some job from a Jobs table ( like, read email, check stocks existences, visit customer ) . This job is stored in the users table. when you click in “Iniciar” (start the job) the following action is started : ADD ROW to JobRecordTable , where you set the Job name ( pulled from User table ) and also set the Start time stamp . So far ok, the thing is, that i wanted, with the same click , to start the new JOB , “close” the previous job ( put Timestamp in the END column of the previous entry ) for this i used SET COLUMN VALUES , but always put the timestamp in the first row.
Glide allows for many workarounds and the fastest prototyping i have ever seen , so i did the following 
After you click START , the added job is shown in a collection ( shows only all jobs open, END timestamp empty ). The START button is hidden ( same condition) . Then the user has to click the “job” and this generates an action “set column value” that , since is ligated to this collection item, it targets to the desired column ( looks here is the relation Mr Eric was mentioning ) When you click , the job is timestamped and return to the origin
I need to do two click, but it is fine for my team , in the end you get some reports. The idea behind this is to see where the most time is spend in the office, see if it makes sense, or not, and how can we speed up, doing more, with same resources, or where to invest more heacount
