Clay Icon

Repro of Bug: Missing Owner Key-Value Pair in Company Table Reference

Β·
Β·

Arturo O. Here is a repro of the bug i referenced yesterday. in the company table you can see there is an owner. In the people search you can see there is no key value pair for owner when i look at the company table reference. https://app.clay.com/workspaces/111299/tables/t_YjkxcFWl62HO/views/gv_H3gCBJ4v5Fjp https://app.clay.com/workspaces/111299/tables/t_sorDMJSC884c/views/gv_mmaelkVdQcGI I have tried re-running the company column and no luck. it is not a new column

  • 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 Clay Team
    Clay Team
    APP
    Β·
    Β·

    Thank you, Taylor. Checking it out

  • Avatar of Taylor U.
    Taylor U.
    Β·
    Β·

    Arturo O. any updates?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    sorry!! I'll try adding a workaround to help out. I'm guessing it is a bug with the type of column, very odd

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Taylor U., I had to extract the value from your dropdown column from the accounts table so it could be read properly, I re-ran the company table column and it fetched the new result... Extracted the column next to it

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    I'll have to submit a ticket to ask if we can debug that issue though, where those types of fields can be read by the tool

  • Avatar of Taylor U.
    Taylor U.
    Β·
    Β·

    Arturo O. okay so is the tldr for. now dropdowns down don't populate and you need to extract the value?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Yep! πŸ˜…

  • Avatar of Taylor U.
    Taylor U.
    Β·
    Β·

    Lololol totally get it --> very happy with work arounds as you mature

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    I found it with the regular Lookup but it just returns an ID of the field instead of the text value

  • Avatar of Taylor U.
    Taylor U.
    Β·
    Β·

    oh weird. it didn't even show up for me? as you can see from the screenshot --> maybe it takes a day or two to bake?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Yeah, workarounds for dayyyssss!! lol

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    I used the separate integration of Lookup though, not the Company Table column to check for it

  • Avatar of Taylor U.
    Taylor U.
    Β·
    Β·

    oh oh -- okay got it i'll check out how you did that