Please Help I want to read set and Get data specific cell at my google spreadsheets

Discuss
, , , ,
#1

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

I Need help in google spreadsheet Please if someone can help me?
#2

What have you tried so far?

Customized Google Spreadsheet Best Script Till Now
#3

Sheets
Sheets1312×657 54.3 KB

this the sheet im trying to input data from my app and in response like to receive data from cells

#4

blocks
blocks889×381 30.2 KB

Front end
Front end1281×733 75.8 KB

Just a start

#5

Front end
Front end1600×900 127 KB

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”);

}

}

#6

Are you using default spreadsheet component?

#7

Hi! Welcome to Kodular Community :wave:

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!

1 Like
#8

yes im using default extension

#9

thanks im working on it

#10

I still don’t know where to start. Please Help me

#11

Is other functions are working? Like calling data’s and writing in rows or columns??

#12

yes those works for me but randomly not writing at specific cells

#13

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…

#14

yes there is avaialble one

#15

show me the place…

#16

Sorry to say, you are trying to write in AIRTABLE and not in google sheet…

image

This Spreadsheet component is doesnot mean the google sheet but it means Airtable

#17

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.

  1. User will select the RAW Material first
  2. Type of cutting if this is a BOX cutting application will further ask Length width and Height
  3. Application further ask Machine Total Run time (save value to that cell)
  4. Labor cost
  5. Designing cost
    6 .Answer in Rupees . (Cell will be updated according to given input values)
#18

20221013_162640
20221013_1626401920×2560 267 KB

#19

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…

1 Like
#20

i have just tired tested your demo . other than that ihavenot tired anything else . sorry