Way to merge tables data

Chasovskikh Kirill

Hi!

There is a table "employees" and there is a table "legal entities".
Is there a way while editing the table "employees"  in the COLUMN "legal entity" to give the user the opportunity to select one or more values from the TABLE "legal entity", the COLUMN "legal entity name"?

Max Foerster - K15t

Hey @Chasovskikh Kirill,

as @Andy Gladstone already mentioned, it is unfortunately impossible to implement this use case in Confluence without additional apps. Tables are just not smart enough and only static.

That was the not-so-good news, but that shouldn't get you down. 😉
There is also good news because one of the marketplace apps meant for your use case is Orderly Databases for Confluence, which my team is working on at K15t. 😄 

But pictures are worth a thousand words, so I've reproduced your use case. Please excuse small inaccuracies. I have no idea what you want to store in your tables, so I improvised. 😄 But I hope you will be able to follow what I'm doing.

Let's assume you have set up a people directory in Confluence. It could look something like this after you set it up with Orderly. Looks like a table, but it has more features and is smart. Pretty nifty for structuring content. We have here a few different fields for text, select lists, images, nothing out of the ordinary.

 

Your next step will probably be to set up the legal entities database. Again, some text, select lists, dates... One special field (Employees) I will explain later. 😉

 

Now you want to bring that information into the people directory. That can be done using a new Entry link field in the people directory. Reference the Legal Entities database and save the configuration.

 

Now you can start to select the correct legal entities for the employee in the table. The available values are the entries from the Legal Entities database.

 

And you might have noticed that the Jurisdiction field is automatically populated too. I added that as a little extra. You can reference any field from other databases related to this by using the Lookup field in Orderly. That's the configuration in my case:

Now let me come back to the Employees field. That's a Backlink field. It's displaying in what entries of other databases, such as the Employee Directory, this entity has been referenced.

I know this was just a quick guide, but if you have any questions, feel free to contact me. I hope this has been useful. Have a great day. 🤘🏼

Best, Max