Hello @robmulally!
Thank you for the feedback. We know this is a requested feature. I will share your feedback about the feature not being native to monday with our team
Cheers,
Matias
Hello @robmulally!
Thank you for the feedback. We know this is a requested feature. I will share your feedback about the feature not being native to monday with our team
Cheers,
Matias
I have to be missing something obvious⊠I have the free version, but based on the documentation I believe it should function as intended. I am simply testing the casting of a text column to a text column, no other formulas.
When I first click the text input column, it says {undefinedâs Text Input}. When I hit done and go back into the formula, it then says {pulse.Text Input}. When I change the status of my item to trigger the integration, I get a #NAME? error. I donât understand how because there should be no syntax errors.
Did you find a solution to this? I am having the same issue but on a new board it works fine
I did not. Gave up on testing General Caster after this.
Thatâs definitely a Mondayâs problem.
General Caster doesnât manage the integration window, Monday does.
If, when you click on a column button at the bottom of the formula box, you get an incorrect column reference, General Caster canât link to it.
Please report the problem to Mondayâs support.
Roger that, will do.
Iâm having a hard time connecting with General Caster support team using the email help@generalcaster.app on their website so I thought Iâd bring my issues to the monday community to see if I can get help here.
Here are details on the GC recipe I"m using and an explanation of what I need it to do. I know my formula needs revised to meet the specifications of General Caster but donât know what it should be. Looking for help ASAP!
Thank you<
Carrie
Hello there @Carrie,
I believe the syntax is not correct in your GC formula.
You can find the documentation on how to format it here.
@rob would you be able to help build this formula here?
Cheers,
Matias
Hey @Carrie
Sorry for my late reply.
I confirm the formula is not correct.
You need to use an Excel-like syntax, as explained in our documentation.
As you are working with a Duration column you need to use a Helper function, which requires a M plan or higher.
Hello, as of this morning General Caster paid features are not running and the website https://generalcaster.app/ is no longer accessible.
Is this app still being supported?
Hello there @meti_integration,
Does this problem persist for you? I see the website and the integration works on my end.
Cheers,
Matias
Sorry for the problem, @meti_integration.
We experienced a temporary outage, now fixed.
https://generalcaster1.statuspage.io/incidents/kj4qbcyx17hv
Hi @rob, I am trying to calculate the next due date of a cat vaccine for our foster system. Iâm using conditionals as the duration between vaccinations changes depending on how many theyâve already had and how old they are.
I created the formula in a native Monday formula column, and know that it works. Here it is:
IF({Kitten}, IF({VaccineNo}<3, FORMAT_DATE(ADD_DAYS({Date},28)), FORMAT_DATE(ADD_DAYS({Date},365))), FORMAT_DATE(ADD_DAYS({Date},1095)) )
When I tried to convert it to use in a General Caster integration, I donât seem to be doing something correctly, as I also get the Jan 1, 1970 result.
IF({pulse.Subitems Kitten},IF({pulse.Subitems VaccineNo}<3,TEXT(DATEVALUE({pulse.Subitems Date})+28,âYYYY-MM-DDâ),TEXT(DATEVALUE({pulse.Subitems Date})+365,âYYYY-MM-DDâ)),TEXT(DATEVALUE({pulse.Subitems Date})+1095,âYYYY-MM-DDâ))
It also keeps auto changing "Itemâs " to âpulse.â
Could you please advise where Iâm going wrong?
@jodirkh Sorry for my late reply.
Subitems are not directly supported by General Caster.
Only subitems summary columns are.
In this case you need to use a Helper function to get a single value from a set of subitems.
Hi Rob,
I want to merge two hour columns into a text column based on the condition âwhen one of the hour columns changes.â I attempted to use the CONCATENATE function like this: CONCATENATE({Dealâs Hour Start}, âhh:mmâ, " - ", {Dealâs Hour End}, âhh:mmâ). However, itâs producing an incomplete result (Hour Start: 08:00, Hour End: 10:00; Text column: 8:0 - 10:0).
Could you please help me identify what I did wrong?
What did I do wrong?
Mmm, thatâs strange.
The formula
CONCATENATE({Dealâs Hour Start}, "hh:mm", " - ", {Dealâs Hour End}, "hh:mm")
shouldnât return
8:0 - 10:0
But you should see "hh:mm"
in the result.
What do you get if you perform the following formula?
{Dealâs Hour Start} & " - " & {Dealâs Hour End}
If I perform the formula: {Dealâs Hour Start} & " - " & {Dealâs Hour End}
I get: 8:0 - 10:0
The extra zeros are being skipped at this point.
I am having the same issue others in this thread have had, my General Caster forumla is returning Jan 1 1970 no matter what I do. The same formula is working in a nonautomated non-GC column just using a formula column. also once I get this to work is it possible to have the working days be a negative number, ie in my example have the Date 1 column return Feb 29 -2 days so Feb 27