Question

I want to use a radio button within the collection to determine which iteration populates fields outside of the colleciton

Version 11 Classic Form Designer Ideas

Updated April 1

asked on March 31

I am wondering if I can have a collection that has values associated with a radio button that then allows the values of the collection to be populated in fields outside of the collection.

If you select Biological Mother then these fields are populated on a different form in the Business process:

then if there is a father the fathers information is populated in these fields:

I would like to do this using formulas. I have tried a simple if statement and I have tried using index and row but it doesn't seem to work properly. There will always only be one biological father and biological mother. I fell I am missing something with how I am calling up the radio button. Any help is appreciated.

0 0

Replies

replied on March 31

I find it unclear on what values you want to go where and under what condition. What is your expected outcome?

0 0

replied on March 31

If Biological Mother is selected in radio button and then they fill out the first name, last name, DOB and Tribal ID, then in the other form the Mothers first name is filled with the First Name in Collection, Mothers last name is filled with the last name in the Collection etc.. Based on the Radio Button selecting Biological Mother. The same would happed if the Biological Father was select filling in the Fathers first name etc..

0 0

replied on March 31

Formula does not have the ability to iterate through all rows in a collection and find a certain value.

How many rows could it have in your collection? If it's only one or two rows then you may use IF formula to check them one by one; but if it's a collection that allows adding many rows, then I think you'd better switch to use custom script for getting the data.

0 0

replied on April 1

there would only be a maximum of 3 rows, most of the time 2. I had a feeling that I would need to use jquery. I did try an if statement and was able to populate mother's data when she was the only row, but when I added 2 rows, one for mother and one for father, it did not populate the fathers fields and instead put both variables in the if statement under the mother. I had different if statements in each field. Just seems messy and the script would be the better way to go. I was just wondering if it could be done.

0 0

You are not allowed to follow up in this post.

Question

Question

I want to use a radio button within the collection to determine which iteration populates fields outside of the colleciton

Replies

Sign in to reply to this post.