Cognito-forms – Formatting a calculation field number

cognito-forms

I have two date fields with a calculation field to determine the total days between the two, using the code:

= (DepartureDate-ArrivalDate).TotalDays

The calculation field is a number type, but the result always shows a decimal result and I can't find a way to force it to be a whole number. I've tried the Int32.Parse method but it doesn't change anything. Giving the field a Text type works okay, but then I can't use the result in another calculation further down the form.

Any ideas please?

Best Answer

One option would be to add an additional calculation field to represent the numeric value that is set to Show This Field - Never. This field will only be available in calculations, so will not affect the layout of your form.

Related Solutions

Cognito-forms – Default Date based on Drop Down selection in Cognito Forms

I am a developer for Cognito Forms.

You are very close to getting the calculation to work, AddDays takes an integer value and the value and what you were generating is a decimal value. You will need to add a little extra code to your Due Date calculation to get it running correctly.

=DateTime.Today.AddDays(Int32(CalculatedTime))

One other change I would make to your calculation in the CalculatedTime field would be to remove the quotation marks (") from around the numebrs, so your calculation looks like this:

=ProjectType = "Flyer: Up to 30 Products" ? 7 : ProjectType = "Flyer: Up to 60 Products" ? 12 : ProjectType = "Flyer: 60+ Products" ? 18 : 7

Cognito-forms – How to reference a field on a different section of a Cognito form

Tom, unfortunately you cannot reference fields from "sibling" or "parent" sections in Cognito Forms right now. We are working on enabling this, but it is a bit more complicated than it would seem at face value, factoring in our support for validation, intellisense, automatic renaming, repeating setions, etc. that is built into our calculation system. Plus, this introduces what is called a "circular reference" in the model for the form, which presents it's own unique issues (like the browser or server crashing if we get it wrong).

This is on our Idea Board under In Progress, because we are actively working on adding support for these types of calculations: https://trello.com/c/dKhdGujx. Please up vote this feature and feel free to add a comment explaining how you plan to use this capability.

Best Answer

Related Solutions

Cognito-forms – Default Date based on Drop Down selection in Cognito Forms

Cognito-forms – How to reference a field on a different section of a Cognito form

Related Topic