I'm currently busy with a section of an app I'm creating. In this section the user can select to move goods between 4 groups, namely Group 1, Group 2, Group 3 and VGroup. So in order to do this within AI2 I am searching for the required group i.e Group 1 in Google Sheets sheet (a) using a spinner. The found data (.csv) is then returned into a ListView. Can I then have all the data in the ListView be written to a sheet (b) and not just the selected data.
Reason being, after all the data has been written to the sheet (b), I then want to replace the word "Group 1" with whatever group, e.g VGroup, has been selected in the second spinner. After the word "Group 1" has been replaced with word "VGroup", the data from sheet (b) should be written back to sheet (a) replacing the original data in sheet (a).
I'll be able to do the second part of my explanation however the part I'm stuck on is how to write all the data in the listview to the sheet.
If anyone can assist me with this or maybe just point my in the right direction it would really be greatly appreciated.
Hmmm, not quite sure what you are trying to do. From your blocks it appears you are trying to call a google apps script web app, with no data parameters (to update?), and a gviz query on google sheet data (to get data) using the same single web1.Get. I don't think this will work as you expect. What do you have in your google apps script web app?
Here is everything I've done so far regarding this matter, including a script I've been working on which sort of works doesn't yield the desired result, instead it just deletes everything from my sheet.
This needs simplifying, too many things that can go wrong at once! Also it is difficult to debug without seeing the google sheet, the full google apps script and the aia project.
Write out your workflow in steps, convert this to blocks one step at a time, testing as you go...
From what I can see, you first want to get some data from your google sheet. Start there and report back ....
