I have a table with the following info Table1 Candidate1 - role1, role2, role3 Candidate2 - role3, role4 Candidate3 - role1, role4
I want to have a newTable2 that shows the status (this field I want to edit) per candidate per role Role1 Candidate1 statusX Role1 Candidate3 statusY Role2 Candidate1 statusZ Role4 Candidate2 StatusX Role4 Candidate3 StatusY .....
Is it possible?
I found this question; it is somewhat related, but it looks like it implements one-way syncing from Table1 to Table2 through JS.
Yeah you'd need to create new records for each of those permutations so that you could apply a status to each of them I'm afraid. Check out repeating group functionality and use the field that contains the roles as a list, and create one record per role