Convert Long Text from Form into Multiple select in another column

[Zane_Wolf]

Hello,

I’m setting up a form where people can write their own keywords in a long text answer block, but I would like to have those keywords converted to Multiple Select in another column upon import, without having to do anything manually. Is this possible?

Thank you,
Z

[Justin_Barrett]

Welcome to the community, @Zane_Wolf! :grinning_face_with_big_eyes: Perhaps you can adapt one of the solutions that I shared in this thread a while ago:

Automation: Allow users to add new options to a predefined list via a form Show and tell

A question arose recently that’s come up a few times in the past: is it possible to give form users the ability to either pick an item from a predefined list or add their own “other” option, and have manually-added options actually appear in the list for later form users? For most of Airtable’s existence so far, this wasn’t possible (at least not without delving into the API, and even then I’m not completely sure that was doable). However, it can be done using Airtable’s automation feature. Here…