I hope you can help me with a question on how to deal with some information I need to look at in a certain way in Airtable.
My table is configured to coordinate translation work. I receive a request which creates 1 record. Each record will belong to 1 language combination, and on the same record I want to keep track of who is translating and reviewing the document. So I have 1 record, 1 language combination field, one translator (or more), one reviewer. All the language professionals are in a table that links to the “translator”, “reviewer”
Can I create a junction table where I can see the information from the language professionals point of view, to see which jobs they have to invoice each month and each of them becomes a record itself?
For example. In my ongoing work table, I have in 1 line:
Job number Translator Reviewer
GLO-FEB-01 Nelson Anderson Anna Zars
GLO-FEB-02 Maria Yale Anna Zars
Could I have a junction table where I see the information this way? And how would I set it up?
Translator/reviewer Job number Activity
Nelson Anderson GLO-FEB-01 Translation
Anna Zars GLO-FEB-01 Review
Anna Zars GLO-FEB-02 Review
Maria YaleGLO-FEB-02 Translation
Thanks very much in advance!