CRUD Method for Private/Public Google Sheets

Guides Resources
#1

Hey Everyone,
This is a New CRUD method basically kind of similar to @TIMAI2 version of CRUDQ version 2 but I kind of made it more easier for people to understand it and expand the script if needed.

This is why I recreated CRUD method using google app script for Private/Public Google Sheets.

Here are the google app scripts:
(I wanted it to not be super long and as simply written as possible so I posted a google docs)

Click here to open

NOTE: I am Still Adding stuff and modifying some of these functions (Maybe in the future I will provide a video tutorial)

Test the data flow here using this aia (AIA link is provide in Google Docs link provided above):

Test APK.apk (5.6 MB)
(This APK hasnt Changed in a long time) compile the aia for the latest Functions

Here is the link to google sheets connected with this test apk

Thanks,
Sai Athulith Neela

1 Like
#2

Remember to Create a New Deployment set it to Web App and the who has access to anyone and execute it as to me:

image
image754×629 5.07 KB

also dont forget to Authorize it with your account where the google sheet is located

1 Like
#3

Added New Column Functions and Row Functions:

  1. New Row
  2. Remove Row
  3. Write Row
  4. Get Row
  5. Create Column
  6. Remove Column
  7. Write Column
  8. Get Column

More coming Tmr!!

1 Like
#4

Added Instructions for users to setup the scripts and blocks

#5

Added Cell Functions and Find Functions!!

  1. Get Cell using cellid
  2. Find Cell by checking the whole sheet given result cellid
  3. Find value in a particular row given result cellid
  4. Find value in a particular column given result cellid

Will add more functions Tmr

#6

Added Extra Features

  1. Find Row number of a value in a Column
  2. Create a New Sheet
  3. Query

I am done creating all kinds of different function that came on my thought if you guys have any idea or something that you need a script for in google sheets post your question here I will try to help when i can.