hi I am using a script (which worked with another no code tool) to transfer lists and two other parameters in google sheet these lists I transformed them into csv I try to adapt and I manage to transfer a single list (without transforming it into csv) with the following blocks [Capture d’écran…

no it doesn’t work due to my difficulties to translate my app with thunkable this is how I worked on the other no-code tool [Capture d’écran 2021-12-19 à 13.02.43]

Wanna share your script code? That would be helpful in determining the issue. All looks good (seemingly) on how you are sending stuff.

The block you shared from App Investor is not the same as the one you shared from Thunkable therefore you should not expect it to work the same. Anyway, no one can give you a good suggestion without seeing your code from both sides (Thunkable side and the Google Apps Script side). Both should match…

hi it is true that they are not the same (and that it gives another result) and as for a list it worked I thought to continue in this way but I realized that it was not right objects are not that yet !!! I need to get as close as possible to what I was doing on the other no-code tool

[image] bibbi: I need to get as close as possible to what I was doing on the other no-code tool That is very difficult to answer. It is obvious that you do not want to share your project and your google script and therefore it will be hard to provide a solution other than guessing.

If it’s the same script, you could try sending your data in the actual url string But If it’s the same script, then it would seem it’s not working because your key names don’t match?

hi my problem, I think, is to “encode” the lists with thunkable blocks when the script that I built by taking inspiration from this and there I simplified it because it included a file search (one of the parameters that is missing is the name of the folder) [Capture d’écran 2021-12-19 à 13.48.…

hi I manage to send simple data to my script so it works in part the problem is how to send lists in the form of csv

The script you shared expects 3 lists as parameters. You are passing two parameters and one list so the script will not run correctly. The best this script will do is to create one single row entry in your Google sheet.

[image] bibbi: how to send lists in the form of csv If you are using the QueryParameters then remember that the maximum length should not exceed 2083 characters combined with the script URL. Again, you should not have spaces in your list so you need to convert the spaces to %20. The last th…

Send list to google sheets using script issue

Questions about Thunkable X

muneer December 20, 2021, 11:25am 21

This should not work.

Your script is clearing the sheet every time you call it.

[Edit]
To send large data to Google sheet or Google script see this demo

Topic		Replies	Views
Export List Values to Google Sheet Questions about Thunkable X	7	491	November 8, 2024
Some data source blocks not working Questions about Thunkable X design , beginner	33	1333	November 8, 2024
Get data from sheets Questions about Thunkable X	3	310	November 8, 2024
Please help me.Please help me Questions about Thunkable X beginner	2	607	November 8, 2024
Add item to simple list Questions about Thunkable X list	2	340	December 26, 2023

Send list to google sheets using script issue

Related topics