Context: When first creating a Google Sheet Updater block, all columns appear correctly (if I add a column to the source Google Sheet and refresh the Updater, the new columns will not show, forcing me to recreate the block from scratch).
Problem: When I list the columns that I wish to add content for, the Updater block takes away all columns besides the first 3 columns and I cannot input the fields nor run the block without listing the columns.
The image below shows:
- The Updater block on the left displays all of the columns correctly for input but does not have any columns listed in the Columns fields - this block cannot run without the Columns field populated.
- The Updater block on the right has all of the columns listed in the Columns field but shows only 3 columns as available inputs. If I remove those specific 3 columns, they disappear from the inputs and the other listed Columns variables will not display as available inputs.
- What is not shown is: even when I load up the Updater and it displays all the inputs, when I click refresh on the Columns field or type any columns in, all the inputs (beyond the 3 variables shown in the right Updater) disappear. For some reason, the inputs do not disappear when I update the Sheet Name field, just the Columns field.
This has effectively killed the Google Sheets Updater for me and I do not know how to fix it. I’ve also tried logging out and logging back in, rebuilding the blocks, etc.
Please help.