Help

Re: Can I Link Single Field In 1 Table To Many In Another?

325 1
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Rowell
4 - Data Explorer
4 - Data Explorer

MY SITUATION

I have a base containing several tables:

  • ‘Translations’: Using DeepL API this 10 row table converts the record contents under 3 distinct fields ‘header’, ‘subheader’ & ‘cta’ into 10 languages
  • ‘Banner Orientation 1’: Has fields ‘lang’, ‘target-header’, ‘target-subheader’ & ‘cta’ etc) & 1000 rows

Table ‘Banner Orientation 1’ has:

  • 100 rows where the field ‘lang’ records hold the 2-letter code for the 1st language
  • 100 rows where the field ‘lang’ records hold the 2-letter code for the 2nd language
  • etc…

THE PROBLEM

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!

MY GOAL

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,

David

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…

2 Replies 2

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.

Kuovonne:

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.

David

kuovonne via Airtable Community Forum airtable@discoursemail.com wrote …