Hidden Columns and Zapier

Just working on a project that involves using a Zapier webhook to transfer data to Xero. I’ve noticed that if a column is hidden in Appsheet (Actual or Virtual) then the data in it is not passed to Zapier.

Presume this is a bug somewhere as there are lots of reasons (e.g. not showing the App user the price of something) why you might want hide a column. Yet still send the data to Zapier.

Got around it by using

UserEmail()="Simon@1minManager.com

as the Show_IF but still it doesn’t feel very intuitive :confused:

1 Like

Sorry this is not what you expected and wanted.

When I run my own company in UK, I used to use Xero, which is pretty much common and widely used platform for accouting stuffs.

I would suggest you throw the request to get the native connectors for Xero.

@Scott_Haaland

For the moment, we only have SalesForce as native connectors, but better to have other native connectors for those such as xero or other accouting, support ticket platforms, such as zendesk.

2 Likes

How are you doing this?

So I’ve setup a Zap but set the trigger so its a Zapier webhook. This gives you a Zapier URL. Then I’ve created a Bot Task as follows

Simon@1minManager.com

By not specifying a Body, the system auto-creates a “default” template for you. Although I basically never use it, I believe the default template “smartly” doesn’t contain hidden columns. You can just input your own template to contain whatever columns you want.

1 Like

Do you have an example of the syntax used for the body template?

For a Zapier payload? I do not. Try clicking that “Create” button next to the Body Template field. Or check the actual payloads in your audit logs for previous executions.

2 Likes