Cognito-forms – Choice list autocomplete

cognito-forms

If I have a long choice list and I'd like the user to be able to 'search' the choices. This is in part possible with the 'Allow Fill in' option, as it shows choices as you type. However, this allows the user to enter a value which is not in the choice list which is not desirable.

Can this be achieved?

Is there a custom error which can be used to validate the field has a choice from the choices in the list?

Best Answer

I am a developer with Cognito Forms. Yes, you can create a custom error to display when an entered choice is not in the list of choices. However, your calculation used to display the error would have to check the entered value against all allowed choices. Below is an example of a calculation to display an error when the choice is not one of the following: First Choice, Second Choice, or Third Choice.

Related Solutions

Cognito-forms – Formats and Calculations

I am a developer for Cognito Forms

We do not have a way to auto format a field or change entered text from "123A5B78901E" to "12:3A:5B:78:90:1E". However you can use a calculation and pull the information entered into a text field over into a calculation field that will format the text for you. This will not validate the text though. In order to do this start with a Text field and then create a Calculation field just under it. You can then place this calculation into the Calculation field. In this example I am targeting the Text field titled "Text Field". This calculation will place a colon after every 2 items in the string. It wont change the Text field but the new calculation field will show the formated entry.

=TextField.Substring(0,2) +":"+ TextField.Substring(2,2) +":"+ TextField.Substring(4,2) +":"+ TextField.Substring(6,2) +":"+ TextField.Substring(8,2) +":"+ TextField.Substring(10,2)

If you want the number to be generated in a field that users cant edit I would recommend using a Calculation Field. This will show users the number and allow you to use the number in other calculations. You will need to set the "Type" of this Calculation field to "Numbers". You can then use this calculation to reference your choice field and assign numbers based on the selected drop down option. In this example I have used "Choice" as the Choice field title and then First, Second, and Third as each choice option. I have then assigned a number to each option First = 10, Second = 20, and Third = 30. If nothing is selected then 0 will be placed in the Calculation field.

=Choice = "First Choice" ? 10 : Choice = "Second Choice" ? 20 : Choice = "Third Choice" ? 30 : 0

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

Best Answer

Related Solutions

Cognito-forms – Formats and Calculations

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

Related Topic