View the original community article here
Last tested: Aug 29, 2019
If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.
Example of where this would fail:
dimension: test {
type: string
sql: ${TABLE}.field ;;
# The below html references are incorrect. Substitution operators (the ${}) can't be used in html because they evaluate to SQL.
html: My values are ${TABLE}.field and ${otherfield ;;
}
To fix this, use liquid references instead!
dimension: test {
type: string
sql: ${TABLE}.field ;;
# {{value}} is how you reference the value of this field, and {{viewname.fieldname._value}} is how you reference the values of other fields.
html: My values are {{value}} and {{otherfield._value}} ;;
}
This content is subject to limited support.