General Caster is here. Get rid of formula columns!

CONCATENATE("https://drive.google.com/drive/u/0/search?q=", {item.name}, ";Photos")

😀 😇 🙌 👌

thanks @rob

I got it working for the time tracking column but not for subitem time tracking which is rolled up onto item. Any way around this?
Also, couldn’t work out how to format the timetracking beyond having the timetracking input e.g. to round to nearest hour. Using ‘Round’ didn’t work

Thanks for your help!

Can The General perform calculations and casting to subitem columns?
If so - how?
If not, is this something you’re planning to implement?

Many thanks in advance!

Hey @Nomphra.
Subitems are not supported at the moment, but we are going to support them in the future.
No timeplan for the release. Sorry.

general caster fans, is it true that I cannot include a casted hyperlink in a custom notification? I can cast the hyperlink for sure but I haven’t been able to include it in the notification message. Would anyone happen to know the casted columns supported in our auto-populate fields? My use case: I introduced the client to the item id column so that they could merge the item it with a survey link prefix because every survey link is unique. Then, in the scenario that the person is not part of the platform , they would be emailed the survey link. Formulas are definitely not a supported auto-populated field so I casted it into a hyperlink column and then also a text column. I’m allowed to select them as an auto-populated field but it won’t actually appear in the notification when I set off the automation. Pretty bummed.

Notifications can contain text only.
In addition General Casters uses notifications only when an error happens.

Hi Rob,

I should’ve been clearer, I’m not referring to general caster’s error notifications. I’m referring to monday.com’s notifications.
Ex: When I cast a date, I can include that casted date in monday.com custom notifications by choosing to merge the date column into the message. I cannot do that with a casted hyperlink though. I can choose a hyperlink field but it won’t actually appear in the notification message. Can you advise?

So please open a new thread.

I am trying to cast existing formula in a number column, but it doesn’t work.
The formula is using IF function.

@Altuijri

The formatting and language is slightly different than Monday formulas. Can you share your formula or an example?

You could also try the other General Caster integration “perform formula and cast to column” instead of the existing formula one.

Thanks for responding

It is as follows:
({Amount}-{Pay.1}-{Pay.2}-{Pay.3}-{Pay.4}-{Pay.5})/{Amount}%

I tired both integrations, but had no luck

What I want to do is casting a percentage in a number result, so I can use status and automation, as on automation doesn’t recognize the result number in a formula column, so I thought casting the result into a number column will help me to do what I need.

@Altuijri

I never use the “perform existing formula” integration simply because I don’t like the trigger “when any column changes”. I find that it is slower to trigger and not as reliable as “when status changes”. But I understand if you need to use that in your workflow.

I tested a formula similar to yours and the culprit is the “%” at the end of your formula. General Caster isn’t recognizing it even when performing an existing formula. Can you adjust your formula in Monday so that you get the same number result, without using the “%”? If not, you might want to look into General Casters formatting and figure out how to do it there. This link shows the functions that they support: Functions | Formula.js.

Keep in mind, if you are going to build the formula in General Caster, you will need to change you the bracketed column names to match GC’s formatting as well. You can’t just copy and paste from the Monday formula column to General Caster.

Hope this helps!

Hi @rob! This looks amazing…although I’m currently having trouble installing and running the integration. I am able to install the app and set up the integration but nothing happens (I’ve tried both the “any columns” flavor and “when status changes” flavor - both attempting to cast to a Text column. I’ve tried to make the formula just the name of the item for testing purposes and no luck. Any suggestions?

@adrian1 Please contact us at info@omnidea.it attaching your:

• User ID
• Account ID
• Account URL

good afternoon, i am trying do it with a mirror column to get it that information to a number column, if it is possible do that?, also i created a column of formula with the information of the mirror column but and when i did the integration with general caster in the number column get a 0 and not the number that i have in the mirror column. i need help please, thanks.

The new version of General Caster that will be released in a couple of days will support mirror columns.

Do you have any recipes that would only cast a formula result when an item is created rather than when any column changes?

Also if I am casting the formula result to a date column, Is there any way in the formula to make sure the time doesn’t show up in the date column?

Yes, item creation trigger will be supported.

The new version fixes it.
Please DM me to get an installation link.

Thanks Rob

I’ve sent a DM to you 🙂

I’ve just noticed that the app seems to have been updated but the ‘perform existing formula’ options has gone?

Is there a chance you can create an automation for ‘when status changes perform existing forumla and cast result to column’?

The new and improved General Caster version is available here:

At the moment the “perform existing formula” integration is not available.

Any idea when the ‘perform existing formula’ integration will be available again?

It has become an integral part of our workflow.

I agree! The existing formula is really important for us. Unless you can perform the same formula directly in Caster?