Counting Items From Folders

Hi there,

I am trying to count the amount of files I have in a specific folder and then put this figure into airtbale.

I have done this by counting the number of bundles it outputs, but even if there are 0 files in the folder it will still output 1 bundle, and update the airtable field with the number 1 when I need it to say 0

Here is a video to explain. Any help would be much appreciated: Video Sending | Loom
blueprint (17).json (73.3 KB)

Hey @christargett
You can check other parameters whether they exist or not and based on that make a filtering.
Can you download and share output examples for both cases:

  1. files found and 2. no files found, so I can have a closer look?

Hello @christargett,

Understand the Problem

When you aggregate anything, even if the given input data doesn’t have any rows to aggregate, the aggregate still produces at least 1 bundle to show you the result of the Aggregation.
See this

Solution.

I’ve seen that on your attached blueprint in the aggregator setting you’ve selected option “Total number of bundles”. Keep it selected.
Now try this way.

Also don’t consider those other fields like ID, Created Time, and Name. That doesn’t matter if it’s there or not. The only important is “Total number of bundles” option from the Aggregation.
I hope this helps to you.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down:

4 Likes

Hey @christargett

You just need to map total nuber of bundles from aggregator. DO NOT map IMTLENGTH from aggregator.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation

This has worked perfect, really appreciate your help thank you

Hello @christargett,
:white_check_mark: Please remember to mark the most helpful replies to your questions as solutions. It helps keep the community organized.
:+1: