Ok - that is different. Hmm…
One solution may be to create a model on the parent object, and then add the child fields using the “child relationships” method.
When you add a child relationship - and click on the relationship in the field list (In the left hand pallette section of the builder), there will be a Properties tab. There you can limit your child relationship records to 1, and also set the order by to CreateDate.
Then you drag that child relationship item from the field list down into your table and it acts like a template component, where you define a custom label and identify the merge field.
In the picture below I’ve added Events to my Contacts model, and added a “most recent event” field to my table.
Here is the child relationship properities:
Here is the field definition:
The only downside to this method is that the child relationship data is not editable inline. If you need to edit the child data, you can probably get this done in a popup or drawer connected to the table.
Let us know if this works.
