I want to check physical media in and out, and to attach some basic details on an online form.
One choice that I want available when filling out this form is a 'project' to attach the record to. The project numbering is defined from a project management system (Teamwork). A list of projects can easily be viewed in a very simple google doc, as below.
Is there a simple way that I can present this list in my picklist, and when the google doc is updated the picklist will automatically be update, too, please?
Many thanks in advance,
Tom.
| dlj0082_small_project |
| dlj0083_another_film |
| dlj0084_a_commercial |
| dlj0085_short_film |