after creating the sheet etc which seems ( or not) went well i am not sure how to find the error in a flow.
How do I register a flowcard? the error is:
I created an error report would you please direct me in the right direction to solve this.
89bc62fc-7239-463b-a9bf-9358ece88ca3
[err] 2023-02-09 12:21:31 [EasyLoggerApp] Credentials file were invalid, could not parse the content SyntaxError: Unexpected token h in JSON at position 1908
@Addie Can you put your own timestamp format to that cell/column to verify this is a valid timestamp. Maybe do a duration calculation to see if it works
@Addie Try this formula =YEAR(P10) where P10 is a cell with date created by EasyLogger. If the year component is correct, the date is parsed the way it should be.
The error is that A67 is e text field and not a number.
Would it be possible to change the seperator to the “/” and the “:” or to have this as a variable in the settings menu?
My assumption is that it is the separator in date and time.
In your samples on the website:
The date/time field are on the right side of the cell, mine are on the left side.
When I format to date/time with the other separator in mine sheet it moves to the right as well.
When I change the sheet ( file >> settings to “Norway Norwegian Nynorsk”) it solve the problem and even added the KL to it.
So it appears that depending on the (language) setting in the sheet you need to change separator.
Is it possible to add “at row-nbr” to the action card “Append multicell items”?
I would like to be able to fill such a table with values. With the beginning of a new month, I would then select a new column and simply fill in the values one below the other: