Sep 01, 2021 06:18 PM
I have a base containing several tables:
Table ‘Banner Orientation 1’ has:
All 100 rows for the 1st language contain the same record value for each of the 3 fields mentioned above (and the other 9 sets of 100 rows each share the same 3 translated phrases).
So… table ‘Translations’ only has to do 3x10=30 translations ONE TIME.
The alternative to these 30 API calls?
If I translate each row record separately I get 3 records x 1000 rows = 3000 API calls to DeepL for only 30 unique phrases… not good!
I want those 3 translation records copied from table ‘Translations’ to each of the 100 rows for that particular language in table ‘Banner Orientation 1’…
Then again for the remaining languages.
CAN YOU ASSIST? IDEAS?
Hopefully I’ve explained well enough…
Thx in advance,
P.S. Yes, I know I could simply ‘copy/paste’ the translations myself into 1000 rows. Just hoping there’s a way to do this automagically :winking_face:
P.P.S. ‘Lookup’ fields came the closest but I couldn’t figure it out…
Sep 02, 2021 04:35 AM
Welcome to the Airtable community!
This support article may help.
Keep in mind that your model of having very wide tables will not scale up. Airtable has a limit of 500 fields per table.
I recommend a base redesign to introduce a languages table and a join table between languages and the original phrases.
Sep 02, 2021 02:29 PM
Thanks for the feedback!
I will take your advice and see where it leads…
FYI my tables are NOT “wide”. They only have about 10 columns /headers… but they DO have a lot of rows. I probably didn’t explain it well enough.
kuovonne via Airtable Community Forum email@example.com wrote …