Problems encountered with repeating tables

[LTAN]

Hello. I’ve created a repeating table with 6 columns (course description,
course fee, type of training, no. of days, no. of participants, and total
fee). I have used a secondary data source (ms access). This is where I get
data in the drop down list of course description. I was able to automatically
display the no. of days as well as the course fee by just choosing one of the
course description (drop down) using Rules and Actions. My problem is that
every time I insert another row in the repeating table, it copies the no. of
days and the course fee of the previous row. Another one, it doesn’t function
anymore the rules and actions I made in succeeding rows.

I was wondering why it happens, because whenever I use repeating table with
no added rules and actions, it functions well.

Pls. help me. Can u give me the procedures on how to do it correctly using
Rules and Actions since I am not a programmer. Thanks a lot.

 

[Chandrakanth (GGK Tech)]

Hi,

Please follow these steps for implementing your functionality.

1) In the "Course Description" drop down properties select "Rules".
2) In the "Rules" select "Add", and select "Add Action".
3) In the "Action" drop down box select "Set a fields value".
4) In "field" text box select the "no. of days" node in the "Main Schema".
5) In the "Value" text box , select "Insert field or Group" and select the
"No. of days" node in the secondary data source
and apply "filter Data" so that "Course Description" field in the secondary
data source should be equal to the "Course Description" field in the
main data source and click on "OK" buttons.
6) After applying the above rules, you will see the "No. of Days" value in
"No. of Days" filed,after selecting the value "Course Description" drop down
field.
7) Please follow the above steps for implementing the above functionality to
the remaining fields.

 

[Swathi]

Hi
Read the following link. It may be helpful for you.
http://www.infopathdev.com/forums/p/1884/5078.aspx#5078

 

[LTAN]

Hi Chandrakanth,

Thank you for your response.

I would like to explain futher my sample table: i have 6 columns.
CourseDesc(dropdown), Type of TRaining (dropdown). the rest are all textboxes.

CourseDesc TypeOfTraining CourseFee NfDays NfParticipants
TotalFee
(drop down) (drop down)
Automotive Standard 50,000.00 5
Customized (blank)
Speech Power Sandard 80,000.00 3
Customized (blank)

How can I do these?

The user will first choose in the course description, then he will choose
what type of training, would it be a STANDARD or CUSTOMIZED. For every
course, it must be a Standard or Customized. He has to choose one. If the
user chooses STANDARD, the course fee and the no. of days should
automatically reflected in their respective fields, since the policy is that
if it's STANDARD, these two (Course Fee and No. of Days) are fixed, cannot be
modified. On the other hand, if the user chooses CUSTOMIZED then these fields
should be blank and should be filled up.

I've tried the steps you gave me. it was good. i just noticed that if i
choose course description, the no. of days will automatically be displayed.
but how about the type of training? since it should be the first to determine
before the no. of days will be displayed.

I hope I have explained it well. I hope you can again help me with this.
Thank you again.

 

[LTAN]

I have a repeating table with 5 columns. I have combined the Type and Course
into one drop down list box since I wasn’t able to configure the 2 drop down
lists in the repeating table.

Type/Course CourseFee No. of Days Participants TotalFee

Type/Course is a dropdown list box. The lists are as follows:
• Standard/ Automotive
• Customized/ Automotive
• Standard/ Speech Power
• Customized/ Speech Power

I was able to do what you have taught me. Thank you. If I choose STANDARD,
the course fee and duration are automatically displayed.

The ff. are the sample STANDARD TRAINING (These are fixed)

Type/Course CourseFee No. of Days
Standard/Automotive 50,000.00 5
Standard/Speech Power 80,000.00 3

I would like to ask another favor, if you could help me with this:

The ff. should be displayed if CUSTOMIZED has been chosen. I think these
should also be based on the COURSE FEE of STANDARD TRAINING

• Case 1 – if the NO. OF DAYS is reduced, the course fee should be the same
as the STANDARD's COURSE FEE.
• Case 2- if the NO. OF DAYS exceeds in the STANDARD, the COURSE FEE should
also increase per day.

For example, CUSTOMIZED / AUTOMOTIVE has been chosen. These should be
displayed.

Type/Course CourseFee No. of Days
Customized/Automotive 50,000.00 3

For example, CUSTOMIZED / SPEECH POWER has been chosen. These should be
displayed.

Type/Course CourseFee No. of Days
Customized/Speech Power 80,000.00 2


For example, CUSTOMIZED / AUTOMOTIVE has been chosen and exceeds the no. of
standard days of training. These should be displayed.

Type/Course CourseFee No. of Days Participants TotalFee
Customized/Automotive 50,000.00 6 1 60,000.00

Note: TOTAL FEE (COURSE FEE * NO. OF PARTICIPANTS)

Can you help me with the Rules and Actions i need to implemetn. Thank you
very much.