Hello, i am building a web app and i am having trouble on building a dropdown to show different values from a table.
For example, i have a table with 3 columns: city names, IAP(which is a value like 1.11 that changes for every city) and year column. So each city has a value for every year. I have 18 cities with 18 different values for 2011, the same 18 cities with 18 different values for 2012 etc etc. The value i want to display on the dropdown is all the years from 2011 to 2020.
My code right now for the dropdown is
self.start_year.items = [(row[“Ano”], row[‘IAP’]) for row in app_tables.iap_table.search()]
(“Ano” is year in portuguese)
But this code displays values on my dropdown like this:
Instead of showing 2011 eighteen times like that i want to display it only once, and 2012 only once and so on.
The final goal is to pick a year in the dropdown in order to show data on the chart on the right side of that screenshot.
Can anybody help me do that? i am new to Anvil but every detail you need to further help me i can try to share.
Thanks!
