Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Duplicate Single Line Text into Multiple Select in a different column

Topic Labels: Formulas
549 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Capture.JPG

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:

IMG_FE29B735C670-1.jpeg

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.