Translating Form Submissions

[Matthew_Bickfor]

Hello, Community!

My organization uses forms and survey extensively. We’re in small business services so we typically have a select field that allows users to pick their preferred language. From there, we create conditional fields based on their language preference. My issue is that I get records that are in multiple languages and have to use long and cumbersome formulas in the destination table to combine the responses and get them all back into English for reporting. Does anyone know a better solution that would conditionally convert everything back to the English response values? For example { if (person chooses response X-c in Chinese) then (data submitted is equivalent response X-e in English) }.

Thanks a ton for your help!

[ScottWorld]

Welcome to the community, @Matthew_Bickford!

My clients use DeepL.com:

deepl.com

DeepL Translate: The world's most accurate translator

Translate texts & full document files instantly. Accurate translations for individuals and Teams. Millions translate with DeepL every day.

DeepL has a completely free & very easy API, and it is supposed to be the best on the web for translating text.

You could use many different tools to tap into this API. You could write your own JavaScript scripts to do it, or you could use the DataFetcher app, or you could use my favorite no-code tool, Integromat.

With no code at all, Integromat can automatically translate all of your text into English:

Integromat

DeepL Integrations

Online translation service.

p.s. Even though there is no code involved, this would still likely take you a few hours to setup. If you have a budget for your project and you’d like to hire an expert Airtable consultant & Integromat Partner to help you set all of this up, please feel free to contact me through my website at ScottWorld.com:

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable Consulting,...

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable...

ScottWorld provides the world's best Airtable consultants, Airtable experts, Airtable developers, FileMaker consultants, and Airtable trainers. Airtable consulting, FileMaker development, and Airtable training.

[Matthew_Bickfor]

Thanks, Scott! I’m not sure this would actually save much time on my end. As is, I can simply take the destination table and create formula fields and use If statements to translate which I would essentially have to do anyway using a third-party tool.

[HannesK-ME]

Hey there, just wanted to mention that our team at miniExtensions has developed an automation which uses OpenAI's GPT to do just about anything with your data, including translating text. All you'd need would be a simple prompt like "translate this to english". Depending on your exact setup, you may need more than one instance of this automation (e.g. if you have multiple source and target fields), but it's very straightforward to set up and may be pretty useful for anybody who comes across this in the future!