Wanted to let you know that I understand your reasons for taking your time with the docs…
Cognito Forms calculations are very sophisticated, which is one of the reasons why we have not already released the documentation. …
Lastly, our calculations are based on an open source parser created by Microsoft in 2008 called Dynamic Linq. If you need more help in the short term and are technically minded, check out Scott Guthrie’s post, download the sample zip and read the full documentation under LinqSamples\DynamicQuery. After reading this documentation you will see why we are taking our time creating documentation that is more approachable for less technical audiences.
…and that I’m slowly managing to get my calculations to work with the information you have provided thus far.
I did have a problem trying to get this type of calculation to work (copied From your support site) =Attendees.Count(TShirt.Contains("Youth”) * 15 + Attendees.Count(TShirt.Contains("Adult”) * 20
– The error message I got had something to do with mixing strings and numbers.
I don’t know if this is the best way to handle it, but what I ended up doing was creating a separate number calculation for each item I wanted added up,
NoAdultTs=Attendees.Count(TShirt.Contains("Adult”)
NoYouthTs=Attendees.Count(TShirt.Contains("Youth”)
and then creating a currency calculation to get a subTotal:
SubtotalTees=(NoAdultTs*20) + (NoYouthTs * 10)
If if I have questions regarding other calculations is it better to ask them here or on Cognito’s support forum?
I’m going to leave a stellar review because despite the lack of documentation regarding calculations, your form builder is one of the easiest and feature filled I have ever come across, and I have tried them all!