Database trigger (split text to a list)

Hello all, i need help with one think…

i have in database two fields but one is text and one is list. for another reason i are avaible save value only in text field.

what i want to do is backend workflow for database trigger and when is add new value to the text field automaticly will be change to a list.

the text is split by (,)

but i cannot setup the workflov :frowning:

please any help.
thank you

rather than using CSV in a input, can you not use a new data type and add it to a list?

sorry but i dont understand what you mean :frowning:

I mean your List of text values is just a dumb list of characters. your list of MSs are a list of entries from a data type.

yes i have created one more database entry like (list of text) the nr.2

here the backend workflow work with this setup:

and is created the list.

but i want to manipulate this values when i edit user data in pop up. and this not working now :frowning:

Sorry if I am missing something, it is hard to tell from just the screen shots. It looks like you are storing the MS as text rather than a database entry? why don’t you just have a data type called MSs and the on the order_tech_calls_user you store a list of MSs rather than writing them in to plan text as CSV?

Hello is hard to explain but,

i use plugin Floppy: localStorage, List Shifter for the store information to the database and i can store only like text i dont find any another solution. for that reason i need find the way how to make from that text like (MS1, MS2…) which is also oprion set (MS)

list of MS and i can edit this list of MS on the user.

thank you