LinkedIn
Twitter
Hi,
I’m getting an error and I can’t work out where I am going wrong
I have a ref column
I want to dereference this column from the Single items table
It’s column 54 of the table “Single items”
But when I try to dereference I get the error below.
I’ve used the appsheet training plugin to insert the column name so the name should be correct but for some reason it doesn’t seem to be looking at the Single items table for the [Total cost of food - single item column].
I don’t know where I’m going wrong. Can anybody please share a suggestion on what I might be doing wrong?
Solved
1 ACCEPTED SOLUTION
From your screen show we can’t tell which table the column Item 1 belongs to. In that table a column is marked as the KEY column. See image below.
The value from this key column is what should be stored into the column [Total cost of food - single item].
How are you assigning a value to column [Total cost of food - single item]? If you are using a dropdown list - show us the expression that provides the dropdown values.
