True, but using a google form means you can, if you wish, keep the google spreadsheet restricted whilst still adding data.
However, if you use a service account with the spreadsheet component, you can do much the same.
Also, have you decided yet if you are going to work inside your organisation's Google workspace? Can an admin give external access to the sheet (and form if used) so that the appinventor app can use it?
i wont use the workspace. keeping it simple
Here is a simple example, using a form and spreadsheet, it is live so you should be able to test:
meritRecords.aia (5.6 KB)
I haven't handled default teacher or subject.
i tried with spreadsheet n form that i make myself, i manage to record the submitted answer to my google form, but the info in the spreadsheet not showing in the app and data recorded. maybe i put the link in the wrong place of the code. here i provided my drive folder so you can put it there.
https://drive.google.com/drive/folders/1OBJVIP3ZcFHqOpkEuuicBmSmQ4F68dkp?usp=drive_link
Put what there ?
Have you pointed the google form responses to your spreadsheet correctly ?
drive to put the spreadsheet file and form file so i can edit in the future,
i havent pointed the google responses to the spreadsheet. i dont know how.
When you have the google form open in edit mode, click on Responses and select your google sheet from the top right of the display.
Note the order of the worksheets in the spreadsheet, it is important that the spinner data is the first worksheet.
My example is just that, and example. I provided links so you could see how it works. You need to create your own google sheet and data.
does the form link to the spinner spreadsheet? or create a new spreadsheet?
and in the code which part do i put my form link?
You can do either. I just used the spinnerData spreadsheet for both
I meant to split up the form url so you could see how it is constructed:
Ref:
so does response spreadsheet be different or same with the spinner spreadsheet?
how to get the entry code?
You can use two separate spreadsheets or just the one
You generate a prefilled form url
nice, i finally get my form to be fill in with the spinner data. my next question are
It uses one spreadsheet, one worksheet for SpinnerData (lists) and one worksheet for the form responses. This should be obvious if you look at my spreadsheet.
What do you mean ?
Ow... Now i get it... I will try make thw same new worksheet
yes, i finally understand how this work. thanks a lot. god bless u.
1 more thing i want to ask, after are working well, how can we make it that we can choose/click multiple students name for each time submitting.
That would require a different approach, and more work/blocks.
You could use this extension, which provides for multi-select:
then you would need to make individual uploads for each record, or use a google apps script to allow for all data to be uploaded in one go:
thanks, i will go through it.
