Skip to main content
Solved

Unrolling "linked" fields (or records (multiple) -> one-per-row conversion)

  • March 1, 2023
  • 2 replies
  • 27 views
V
Forum|alt.badge.img+3

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.

Best answer by VictorN

I realized that the list view ALMOST gives me what I want. It "unrolls" linked records but doesn't allow me to make per-row edits.

2 replies

V
Forum|alt.badge.img+3
  • VictorN
  • Author
  • New Participant
  • Answer
  • March 1, 2023

I realized that the list view ALMOST gives me what I want. It "unrolls" linked records but doesn't allow me to make per-row edits.

TheTimeSavingCo
Forum|alt.badge.img+31

I realized that the list view ALMOST gives me what I want. It "unrolls" linked records but doesn't allow me to make per-row edits.


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

Here's an example

Adam, Airtable Consultant - thetimesaving.company
V
Terms & ConditionsAccessibility statement