Updating a linked field through API

[Brian_McEuen]

Hi All

I’m building an app with Adalo using Airtable as my database.

I have, as of now, 1 base with two tables, users and products. A product can have many users and a user can have many products. Obviously there is a linked field connecting Users → Products and it’s a multi-select linked field (a product can have many users).

I’m trying to “add” a user or “append” a user to the user array through the airtable API (PATCH) and each time I get something to work, I can only get it to overwrite the current user in that table as opposed to adding a new user.

Any thoughts on what I’m missing here?

Thanks!

[Olivia_B]

pm sent , please check

[SergioCodes]

Hi there @Brian_McEuen

Based on the documentation:

A PATCH request will only update the fields you specify, leaving the rest as they were. A PUT request will perform a destructive update and clear all unspecified cell values.

In this case, I think you are looking for a way to “create if not exist,” which is not available in the API; I do recommend looking for the record using GET with filterByFormula=, and if the result is an empty array, then create it POST, else update it (PATCH)

If you need any help and you have a budget, then we can talk.

Best
Sergio

DevBlocks Agency

DevBlocks Agency

Top Airtable & NoCode Architecture and Development