Data linked preview in table

Product Suggestions
1

Hello,

Would it be possible to add a new data type (or just a preview data) for the columns of a table?
Here is my situation:
I have to load and manipulate a Workorder table. In this workorder table, i have many foreign keys used in other tables (Material ID, Location ID, Batch ID, …).

But the data that I would need from the Workorder table to generate a report (or other use) are not the ID itself, I would need the Material Name from Material Table, Location Name and Type from Location table, Batch Status from Batch Table.

Since there is no functionality to do a joint query easily in Tulip, would it be possible to have in my Workorder table the Material Name column? The goal is not to replicate the Material Name column from the Material Table but to have a viewer/preview of the actual Material Name column based on the Material ID that is already provided (Think about pointers in C language).

This functionality would simplify the need to use a lot of “Load Record PlaceHolder based on ID X” and it would make tables a lot more human readable without storing extra data in them. It would also enable to make Query based on data that are in another table. Any modification in my Material table would be propagated directly to all the “preview/viewer” and you won’t need to duplicate your data anymore.

Here is another visual example:

image
image3000×581 32.1 KB

Question: As in my example, are you duplicating data from one table to another in order to make it more convenient/human readable? (e.g. Material Name, Location Name)
  • Yes, I have already done it.
  • No, Data replicates are bad practice and I prefer to live with user unfriendly IDs
0 voters
2

Hi @kefl - It is possible to use the interactive table widget to show columns from more than one table at a time. When a table has a linked column, the fields from the linked table can be added to the widget.

However, this is only for viewing and does not remove the need to load the other tables when you need to make edits. We are considering a few ways we might solve this, including improvements to analytics. Thanks for the detailed feedback, it helps as we think about the best way to approach this.

2 Likes