Saving data to sheets

Im not too sure I understand your reply

I just remembered, I did a sample app that can scan Marathon runner bar codes and log their times to Google Sheets:

Replace that ? by a &
Taifun

done, and still nothing

show this full url

image

Did you read my guide ?

Use Do it and show us the result

Use the companion app and Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

Taifun


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.


image
I tried both "do it" and "doit"

if I right click, do it is not available

Well, nobody said, you should replace all ? by &
The first delimiter is a ?, and all further delimiters are &
Also the complete url is still hidden, there might be further errors inside
Sp what about fixing the errors and provide a Do it result?

Screenshot_20250103_094642_DuckDuckGo
?

Taifun

Again Use the companion app

Use the companion app and Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

Taifun


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.

ok so I changed some labels and was able to use the do it function but I'm not sure what i need to do once the text boxes pop up?

This method may be helpful to you. But, according to Google policy we should not collect confidential information from users (Anyhow, cross check if my understanding is correct).

I watched and did exactly the same but it still dose not save to sheets. If I do a test and submit form response it dose populate in sheets but when I use the app it dose nothing.

Now compare carefully your url with the guide from @TIMAI2 from here METRIC RAT AI2 - Use AI2 to directly submit Google Form Data

The first delimiter is a ?
All further delimiters are a &

Taifun

I think you have to change the permission in such a way that the form/googlesheet can be seen/read/respond by any one.

Capture

Click the publish button at the right top corner and change the permission as given in the image. This may work.

No you do not

This is for NEW forms only. You must Publish and give Respondents "Anyone with the link" access when you do, so that the form can accept responses.

The Do It on the first text block of the form submission URL reveals the problem.

Compare the invisible end of the first text block with the next text block in the url join.

That first text block should be duplicated three times and broken down into four completely visible parts in the URL join.

I have no idea what I did but it is FINALLY working. Thank you all for the assistance and suggestions

1 Like

You have to change the Share settings (Permission settings) of Google sheet as well as 'Anyone with link'.

Experiment yourself by changing the share settings of Google sheet and form. Don't give permission to edit but give permission only to view or respond.