Multi select "rollup is not defined" error when trying to generate unique dynamic list from table value

Ask us anything How do I?
1

Hi!

I am following along with this tutorial here: https://www.youtube.com/watch?v=8e3-qvGb1ms

When I attempt to duplicate what was done for the rollup to extract values from the list, I am getting a rollup is not defined. I’d like to pull the unique lists of classes from the class column.

image
image1920×765 95.2 KB

Also, I notice sometimes in the tutorials the top level collection is added and sometimes the next level down is added, and I’m not sure of the distinction. In my example, spells would sometimes be added and other times it looks like spells.data should be added. Which one do you use when? I’m wondering if I’m grabbing the wrong level here, though I did try both.

Thanks for the help!

-Brendan

2

I ended up testing out the AI generator. The output it created was successful (I think). It appears to be working, though it doesn’t follow the same structure in the example documentation I linked previously.

image
image3071×896 248 KB

3

Did you copy and paste the ‘rollup(‘ in? Try backspacing everything and trying again, typing into the box.

When it’s correctly entered you can see that there’s this grey background to the words.

Something like your second screenshot, you can see that ‘distinct’ has a grey background, but not ‘rollup’ in your first screenshot.

1 Like
4

Oh that’s an interesting observation. I manually typed it originally, though I just retested and it seems to be working this time! I’m not sure if there’s a problem with the other way of doing it or not, maybe @Joyce can say.

image
image651×508 33 KB

5

Hey,
if you go to the javascript version, you will see that rollup in a gray background is actually wwFormulas.rollup. We parse it and display it in a more user friendly way inside the formula version. Normally copy/pasting take care of this, but maybe at a point you add rollup instead of wwFormulas.rollup and this is why it happens :slight_smile:

1 Like