I need to create a 2-page app where the 1st screen is for login and the second screen is to display data. I want to view data from Google Sheets. If the ID in column A and the password in column B match, then I want to show the data of columns C, D, E, F, G for that particular ID's row in labels on the 2nd screen. Is there any shortcut for this?
If someone with ID A1 is logging in, then they will see the data from their own row, something like that.
Please help me
TIMAI2
February 26, 2024, 8:21pm
3
How are your users logging in ?
You can use a gviz query, or the Spreadsheet component, or a google apps script for the second part of your question.
Here is a CRUD example for google apps script:
I have lost count of the number of times the community has received requests for help from developers, after following the Hay Kel series of videos on CRUD with google sheets.
The videos are well produced, and offer the viewer a good insight to creating the app-sheet-script ensemble required for CRUD activities.
However, the script is flawed: a bound to sheet script, with code that only allows the bound spreadsheet and use of the first sheet; hard-coded columns and hard-coded row data for upda…
and
Note: you may need to set your spreadsheet locale to UK English for the script to work. Thhis script has been set with semi-colons in the sheet formula used, instead of commas, this should work in all locales....
