I have query data as in attached file and display by using DataGrid on Glide page.
I tried to export these data to Google Sheet by using Integromat but it sent only first single line. Is it possible to export all these data by Integromat?
Create a template column to join all the columns together, and then use a joined list column to combine all rows.
1 Like
The joined list can combine all data from many records. But it’s very difficult to separate data from rows back to its record.
Can you go into more details what’s the specific challenge here?
I have joined data look like this.
item0001, pen, 10.00, item0002, pencil, 15.00, item0003, desk, 13.00
I would like Google Sheets to separate any item to be different row not just in a single cell.
Thank you.
Actually, I did it by copy data from Google Sheets to Excel. But it’s too many process.
The delimiter on your joined list column should probably be New Line character instead of a comma.
What is New Line character in Glide?
Delete the comma in the Joined List configuration, and press the Enter key to create a new line…unless other people have a better suggestion or a different character sequence that they would suggest. I’m just guessing on this, since I’ve never done this myself.
1 Like
Yes, that’s the way to do it. And that’s covered in the tutorial that I linked to earlier in the thread. @paiboolk did you look at that?
1 Like
I saw it already. But it can’t line up as required.
You need to explain what “required” is in this context.
A screen shot of what you get, and what you would expect to get, would be incredibly useful.
I explained up there as…
I have joined data look like this.
item0001, pen, 10.00, item0002, pencil, 15.00, item0003, desk, 13.00
I would like Google Sheets to separate any item to be different row not just in a single cell.
Thank you.
My required display on Excel / Google Sheets is
item0001, pen, 10.00
item0002, pencil, 15.00
item0003, desk, 13.00
Well, by following the instructions in the tutorial, the end result should have been a CSV file, which could then be opened directly in Google Sheets and converted to Google Sheet format.
If you’ve pasted the data into an existing sheet and it’s all wound up in a single column, then you can probably fix that using Data → Split Text to Columns
If you tried to split the data like that. All data will split to the column. Not to the row as I told.
Thank you all. I solved it out already.