Check schedule table daily and send SMS

[adominicci]

Hi:

I have a maintenance web app and it is complete but I need to once a day check my schedule table and see if there are maintenaces scheduled for the next day. If so I want to send an SMS to the person the maintenance is assigned to.

Any help will be greatly appreciate it. Thanks.

[theadaloguy]

Use make.com to call adalo collections api, filter to see events tomorrow, then send twilio text message from there

[adominicci]

Thank you. I will try it!!!

[adominicci]

Would it be something like this in the query?

[theadaloguy]

It looks like it should work, although i’m not a make.com expert, @Victor might be able to help more there.

[adominicci]

After looking at it I realized it will not work like that because it has the hour so I did the following. on the date schedule key value added the function

dateFormat(scheduled_date;“MM/DD/YYYY”)

and the filter

addDays(dateFormat(now,“MM/DD/YYYY”);1}.

I still have to test it; will let you know if it works. Thank you for your help.

[Victor]

Hi there,

@adominicci I’m not sure what exactly would you like to do with this query string. If you’re doing the filtered request to Adalo API (GET ALL filtered), then you need to use 2 params: filterKey and filterValue.
So in your case:
Query String, Item 1:

• you type in “filterKey” (no quotes) into Key
• you put Schedule_Date (name of the field) into Value
  Query String, Item 2:
• you type in “filterValue” (no quotes) into Key
• you put the date you need into Value.
  With this query, Adalo API should return all records for which Schedule_Date is absolutely equal to the value in Item2.

However this is becoming a bit complicated because of dates’ comparison. I can’t check right now how the dates are stored in Adalo collection, but as I remember if you’re adding a “date” property, then it should be stored as date at 12:00AM GMT+0. So you need to make sure that your comparison criteria (now+1) is also presented in the same format. You might need to play with formatDate / parseDate functions to achieve this.

If you’re not doing the filtered API query but just doing “GET ALL”, then things become a bit simpler (however you have a limitation of 1000 records returned in this call).
Instead of adding a query, you can set up a filter in the connection to the next module. There are datetime comparisons which will help.

@theadaloguy thanks for tagging

Best,
Victor.

[adominicci]

@Victor

However this is becoming a bit complicated because of dates’ comparison. I can’t check right now how the dates are stored in Adalo collection, but as I remember if you’re adding a “date” property, then it should be stored as date at 12:00AM GMT+0. So you need to make sure that your comparison criteria (now+1) is also presented in the same format. You might need to play with formatDate / parseDate functions to achieve this.

Hi Victor:

Thank you for all the valuable information. I was super busy yesterday with other work related stuff and couldn’t get to it. I’ll follow your suggestions and report back. Thank you always for all your contributions to the communicty. Regards…