Sorry if this is already a roadmap item but I looked around and can’t find it. I don’t do a lot with automations but wanted to set something up I’ve been meaning to do for years - move a project’s due date along with the last task in it due date. Wrike and some other tools have this. I finally sat down today with Fibery AI to work this out, and was told from the AI:
“Currently, Fibery automation rules cannot directly trigger when a field (like “due Date”) is updated on a related entity (such as a Task inside a Project). This is a limitation of Fibery’s automation engine: triggers only work for changes on the main entity or for add/remove events in collections, not for field changes inside related entities.”
It proposed instead a that the project due date have a formula that would line up with the final task’s due date, but that means you can’t update the project’s due date manually, which I need to do in some cases.
So if this is indeed a need and not tracked elsewhere, please log this as a new feature request, thanks!
You could just have a helper formula field showing the latest “due Date” of all the tasks, something like:
This Project.Tasks.sort(by due Date ascending).last.due Date
Then set up the automation to be triggered when this helper field is updated, and copy the helper field’s due date to the project’s due date.
Apologies for the incorrect syntax, hope it’s enough to get the idea across
ok thanks. I don’t have a developer to help with this, so to clarify - the AI told me incorrect information? Can I feed what you wrote @Chr1sG into the AI and see if it can figure this out? I have tried with the MCP connection from the LLM’s but they are telling me they can’t affect automations. Thanks again!
Here’s a step by step. If you need a hand, feel free to reach out.
Add a formula field called Task Due Latest on the project which gets the related task with the furthest due date. Probably something like Chris said: Tasks.Max([Due date])
Add another Another formula field which checks which is later, current project due date, or task with latest due date. Checkbox field called Project needs updated due date? with the formula [Task Due Latest] > [Due Date]
Then an automation which is triggered when that checkbox formula is changed + when it’s true. The set the project due date to equal the furthest task due date (formula field on the project entity). See here:
ok thanks Ron! And can you or @Chr1sG tell me if once I set up the API (which somebody else is doing in our org right now who’s actually a developer) will I be able to edit automations through an LLM? I have been trying to gauge Chat, Claude, a couple others and gotten responses that “the Fibery automations are unavailable through API” here’s an example:
1. Can I do automations myself once the API is set up? Partially. The Fibery REST API and MCP let me create/update/delete entities and trigger logic externally — but Fibery’s internal automation rules (the ones you configure in the UI) still live in Fibery’s automation engine and can’t be created or edited via API. What I can do is replace the need for those automations entirely by running the equivalent logic externally via API calls — for example, when a task’s date changes, you trigger me and I update the project date directly. So the answer is: yes, but by bypassing Fibery automations rather than editing them.
the experience with the Fibery AI was downright a pain I have to say - spent better part of 6 hours it literally kept trying to fix the simple automation and was doing things like updating the wrong field, adding a due date I didn’t want, and then reassuring me it was going to fix it “the next time.” I know the plan is to now leverage LLM’s and MCP’s to get into Fibery, but I do think if there was some basic level of AI available in Fibery that would be good, too. What we’re talking about in this case is a very simple thing - and between coming in here in the community and playing around with trying to get my LLM’s to do this, it’s just too hard and caused me more work that I’d like. While doing that Notion test I mentioned, its AI was able to do a ton of stuff at the snap of a finger, I think if would be great if the Fibery AI should got at least some “middle ground” capabilities so you could get stuff like this done in a few seconds and not have to invoke external AI - again use case being if you are just struck with an idea while working in Fibery and want to knock out quickly.
Thanks again I’ll try to come back and let you know if this worked! For now on the one instance of this the AI did complete, it told me the only way this works is if I add in a task that has the “furthest away” due date to the project. I can’t actually update a task when it’s in the project and have the project’s end date move with that task’s end date. Inconvenient workaround I hope your solution solves!
