.png&w=3840&q=75){kind=logo}
Formula Error in Data Provider Cells: Need Help with Table
Hey, I'll need help with this table. For some reason the formula I created isn't working. I'm getting ''error'' in the data provider cells
Hey there Kenan thanks for reaching out. Let me take a look.
Kenan K.··Hey Luis, thank you
So I created a new column that used a formula to combine the first and clast name, try running a couple rows with this input and check if the error still appears.
- Kenan K.··
Ok, thank you Luis
- Kenan K.··
let me do that
- Kenan K.··
Also, I'd love to know how you did it, just in case I encounter the same problem I'll know how to go about it
- Kenan K.··
LuisArturo the problem still persist
- Kenan K.··
The first time I did it, it showed formula under Setup inputs
Here is a video on how to use formulas to combine or disconnect names. https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6cLet me take another look.
- Kenan K.··
I'd like /first name - people + /last name - People to be used in the formula. Under setup inputs, it should be listed in the drop down menu as ''formula''
So the formula generator in the enrichment is used set up conditions for the enrichment to be run. It won't actually combine the columns there.
- Kenan K.··
Better still, how can I create a new column named ''Full name'' which includes first and last name and use it under ''Setup Input''?
- Kenan K.··
I'm not sure I understand, can you explain it differently?
So all of Clay's integrations have an option to setup conditions for a column to be run.For example say you have a table of people with LinkedIn Profile URLs, but some people don't have an LinkedIn account, you can set-up a conditional formula in that enrichment that says "Only run if the LinkedIn URL is present". The column will then run for the rows with the URL in it.So that formula in the enrichment is only meant to set conditions for the column to run
- Kenan K.··
Ohhhh Ok
- Kenan K.··
I get it now
- Kenan K.··
Thing is, all the people in the table have LinkedIn urls
It doesn't have to be LinkedIn URLs, you can set the condition to be whatever column you want to check a value for.
- Kenan K.··
Ok great
- Kenan K.··
It's working now
- Kenan K.··
But I have more request
- Kenan K.··
I want to run the data provider columns simultaneously
- Kenan K.··
Do I have to delete them and restart the find work email process afresh
- Kenan K.··
or is there a way to make them run at the same time from the table
- Kenan K.··
?
Once the first provider runs it should start running all the other ones since they are part of the same waterfall.
- Kenan K.··
ok
- Kenan K.··
Got it!