How do I transfer data from Web to google spreadsheet while using MIT app?

MIT App Inventor Help
1

I am facing issue

Screenshot 2025-02-17 150630
Screenshot 2025-02-17 150630745×539 19.7 KB

2
3

tell us what is your issue? what is your script code?

in such case i always share this wounderful guide by @TIMAI2

4

I have been using these script codes but for my data it is not working

5

If you ise thise code then no need of post text block. Show us your script code and your error

6

the join block is not right. it should be like aa=bb&cc=dd

7

function myFunction() {
function doGet(e) {
var ss = SpreadsheetApp.openByUrl("sheet11 - Google Sheets");
var sheet = ss.getSheetByName("sheet11");

addOrder(e, sheet);
}

function doPost(e) {
var ss = SpreadsheetApp.openByUrl("sheet11 - Google Sheets");
var sheet = ss.getSheetByName("sheet11");

addOrder(e, sheet);
}

function addOrder(e, sheet) {
var item1 = e.parameter.item1;
var q1 = e.parameter.q1;
var item2 = e.parameter.item2;
var q2 = e.parameter.q2;
var item3 = e.parameter.item3;
var q3 = e.parameter.q3;
var totalAmount = e.parameter.totalAmount;
var name = e.parameter.name;
var phone = e.parameter.phone;
var email = e.parameter.email;

// Appending the row with the provided parameters
sheet.appendRow([item1, q1, item2, q2, item3, q3, totalAmount, name, phone, email]);
}
}

8

why?

9

you are missing = and &.

10

doit for me , if you can

11

See here, easier script and blocks

12

I am still unable to pursue

13

Did you follow my guide, for the script and the blocks ?

What doesn't work for you?

Show the reported errors, in full.

14

data is uploaded to web but unable to appear on spreadsheet

15

Your short posts to not help anybody to help you
See the following article about how to ask questions

Taifun

16

just try this simple post apps script code,

function doPost(e) { 
  var ss = SpreadsheetApp.openByUrl("<Paste_your_gsheet_URL_Here>");
  var sheet = ss.getSheetByName("Sheet1"); 

  var name = e.parameter.name ; 
  var email = e.parameter.email ;
//you can add other var too here

  sheet.appendRow([name,email]);
//add the same var name here
  return ContentService.createTextOutput("Success");  
}

and in the var you can add and add the same texts in the appendRow and try , you will get success reply in teh response content .

image