So, Table A has column ID (key) and column A1.
Now, I need to create a Table B with a column whose values must be chosen dynamically among A1 values.
Is there a strategy for doing this?
Thanks in advance
Solved! Go to Solution.
Hi, try this, one way of doing it:
in table B, in the column you want to use: under data validity - valid if: tableA[A1]
Alternatively you can create a reference to tableA, depending on what the relationship between those two tables is.
G
Hi, try this, one way of doing it:
in table B, in the column you want to use: under data validity - valid if: tableA[A1]
Alternatively you can create a reference to tableA, depending on what the relationship between those two tables is.
G
Thanks, the โValidity ifโ is the solution!
On the other side, I am not sure if the reference can be done, because itโs not referencing the primary key.
Unfortunately there is a bit of additional work to do in order to mimic the relationship between the tables, you need to create actions with navigations using LINKTOFILTEREDVIEW.
Itโd be nice to have everything already cooked. Maybe should I post a new feature request for implementing this?
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |