Aug 11, 2023 08:38 AM
We interact with multiple Utility Companies (Water, Electric, Gas from different cities and counties).
Is it possible that when I select a Utility company, the contact information auto populates in another field (Separate Single Line Text Fields or a Long Text Field)?
Thank you.
Aug 11, 2023 12:45 PM
Have a separate table with the utility companies you work with and their contact information in separate fields.
Use a linked record field in the original table that links to the utility company table and lookup fields for contact info.
Single select fields are pretty, but outside of automations & scripts, there's no way to associate information with selections.
Aug 11, 2023 12:48 PM
I'll give that a try! Thank you.