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.
Question
Unique Grandchild Records
+9
+31If 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:
- Create a link field to Table C from Table A
- Create a lookup field to display the linked Table C records from Table B
- 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
+28Hey
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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.