SeanS
BBuildShip
•Created by Harini on 12/29/2022 in #💬・general
string to array derivative
SOLVED: met with Shams (thank you!) solved my formatting issues, and gained clarity on using derivative columns.
9 replies
BBuildShip
•Created by Harini on 12/29/2022 in #💬・general
string to array derivative
Yes. Should it be something else? JSON? Code? I tried JSON without luck. If so, what would be the proper format?
9 replies
BBuildShip
•Created by Harini on 12/29/2022 in #💬・general
string to array derivative
This seems pretty straightforward, but I wasn't able to get it to run. Feel like I'm missing something simple and obvious, but don't know what it is. It simply doesn't seem to run, regardless of the trigger I use.
I created a derivative column (activityStepsArray) with a trigger from both source column (activitySteps). I added the following code to the derivative with the source field:
return JSON.parse(row.activitySteps);
But, no luck.
Maybe the format of the content is wrong? I was just using simple line breaks, but have also tried this format:
`[
"Whenever you hear your child babbling or chatting, imitate their sounds",
"They say ""bababababa"" while looking out the window of the car, you repeat it",
"Some kids may require a gentle entrance into this activity, even repeating them in a whisper may be best",
"Some kids will need a higher energy response, maybe singing their babbled sounds is best to get their attention",
"We are trying to establish the game of vocal imitation by imitating them",
"Use fun facial expressions and movements if your child enjoys them",
"Be silly, have fun!",
]'
Any suggestions? I'll post a screenshot below.9 replies
BBuildShip
•Created by Harini on 12/29/2022 in #💬・general
string to array derivative
Awesome. Thank you!
9 replies
BBuildShip
•Created by Harini on 12/29/2022 in #💬・general
string to array derivative
Hi @harini I found the docs for creating a derivative field and understand how this works, but I'm not a dev and wondering if you have a example of what's needed to parse a text field and then store it as an array in another column?
9 replies