I have a contracts table and in it, users will select a child company from the linked child company table.
I am trying to create a client contacts form that will automatically populate the selected child company(ies) in contracts in the associated client contact field
Can you tell me how? Or is there a way to create a second column that will do something like linked record = linked record text
Noelle shared this idea · Dec 10, 2018
Comments
4 comments
Hi Noelle,
Thank you for reaching out! It is possible to add another column to your table that outputs the text version of what a particular record is linking to on its parent table. This can be done by adding a calculated field to your table and performing what is called a "Parent Lookup". You can reference the field of the parent table that you want to show on the child table.
A parent table's field is referenced in a calculated field using the format: {Table Name}.{Relationship Name}.{Field Name}.
If you are looking to show the text version of a certain field of the numerous child records linked to the parent table, you would need to use the child functions in the link below on a calculated or triggered field.
Child Functions
Whether you do a "Parent Lookup" or use child functions, will depend on the relationship between your clients, contracts and companies tables.
Feel free to reach out at support@trackvia.com for further assistance.
Regards,
Cristina
Hi Cristina,
I followed what you said below, but I get the error "need an aggregate function".
Hi Noelle,
That error usually happens when you are looking at child tables in your calculations without a child function (also known as an aggregate function). If you would like to troubleshoot further, could you send the name of the app and table where this is happening and the information you are trying to show in your calculated field to support@trackvia.com?
Thank you!
Cristina
Noelle, the aggregate function in this case would be one of the "childconcatenate()" functions.
Trackvia has a great resource here
https://help.trackvia.com/hc/en-us/articles/12728964830491-Complete-List-of-Functions#h_01GRVMR5YX16Y27RT2T2VYNBN9
or here
https://help.trackvia.com/hc/en-us/articles/12728964830491-Complete-List-of-Functions#h_01GRVMR5YX16Y27RT2T2VYNBN9:~:text=6.1)%20returns%206.-,Child%20Aggregate%20Functions,-childconcatenate()
Please sign in to leave a comment.