0

so I have a scenario in make.com that is triggered by someone filling out a typeform. One of the questions is a date.

The logic is:

if a sheet with that date name doesn't exist one is created and their details added.

if a sheet with that date exists their details are just added to the next row in existing sheet.

Current make.com setup

The problem is I can't get the filters to work properly. If you use a sheet value that doesnt exist theres no problem, but if you use the name of an existing sheet it incorrectly passes through the first filter and makes an error

enter image description here

The issue is its only comparing the values of the first bundle of the aggregated sheet names, and letting it pass through, whereas if it checked all of them it would see the sheet name does indeed exist.

enter image description here

So the question is how do I search through ALL of the sheet names within that aggregated array and not just the first part?

enter image description here

Thanks

bboybeatle
  • 549
  • 1
  • 8
  • 28

0 Answers0