-
Notifications
You must be signed in to change notification settings - Fork 268
Batch append to Google Sheets #1525
-
I wonder if (and in that case: how) it is possible to batch append new values to a Google Sheet.
An example: In one table element in Lowcoder I have selected a few rows that I wish to save to a table in Google Sheets. Sure, {{tablename.selectedRows}} holds an array with all the data of the selected rows. But is it possible to append them to a Google Sheet all at once?
In the corresponding data query function you can surely set {{tablename.selectedRows[0].value1}} as value of one key. But in that case only the first object in the array is appended. Is there a way to iterate over the selectedRows array so that all objects inside will be added as new rows to Google Sheet?
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 1 comment 2 replies
-
This is a very, very old open topic. We even have a feature request issue here in github for it.
We checked it a while ago, and it did mean a larger rewrite of the data source, as the way Google API offers this was distant from the standard way we had solved the other functions. We need to look again into it...
Beta Was this translation helpful? Give feedback.
All reactions
-
Beta Was this translation helpful? Give feedback.
All reactions
-
Sorry, didn ́t see it. Thank you.
Beta Was this translation helpful? Give feedback.