Duplicate Single Line Text into Multiple Select in a different column

Topic Labels: Formulas
927 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Is there a way to duplicate single line text into a multiple select column automatically.

My end goal is to be able to add additional item descriptions in my form while on the fly (Cell Phone Form).

IE: Add Flamethrower to Item Description while on the go.

Later I can filter based on the Item description.


1 Reply 1

Unfortunately not. Airtable’s field types are either reactive (i.e. pulling data from somewhere else: formula, rollup, lookup, etc), or manual entry (single/multiple select, single line text, date, etc.). They can’t be both.

You can add a new entry to that multiple select field on the fly, though not while in a form view. You’ll have to do it in the expanded record in a grid or other non-form view. Tap on the field in the expanded record, and you’ll see something like this:


In the field that says “Find or add option,” type the name of the option you want to add, then tap the button starting with the label “New” that shows your new item.