Help

Single select as Linked Lookup Field

Solved
Jump to Solution
1032 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle_Fox
4 - Data Explorer
4 - Data Explorer

Hello!

I have two tables “Episodes” and “Team/Dates”. “Episodes” has a single select field called “Status” with 20 non-alphabetically listed options. When I create a linked lookup field in “Team/Dates” to the “Status” column in “Episodes”, it imports the field as text.

Is it possible to import it as a single-select field? Or to somehow retain the sorting order from the “Episodes” single select field?

The two workarounds I’ve found so far are adding a numerical prefix to each status (e.g., 01 Script, 02 Storyboards, 03 Edit) or using a formula in the second table with an emoji in front to do sorting.

Thank you!

1 Solution

Accepted Solutions
Aron
7 - App Architect
7 - App Architect

The formatting is indeed lost when you lookup a single select from another table and you’ve already figured out the solve I would recommend! Thanks for the feedback Michelle.

See Solution in Thread

1 Reply 1
Aron
7 - App Architect
7 - App Architect

The formatting is indeed lost when you lookup a single select from another table and you’ve already figured out the solve I would recommend! Thanks for the feedback Michelle.