Hurray! Finally got it to work using BLL. Thanks for the help Arie. Much obliged.
Up until now I managed a little workaround. A script that checks if new data is added and then adds date/time/whatever to a chosen column.
The data from Homey gets logged into “Blad3” (Swedish for Sheet 3) and then imported to “Blad4” via ImportRange.
Why duplicate everything by using ImportRange? Because I suspect the trigger OnEdit doesn’t work when data is added through external sources - but it works with ImportRange. Hence linking column A from Blad3 to column A in Blad4 by: =IMPORTRANGE(“http-URL-to-sheet”; “Blad3!A:A”)
In Sheets (Extensions/Apps Script) I (well ok, ChatGPT) then added:
function onEdit(e) {
var sheet = e.range.getSheet();
var editedCell = e.range;
// Check if a new value is added in column A
if (sheet.getName() === ‘Blad4’ && editedCell.getColumn() === 1 && editedCell.getRow() > 1 && editedCell.getValue() !== ‘’) {
var newRow = editedCell.getRow();
var timestampRange = sheet.getRange(‘G’ + newRow);
var date = new Date();
var timestamp = Utilities.formatDate(date, ‘GMT’, ‘YYYY-MM-dd HH.mm.ss’);
timestampRange.setValue(timestamp);
}
}
Anywho, it’s all moot now that the BLL formatting works. Sweet!
Using the app for over a month now to write my p1 meter values to a google sheet. I run the flow every hour. Noticed that, although the flow runs every hour, sometimes the values aren’t logged into the google sheet. Anyone recognize this and have a clue how to solve this?
I’m familiar with that app. The advantage iof google sheets is that it can be used in excel as a datasource and all my graphs are refreshed when opening the excel file. Don’t know if that’s possible with simple log as well
I also have a problem with no data being logged to sheets. I’ve tried different flow starts, as 11:59pm and so on with data only being logged 1 of 5 days. Flow only runs once a day. Frustrating…
I was not I can check this out.
But when I test the flow it works. And if I set a time in the next minute when I’m inside the advanced flow it reports. But not at the time I actually want it to report.
Have a strange issue with the Google Sheet flow; When I start the flow from test mode, the flow runs perfectly and a new row is added to the spreadsheet. However when the flow runs unattended (every hour) I get a “Rate Limited” error. I added a retry 65 sec’s later, but still the same rate limited. Do you get a rate limited as well?
