Can I create a drop down box that shows a Code (in this case a trip code) and link it to another box where the Name of the trip corresponding to that code would be shown?
Cognito-forms – How to make the value of one field change based on changes made to another field in Cognito Forms
cognito-forms
Related Solutions
I'm a developer with Cognito Forms. Unfortunately, a checkbox can only have two states, checked or unchecked, which equates to true or false in the context of a calculation. However, I do believe you can accomplish your requirement by using the "Radio Buttons" option for the Choice field, without it looking strange or odd. A Choice field does not require a default value therefore you do not need a third option to represent that null state. For a choice field to not have a default selection, the checkbox next to all Choices should be unchecked. I included a couple of screenshots to help explain this configuration. The first one is the configuration for the "Radio Buttons" Choice field and the second is a Yes/No field configured to be visible when the Choice field value is "Yes". I hope this helps. Hopefully, I am not misunderstanding your requirement.
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
Related Topic
- Cognito-forms – Trying to do a calculation with a text field and a number in Cognito Forms
- Cognito Forms – Remove Commas from Number Field
- Cognito-forms – Select drop down field in one Cognito Form where the values come from another form
- Cognito Forms – Country Field with Drop-Down Menu
- Cognito-forms – Change Cognito Forms status from Incomplete to Reviewed
- Cognito-forms – Import Cognito Forms data from another page
- Cognito-forms – Cognito Forms: Lookup Value
Best Answer
You can easily change the values of other fields on your Cognito Forms using calculations. Here are two common ways to do this:
Add a Calculation field
Add a Calculation field next to your Trip Code dropdown called Name of Trip. Specify a calculation for this field that calculates the name of the trip based on the code selected in the Trip Code field. For example,
=TripCode = "SkiGetaway" ? "Colorado Ski Retreat" : TripCode = "Cruise15" ? "Alaskan Cruise" : "No Trip Selected"Calculate a Default Value
As an alternative, you can also update the values of other fields on your form when changes occur by using a calculation to update the current value of a field. Many of the field types support a Default Value, which can actually be a calculation that references other fields on your form. If you added a Textbox field instead, called Name of Trip, and used the above calculation as the Default Value, the text in this field would automatically change when the trip code changes. This is useful when you still want the user to be able to change the calculated value, such as an auto-calculated end date for a reservation.
Check out our documentation on calculations for more details of how to write powerful calculations in Cognito Forms:
https://www.cognitoforms.com/support/2/calculations