Clay Icon
  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    column is Domain Match Check what I'm trying to achieve is if any of company name words is present in email domain, then returns true but formula I have is not doing the job

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·
    {{Company Table Data}}?.["Company Name"]?.split(" ")?.some(word => {{Mixed Email}}?.includes(word)) ? true : false
  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    that formula doesn't even reading from email domain but instead entire domain, still not working

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    also tried with this one, which is if mixed email exist, and domain exclude company name then true

    {{Mixed Email}} && {{Mixed Email}}?.split('@')[1].includes( ({{Company Table Data}}?.["Company Name"].includes(' ') ? {{Company Table Data}}?.["Company Name"].spit(' ')[0] : {{Company Table Data}}?.["Company Name"]) ) ? true : false
  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    notice that for company name I'm internally doing with js if company name includes " " (space in between) then see if first word it's contained in email domain

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    none of this is working properly

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    nvm, solved this formula worked {{Mixed Email}}?.split("@")?.[1]?.includes({{Company Table Data}}?.["Company Name"]?.toLowerCase()?.split(" ")?.[0])

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    nope, not fully working can you help me figuring out this?

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    try this formula

    ({{Company Name}}?.toLowerCase()?.split(/\s+/) || []) .some(word => ({{Mixed Email}}?.toLowerCase()?.split('@')[1] || "")?.includes(word))
  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·
  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi Esteban, thanks so much for reaching out, and a big thank you to Muhammad for your help! 😊 Just checking in—has this been resolved?

  • Avatar of Esteban L.
    Esteban L.
    ·
    ·

    I need to test it first sorry the deay

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Esteban L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: