Please Help I want to read set and Get data specific cell at my google spreadsheets . I’have reader topics here please help me in start. Thanks
This is the first thing I like to do.I already deploy the script into here is the example.
function doGet(e) {
return ManageSheet(e);
}
function doPost(e) {
return ManageSheet(e);
}
function ManageSheet(e) {
//CREATE NEW RECORD
if (e.parameter.func == “Create”) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var data =[e.parameter.C, e.parameter.D,e.parameter.E];
sh.appendRow(data);
return ContentService.createTextOutput(“Success”);
}
}
Are you using default spreadsheet component?
Hi! Welcome to Kodular Community
The Spreadsheet component uses the Airtable API, which is somewhat similar to Google Spreadsheet
The method I suggest is to use the Web Component to interact with your Spreadsheet, there are many tutorials here in the community!
#HappyKoding!
yes im using default extension
thanks im working on it
I still don’t know where to start. Please Help me
Is other functions are working? Like calling data’s and writing in rows or columns??
yes those works for me but randomly not writing at specific cells
I always use this script code method and it works very well (Thanks & credit to @TimAi2 )
BTW, where so the spreadsheet component is there? i am unable to find it in default components
I can able to write in ROWS, Colums as well as in any cell…
yes there is avaialble one
show me the place…
Sorry to say, you are trying to write in AIRTABLE and not in google sheet…
This Spreadsheet component is doesnot mean the google sheet but it means Airtable
Okey I have used your given AIA and Script . now I’m able to send and receive values. Everything.
In my sheet as you can see there are multiple selection like 1.5mm black sheet 2mm black sheet etc. i like to categories.
- User will select the RAW Material first
- Type of cutting if this is a BOX cutting application will further ask Length width and Height
- Application further ask Machine Total Run time (save value to that cell)
- Labor cost
- Designing cost
6 .Answer in Rupees . (Cell will be updated according to given input values)
This is not a big matter… just a mathematical equations only… if you have tried anything so for, please provide the demo AIA either here or in pm to me… we could try to fix it…
i have just tired tested your demo . other than that ihavenot tired anything else . sorry