Show select_option suggestion when converting TO a single_select field
Problem Statement
When a user is converting any text field to a single_select or a multiple_select field they don't receive any sort of feedback as to which select_options will get created after the conversion. It would be nice if the user wants to change to a multiple/singe select field that they will be shown which select_options can get extracted from the "from_field" into a select_option. That way they can also decide which of the values to keep as select_options.
Currently the multiple_select field will try to extract select_options when the user does not provide any themselves. The single_select will only convert the values to a select_option if the user enters these values as select_option.
Who will benefit?
This will potentially benefit any user converting to a single_select and multiple_select field from a field from which they want to preserve the values.
Benefits and risks
A user can decide for themselves which select_option should be available after a conversion.
Proposed solution
Create a new API endpoint which takes in a field id (so in the case of a conversion the from_field) and respond with a list of extracted values which can then be used inside the multiple/singe select SubForm to show which select_options will be created. Example:
A text field column exists with the following two row values: row1: Option 1, Option 2 row2: Option 2, Option 3
The endpoint should respond with the following list:
['Option 2', 'Option 1', 'Option 3']
sorted by frequency.
Examples
When converting from a text field to a single_select or multiple_select field in Airtable, a list of values that will be converted to a select_option will be shown.
UI/UX Design Required
-
Substantial (This involves the creation of entirely new pages, layouts, many new components which don't exist in the style guide) -
Some (Mainly involves re-use or duplication of existing UI components with minimal customization) -
None (No UI/UX work required for this feature)
Priority/Severity
-
High (This will bring a huge increase in performance/productivity/usability/legislative cover) -
Medium (This will bring a good increase in performance/productivity/usability) -
Low (anything else e.g., trivial, minor improvements)