Clay Icon
  • 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 Tarek F.
    Tarek F.
    ยท
    ยท

    also, could you look at the third column to see if there's a better way to deduce the first name and last name from an email? Thank you!

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

    Appreciate your patience, Tarek! taking a look now

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

    Just saw that all the values in the prompt are set to "required to run" meaning they must all not be empty for this column to run. You can toggle that off for each item though, so it turns into "optional"

    5ce4cc2a-e53e-49cc-8e04-12d14bbed16a.png(23 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Also, for the names, unfortunately it's a bit tougher but some email providers could find the right person if they have a match. Will test it out for you

  • Avatar of Tarek F.
    Tarek F.
    ยท
    ยท

    Thank you Arturo O.! It worked for the prompt ๐Ÿ™‚ Please let me know if you have any luck with the deduction of the name from the email ๐Ÿ™‚

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

    Sorry for the delay, Tarek! This one is a bit trickier because it's not consistent for all cases so just trying to approach it the best way

  • Avatar of Tarek F.
    Tarek F.
    ยท
    ยท

    hey Arturo O., no worries! I was asking in case it could be done through a formula or another tool that costs less credits