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

Question

Question

Set field value based on Row with checkbox

Forms Layout Designer Forms
Updated April 25
asked on April 23

I have built a Form Collection and set the checkbox value by a lookup rule. 
What I am stuck on, is getting the EventID value in to a separate field. I also want other rows to be hidden when one is selected. I almost have a solution for hiding the rows, based on counting the checked boxes. However, that breaks when I use the lookup rule to set the checkbox names.

 

Any help would be appreciated.

0 0

Replies

replied on April 23

Just to clarify, you're wanting to duplicate the selected checkbox value into a field outside of the collection, and only allow them to select one checkbox within the collection?

Personally, I would remove the checkbox & collection, and instead use a radio button above a section that then fills in information based on the selected value & your lookup table (since you said you're only wanting one showing/selected).

If I'm way off on what you're trying to accomplish, please let me know and I can try to find another solution.

0 0
replied on April 23

Thanks, Sarah. 
The idea is that a staff member will select a training course name from a dropdown. Then, the available event times are listed in the collection (as above). We then want them to select only one of those listed events. We would like to hide the other events once they have selected one. 
On the row that they have selected, is a field called Event ID. I want that value copied to a single line field outside of the collection. 

Clear as mud? :)

Jono

0 0
replied on April 24

I think the complication here is going to hinge on the fact that the checkbox is populated by the lookup, so you don’t know what its value is in advance.  Unless I’m mistaken, any formulas that can count the checkboxes or reference fields from the row with a marked checkbox - are going to depend on the value of the checkbox.

Since the value appears to be the same on your Event ID field and the checkbox - could you just populate the Event ID and leave the checkbox set to a regular default value that you could use in formulas?

0 0
replied on April 25

Rather than showing all of the available event times & details in collections, could you use a second drop-down with just the dates and times listed as the options, instead of selecting by event ID? You could then have the values set to the corresponding event ID, and have it fill in a section with all of the event details based on the date/event ID they select. 

If you're working with a small number of options, I think it would be reasonable to add a blurb prompting them to select a date/time to see more details, and then they can decide from there. 

It would limit them to only selecting one event, and it would allow you to easily pull the value for that event ID.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...