🎉🎉🎉

General Caster now supports some useful functions to work with subitems and mirrored columns:

https://generalcaster.app/website/documentation/formula/#subitems-and-mirrored-columns

Functions are:

• 
  SUBITEMS.MIN({item's Order Amount}) will retrieve the lowest amount in all subitems;


• 
  SUBITEMS.MAX({item's Order Amount}) will retrieve the highest amount in all subitems;


• 
  SUBITEMS.SUM({item's Product Price}) will retrieve the total price in all subitems;


• 
  SUBITEMS.COUNT({item's Product SKU}) will retrieve the number of products all subitems.

Similar functions are available for mirrored columns: MIRROR.MIN, MIRROR.MAX, MIRROR.SUM and MIRROR.COUNT.

Happy Casting!

Hi! I’m trying to get GC to work, all I get is 0.

I have a board with multiple time tracking columns, and a totalling formula cell.

i’m trying to replace the formula with a GC formula:

SUM({item’s Person1’s Time Tracking}, {item’s Person2’s Time Tracking}, {item’s Person3’s Time Tracking})

But it always returns 0. Is this because it is readonly and/or in seconds?

Has anyone done work with time tracking and General Caster that could assist?

Hey @george_planit

Please take a look at General Caster documentation.

Time Tracking column is readonly and content is in seconds.

I suggest you to temporary cast result into a Text column to check what’s actually calculated.

Anyway you can use a simple operation with + to sum the values.

Hi all,

we have just released General Caster v2 with new triggers and new actions!

https://generalcaster.app/website/documentation/general/#integrations

Hey @rob

I was wondering if you can help with a formula please.

This formula is currently running on Monday but as its a formula I cant auto email the data to our team. So Monday have suggested using your app.

I have a IF statement running for 5x creative types can I run this formula like I do in Monday or do I need to set up 5x automations?

If I load just one this is the example formula -

IF({item’s Creative URN}=“urnsponsoredCreative:141796483”,“Digital Workshops”)

But it’s outputting nothing and I can’t figure out why

Hope you can help.

Thank you.

Danielle

PS I am using When Creative URN changes, perform formula and cast results to Enquiry Type

General Caster v2.1 is now available with three new integrations to cast formula results into item name.

We never stop to add new integrations to General Caster!

A new auto-increment recipe is now available in GCv2.2.

Hi @rob

I’m trying use GC to split text in an email column so that I can extract only the last part of the address in a text column like this: name@email.com will be extracted as email.com in another text column. I currently use this formula:

RIGHT({item’s Email}, LEN({item’s Email})-FIND(“@”, {item’s Email}))

or

TRIM(MID({item’s Email}, SEARCH(“@”, {item’s Email})+1,9999))

This works fine, but the result also include the original email address after a colon, like this:

email.com:name@email.com

My goal is to extract only “email.com” without the “:name@email.com”.

If I make the email column a normal text column, this does not happen.

How can this be fixed when using an email column? Is there a formula that can delete the last part of the result (:name@email.com)?

Anyone have advice?

Hi @rob i would like to copy an email from a mirrored email column to a email column. Could you give me the formula? It it possible? I understood from documentation that this would work but doesnt:

“{item’s Email}:{item’s Email}”

Hey @Sjurd

That’s a tricky question!

monday.com lets you specify a name for a given email address. If no name is set, email address is used, so that’s why querying the email column you get name@domain.com:name@domain.com.

So you should repeat your formula to extract again online the part at the left of the semicolon char.

Hey @elena

first of all cast {item’s Email} into a temp text column to check what’s actually retrieved.

If you see something like name@domain.com:your name, just cast it into the email column.

If you see something like name@domain.com, you need to convert it into the correct format with CONCATENATE function:

CONCATENATE({item’s Email}, ":", {item’s Email})

Thanks @rob !

I added a new column and extracted a second time as you suggested. It works fine!

I found out that monday.com does the same for the link column.

If there’s another workaround, please let me know, but for now this will do the job.

Just use a temp text column to check what’s actually retrieved. You can avoid to use it if you build one single formula that does the two steps in a single operation (and you don’t waste your GC monthly ops threshold).

General Caster feels so robust and intuitive that it should be a part of the core monday.com experience, in my opinion. I was surprised that I had to utilize a third-party app in order to set up some automations that I felt were rather basic, but General Caster made a lot of those really easy. Are there any plans to integrate with monday.com natively whether it be the app being bought or selling the app to them?

Thanks for your lovely feedback, @aholtzhauer . 😊

That’s anyway something your should ask to monday.com. 😀

I do have one formula question that I couldn’t seem to figure out… currently have a setup where there are two people columns (“Currently Working On” and “CAD Designer”), and wanted one column’s person to be casted to the other people column but only if a different columns status (“Current Stage”) contained something. I actually got it via:

IF(ISNUMBER(SEARCH("CAD",{project's Current Stage})),{project's CAD Designer})

However, if I ever take the CAD Designer column and unassign a person and not assign anyone, it doesn’t “assign no one” to the other column… so if someone was there before, they remain there. Is it possible to clear this out?

And in the opposing direction, how would one instead append a person to the column? I’m imagining something like:

IF(...,{project's Currently Working On}+{project's CAD Designer})

Not sure if “+” is the proper operator here. EDIT: Yeah should’ve thought this through better… can’t reference a column that I’m trying to cast a value to as it creates a loop. Still stuck on how to append a person to a people column though. 😅

Thanks Rob!

Hi @rob

Firstly I am very new to Monday so apologies for what maybe a rookie question

@george_planit asked a similar question on 24 June and I have reviewed the documentation to which you referred him.

My problem

I have items which have several subitems. The subitems have a formula cell calls “status point” that calculate subitem status “points” when the subitem status reaches “Done” using this formula

SWITCH({Name},“Detailing”,10,“AOS Checking”,100,“AOS Revision”,1000,“CFS Checking”,10000,“CFS Revision”,100000)*if({Status}=“Done”,1,0)

Subitems status points are summarised on the parent item and I want to use the total of these points in an automation to update the Parent status, which I cant do as Monday does not support summary fields in automation

So I have ben trying to use GC to cast the summary value into a number column that could then use in an automation

When I change the GC automation to reference a normal text or number field on the parent item the value is cast correctly by GC- For example {board name} works fine.

If I reference a summary field of a regular sub item number column ie {Job’s Subitems Numbers} (numbers being a vanilla number column in the sub item) it works fine

However the summary of a subitem formula field does not cast

I have tried SUBITEMS.SUM({Job’s Subitems Status Points}) and {Job’s Subitems Status Points}, but neither work.

Does GC work on summary field of formula columns or is this a limitation

Each of my sub items are sequential steps in a process and I want the parent status to reflect status of the most recent process- As I said I am a rookie so there maybe be a simple way to do this but if there is I cant find it- All and any help appreciated

Thanks

Steve

Hey @SteveinAU

The formula should work. Try and cast the result into a temp Text column (it accepts any value) to check what’s actually casted.

AFAICS you are using a custom automation/integration, that actually uses only the “action” part of GC. I guess it’s something new and available for some accounts only, as I can’t use it. cc @dipro

hi Rob,

It looks like this feature (using endpoint from apps in custom automations) is starting to roll out to specific accounts. I can see in my logfiles that some accounts are calling my app’s action endpoints without going through the subscribe endpoint (custom trigger). This causes a real headache.

Are you experiencing the same?

/Bas

Oooh, I didn’t know that, in this case, it skips the auth process. That’s a problem!

It can’t work without authorization.

Hi @rob ,

Thanks for the reply

I found another method to achieve what I need without formula fields

When I first set up the automation the screen was yellow. I am not sure how I managed to get the integration automation over to the automations section (White). From memory it just appeared in the automations section. I deleted the automation when developed the new method and I have tried to recreate this morning but there is no “perform formula” option in automations so I cant see how I could have created that automation in the automation section- Beginners luck 🙂

So I set up this one now

Work Points is a summary column of a subitem formula column and DT Status is a text column.

The result of the automation is a blank in DT Status

If I modify the formula to select non formula summary column or non formula column it works as

expected

These are the fields I have available in GC to select

Note point budget and Point Budget and Points Bal are formula fields and not available in GC for selection in a formula

I guess the feature is in A/B testing, so it’s not available for all and could disappear.

Formula columns are not supported because the value you see is calculated client-side and it’s not available as input in General Caster.

@rob How can the formula ENCODEURL work with a column.

It only find that works with ENCODEURL(“hello hello”) but does not work with ENCODEURL("{item’s name}") or ENCODEURL({item’s name})

Hey @elena

ENCODEURL({item’s name}) should work.

Just make sure you are using the correct column reference by clicking on the corresponding column button at the bottom of formula field.

Hi @rob no it does not work. I have tried lots of times, with lots of columns and doing it as you say.