Skip to main content

I have 3 tables: A, B and C that are linked A→ B → C.  All child records are one (parent) to many (child).  Is there a way to have A pull in unique C records?  I can pull in a list of C records into A by using a lookup field.  However, this pulls in duplicate C records.  If I use a rollup field in A with an Arrayunique formula, it converts all of the C records to text values.  

If you want to be able to click into a unique list of grandchild records then I think you’ll need to use an automation for this I’m afraid

The idea would be to:

  1. Create a link field to Table C from Table A
  2. Create a lookup field to display the linked Table C records from Table B
  3. Create an automation whenever the field from step 2 is updated, and its action would be to paste the lookup value into the linked field to C

This is how it would look and I’ve set it up here for you to check out

 

Hey ​@leisterbrau,

 

As mentioned by Adam above, I’m afraid this is not possible unless you do so as suggested usin a new link and automation. Having said that, would you like to further describe your use case? Maybe we can think of a different workaround. 

Terms & Conditions