Hi @tatiang, I have applied the amended blocks to my sheet and exchanged my “Date Input” box for a Label (AddRecLabelBox) instead. When the Label is clicked it launches the “Date Picker” See blocks below:
Curiously though, when I select a date from the date picker, my Label that the formatted date is suppose to appear on disappears altogether. At first, I thought it was perhaps that I had set the Label’s visibility to “false” but this was not the case. So I tried to resolve this by using a “wait for_ seconds” block set to 20 seconds, but the formatted Label still disappeared the moment the date was selected. See 2 images below:
Before date selected:
The Date Row and Formatted date Label are still visible.
After the date is selected (in this case 18JAN2022)
The formatted date Label vanishes. See below:
Because the formatted Label has vanished, there is no Date Entry made into my Google Sheet. As you can see, I have tried this several times and always received the same result. See below:
Do you know why the formatted Label would keep disappearing like that?
I can’t see anything mistakes (- in my novice opinion) of my blocks that I copied from you being wrong. In the Design area, the formatted Label is set to “Visible”.
How can I fix this issue?