MIT AppInventor -> Google Form -> Google Sheet

MIT App Inventor Help
1

I am trying to get data from a form to Google Sheet. First 3 rows work well but I am unable to get the last 4 rows into Google Sheets

FYI - The first three rows are direct user entry whereas last 4 enteries are calculated field (or have been copied by a button)

Any help will be appreciated.

blocks
blocks1908×1258 283 KB

2

Make sure each field id matches with gform and the field name matches with gsheet headers

instead of this method why dont you try someother easy mehtod s like,

3

You may need to use the UriEncode block on your entries.

e.g.

image
image716×314 26.3 KB

4

You might have a timing problem, where you are trying to add rows before the rows above them have not yet completed their inclusion into the sheet.

Consider just one wide row per transaction.

Also, the AI2 Sheets component has completion events that could be used to avoid this.

Another consideration...

Could multiple users try to add data simultaneously?
That points you to single row transactions, avoiding interspersed entries.

7

Thanks Abie

It turned out to be timing issue (as was using Click and TouchUp events simultaneously on same Button).

Nevertheless, I tried Scripting (something which I was never wanting to use) which gave good results

YouTube video was very good

Thanks a lot for the help

1 Like
9

Thanks Tim

I will try

10

Hi Still Learning

I have gone the path of scripting which has resolved the issues.

Thanks

1 Like