Need help with write to table column not working

Adam I. · 2024-02-14T14:41:00.610778+00:00

My write to other table column stopped working on a table about a month ago, and I can't figure out why! Someone available to take a quick peek? Appreciate the help!

Adam I.

·

https://app.clay.com/workspaces/12988/tables/t_GEcK4BoIgZlJ/views/gv_LFdEUjesahGr

Adam I.

·

If you look at row 84 you'll see "invalid input" I think that's the error causing my troubles. I can't figure out why it doesn't think there are people in the list, when clearly there are 8. And I think I'm using the right object but I could be wrong

Clay T.

APP

·

Hi, thanks for getting in touch! let me check

Adam I.

·

Thanks Juan

Adam I.

·

Any luck?

Clay T.

APP

·

no sorry, I'm still checking

:thumbsup_all:1

Clay T.

APP

·

This seems a problem with the enrichment we are checking this

Arturo O.

·

Hey Adam I.!! I think I found the issue and it's because the results found show in two different formats. Looks like you had this over a month ago and that was recently fixed to be standardized.

Arturo O.

·

I'll check if I can apply a quick fix with a formula to combine the formats and still write them over

Adam I.

·

okay or im happy to use a new write to table column going forward

Arturo O.

·

That also works! You can use that row as the example and it should only run in such cases but moving forward, the format should be standardize for new results anyway

Adam I.

·

okay let me get a new column set up now, will let you know if it gives me any trouble

Adam I.

·

should i use people or results?

Arturo O.

·

Sorry, yep, Results -> People

Arturo O.

·

Adam I.

·

Fixed! thank you!

🔥1

16 comments