Get a value from another table with ref, dinamicaly

[Flyingpeter]

Hey guys!

I'm new to appsheet and I'm not finding a solution for a problem I'm having.

I have two tables. In the Data tab I referenced a value in one of the tables (let's call it name1).

Now I can access the value on table1 with [name1].[variable_to_access].

Ok till now.

Now I want the variable to be dinamicaly assigned...

[name1].[dinamicaly_assign_a_variable]. My goal would be to do:

[name1].[ [name1].[variable] ]

Calling  [name1].[variable] I am getting a variable  name to access in table 1.

Any ideas?

Thanks in advance

[Rafael_ANEIC-PY]

Hello @Flyingpeter, it is not clear to me what you're trying to achieve, as I understand it, you have two tables with one referencing the other, and this ref column is called [name1], and you wish to obtain a value from that table you've referenced, but you've posted a few dereference expressions that seem appropiate, so what's the problem?

[Flyingpeter]

Hi Rafael!

Thanks for your reply.

I just wanted to build like excel/sheets =indirect() way to rich a field.

like... dinamicaly generate a field name.. lets imagine variable ZZZ = if(this)="red";X;Y) and then just call [tableName].[ZZZ] to get the result from the X or Y column...

but i managed to do it with lookup() i think i found the solution=)