Mapping a sub collection when the first result is empty

How To
1

I’m trying to grab some data from Everhour and throw it into a Google Sheet.

The first result from the Everhour query doesn’t have a budget value:

image
image712×954 77.1 KB

But most of the rest do:

image
image842×1426 125 KB

The issue I’m having is when trying to map values from the budget collection. Because the first result is empty, it’s not giving me the values within the collection.

image
image668×1150 39.2 KB

If I do a query for a single project in Everhour (one which I know has a budget), it expands and lets me select the values within.

image
image648×1476 54.3 KB

In the instance that I don’t have data within a particular result, I’m happy for it to be empty or 0, but I can’t get past the barrier that the first result is seemingly acting as a template for the rest of the results, and thus is preventing me from doing what I need.

Is there a way of manually typing in the sources of the values, rather than dragging them in?

Thanks.

2

Welcome to the Make community!

You can type out the values like this

{{19.budget.type}}
{{19.budget.budget}}
{{19.budget.progress}}
{{19.budget.timeProgress}}
{{19.budget.showToUsers}}
etc.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

2 Likes
3

Thank you for your help. I was sure that I had tried that, and it didn’t work, but as soon as I tried again, it appears to be working perfectly.

I assume you’ve got the 19 from from the top of the last screenshot? I’ve replaced this with a 1 (from the top of the 3rd screenshot) because that’s where I want the data from, and it looks like it’s working.

1 Like