Cognito-forms – Making field calculate different answer depending on another field’s input

cognito-forms

I am trying to use Cognito Forms to make a character sheet. I have a field called STR that can have values 10-25 for example. I want to make another field that automatically shows a value based on the value in the STR field.

So if STR is 10 or 11, field 2 should display "0"
If STR is 12 or 13, field 2 should display "1"

and so on. I can't seem to figure out how to make it work.

Instructions?

Best Answer

_{Disclaimer: I am an engineer on the Cognito Forms team and former Pen & Paper nut}

Looks like it's time for an intelligence check! rattle rattle Got it! Checking my languages, it looks like I can speak Elder Expression! This long forgotten language includes such constructs as "Ye Olde Ternary" and "Mathematical Verbisms!"

So, open ye olde scroll of Character Definition and include in this most ancient and prescient of documents an additional line item of type Calculation of the Numberic nomenclature. Append the Lay of Expressive Renown:
=Strength > 11 ? Math.Floor((Strength - 10) / 2) : 0

Failing that, the lost Ternary of Tho'mas can be used for more finite control: =(Strength = 12 Or Strength = 13) ? 1 : (Strength = 14 Or Strength = 15) ? 2 :...

But beware, along that path lies much danger and confusion!

Related Solutions

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.

Cognito Forms – Calculating Number of Selected Checkboxes in Repeating Section

Calculations for Repeating Sections in Cognito Forms, allow you to easily filter and total lists of structured information.

You can find detailed documentation for calculations involving repeating sections here: https://www.cognitoforms.com/support/51/calculations/repeating-sectionstables

For your specific example, the following calculation will automatically calculate the number of selected sessions across all repeating sections:

=CamperInformation.Sum(Sessions.Count)

You can then use this inside a discount calculation for a Price field outside of the repeating section as follows:

=(
   if CamperInformation.Sum(Sessions.Count) > 3 then -0.1 
   else if CamperInformation.Sum(Sessions.Count) > 1 then -0.05 
   else 0
 ) *
 CamperInformation.Sum(Sessions_Amount)

Best Answer

Related Solutions

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

Cognito Forms – Calculating Number of Selected Checkboxes in Repeating Section

Related Topic