Hi Rob, in my Master-Detail app I do calculations on entire columns (full board only) and the challenge here is to get triggers on column changes. As a duplicate item in the UI does not trigger a column_change event you need to have both column_change and add_item triggers and find out in the backend if the add_item includes a value in the column where your calculation is based on.
I am still missing a trigger for “delete_item”, so there is currently no possibility to ensure your (e.g.) sum of a column is always up-to-date. It gets even more difficult when you want to do sum of columns for a specific group. For this we are missing a “change_group” trigger.
As you said, currently there’s a problem in how and when actions are triggered.
In addition, querying an entire board and updating an entire column are “heavy” operations, especially with large matrices.
My first concern is about speed. We are still struggling to get prompt updates for a single item, from trigger to formula to update, and this is something monday should improve.
General Caster is coming soon in Apps Marketplace!
That looks awesome @rob, I love the look of the app there 🙂 Glad you’re adding more and more features and keeping the quality high here.
-Alex
Thankyou @rob, looking forward to hearing your thoughts! 😀
Is there any info when will marketplace be available for us so we can enjoy in some of the great apps, like General Caster, people are making?
You can definitely get ideas from the Formula column and copy/paste it to get your General Caster formula, but you need to change all column references with correct placeholders (for example {item.date} and not Due Date).
Use column buttons at the bottom of formula field to retrieve them.
I can make the hyperlink work but I want to use the text field also as the display name so I added “;” the text field but that casts an error
Love the app! Solved a big chunk of our headache on monday.com
However the integration has stopped working and we are desperately trying to fix it. It says that usage limit has been reached. How can we unlock it for continued usage? Is there any pro plan we have to subscribe to? Please advise.
Is time tracking supported by GC? if not, is it on the roadmap? this would be super useful for integrating with salesforce, as formulas aren’t supported by integrations, so users could use GC instead to pull timetracking into SF as well.
looking forward to hear from you
Time Tracking column is supported as input.
It’s in the format HH:MM:SS.
hey
love the app
is it possible to control the Default value (the default text to display in link column) when i casting the formula Results to link column
