Hi All,

This is about students of an academy filling an application form to be accepted to the academy. The fields to fill depend to which group a student belongs, knowing there are only 2 groups and about 20 fields per group. The two groups have about 5 common fields only to be filled at the end of the application form. All other fields are related to a single group.
The question to what group a student belongs would be asked as a first question.

I can use conditional fields but I feel uncomfortable to use so many conditions. What is the best approach to implement this use case?

I would still use conditional fields, it's the simplest approach

Thank you for your reply.

I thought over this again and again and I think the best solution is to have 3 forms: "welcome" & "group 1" & "group 2"

Form "welcome": the welcome form includes a radio group field that asks to which of the two groups they belong. The values of the two radio items are two URLs, being a link to the form of "group 1" and to the "group 2". The form info property has the "Submission return URL" equal to the radio group value {group:value}. And this "welcome" form is set not to store submissions in the database.

Form "group1" and form "group 2": two independent forms with their own submissions.

That works great, I implemented it last night. The only thing is that I'll have two independent set of submissions that I would need to merge in the excel file issued from an export. Not big deal but would be nice to improve.

Also, I have a field "counter" of submissions for each of the two forms. I would like that this counter be unique.

This is from a totally different database but i wrote a php file to query and return data I wanted to make a print list for a club newsletter, then in excel data I selected options that led to the files url and imported the data it returned. You could use that method with the submissions table perhaps