Zapier integration typo: "insert" -> "upsert"

Suggestion Box Bugs
1

image
image1402Ă—1234 87.2 KB

2

Hi @Kai_Zhu welcome to the Coda community! :wave:

Upsert is an amalgam of Insert and Update. Its best used when you are uncertain if the row exists.

If you try to Update a row that doesn’t exist, the zap will fail. If you try to Insert a row that already exists, the zap will fail.

Upsert will always work … but sometimes you do want it to fail. It gives you more flexibility depending on the use case.

1 Like
3

Alright, so this is just a non-English speaker’s misunderstanding.

Thanks!