Hello dear community,
I am trying to build an app that lists projects with deadlines. This is my first project and I currently only use the free version of bubble since I wanted to test if my idea can become true. I am willing to get the payed version if anyone can confirm that this is even possible 
The basic concept is the following:
-There is a thing, a task that needs files to be uploaded by a specific user (for now it is an external upload to google drive which isn’t connected to buuble). When the upload is done, the user klicks a checkbox in a repeating group.
-Every thing has a due date. To not let this pass, I’ve created a deadline 5 days before the due date.
-I want the user to get an automated reminder via mail that the deadline of the thing has just passed.
The thing has the following fields:
-Departement (this is to be matched with the user)
-Due date
-Deadline
-Checkbox
The user has the following fields:
-Name
-Email
-Departement (can be a list of multiple departments)
What I wanted to do is the following automated process:
-The automation checks once a day if the deadline date of every thing in a specific repeating group equals the current date.
-If a thing with todays date as a deadline is found, the automation checks if the checkbox for the file upload is checked.
-If this is not the case and the user has missed the first deadline, the automation checks which user is responsible for that thing and sends him an email containing the things name and due date.
None of this works
To me this doesn’t sound to spectacular but when I tried creating this process I even struggled with matching the thing with a user. When a thing is created I want to only give it a department. The process should match the things department to the users department.
And then we’re not even talking about the emails content and so on…
I hope this was kind of understandable to you - maybe someone can help me 