Error evaluating formula code on row 1: Syntax Error :invalid or unexpected token

Options

Hello everybody,
I have the error
Error evaluating formula code on row 1: Syntax Error :invalid or unexpected token
using the component Tables:apply formula to columns
I am doing a for each on a table with 2 fields: "email" and "standard"
Then in the mentioned component as Row formula : columns[2] = {{email}}
It's very strange because I use the field {{email}} above in a filter component where it is recognized and works correctly
Can you help me to solve this issue
Thanks in advance

Answers

  • Dylan_191182
    Dylan_191182 Posts: 92 admin
    edited July 2020
    Options

    @Elia_321768 can you try enclosing the {{email}} in quotes? So it would look like


    columns[2] = "{{email}}"


    In the filter case we are able to automatically add the quotes for you, but when you are writing a formula (in Tables: Apply formulas or Field formulas) we need you to specify them.

    Let me know if this works!


    Thanks,

    Dylan

  • Elia_321768
    Options

    Ciao Dylan.
    It works !
    Thank you very much
    Elia