in the app its showing in the listview the same (name songname artistname)
Show both sheets with selection of cell A2
you didn't reply
Been busy
It is working, but you, again, have some empty form submissions (delete rows 2,3,4 and go into the google form and delete the empty responses) and for some reason you have submitted the form with the column headers?
done that, but hows it working when it keeps saying name, songname, artistname when the forms submitted?
I just used the actual form to submit a request, which came through, but you still have many blank rows above it
but how would it work within the app without it saying name, songname, artistname
instead it would show up with something like you submitted
Seems there is an issue with your blocks and your editing of the pre-filled url from the google form. Please show all your relevant blocks, and the pre-filled form link in full.
Please copy the prefill link and paste it here as text
, I do not have access to your google form
Again, post your pre-filled link here as text
. It should look something like this:
https://docs.google.com/forms/d/e/1FAIpQLSc_Opj_NpCYK4u3mK1t_rOvzsq8_JHIbrYd7Mrbr4YWTeaTtQ/viewform?usp=pp_url&entry.1009711411=A&entry.704396903=B&entry.1375045067=C&entry.2109381646=D&entry.1798832277=E
When you go to the prefill page and click Get Link a big COPY LINK button appears...
(https://docs.google.com/forms/d/e/1FAIpQLSdbudeEpSyrO6fJVNHuQQclzu67QkldMHE_C7dFir9K0faDMw/viewform?usp=pp_url&entry.499384476=x&entry.804873663=y&entry.798570359=z)
OK, good.
Now test with this example project, it should add an entry and return the displayed entries.
hottunezhelp.aia (2.9 KB)
If this works for you, (which it does for me) then apply the same logic and values to your app's blocks.
Do not touch anything on either of your worksheets: requests or req.
You can do that, or just compare, check, edit your current blocks to match.