Typebot

Log inLog into community

Share feedback, ideas and get community help

Updated 3 months ago

Date Output Error!!

Date Output Error!!

·

1. 28 21:16:03

In the above format, a variable representing the current date and time was inserted into the Google spreadsheet, and the variable value was output in a text block.

It is well inserted in the Google spreadsheet.
However, outputting a variable value causes an error.

Attachments

2024-09-28_9.27.07.png

2024-09-28_9.33.28.png

L

s

B

10 comments

is the type of the cell on spreadsheet actually a date? It might be a text well formatted as a date but only visually

You can change the format in Google spreadsheet.

Attachment

2024-09-28_10.21.15.png

can you test with different formats and see if the issue persists only with the first one

2024-09-28 21:29:00
When specified in the above format, it is output normally

Attachments

2024-09-29_8.43.05.png

2024-09-29_8.47.27.png

This is an error code

Attachments

2024-09-29_8.48.47.png

2024-09-29_8.48.52.png

error code -> return ${year}. ${month}. ${day} ${hours}:${minutes}:${seconds};
normal code -> return ${year}-${month}-${day} ${hours}:${minutes}:${seconds};

(Results) looks normal.

Attachment

2024-09-29_8.54.06.png

In both cases, (Results) appear normal.

That looks odd indeed

Can you create a simple bot flow that reproduces the issue and share it here?

Add a reply

Sign up and join the conversation on Discord