use firebase its easy and fast(so fast)
watch a video from youtube
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
sendver_1.aia (1.7 MB)
this url sheet
this url script
https://script.google.com/macros/s/AKfycbz-6p9dQ1oiHYDKjA_H95qcDuR0aHapxDLSPBZyZQJXk4Nw1M7yCaUvCKBcib1t6DJh/exec
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
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
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 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