List of texts to multiple rows

[amufaamo]

I am making project management app. Usually one project has several tasks. Is it possible to make from list of text to multiple row?

For example, project "Drive a car" has tasks below

1. Starting the Car
2. Depress the Clutch
3. Select 1st Gear
4. A Little Gas
5. Find the Bite Point
6. Handbrake
7. Moving the Car Off

When I add these tasks to form, I want to generate multiple rows at one time.

[TeeSee1 · Accepted solution]

By using an ENUMLIST (allow it new values to be added) or create a virtual column to split you longtext column into a list

SPLIT([your text col], "  //the quotes contain a newline character
")

then you should be able to use the technique described here.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/FAQ-add-row-per-value-in-EnumList/m-p/357133#M38...

[amufaamo]

Thank you so much. I could do that！！