Calculated Field - "Unknown column"
This has happened a couple of times to me:
When creating a Freehand SQL calculated field, validation fails with the following message: “Unknown column 'X' in 'field list”
I have looked up the correct field name in the view source information and tried using this - no luck
I have selected the same field using the ‘Simple’ calculated field option - this works, but then copy and pasting that simple code as a Freehand SQL statement fails.