Re: How to make a synced record permanent
Hi,
of course, you can duplicate field in synced table or add more unsynced editable fields to make data static. But your problem is that when the the record deleted, it will delete in synced table together with ‘static’ data.
If your plan allows multi-source syncing, I would organize another table in Base1, to hold your static data, and sync it to the same destination, but in a following way:
each record in Table2 of Base1 linked to it’s respective record in Table1. Sync view from table1 needs additional filter ‘link to Table2 is empty’.
The case is interesting, I even tried to to make working test
Table 1
Base2, synced table with additional fields
When you check ‘freeze’, automation runs, let it be #6
(little mistake here, passing NEW field value is useless, you should use it in 'frozen ’ records)
When Base1 incoming webhook automation gets a call, it creates a record in Table2
linking record in Table1 excludes it from sync
it’s now saved to static source and you can work with it.
Sorry for a lot of pictures ))
p.s. source for webhook call
//Webhook to copy record. data:{number,set,tags}
let payload=input.config()
const testwhook= 'https://hooks.airtable.com/workflows/v1/genericWebhook/app_put1your2webhook3link4here5'
const options={method:'POST',body:JSON.stringify(payload),
headers:{'Content-Type': 'application/json'}}
const responce=await fetch(testwhook,options);
const result=(responce.ok)? await responce.json() : responce.statusText;
Hm, feels like we’re having some sort of miscommunication. Here’s a gif of the automation running to see if it clears things up:
