I want to create a small web app which would display a list of movies, with a Google spreadsheet set as a database. So far, I was able to connect my spreadsheet to my app and I also added some filters to it. (As a side note, this thread really helped me in the process.)
Here is a very simplified version of my app: http://plnkr.co/edit/BtbSCVOh7KJsMHjANxMP?p=preview
I still have 3 problems with my <select>
, which I can't fix despite trying for hours:
- I can't sort my
<options>
alphabetically. Trying withorderBy
didn't return anything. - I can't figure out a way to split my categories when there are more than one for a movie.
- If the "categorie" field in my spreadsheet is empty, it will return a blank
<option>
which I would like to remove or hide.
My guess is that I'll need to update my function one way or another, but I'm a bit lost at the moment.
Any help on this would be really appreciated!