formRanger script

Below right, you see the "form source" work sheet. The list of "sessions" under Session 1 is used to populate the Session 1 pull-down on the form on the left. If you scroll to the right in the spreadsheet, you will see a Session 2 list which is used to populate the Session 2 pull-down on the form. Triggers can be configured in the Sheet such that as changes are made to the lists and the form "refreshed," the form is automagically updated.