Skip to main content

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!

I’ve got my clients doing this very easily by using a combination of:

As soon as a form is submitted in Fillout, the Make automation translates the form and sends the data to Airtable.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

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.

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!

Reply


Terms & Conditions