Hi there!
My recommendation would be to add a new table to the base you are syncing to, and use automations to create a new record on the new table each time a record is added to your synced table.
This would allow your users to adjust the primary field in the new table, and use lookups/rollups to pull over the relevant data from the synced table.
I hope this makes sense - happy to explain further
good luck!
Hi there!
My recommendation would be to add a new table to the base you are syncing to, and use automations to create a new record on the new table each time a record is added to your synced table.
This would allow your users to adjust the primary field in the new table, and use lookups/rollups to pull over the relevant data from the synced table.
I hope this makes sense - happy to explain further
good luck!
Thank you @AlliAlosa , I know exactly what you mean, I am actually using automation heavily, however, I love to play it simple, Airtable sync is wonderful, no need for extra steps or other third-party paid services.
My question is, Can I create different primary Columns inside one table, or Can I un sync the Primary column from a synced table and create another?
Thanks a lot
Thank you @AlliAlosa , I know exactly what you mean, I am actually using automation heavily, however, I love to play it simple, Airtable sync is wonderful, no need for extra steps or other third-party paid services.
My question is, Can I create different primary Columns inside one table, or Can I un sync the Primary column from a synced table and create another?
Thanks a lot
I have a similar problem where my primary column contains sensitive information that I don’t want to share on my synced table. Did you get a workaround this issue?
I have a similar problem where my primary column contains sensitive information that I don’t want to share on my synced table. Did you get a workaround this issue?
Hi @Joel1, The only solution I could find is to use a third-party application to transport some specific data I wanted to move ( Not the sensitive data thought )
I used Zapier to send data to a new base that’s not synced, and I used the primary column to receive a normal data I wanted to be there as a marketing campaign or so.
I hope that helps. Take Care