thanks for the guide @Sain_SK
Very Nice guide Thank you so much
- āClick share and public the linkā - this is for your spreadsheet, your spreadsheet sharing option needs to be set to āanyone with the link - can viewā as a minimum.
- You use HTTP GET in your app blocks, why do you have doPost() in your script ?
please tell me how to make category and subcategory in google sheets please guide me
"doPost(e)" in the script is for storing values from our app to spreadsheet.
The way is more fast, convenient and free in comparison with airtable. Thank you so much
If we use doPost or doGet it should be free from category. If it exits then entry will be recorded.
Once you get data, you use formula in sheet 2 like what you want
Useful Guide, Keep Up The Work.
Else if we want to get a specific row from our spreadsheet, then you have to write the following script in your Script editor:-
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.Name, e.parameter.PhoneNumber,e.parameter.Gmail];
sh.appendRow(data);
return ContentService.createTextOutput("Success");
}
else if ( e.parameter.func == āReadOneRecordā) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheets()[0];
var rg = sh.getDataRange().getValues();
var outString = āā;
outString += rg[parseInt(e.parameter.id)].join(ā**ā);
return ContentService.createTextOutput(outString).setMimeType(ContentService.MimeType.TEXT);
}
}
And also we have to add some additional blocks in our app:
I am pleased you understand that
I found some great resources on web that you can use:
-
http://gsx2json.com ā you will get pure json from any google spreadsheet with only 1 minute of setup with absolute free.
-
https://baserow.io --alternative to Airtable and google spreadsheet with full CRUD api online with unlimited rows/tableā¦Also you can can host your own as itās opensource.
-
GitHub - Niotron/TinyWebDB-Google-App-Script ā host use TinyDB web on google spreadsheet with free script.
All above is practically used by me and very usefull.
I like your guide. Will be of immense help for me. Thanks
Is it fast as well?
Yes. I havenāt compared to other DB options which is available in kodular but sure performance is very good even in multiple web request simultaneously.
Do you know how ro use this website?
I want to know.
http://gsx2json.com/api?id=SPREADSHEET_ID&sheet=SHEET_NUMBER&q=QUERY
Call this using web component to get json format
i also have some issues please helped .
and your issues are ?