Hi

I thought you might like to know about a method I evolved for repeating conditional fields on translated forms. This evolved from a problem I faced with a long form with many conditions that is translated to 9 languages. Basic knowledge of PHPMYADMIN, excel and notepad are required.

1. Create a form in the language you want, with all the conditions and formatting resolved as you want it.

2. Create a translated version of the form (Start editing the form in another language)

3. Create all the translations you want

4. Go into PHPMYADMIN and export as csv files rsform_conditions and rsform_condition_details

5. Open these in excel as UTF-8.

6. Copy all the cells in "conditions" and paste them below the last cell. Change the language code in the pasted cells (for example from en-EN to it-IT or whatever language your installation is using. Repeat the copy and paste and language change until all your languages are covered.

7. Copy all the cells in "condition_details" and paste them below the last cell. Change the translation in the pasted cells to reflect the translations on the form, eg if the original choice was a radio cell with "dealer" and "customer", change each to "Concessionario" and "Cliente" in the pasted cells. NB the translation must match the translation you have used on your form.

8. Create a sequence of consecutive numbers (starting at 1 if you are replacing your table contents) in the id column of "rsform_conditions" and in the id and condition_id columns of rsform_condition_details

9. Check that the id fields correlate between your sets of pasted data (so the it-IT conditions correspond to the "cliente/concessario" fields) and that you have the same number of rows in each table, and no headers, and then export these as UTF8 csv files.

10. In phpmyadmin, remove the rows you're about to replace, which might mean emptying both tables if you have no other forms to worry about. Import your new csv files into the respective tables. Check the form via the joomla back end and you should see that all the conditions now exist in the form for every language!