Skip to main content

Single Select field

  • August 11, 2023
  • 2 replies
  • 21 views

matt3
Forum|alt.badge.img+3
  • Participating Frequently

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.

2 replies

Forum|alt.badge.img+21

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.


matt3
Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • August 11, 2023

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.


I'll give that a try! Thank you.