I need to automate the update of a dropdown project custom field based on a text project custom field value. The values are consistent because they originate from a dropdown in the PaintScout system, which is the source of the project data being transferred. This automation would streamline our workflow and ensure data consistency across systems.