how do i make so that i could choose 1 name from class (tahun6) the list in the spreadsheet, and then it will show me the number of merits from the spreadsheet.
so it work like this. click a class button(tahun6), choose a name from list, when chosen, a label or 2 label will appear and show name chosen and merits at the side.
thanks
Are you using the build-in Spreadsheet component?
if yes, you can
read the sheet data, you will get list, lookup the name in column tahun6, get the index, pick the item from column merit according to the index.
Firstly, don't store your data like this:
Store all records the same:
tahun5,Richard,1;
tahun5,Susan,3;
tahun6,Nick,2;
tahun7,John,4;
then you can more easily query the data by name/class/values
where do i type these
tahun5,Richard,1;
tahun5,Susan,3;
tahun6,Nick,2;
tahun7,John,4;
and whats the last number 1,3,2,4 stand for?
i read that using spreadheets component needs Google Sheets API.
In order to utilize this component, one must first have a Google Developer Account. doesnt google Developer account need to pay. i was hoping for free as im still learning
Sorry, let me add the header row:
Class,Student,Merits;
tahun5,Richard,1;
tahun5,Susan,3;
tahun6,Nick,2;
tahun7,John,4;
these would be the rows in your spreadsheet.
No, you do not need to pay for a google development account, follow the instructions provided
I use the Spreadsheet component for updating sheets and have never been asked for a credit card nor any money.
Ow... Similar like the spinnerID that i learnt from u right?
So do i put it as the first worksheet of the spreadsheet like last time?
You can if that is what you want to do ...
When you call the data from the spreadsheet, if you do not define the worksheet you want the data from, the request will always use the first worksheet.
Not if you first select a class name and filter the rows by that class name.
Then you should only see one class's student rows.
You need to remove any empty rows
Now you can query the data.
you can find them in Web (connectivity) component (not in WebViewer)
thanks ramon.
now finalize my app.
code below same like the tutorial
Would be better to make a list of classes: tahun1,tahun2 etc., then select from list to make the query
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
