Rule to create a database item

Hi! I’m new to Fibery. And I’m trying to figure out if this will work with my work glow.
I have a sync to a table from NOTION, in Fibery. Is it possible that every time a new database item is added to this coda synced table, a Client is “created or updated” in Clients Db. Is this possible? Thanks in advance!

Do you mean a sync from Fibery to Coda?

Sorry. I meant From Notion To Fibery. In Fibery…sorry!

I’m not sure what you’re asking.
When a Notion table (database) is being synced into Fibery (not merely imported) then changes/additions to the Notion db will be reflected in the Fibery integration (syncd) database, without any action on your part, the next time a sync occurs (which can be on a schedule or manually).

Exactly, and how can I use this data, automaticity. In this database there’s info about clients, and I want to create an automation that every time a new item from this database is synced in into Fibery from Notion then a new client (entry) gets created in Fibery Clients DB. And if it’s already there , that it gets updated.

Before answering the question your asking :stuck_out_tongue: I’m curious to know why you actually need to have a separate Fibery Client db?
Could you possibly solve the underlying use case by adding fields to the Notion sync’d (integration) database?

Chr1s. thanks for your help. Maybe I’m not explaining my self, or don’t understand the terminology in Fibery :slight_smile: Thanks for your patience!
In “Notion Db”, I have a relation to “client db”, but I can not update it. I guess because the client is not in the client db yet.

OK, I didn’t understand the use case. I thought there was a 1:1 relation between the Notion DB and the Client DB, so I thought you could just use a single db (the Notion sync one) for all needed fields.

It looks like you actually have Client 1:n Notion. Is this relation an auto-linking relation that you added? If so, then that would explain why you can’t manually update it.

Yes. Is there another was to do it?

It’s a fine way to link them, but as you are discovering, an automation cannot add new entities via an auto-linking relation.

The options are as follows:

  • use a script in the automation to add a Client (which then will get auto-linked)
  • add a regular (not auto-linking) relation, solely to allow an automation in the Notion db to create new Clients

Even with these options, it can be tricky to make it work reliably, because auto-linking relations are updated asynchronously - this means that there is a small amount of time between the record being synced from Notion into Fibery and the relevant Client getting linked. So it is impossible to know exactly at the time of the Notion db entity creation, whether or not a corresponding Client exists or not.
One way around this is to run an automation on a schedule, to check which Notion records are missing a Client, and create the necessary clients.

Thanks, I will try these, options. Let’s see if I can make it work. :sweat_smile: