I have a Product column from which I’m referencing a table, Product Info 2
I’ve added a virtual column, Product Image ref, which takes the value from the Product column and then references another table, Product image url.csv
When I save it works on the emulator and in the app on another device, but when I go into the Product Image ref column it gas changed to reference Product Info 2.
Then if I save again I get the error, Unable to find column.
I’m sure I’ve done virtual ref columns using values from other Ref columns before.
Is this s new bug?
Solved! Go to Solution.
Yes, Product image url.csv in is the tables.
I’ve got round it by making a virtual column, Product Text, as type Text using the value from the Product column.
Then another virtual column type Ref taking the value from the Product Text column.
This way the Ref table stays as I want it.
It seems that if a virtual column is a Ref and it just uses the value of a column which is also Ref it wants it to match the table as well.
I doubt it, but tough to say without seeing the details of your virtual column, at least.
Here is the virtual column details
Please post the configuration displayed when you click View Definition:
Nothing shows when I click that
In Data > Tables, does there exist a table name Product Image url.csv
? If not, is there a slice of that name in Data > Slices?
Yes, Product image url.csv in is the tables.
I’ve got round it by making a virtual column, Product Text, as type Text using the value from the Product column.
Then another virtual column type Ref taking the value from the Product Text column.
This way the Ref table stays as I want it.
It seems that if a virtual column is a Ref and it just uses the value of a column which is also Ref it wants it to match the table as well.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |