Set up a filter with date

[Nicky1]

Hi,

I’m new to make and I’m trying to create an onboarding process with an app called ‘Virtuagym’ and e-mail.

The goal is to send me several e-mails with a time delay so I can remember my team to take an action.

I tried to set-up a filter with data from Virtuagym. The data I’ve been using is ‘member since’.

My goal is to take member since as day one and use filters to send a e-mail with different delays in between.

The problem is I’m not getting any data through my filter.

Futhermore Virtuagym won’t collect data beyond the 5th of July. There are now members since that date, and I’ve added at least 20 in the system.

I’m looking for help to set-up the right filter.

Thanks

[samliew]

Welcome to the Make community!

I don’t think you should be using the “Watch New/Updated Members” module, since it only triggers once per event.

You should instead, create one scenario that triggers each day for each type of email sent, with the “Search Members” module, then filter only members date joined that matches the criteria for that particular email.

[Nicky1]

Thanks for your reply! I changed it and tried to filter it

How can I change the filter so I will send my an e-mail after 1 day after the date of ‘member since’

[samliew]

I do not have a test Virtuagym instance to test on.

Please provide the input/output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a bundle.json file, and upload it here into this discussion thread:

This will allow others to better assist you. Thanks!

[Nicky1]

I’m not able to create a json.file. I can’t upload it.

I’m sorry, I’m not the most experienced person here…

[samliew]

That’s okay, could you copy and paste the output bundle contents here instead?

1.

Could you format the output bundle by editing three backticks ``` before and after the code, like this:

```
<sup>input/output bundle goes here</sup>
```

2.

or select all and use the format code button in the editor:

[samliew]

This filter should work for you, assuming your schedule is set to run once per day.

[Nicky1]

I used the Filter but somehow there still isn’t a member who passed the filter. I also added someone yesterday so this person should get through

[samliew]

Did you copy my filters exactly? Please provide a new screenshot.

[Nicky1]

[Nicky1]

Wait, I see my mistake! I used the text operator istead of datetime.

[samliew]

You also cannot use “Equal to”. It just doesn’t make sense logically.

[Nicky1]

Yep, see it now! You’ve been a real hero and you helped me a lot! Thx!!