Skip to main content

I ran into a few issues in using Zapier Tables

1, I know that it can't do sumifs like excel or sheets and I have to do it through codes

2. When I do this, it kept on returning zero - my question is how does the code read a column? Like how does it identify it "Column 2 or Column B or it uses the column name?"

3. I need to then transfer the result to another table

Hi ​@Equi 

To help us have more info, post screenshots about what you are referring to related to the Code and Zapier Table.


it does everything successfully in the test but the data output is blank

 


@Equi 

The screenshot of the Code step shows an input variable from Zap step 1 that is an ISO datetime.

It does not show the output values that are generated.

 

The screenshots of Zap step 3 does not show how it is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.