Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Not Using the Primary Field for the Dropdown in Record Summary Interface?

Topic Labels: Interface Designer
Solved
Jump to Solution
1236 1
cancel
Showing results for 
Search instead for 
Did you mean: 
shelbybeck
4 - Data Explorer
4 - Data Explorer

I am creating a record summary interface but am wanting to use a different field than the primary field in my table for the dropdown to search up a record. Is this possible? Is there a work around? It is difficult to use the primary field in our table for searches as it is a code, it would be much simpler to use a different field. 

Thanks!

1 Solution

Accepted Solutions
Sherman
6 - Interface Innovator
6 - Interface Innovator

So the record is a "code", like "THX 1138", and you want to see something more user friendly like "Robert" in the pull-down menu?

Can you shift the code to another column? Probably the easiest solution I know of. If you're using that code as a reference for linked tables, you can add a look-up field maybe? You can also concatenate the primary record field with a formula that combines your code and the easier to view description. 

See Solution in Thread

1 Reply 1
Sherman
6 - Interface Innovator
6 - Interface Innovator

So the record is a "code", like "THX 1138", and you want to see something more user friendly like "Robert" in the pull-down menu?

Can you shift the code to another column? Probably the easiest solution I know of. If you're using that code as a reference for linked tables, you can add a look-up field maybe? You can also concatenate the primary record field with a formula that combines your code and the easier to view description.