Hi,
In my app, new data is added to a new cell after each request, and I need to retrieve the value from the most recent cell after every run. Currently, I’m using the Google Sheets Get Cell module, but I’m unsure how to dynamically move from, for example, cell C2 to C3 (or the next available row) after each run.
Could anyone help me set this up or suggest a better approach for always retrieving the most recent value?
Thanks in advance!
Welcome to the Make community!
You need a “date used” column to keep track of when the item was last used. Then your search module simply has to sort by date last used, oldest first.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Thank you for the answer. Where can I set that in the module to sort based on the dates from another column?
That would be the “Search Rows” module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Thank you, I added the Search Rows module and it works as I wanted. Currently, my only problem is that the Search Rows module is keep running, constantly creating operations despite the values remaining the same. How could I do that it would only run once when there is a new data/row added to the google sheet?
You’ll have to add a new column to update once each item’s been processed then.