Use update a row with aggregator

Hello

I’m learning Make and was wondering if the following could be possible?

Get daily weather forecast
Google Sheet - add a row with some information
Aggregator to obtain the average of the week
Google Sheet - update the last row
→ here is my problem : When I try to map the row from Google Sheet, I can only select the data from the aggregator.

Is it possible to map other data than the aggregator?

Thanks!

3 Likes

You can use inline array functions. Like map and get. With those functions, you can select items from an array.

1 Like

Heyy @Elisabeth_Rheaume Welcome to the community!

If you share relevant screenshots or scenario, explanation, output and expected mapping need, we can help!

Best,
@Prem_Patel

Hello

It’s unclear for me how to inline array functions. Can you explain more please? Thanks!

2 Likes

Hello @Elisabeth_Rheaume , since you’re using the aggregated values, you’ll be making use of inline functions.

Inline functions are a way to manipulate data within an input Field.

The highlighted areas are where you can find these inline functions. The ones you need are map and get

1 Like