Google Sheets and Apps Script

Guides Resources
#9

Thanks for detail guide. I use google sheet for my database. Thanks

1 Like
#10

thanks! i yesterday start to learn this world of google apps script. this is very good :+1:

1 Like
#11

how to call data from a different sheet from google spreadsheet into tableview so that it doesn’t overlap from the data sheet that was previously called.

#12

Thanks for your guide. I change my script after i learned your guide.

With you guide, i can post data and update data faster. Thank you very much.

2 Likes
#13

The very easy way to use Google Sheet as rest api (CRUD) is here…also no cost…

Visit - https://spreadapi.com

#14

@ikshefi I customized your script and here it is

#15

At first the post seems terrifying. But as I proceeded accordingly. It worked. Thank you so much :+1:

#16

Sorry I have this problem when i try to go to scrept in my spread sheet

Untitled
Untitled811×487 11.7 KB

How to fix it

#17

@ABDILAHI_KHAMIS , see this link : Multiple accounts issue with Google Apps Script

1 Like
#18

Thank you it solved for your solution.

1 Like
#19

Thank you very much ikshefi !

I had 2 problems becouse I´m a beginer and explain solution for others.

  1. To add 3th element in a Kodular “make a list”, using Mutator
    http://appinventor.mit.edu/explore/sites/all/files/UserGuide/concepts/minmutator.gif
  2. To write “row” values, becouse a use bad separator: NOT ” , is this "
#20

:sweat_smile: Thanks, this helped a lot!

#21

How To Input 2 Text Inputs To To Different Rows

#22

HI @ikshefi

Please add a method for creating a new sheet.

#23

You can also use this

#24

Thank you so much for your work, it’s helping me a lot.

I would like your help to create in my API a “deleteRow” command.
I find the code in the manual, but I think I don’t use it correctly in my API. Could you help me ?

Here is the part of my API:

image

Thanks a lot !

Tom

#25

Try this this one work perfect for me

#26

Thx @eagle_vision !

I’ll take time to read it correctly. If I have some problems, I’ll ask you again.

Tom

1 Like
#27

Hello i had a problem with google spreadsheet with extension
it successfully post data up to 3 columns but not coming in 4 and further columns
please help

hope any one help

#28

Try googlesheets without extension that a mentioned above there is a app script put it on your Google sheet publish it you will be able to post more than 4 line if you don’t come right post you blocks here I will assist