Newbie Questions

Re: How to avoid infinite loops on setting fields

ckili — Mon, 14 Mar 2011 22:26:59 GMT

Thanks leoffneym, Yet, the user has the tendency of playing, and you'll end up with different ID's and descriptions. And in my (real) problem, I need to play with 3 drop-down lists!!! I came to understand that rules on a control run whenever the control changes, so by putting a check box field (default:false) and put a condition:if checkbox=false, then checkbox=true, do the actions, checkbox=false, then on the other control, when is changed, it'll find checkbox=true and won't run... In theory....

Re: How to avoid infinite loops on setting fields

leoffneym — Mon, 14 Mar 2011 20:29:28 GMT

In the conditions for your rules, check to see if the other one is blank: Ex: In field A, condition: If B is blank, set B. In field B, condition: If A is blank, set A.

This will stop your loop from ocurring, since it has no way to occur.

How to avoid infinite loops on setting fields

ckili — Mon, 14 Mar 2011 16:16:19 GMT

Hello, I have two fields, item ID and Description from an SQL DB. I put them in drop-down list boxes. When I choose Item Id, the Description should be set. When I choose Description, the Item ID should be set. If I put the rules, an error occurs: "An error occurred in the form's rules or code. The number of rule actions or the number of calls to the OnAfterChange event for a single update in the data exceeded the maximum limit. The rules or code may be causing an infinite loop. To prevent this, ensure that the rule action or event handler does not update the data which causes the same rule action or event handler to execute." I'm trying a solution with a checkbox (if checkbox1=false, checkbox1=true; actions;checkbox1=false), but any other suggestion is welcomed!