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
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 to get the expected results.
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
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.
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)
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.
I took the general form of the script but I tried with one list then two lists and so on
with the âcreate objectâ block I sent a list with two it didnât worked more
You will need to change the script code to deal with objects. Currently the script uses a string of words and commas to build a list from them and then loop through the list to append the items in the sheet. The current code will break when seeing an object passed as parameter.
You append brackets to your array in the code but they would be sent with those already from Thunkable. Iâd you send it as an array, you shouldnât need to add those brackets. Right?
I can get around sending entire lists by putting the block that sends the data in a loop to send all the first elements of each list then every second and so on but I hope with your help I can send all of them the lists at the same time