This is part of a Google Sheet in Glide that is working fine.
This is how it looks now.
As soon as the cell AnsweredDate has a new entry, you can see the last date in Last Answered Date.
I used a Rollup with last date.
What I would like to do or would like to have is, that in LastAnsweredName, the name will show of the last placed name in AnsweredName.
This is the sample of what I would like that it looks;
I have strong doubts that if what I would like to achieve is even possible.
If it is possible, please try to explain it to me in simple steps
I am still learning things.
The reason why I would like to have it like this is because I want to use those cells as a trigger and action for pipedream.
I want to check if 1 cell is updated. That will be the Last Answered Date.
This part is no problem.
But after that, I want to send an email notification and use the LastAnsweredName in that email.
I hesitate to answer because I’m not in front of a computer and I usually prefer double-checking my answers. So please test this answer and I’ll edit if need be.
I would try to set the column “LastAnsweredName” to a “Single value” column. You might not be able to change the type of your current column which is a “Text” type, you might have to create a new single value column.
Then in the settings of this single value column, select “AnsweredName” as the column and “Last” as the element.
(If the approach above returns something empty, you might have to create a “Lookup” column of the “AnsweredName” column first, and I would need to double-check, this is just an idea.)
Determine the index of the last non-empty element. Indexes start at 0, so the index is the number of elements in the array minus 1. To do so, create a math column and subtract 1 from the number of elements.
I think perhaps a simpler approach would be to use the Last Answered Date to create a Single Relation to his AnsweredDate column, and then use a Lookup column to fetch the associated name.
This should work fine, even if the display format of the rollup is different from the AnsweredDate. If there are missing rows, they’ll just be ignored.
@Pierre_de_Man - in your Last Answered Date rollup, are you using “Last” or “Latest”? Important to understand there is a difference. Last is just the last row in the table, where Latest will be the the latest date - which might not always be the last row.
@nathanaelb, Thanks for all the effort.
But I am sorry for the confusion. Darren Murphy had a valid question.
I am looking for the latest name and not the last name in the column.
I tried your first option, and this gave an array with the names in order of the row they were entered.
But I am looking for the latest name that was entered in the column. No matter in which row they were entered.
And if I place a new latest date, I get the correct name behind it.
If I do a date that was before that, it was not changed, and that is good.
Only when I enter a new later date, do I get the correct name again
I still need to work on my relations. As I mentioned in a different question I had, I understand the concept, but I am having problems realizing it.
I saw a video from Robert Petitto about relations and it made sense. But again, to realize it now, no idea why it doesn’t go in with me.
Maybe I need to experiment more.