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).
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.
You should talk with monday on this matter. BTW, @mondayCEO, General Caster is for saleā¦
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.
@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:
You create a new pulse/item
You fill in a column like āFavorite Colorā or āPhone Numberā for that item
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
PS how did you come up with the name General Caster? Iām not sure I get it lol
Iām really enjoying the support and excitement you are currently providing with this feature 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.
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.
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.
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ā.
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?
The name is awesome too.