General Caster is here. Get rid of formula columns!

Omnidea is thrilled to announce the release of General Caster.

This brand new app includes a collection of automation recipes aimed at performing enhanced calculations in monday.com without using a formula column.

magic

As of now, we have released two integration recipes.

  • MATH: When any column changes, perform math formula and cast result to column.
  • CURRENCY: When column changes, convert amount from currency to currency and cast result to column.

General Caster will be in beta until September 2020. Until then, we will be adding new features and work on bug fixing.

Click here for documentation and apply to join our beta program!

7 Likes

Hey rob,

Congrats for this development. Just wanted to know your journey while building these integration. You used which language?

1 Like

Hey @Dhruv45.
General Caster Ingredients: 85% Node.js, 15% tears and curses, 5% knowledge of percentagesā€¦

4 Likes

Hi @rob what kind of operators can we use, only math or logicals too? example. IF ? AND ? OR?

Logical operators are not supported yet, but we are working on it.
You can use all math expressions listed here: math.js | an extensive math library for JavaScript and Node.js

1 Like

This looks great! Is it able to do math involving time tracking columns? We currently have a formula set up that calculates the difference between the number of hours a client purchased (in a number column) and the time weā€™ve spent working with them (in a time tracking column).

1 Like

Thanks, @mwdiscopod.
General Caster currently supports separated recipes for each column type (i.e. number column for math calculations).
We are going to extend support to all columns inside the same recipe.

Hi @rob - will this become a fully integrated app within Monday at some point?

Iā€™m not quite ready to click ā€˜Installā€™ on the message that says Caster has not been reviewed or approved by Monday and it will have access to all of our boardsā€™ data. :grimacing:

2 Likes

You should talk with monday on this matter. BTW, @mondayCEO, General Caster is for saleā€¦ :grinning:

Due to how monday architecture is designed, complete board read and write permissions are required. Anyway General Caster doesnā€™t read any relevant data except for the columns used in the calculation and it doesnā€™t save anything.

2 Likes

@rob I will buy you a beer (and get rid of my custom code zapier zaps!) if you can do link column autofilling based on text value in another column. For example:

  1. You create a new pulse/item
  2. You fill in a column like ā€œFavorite Colorā€ or ā€œPhone Numberā€ for that item
  3. General Caster automatically creates a link in ā€œCRM Lookup Linkā€ column with url ā€œhttp://somecrm.com/search?color=[value from favorite color col]&phone=[value from phone col]ā€

Right now i have zaps that do this and make the change via apiv2 mutation calls. But apiv2 syntax is friendly as a cactus :face_with_symbols_over_mouth:

PS how did you come up with the name General Caster? Iā€™m not sure I get it lol

Hey @jk193.

You can do that withā€¦

The Marvelous General Caster v2

Now shinier than ever!

You can perform any and every formula supported by Formula column and cast result to another column.

The old Math recipe is now deprecated. Now you can use the generic Formula recipe.

4 Likes

It casts generic results so we mocked the US officerā€¦

2 Likes

@rob

Iā€™m really enjoying the support and excitement you are currently providing with this feature :slight_smile: The name is awesome too.

Iā€™ll make sure to pass any users who are looking for something like this in our support channels to this community post! Such an awesome way to help and provide even more value than ever.

-Alex

3 Likes

Hi @rob

I have a board that looks sort of like this

Open opportunities

  • Opp x (value x)
  • Opp y (value x)
  • Opp z (value x)

Won opportunities

  • Opp a (value x)
  • Opp b (value x)
  • Opp c (value x)

Lost opportunities

  • Opp g (value x)
  • Opp j (value x)
  • Opp d (value x)

Now, I need to do reporting and I would like to do it in the dashboard and display for example the conversion rate of WON. To do that I would have to take the SUM value of groups: OPEN, WON, LOST and divide by SUM value of group WON that should result in a %.

Will general caster have a dashboard widget that supports doing these kind reporting calculations or am I being too optimistic?

As soon general caster can do this and be vetted by Monday as a safe app to use. Then the skyā€™s the limit.

Thanks

Hey @Emil.
General Caster currently is a set of recipes, no widgets are available.
Anyway you can perform any formula supported by Monday and use the result as input for your widget.

Ok I understand. However will you be able to take the SUM total of a column and calculate with SUM total of another column in a board?

Calculations based on entire columns (all items in a group/board) is not supported yet and is something we are still thinking about due to how monday triggers an action.

Ok great. I will then keep following the progress. I wish you all the best with General Castor and hopefully one day it will become the tool that makes Monday ā€œwholeā€.

1 Like

Hi Rob,

We are starting to collect app nominations for the upcoming beta phase of the marketplace - let me know if this is of interest to you.

Best,
Amir.

Hi Rob,

When I cast a formula to a column type that is NOT Text, the automation does not work.

I understand this may be a limitation of monday.com?
However, do you have any suggestions on how to format a formula so that the results from the formula can be casted to a column type such as tags or dropdown?