cognito-forms
It is possible to lookup values based on the value entered in a field?
e.g. I am trying to deign a form for staff to submit overtime claims – I would like them to be able to enter their payroll number / staff code and the form to display their name and hourly rate in separate fields.
I have tried using the If Then Else statement but this is cumbersome. I would like to retrieve values from a lookup table as if using a vlookup statement in Excel.
I am a developer with Cognito Forms. Unfortunately, you can only access the fields within the same container. Therefore, only the fields that are contained in the same section or repeating section are accessible. At this time, the only other option is to use a content field to provide that visual separation/grouping. However, we have discussed providing support for this in a future release.
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.
Best Answer
At this time, Cognito Forms does not have the ability to reference external data. They are, however, currently working on this feature. You can follow the progress of this feature on their Idea Board.