Page 2 of 2

Re: NEEDED HELP URGENTLY TO DUPLICATE THE SAME IDS FROM ONE ROSTER1 TO ROSTER2

Posted: November 23rd, 2017, 7:16 am
by josh
If I am understanding your spreadsheet correctly you want to list the crops for each holder. I would implement that with a checkbox for each holder where the options in the checkbox are for the crops. So you would have a roster with two variables: holder id and crops checkbox. This will be easier than dealing with spaces in the roster.

An alternative to using checkboxes is to use a repeating form (repeats once per holder) with a roster for the crops. In the dictionary you would have a record with multiple occurrences (up to max number of holders) that has a holder id with one occurrence and an item for the crop code with multiple occurrences (one per crop type). Drop this record onto a blank form and it will become a repeating form with a roster on it for the crops.

Re: NEEDED HELP URGENTLY TO DUPLICATE THE SAME IDS FROM ONE ROSTER1 TO ROSTER2

Posted: November 23rd, 2017, 8:06 am
by gbos
Josh,
Since, I don't have much understanding of check Boxes as solution, I tried the second solution but was unable to drag the items on the form successfully. So I am sending you the dictionary created for your attention.
RepeatingFormsRoster.zip
(2.28 KiB) Downloaded 366 times

Re: NEEDED HELP URGENTLY TO DUPLICATE THE SAME IDS FROM ONE ROSTER1 TO ROSTER2

Posted: November 24th, 2017, 7:25 am
by josh
Drop the crop code first and then the holder id.