General Caster is here. Get rid of formula columns!

Hey @MarkHHH.
Sorry for my silence. Watching the video you sent right now.

@danaaviv Here’s the Date to Timeline tip:

wow amazing! thank you so much

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.

Love to have a discussion with you on this topic.

-Bas-

Hey @basdebruin.
Thanks for your feedback.
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?

Hey @MarkHHH.
I’ve just took a look at your video.
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.

Hey @Marko.
You need to contact monday support for marketplace public launch.

@Markoi was wondering the same, did Monday confirm that?

Could you help
I have this formula
CONCATENATE(“找不到项目”,{item.text74});{item.text74}
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.

Thank you!

Hey @AshleighOng .

The notification you received is related to the currency conversion service General Caster relies on for converting recipe.
Actually no monthly limit has been reach in General Caster.

We are working on fixing it asap.

I can’t make this app work even on the most simple formulas.

Hey @Patrick
Please fill in the form at WorkForms.

@rob firstly, really enjoying using GC- thank you!!!
I’m looking to set a timetracking column into a numbers column to show nearest hour but it’s not working -it shows 0 when its not 0. (video :Loom | Free Screen & Video Recording Software | Loom)
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

@halell Check documentation at https://general-caster.omnidea.it/documentation.html#how-formula-works-supported-columns

🙏🙏🙏🙏tenksomach

בתאריך יום א׳, 8 בנוב׳ 2020, 20:15, מאת Roberto Tremonti via monday Community ‏<monday@discoursemail.com>:

do not working😒

‫בתאריך יום א׳, 8 בנוב׳ 2020 ב-21:19 מאת הלל הופמן <‪halellhofman@gmail.com‬‏>:‬

@halell This is not how you concatenate strings. Please read documentation.

i was trying to figure out how to do it . i checked ther
but i did not succeed .
can you hakp me ?

// this is the link
https://drive.google.com/drive/u/0/search?q=
// i need to add the item name respectively for each item
{item.name}
// then for the display text
photos

‫בתאריך יום ב׳, 9 בנוב׳ 2020 ב-10:30 מאת ‪Roberto Tremonti via monday Community‬‏ <‪monday@discoursemail.com‬‏>:‬