You are viewing limited content. For full access, please sign in.

Question

Question

populating field from checkbox

asked on March 3, 2021

 

I have a form where the applicant chooses a board in the drop down from preference 1. If they choose any of the 4 specific boards then a checkbox opens up for them to select their qualifications to serve on the board.

I am trying to have a paired down form that I can print for our panel that will use the selection they have chosen in check boxes and fill a single line item of the choice they made rather than having all of the checkboxes on the printed version for the panel. When I try to do this the field is blank on the form. I have used the default value area on the single line field and selected the list of all check option and when I test it the field is blank and doesn't pull anything over. 

I have also tried utilizing workflow which is not working the way I am doing it. Is there a simple formula I could use to make this work. 

 

0 0

Replies

replied on March 3, 2021

Unless I'm misunderstanding the question, you can populate a single-line field with a simple formula.

=IF(checkbox.choice1,"choice1","")&" "&IF(checkbox.choice2,"choice2","")&" "&IF(checkbox.choice3,"choice3","")

You can hide the single line field from view to the user populating the form, but then include it in later user tasks, or reports, etc.

0 0
replied on March 4, 2021

Yes I am wanting it to populate the single line item with the check boxes. So where it says choice1 would I make that be my variable? or the value of each selection?

0 0
replied on March 4, 2021

I tried this formula and couldn't get it to populate my field.

0 0
replied on March 4, 2021

Double check that you are using the matching variable name and values from your checkbox:

  • Replace checkbox.choice1 with the variable name for the checkbox field and the value of the 1st checkbox option.
  • Replace checkbox.choice2 with the variable name for the checkbox field and the value of the 2nd checkbox option.
  • Replace checkbox.choice3 with the variable name for the checkbox field and the value of the 3rd checkbox option.

If in doubt, use the variable picker on the formula field (looks like a > sumbol).

0 0
replied on March 4, 2021

This is what I used and its giving me an error saying there is a calculation error.

=IF(PREF_1_Q_ASAB.Veterinarian,"Veterinarian","")&" "&IF(PREF_1_Q_ASAB.Animal_Welfare_Organization,"Animal_Welfare_Organization","")&" "&IFPREF_1_Q_ASAB.Resident,"Resident","") "&IF(PREF_1_Q_ASAB.Council,"Council","")&" "&IF(PREF_1_Q_ASAB.Shelter_Supervisor,"Shelter_Supervisor","")

 

1 0
replied on March 4, 2021

You're missing a bit of the formula, here:

...  &IFPREF_1_Q_ASAB.Resident,"Resident","") "&  ...

should be like this:

...  &IF(PREF_1_Q_ASAB.Resident,"Resident","")&" "&  ...

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.