Repeating field lookup
Is there a way to paste in repeating field 2 (a text field) lookups from another table based on repeating field 1 (a text field)?
Table 1 is Employees
Table 2 is Meetings
In a Meetings layout, I have repeating field Employee. I would like to populate repeating field Company by pulling from Table 1. (A relationship is based on Employee name.) The Lookup function only populates the first repetition in Company. I know I can create a script to do this, but I want to define the field in a calculation to automatically do it.