Convert text information to relational data


I need to perform the following action.

I’m pulling information from a Mult dropdown and I need to write it to the database in a relational table.

The problem is that the mult dropdown is transforming the data into text and I can’t record this information, as the data type doesn’t match.

Could anyone help or suggest something to solve this problem?

Thanks :slight_smile:

One idea would be to change the multidropdown content type to the same data type you need it to be in, as now, it seems likely you have it set to Text.

If you are unable to do that, then you could simply set the value in the database as you need it by using a do a search for the thing and using constraints that are the multidropdowns value.