Round robin survey which populates 3 database rows

[Peter OC]

Hi,

I'm building an infopath form as the basis of a questionairre. The
questionairre goes out to 4 people who score each other on different aspects.
An example of the database table structure:

ResponeID - ProjectID - Review Period - RespondentName - Role - ScoringWho -
Q1 - Q2 - Q3... Q13.

My first question is: I would like the form to automatically display the 3
repeated sections that will populate the 3 database rows for each person the
repsondant is scoring. How do I do this?

Second question: Depending on the selection of the 'Scoring who' field I'd
like only certain questions to be shown. How do I display / hide lines in a
repeated table?

Many thanks,
P

 

[Shiva]

Hello,

First question: You have to add the condition per each person repeated
section position is greater than 3 hide it. We will get the section position
using the function called position().

Second question: You have to add the Master/Detail repeating section then it
will display the corresponding value for that selected row. If you want to
show/hide questions/fields in that repeating section then you have to add the
conditional formatting for those fields depends on your condition.