General

Re: Repeating table getting values from drop-down list boxes

MaroHamamjyan — Fri, 02 Sep 2016 05:57:29 GMT

Yes, you are right! How i didn't guess myself... Thank you Hilary

Re: Repeating table getting values from drop-down list boxes

Hilary Stoupa — Thu, 01 Sep 2016 15:05:24 GMT

So - the point is to only show one of those at any given time - they are all bound to the same field. You just need to add to the conditional formatting so only the one with the value options you want users to be able to select from is displayed. Does that make sense?

Re: Repeating table getting values from drop-down list boxes

MaroHamamjyan — Thu, 01 Sep 2016 10:12:49 GMT

You understood me well. I've attached a pic to show what i mean.

Re: Repeating table getting values from drop-down list boxes

Hilary Stoupa — Wed, 31 Aug 2016 15:14:36 GMT

Okay, I must have misunderstood. I thought you wanted the Unit dropdown to have a different source for the values the user could select based on whether division, group, etc had a value. I'm sorry - I just don't understand what you are trying to achieve.

Re: Repeating table getting values from drop-down list boxes

MaroHamamjyan — Wed, 31 Aug 2016 05:29:30 GMT

The last form is the form you sent. I mean the repeating table stores duplicate data, when one of the options is changed, the others are being changed as well

Re: Repeating table getting values from drop-down list boxes

Hilary Stoupa — Wed, 31 Aug 2016 01:03:10 GMT

Sorry, I don't understand again. :) Maybe attach your latest form?

Re: Repeating table getting values from drop-down list boxes

MaroHamamjyan — Mon, 29 Aug 2016 09:06:28 GMT

Thank you Hilary, the solution is very interesting! Just a problem still exists: when I choose an option from one of the drop-downs, all 3 are being changed as the drop-downs store duplicate data.

Re: Repeating table getting values from drop-down list boxes

Hilary Stoupa — Fri, 26 Aug 2016 21:31:29 GMT

Okay, now I understand. Thanks for the sample form! So - the issue is we can't dynamically change the data source for a drop down. What you'll need to do is have a number of dropdowns, set up to use the different fields for their values, conditionally formatted to hide. See attached, save the file locally, right click & select Design to open in design mode & preview.

Re: Repeating table getting values from drop-down list boxes

MaroHamamjyan — Fri, 26 Aug 2016 05:25:26 GMT

I need to check, if group is blank, then my repeating table should get values from unit, in case the unit is blank, my repeating table should get values from division, and so on

Re: Repeating table getting values from drop-down list boxes

Hilary Stoupa — Thu, 25 Aug 2016 16:23:23 GMT

Hmmmm. I don't understand. Can you attach a copy of your template under the Options tab in a reply?

Repeating table getting values from drop-down list boxes

MaroHamamjyan — Wed, 24 Aug 2016 07:14:39 GMT

I have several drop-down list boxes which get their values from an External list. I need to check if the 1st drop down is blank then my repeating table should get the values from 2nd drop- down list, in case the 2nd one is blank, my repeating table should get the values from the 3rd drop-down list, and so on… The rule “Set a fields value” with a condition is not working. How can this problem be solved?