Post to google sheet error

[TIMAI2]

That is an error in the app, not in the google apps script. Check other blocks, or disable anything else

[Nicholas_N]

@TIMAI2

Not seen that one before...

i thinks its from appscript,
because when i copy the full url from web3, and paste to browser, the message its error, please try again

err1.txt (1.4 KB)

[TIMAI2]

Ah, you have your script function in the doPost(). It needs to be in the doGet().

[Nicholas_N]

@TIMAI2

It needs to be in the doGet().

ERR2.txt (1.3 KB)
dopost and doget still error sir

[TIMAI2]

I have now had a chance to review the script requirements, this is tested and working:

function doGet(e) {
      var ss = SpreadsheetApp.openById('<your spreadsheet ID');
      var sh1 = ss.getSheetByName('<your sheet name>');
      var rg = sh1.getDataRange().getValues();
      var fn = e.parameter.fn;

 if ( fn == 'DELETE' ) {
       var student_name = e.parameter.student_name;
      for (var i = 0; i < rg.length; i++ ) {
        if ( student_name == rg[i][0] ) {
        sh1.deleteRow(i+1);
      } 
    }
      return ContentService.createTextOutput("Record deleted");    
   }
} 

[Nicholas_N]

@TIMAI2

function doGet(e) {
      var ss = SpreadsheetApp.openById('<your spreadsheet ID');
      var sh1 = ss.getSheetByName('<your sheet name>');
      var rg = sh1.getDataRange().getValues();
      var fn = e.parameter.fn;

 if ( fn == 'DELETE' ) {
       var student_name = e.parameter.student_name;
      for (var i = 0; i < rg.length; i++ ) {
        if ( student_name == rg[i][0] ) {
        sh1.deleteRow(i+1);
      } 
    }
      return ContentService.createTextOutput("Record deleted");    
   }
} 

AMAAZIING its Succesfully. thanks a lot sir

[Nicholas_N]

@TIMAI2

may i ask again another question sir ?
i want to save the data from MIT to google sheet use appscipt, but with dynamic sheet name, so in the script, iam use parameter to store a dynamic sheet name or sheet id, but it has error, this the desciption

Can you help me again sir ?

[TIMAI2]

Do you want to create a new sheet in the spreadsheet, or just use an existing sheet in the spreadsheet by supplying its name / position ?

[Nicholas_N]

@TIMAI2

just use an existing sheet

use existing sheet, and add the row data from MIT

[TIMAI2]

This

is confusing....

replace with this ?

var sht1 = ss.getSheetByName(e.parameters.sht0);

[Nicholas_N]

@TIMAI2

var sht1 = ss.getSheetByName(e.parameters.sht0);

still error sir

[TIMAI2]

What value are you passing in global sheet_code, and is that the name of a sheet on the spreadsheet ?

[Nicholas_N]

@TIMAI2

global sheet_code

i tried this, i tried with '01. KARDIOVASKULAR', but still error

[Nicholas_N]

@TIMAI2

var sht1 = ss.getSheetByName(e.parameters.sht0);

DONEEEE

i tried to re deploy with new file, and its success. thanks again sir