Garbage pickup dates on Actiontiles

#1

1) Give a description of the problem
I’ve created a simple piston to keep track of the garbage pickup dates. Nothing fancy like some other, similar piston i have seen on this forum. But it was quick to set up and it works. I manually added all the dates and get a notification about it in the morning on the day itself. There is also a timer visible on the Webcore dashboard showing how long untill the next pickup.

Now im wondering if there is a way to use this timer to show on Actiontiles how many days are left till next pickup? I have read a few things about event logging and google sheets. Could this be a way? Or are there better ways to export data and make it visual? Any suggestions are welcome! Thanks.

Export number of days left every day at midnight -> Import into Google sheets -> Save as image -> Display image on Actiontiles

2) What is the expected behavior?
Be awesome

3) Post a Green Snapshot of the pistonimage

containers
containers.png1178×1310 161 KB

#2

image
DC649989-5013-4FCC-AFE9-E5BA1427A5D5.jpg1334×750 104 KB

Not really an answer to your question but this would be easier to maintain.

#3

That is a better way to do it indeed. Ive seen pistons which incorporate holiday days in it aswell. The problem is my containers do not come every other week. Sometimes they have an extra pickup. Especially my green container has a schedule which is pretty much random.

#4

I only checked the first few dates to see if there was a pattern. When found created this.

You could use the formatDate() function. Information is on the wiki. But it will be hell because you will have to basically do the same thing you did with all the happens daily triggers