PostgreSQL - Possible to trigger when Updated Row (Custom Query)

  • 26 July 2022
  • 3 replies

Hi, I’m quite new to Zapier and was wondering if it is possible to have an Action Trigger when a row from a custom postgreSQL query is updated? Is there a way to use the New row (custom query) trigger for this?

Would it potentially work if I changed the following postgreSQL query from “ORDER BY building_descriptions.created_at DESC” to “ORDER BY building_descriptions.updated_at DESC”?

--Properties Update
--Porperties New
--Property Desciptions

--Main Table
FROM building_descriptions
LEFT JOIN property_users ON building_descriptions.property_id = property_users.property_id
LEFT JOIN properties ON property_users.property_id =
LEFT JOIN addresses ON = addresses.property_id
LEFT JOIN furnishings ON = furnishings.property_id
LEFT JOIN energies ON = energies.property_id
LEFT JOIN valuations on = valuations.property_id

ORDER BY building_descriptions.created_at DESC


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 6
Badge +6

Hey @nrosen ,


Curios to know why you are not using this trigger event ? This trigger event triggers whenever there is a new or an update on PostreSQL. 



To transform the data you can use Formatter by Zapier or Code by Zapier


I believe this will be much easy for you.

Hi @jayeshkumarbhatia,

thanks for getting back quickly. As you can see in the above query I am joining multiple tables. I don’t think that is possible with the mentioned Trigger.

Userlevel 2
Badge +3

Hi @nrosen !

Just checking in to see if you still need help with this?

You are correct, it’s not possible to use the New or Updated Row trigger for multiple tables, because you’re required to select one.

To be fully transparent, I don’t know PostgreSQL very well, so I can’t confirm if it would trigger on updated rows by using the query “ORDER BY building_descriptions.updated_at DESC”. However, I’d encourage you to give it a try and letting us know if it works. If not, at the very least we can submit a feature request for this.


Keep us posted!