I am currently working on building a keyword definition app in which people can open a subject, say Geography, and then be able to see keyword according to the topic given in a list picker. I would also like there to be an option where they would be a to view all keywords for the subject. I have managed to program one for the user viewing all keywords, but am struggling to program one for viewing keywords based on a particular topic from the list picker. The definitions are stored in a Google sheets database. I’ve attached a screenshot of my code below..
The “Geo_topics” is my list picker and when I select a topic using that, it shows up a runtime error or sometimes the argument is not valid error. How can I fix that?
I see! I changed the “get global keyword” to “get global table” but it still doesn’t show the correct keyword and definition from the database. Could it be that my database isn’t organised correctly? I’ve added a screenshot of that. The first column is for all keywords and the other columns starting from Climate Change are meant to be the subtopics
Instead, I recommend an organization that adds rows as the subject matter grows, like in this sample:
In this sample, the neighboring regions can be considered subtopics, and the subtopic nesting can be limitted only by the number of rows you add to the table.
Instead of going this way, why don't you store the keywords in another global list. So when user picks any item from listpicker, with the help of index just get the keywords from the new variable
In that case, would I need to create a list for each of the subtopics? Because when the user chooses from the list picker, then there would be another list of keywords to choose from.