How Can I Change cell on Google sheet

use firebase its easy and fast(so fast)

watch a video from youtube

Oh my god, you are using other than scripts
 It is hard for me to design further
 But if you follow the above said procedure as per the guide, then modification will be success
 just you need to paste the script url alone here, i modified the aia

image

sendver_1.aia (1.7 MB)

this url sheet

this url script
https://script.google.com/macros/s/AKfycbz-6p9dQ1oiHYDKjA_H95qcDuR0aHapxDLSPBZyZQJXk4Nw1M7yCaUvCKBcib1t6DJh/exec

ok,i can make that firebase thing @Mohamed_Alsabagh

may i see your script ocde? did you add the new scripts and deployed or not?

i think you have not added the enough codes

Plz send me script to add it

i make deploy for script but not working
This script

function doGet(e) {

var ss = SpreadsheetApp.openById(e.parameter.ID);

var sh = ss.getSheetByName(e.parameter.SH);

var fn = e.parameter.FN;

var rg = sh.getDataRange().getValues();

// enter row number and column number to return A1 Notation Cell reference

if ( fn == ‘getCellRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter start and end row numbers and column numbers to return A1 Notation Range reference

else if ( fn == ‘getRangeRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL,e.parameter.ROW1,e.parameter.COL1).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter A1 notation reference to return cell value

else if ( fn == ‘readCell’ ) {

var ref = sh.getRange(e.parameter.REF).getValue();

return ContentService.createTextOutput(ref);

}

// enter row number to return all values in row as a list

else if ( fn == ‘readRow’ ) {

var ref = sh.getRange(parseInt(e.parameter.ROW),1,1,rg[0].length).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

// enter column number (A=1/B=2/etc.) to return all values in column as a list

else if ( fn == ‘readCol’ ) {

var ref = sh.getRange(2,parseInt(e.parameter.COL),rg.length-1,1).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

any update here plz

untill you change, how can we update?

script updated

https://script.google.com/macros/s/AKfycbxiqabsQOG7P1V4tdWFsSwMiXEfM4uHbqXOdtEymj7nbvm2ThT_qkZDPYOrccr8__Qu/exec

id
AKfycbxiqabsQOG7P1V4tdWFsSwMiXEfM4uHbqXOdtEymj7nbvm2ThT_qkZDPYOrccr8__Qu

script

function doGet(e) {

var ss = SpreadsheetApp.openById(e.parameter.ID);

var sh = ss.getSheetByName(e.parameter.SH);

var fn = e.parameter.FN;

var rg = sh.getDataRange().getValues();

// enter row number and column number to return A1 Notation Cell reference

if ( fn == ‘getCellRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter start and end row numbers and column numbers to return A1 Notation Range reference

else if ( fn == ‘getRangeRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL,e.parameter.ROW1,e.parameter.COL1).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter A1 notation reference to return cell value

else if ( fn == ‘readCell’ ) {

var ref = sh.getRange(e.parameter.REF).getValue();

return ContentService.createTextOutput(ref);

}

// enter row number to return all values in row as a list

else if ( fn == ‘readRow’ ) {

var ref = sh.getRange(parseInt(e.parameter.ROW),1,1,rg[0].length).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

// enter column number (A=1/B=2/etc.) to return all values in column as a list

else if ( fn == ‘readCol’ ) {

var ref = sh.getRange(2,parseInt(e.parameter.COL),rg.length-1,1).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

}

Have you tested it? @Mohamed_Alsabagh

(Sharing stopped and deleted the file)

Result; - Working fine, the blocks and code as per your requirement

OK plz send aia file plz

sendver11.aia (1.7 MB)

Making the gsheet to accesible fro few more min, only timer it will be deleted from sys

Kindly
Send script
and
url for googlesheet

Have you open the aia?

It contains my script url as well as Google sheet link. Else check my last reply. (The deleted one)

i need script not url script yes url for script exist but i need script in side url i think this is the problem he work on your aia file as well ?

this url for script

Error?

If you run script url alone after deploy, it will show such error , but no issue . Just carry on


PS: you must enable show list as json in project setting

now check the aia given in the previous post(post no.35)
 and :point_right: check this gsheet

this is my script url


https://script.google.com/macros/s/AKfycbwpyxLuuvxwAlNeBpyFizT0gxXg55ObMIQDyoKL8oeyVF5MZHE/exec

even for my default script url too will show such error, but after adding to the blocks it will work fine

I need script like this not url
Same like this but your script

function doGet(e) {

var ss = SpreadsheetApp.openById(e.parameter.ID);

var sh = ss.getSheetByName(e.parameter.SH);

var fn = e.parameter.FN;

var rg = sh.getDataRange().getValues();

// enter row number and column number to return A1 Notation Cell reference

if ( fn == ‘getCellRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter start and end row numbers and column numbers to return A1 Notation Range reference

else if ( fn == ‘getRangeRef’ ) {

var ref = sh.getRange(e.parameter.ROW,e.parameter.COL,e.parameter.ROW1,e.parameter.COL1).getA1Notation();

return ContentService.createTextOutput(ref);

}

// enter A1 notation reference to return cell value

else if ( fn == ‘readCell’ ) {

var ref = sh.getRange(e.parameter.REF).getValue();

return ContentService.createTextOutput(ref);

}

// enter row number to return all values in row as a list

else if ( fn == ‘readRow’ ) {

var ref = sh.getRange(parseInt(e.parameter.ROW),1,1,rg[0].length).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

// enter column number (A=1/B=2/etc.) to return all values in column as a list

else if ( fn == ‘readCol’ ) {

var ref = sh.getRange(2,parseInt(e.parameter.COL),rg.length-1,1).getValues();

return ContentService.createTextOutput(JSON.stringify(ref));

}

}
I think i have issue on my script