I want to use the value of the [FROM_TABLE] column which equals the other tables' names and another column [ROW_ID] for data that will be searched on the tables name. Is this possible?
Thinking of
Another good question and idea to try in Honeycode, thanks for asking here
Yes, it is possible to have a screen that calls different rows from different tables, from columns that share the same name. However, I'd be curious to know about your end goal, since there may be easier methods to retrieve and update values. (with perhaps a different set up using rowlinks or filters).
Either way, here's something that can achieve what I believe you're asking. For this, you would need to have a table that stores the values of other tables with filters.
Let's say you have two tables that have columns with shared names (in this example, they share "Name" and "ID" columns:
Now you'll need another table that stores the values of these tables in a filter (and you can follow this method to create any filter of an existing table):
And the cells that show the values of the specified row of the table. (I'll note that there is an offset of -1 of the row, since there is a header in the table):
