Hi Bubblers,
Trying to figure out whether it is possible to create a way of converting a list of text items in a multiline input to individual items in a database. This is a function that a Trello card has.
See the video for an example.
Thanks in advance
Did you find a solution?
Not yet. Still working through. Have you worked on something similar?
i believe you can get this to work using regex using :extract with regex. problem is, i can’t find a regex pattern that doesn’t seperate by a space, fullstop, etc. if you could find a regex pattern that only seperates by different lines, then you can do what you wanted to do. hope this helps a little
Good idea, I’ll give it a go.
and if you ever do find a proper solution, please let me know. i’m also looking for something similar and this is the most i could find
Convert line breaks (just hit enter in the "text to find) into commas using F&R.
The extract with regex using [^,\s][^,][^,\s] which will give you a list split on commas
It will break if someone puts a comma in the input … so you can nest a F&R for commas>space inside as well if you like.
@NigelG thank you so much sir. Will give this a crack and feed back.
@warren.hobden any success on this?
I’m trying to get each row of the multiline input to the database. Maybe your case may be helpful for me
Hey there, sorry for the delay. Not had chance to work on this yet. Will let you know when I have built it.
Hi!
I had the same task.
So, here is my solution. Not the best and not the most optimal, but it seems to work.
Without plugins.
We can use Schedule API Workflow on a list event. Type of things = text. And pass the list of text things. In order to convert multiline text (from MultilineInput) into the list of text things we can use :extract with Regex with the pattern: [^\n][^\n]*[^\n]*
Maybe it’s not the best pattern, I’m not an expert in regex.
And you have to pass at least one parameter with This text thing. In my case, this is new_step param. These parameters are created elsewhere, I will show in the second screenshot.
Corresponding API endpoint must be created beforehand. In Backend workflows we create New API endpoint with specific text parameter/key (in my case it’s new_step). And add a step with a new thing creation where you can use this text parameter.
