Would like to see a Master dataset hosted via Excel spreadsheet (or similar) that contains all Master data for a Control project and specifically the information commonly referenced via dropdown lists and pick lists on custom forms.
Suggested that an Excel file would reside on the Control site as a Master file where updates to dropdowns would occur. All forms would have the option to Map fields back to this Excel sheet so that when the same data is included and referenced on multiple forms, it only needs to be updated once via the Master Excel sheet and all referenced forms would be automatically updated.
This would greatly increase efficiency and accuracy regarding Custom Forms and the deployment of those forms and workflows on projects.
Matthew Blake
Thank you for submitting your idea. We understand the desire for it and will consider it for a future release.
