ok, I'm not sure
but I think this is not the correct Url.
This Url it's just the spreadsheet page
Try this instead,for the Url of the "WEB2" component.
https://docs.google.com/spreadsheets/d/1iFvc2CHyNYywC2SDNARDkD3IY0S-H5Xt4XQUn62g-LY/export?format=csv
edit: tested and works for me and there is no problem. I don't know about you.
i haven't given you my aia how have you tested it
I didn't create your whole project,
I Just tested Getting Data from spreadsheet.
The Url you sent me was not working and was giving me error
I deleted everything after slash and replaced it with export?format=csv
this will export the csv file.
so I think this also works for you
Just try that and if it's not working let me know.
will let device charge abit i'll test app an let you know
You know now how to 1) get the raw response content and you know how to 2) use Do it
Now combine that together and follow again @Peter's tip from here
Taifun
Why are there no requests on that sheet?
i've found where the problem lies, it's in web2.gotText
Error: Error from Companion: the variable $responseContent is not bound in the current context
ScreenShot:
no submissions yet!! 
Can't test without test data.
taking ya time 
I was reading the code in all those screens.
How many people worked on this app, over how long?
why?
See
https://groups.google.com/g/mitappinventortest/c/QZfnC76D7gE/m/MaqvmeVWAgAJ
from
for how to work around this problem.
Your format procedure is trying to select items from global variables holding text items and not lists.
Also, it does not match the format procedure in the exported aia file you posted.
At this point, I think my time would be spent more productively elsewhere.
i'm trying to have the song requests in a listview after submission
also the global varibles has to select list?
didn't work in app