# Database trigger (split text to a list)

**URL:** <https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107>\
**Category:** Database\
**Created:** [March 5, 2025, 9:47am UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107 "2025-03-05T09:47:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mj.martinjavorsky](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@mj.martinjavorsky](https://forum.bubble.io/u/mj.martinjavorsky)\
**Post date:** [March 5, 2025, 9:47am UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/1 "2025-03-05T09:47:36Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/e/8/e887e3b13788db1481bf978997b3a18b1af55440.png)

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.

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/e/d/ed44b5b88c4ff503cb86512fdb9dc394c5ae74a6.png)

the text is split by (,)

but i cannot setup the workflov ☹

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/e/9/e9832de3c6984e66360edc300eb19313ac34c3cd.png)

please any help.  
thank you

---

<div class="post-metadata">

**Author:** ![nfisher](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@nfisher](https://forum.bubble.io/u/nfisher)\
**Post date:** [March 5, 2025, 2:34pm UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/2 "2025-03-05T14:34:24Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mj.martinjavorsky](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@mj.martinjavorsky](https://forum.bubble.io/u/mj.martinjavorsky)\
**Post date:** [March 5, 2025, 2:39pm UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/3 "2025-03-05T14:39:56Z")

</div>

sorry but i dont understand what you mean ☹

---

<div class="post-metadata">

**Author:** ![nfisher](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@nfisher](https://forum.bubble.io/u/nfisher)\
**Post date:** [March 5, 2025, 2:43pm UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/4 "2025-03-05T14:43:58Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mj.martinjavorsky](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@mj.martinjavorsky](https://forum.bubble.io/u/mj.martinjavorsky)\
**Post date:** [March 5, 2025, 3:01pm UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/5 "2025-03-05T15:01:19Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/0/c/0c8278e9b6fd2b40fbfb8a5fd90e92d6a0124e66.png)

here the backend workflow work with this setup:

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/4/0/40e7380a2a40b639266b3aac72b6e5748e225212.png)

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 ☹

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/0/f06114285e8763c3a005e235ec7f1de8b6ab32f4.png)

---

<div class="post-metadata">

**Author:** ![nfisher](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@nfisher](https://forum.bubble.io/u/nfisher)\
**Post date:** [March 6, 2025, 8:43am UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/6 "2025-03-06T08:43:52Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![mj.martinjavorsky](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@mj.martinjavorsky](https://forum.bubble.io/u/mj.martinjavorsky)\
**Post date:** [March 6, 2025, 10:56am UTC](https://forum.bubble.io/t/database-trigger-split-text-to-a-list/362107/7 "2025-03-06T10:56:15Z")

</div>

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)

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/d/7/d7987aaa501fa68e3dbb724e761a5bf410503fb1.png)

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

thank you
