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.
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.
@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.
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…