Using Automation/Workflow to copy multiple languages form responses into one sheet

Rebecca Bennett

Hi,

I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish.

I have created an automation that filters for a particular school and creates a copy of the row on a new sheet for that school. The English version works fine, but the Spanish version will not copy over at all.

Would this be because the values in some of my column properties do not match because they are in different languages? I tried changing field properties on the recipient sheet to text/number but I ended up not receiving any responses in either language.

Is there a way for me to copy the responses of both forms into the same sheet?

Thanks!

Andrée Starå

Hi @Rebecca Bennett

I hope you're well and safe!

It should work, so I think something in the Workflow prevents it.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots of the sheets and Workflows? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!