Datetime field using Google Spreadsheet datasource breaks when rearranging the sheet #15864
-
|
I have a form backed by a Google Spreadsheet datasource. I've added a Datetime field via Budibase "Data' as a Datetime (date only) column, and it does appear in the Spreadsheet, but as soon as the column is relocated in the backing Spreadsheet (re-ordering columns) the Budibase datasource fails with Moving the column back to its original position in the spreadsheet fixes it. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Hey @kaipee - I've looked into this. For the time being, the workaround is to go to the Google Sheets connector >> Fetch Sheets >> unselect the sheet, and click "fetch sheets" or "Continue without fetching", and then repeat the process to re-fetch the sheet. I do think this is a bug though, so I'll write up an issue shortly. |
Beta Was this translation helpful? Give feedback.
-
|
Oh nice! Thanks for confirming. |
Beta Was this translation helpful? Give feedback.
Hey @kaipee - I've looked into this. For the time being, the workaround is to go to the Google Sheets connector >> Fetch Sheets >> unselect the sheet, and click "fetch sheets" or "Continue without fetching", and then repeat the process to re-fetch the sheet.
I do think this is a bug though, so I'll write up an issue shortly.