Multiple text aggregators

[Josh_Harris1]

Hi everyone,

I’m trying to understand how I can have two text aggregators.

This is part of my current scenario

In the add row module, I can map from the parse JSON module AND the text aggregator

The issue is that when I add another text aggregator, downstream it means I’m unable to map from either the parse JSON module or the first text aggregator. I can only map from the second.

Scenario with two text aggregator modules

Unable to map to parse JSON

Unable to map to first text aggregator

Only able to see second text aggregator

Is there a way that I can have multiple text aggregators. I ultimately need this to map into one google sheets update row module.

Would a workaround be to have multiple branches with the update row module pulling the relevent rows from it’s specific branch?

Any help would be massively appreciated.

Best,

Josh

[Stoyan_Vatov]

Hey Josh,

you cant access modules that are inside an aggregation. You can only get data from the aggregator it self.

What is the logic behind aggregating the parser and then aggregating the JSON? What is the data you are trying to process and why do you need two aggregations?

[Josh_Harris1]

Hey @Stoyan_Vatov,

Ah I see.

I guess the simple answer is to allow me to map form submissions into gmail, in a clearer, more concise way.

Prior to adding the initial JSON → text parser → text aggregator one of the outputs from the form was “CHECKED Inside fridge, UNCHECKED Inside oven”. Using the modules mentioned previously, allowed me to remove “CHECKED” and 'UNCHECKED". The outputs now also only show values that were ‘CHECKED’ in the form.

Currently the issues I have are:

• I have more form outputs that need the words “CHECKED” and 'UNCHECKED" removed.
• Addresses are coming through as one line without spaces. I need the addresses as either multiple lines or to include commas.

Hope this makes sense!

Thanks!