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
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?
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=)
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |