Insert Multiline Input items into the database

I’m not good at English, i’m sorry. I will try to be objective in the question: I have a multiline input, I will insert several lines with two phone data and name, separated by comma ,“” for example: 558499554454, Lucas (line break) 554488779845,André. OK! I would add each row to a database table separated by phone and name, containing all the rows of the multiline input.

image

Hey, I’ve never built a feature like this before. But if you’re looking to create a list of new users, you’ll need to create a recursive workflow.

When it comes to extracting the data for each user, I’d recommend using the ‘join with line_break’ formatting. This will help you break items down into each row. This tweet helps illustrate this in more detail.

Once you’ve broken the text into line items, you can then use the ‘split by’ function to split each row of text. When splitting the items, you’ll just need to add a comma ‘,’ to source the two items.

I know this doesn’t answer your question directly, but I hope it helps point you in the right direction.

1 Like

@lachlankirkwood1, that way I was able to add only the first line. Could by creating a loop i could give orders to go adding all the rows one by one in the database? [name] [phone]

Thank you! Obrigado! :brazil:

You can use the operators split by and join with to manipulate the values in the multiline input to take what is essentially a single text value and change them into a list of text

Screen Shot 2023-03-15 at 6.01.46 PM
Screen Shot 2023-03-15 at 6.01.40 PM
Screen Shot 2023-03-15 at 6.01.24 PM

The above screen shots show how I allow a user to enter into a multiline input a value such as

I love Ice Cream, I Hate Apples

and have the result look like

I love Ice Cream
I Hate Apples

1 Like

I would like the [phone] only [name] column in the database table to be entered. This should occur for all lines of the multline input. For example:

(input multiline)
558499545454,Lucas
558895423662,André
558433333333,Luiz
558444444444,Pedro
(…)

Save in Data Base
[phone] [name]
558499… Lucas
558895… André
558433… Luiz
558444… Pedro

1 Like