I was wondering if anybody knew if there is a way to have a rule operate on the selected node in a repeating table without performing the rule on the rest of the nodes. I realized that this is a major drag on the performance of my form, considering the multiple views with multiple repeating tables.
I have a set of rules to execute when a user makes a selection in a drop down list box. My drop down list contains country IDs, country names, abbreviations, and pricing region codes (this is retrieved from an XML file), and the user selects a country (i.e. United States of America), then the rules I have set up will show the abbreviation in field in a repeating table (located in the same node/row), and set the pricing region code in a text box also in the same node/row. I'm assuming the rule will perform it's action on all nodes within the repeating table/section, and I assume this because when I have many rows inserted into the table it takes much longer for these rules to execute compared to when I only have 1 or 2 rows. There is a MAJOR time difference!
The question is if I can have a changing event (i.e. the selection of a value in the 'Country' drop down) trigger the same actions as the rules would execute, but only on the current node selected. The views where these rules are in effect have Master/Detail relationships on the repeating tables/sections shown in the view.
I am using C# Managed code and my experience with that language is limited, but I am confident that with some help I can figure it out if it's possible. Any help would be great, thanks!