I have a Google spreadsheet and I need to create a dynamic drop-down list on the form associated with the spreadsheet. For example, on the form, can I create a dropdown list field that lists as choices all the users in my Google Apps domain? Ideally, I would like to enable users to select a user (name) from the dropdown list. The whole point of this is that I do not want to hard code the names - or more specifically, the e-mail addresses - of all the users in my Google Apps domain. Can I set up the dropdown list field to automatically pull the names from a domain Directory or Active Directory, etc.? Any help would be appreciated. Thanks. - Ian B.
