Hello,
I am very new to coding, and quite efficient in excel so I am trying to learn coding. I have a table like below in google sheets.
Result should be as
Able to make unique lists
But stuck at duplicate count and value in dynamic view.
Plz guide if u can …
First of all welcome to Koding not Coding
All your id must be unique just use for each number in list block found in controls section
you can use SQLish commands together with the Google Viusalization API, see also App Inventor Tutorials and Examples: Google Spreadsheet Database | Pura Vida Apps see also the detailed guide by TimAI2 here
https://ai2.metricrat.co.uk/guides/use-gviz-to-get-and-query-google-sheet-data
Taifun
@Shailesh_Dhoot , may be this one helpful to you. You can use the same method as suggested in this post.
