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