I currently have a timesheet that people enter time into a repeating table. The table has these fields
Choice: Job, GL
Job
GL
JobApprover
GLApprover
If they enter time to a GL the GLApprover field will do a lookup and populate the necessary approver's email. if they enter time to a job it will populate the Job approver in the JobApprover field. I have a field outsite the reparting table called Approvers with the value of 'concat(JobApprover, ";", GLApprover) so that this feild will have a ; delimited list of all approvers. However, it will only enter the first line of the repeating table and will not grab all GLApprover(s) and JobApprover(s). If I code to 5 different jobs and 3 different GL's I should have 8 names in the Approvers field but it only pulls the first row. Any ideas?