Clay Icon

Other issue that I have, Clay says that my formula is invalid

ยท
ยท

Other issue that I have, Clay says that my formula is invalid

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hey hey! Can you drop the URL for your table here? (if applicable) ๐Ÿซถ Don't worry, only admins will be able to open your table ๐Ÿ˜‰

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    The message error I get

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hi ยญ@Arnaud Hochart I just looked at your table and I'm not seeing a column called 7.3ยญยญ_Double Check - did you change a column name?

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Yes indeed

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Let me take another example

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    perhaps you could share a loom video of what is happening?

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    The new name is '7.3_DCUMmatchIH (1)'

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Do you still need a loom?

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    okay interesting, let me investigate

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    So it doesn't error on my end - did you add in those quotes?

    e425b1ab-38e8-479f-b4e6-c66b09f7b3c1.png(12 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    or did the system automatically add the ' before and after the column name

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    It did automatically

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    can you record that on loom please? I just tried and it didn't do that for me

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Want to recreate it on video to share with the engineers

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    that will allow them to fix it

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท
  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Is it ok?

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    thank you - I'll share this with the team to see whats up with the formula generator, for now just delete the ' before and after the column name though and it should work

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Ok got it! Thanks for your help ๐Ÿ™‚

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    Hi Stefan K. FYI this bug is still happening

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    When you use the AI

  • Avatar of Daniela D.
    Daniela D.
    ยท
    ยท

    Hey Arnaud! Jumping in here. Can you share the table url? I'll check the formula set up.

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Yup, looks like it keeps adding the quotes around the column name which is the issue. The team has surfaced this too so we'll look into it. Let us know if removing the quotes breaks anything or if you need help correcting it.

  • Avatar of Arnaud
    Arnaud
    ยท
    ยท

    If I remove the quote it starts working again ๐Ÿ™‚ But sometimes I have very long properties (cf my example) so it's a bit a pain to remove them haha But nothing critical ๐Ÿ˜‰

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Yep. It's something the team has brought up and seen but for some reason, the AI for the formulas likes to add them here and there. Annoying, for sure!