Here is the section of code that is relevant to the question. What I'm trying to accomplish. Within the ui.R I'm trying to limit the choices of sites a use can pick based on the year chosen. I understand input.year will not work, I'm still new to shiny and not quite sure how to get the current choice from the user.
conditionalPanel( condition = "input.plot != 'googlemaps'", site1 <- selectInput( inputId = "site1", label = "Select a first site:", choices = dbGetQuery(db, sprintf("SELECT DISTINCT site FROM 'so.mo' WHERE strftime('%%Y',datetime(datetime(date,'unixepoch'))) ='%s'",input.year)) ) ), selectInput( inputId = "species", label = "Species:", choices = species_choices ), conditionalPanel( condition = "input.plot == 'calendar' || input.plot == 'timeVariation'", selectInput( inputId ="year", label = "Year:", choices = year_choices )