Merge and extend an array between two collections

[ydemetriades]

Hello everyone, a big shoutout to Payload and its vibrant community. It's been a while that I have been using Payload as a backend and CMS for my next project and I am really excited about that. The progress that Payload has made is remarkable and that's brilliant. Hoping for even more!! :)

Now back to the topic :)

I have two collections Context and Grid.
In Context collection I have an array of keys in sth like the following:

const Context: CollectionConfig = {
  slug: "context",
  versions: true,
  auth: false,
  fields: [
    {
      name: "properties",
      label: "Entity Properties",
      type: "array",
      fields: [
        {
          name: "key",
          type: "text",
          required: true,
        },
      ],
    },
  ],
};

Now In Grid collection what I am trying to achieve is to have a relationship pointing to Context and an array of Properties (Grid.Properties) which will be populated by the Context.Properties (by inheritance) but also have additional fields (ie. include the key but have also a type, label and other fields.

The Grid.Properties and Context.Properties shall be in sync.

(The use of hooks could be a solution to that)

Waiting for your thoughts...

Thanks a lot.