How to use Synced Tables in Airtable ⚡ One-way Table Sync
Тәжірибелік нұсқаулар және стиль
Airtable Synced Tables eliminate redundant data entry and allow you to work faster! These tips will help you set up your synced tables and navigate them more quickly with convenient buttons in Airtable. I also discuss paid tiers and the number of syncs per tier! 👇
_________________________________________
Learn more at these links: 🔗 👇
Learn the basics of Airtable Automation!
www.garethpronovost.com/webin...
Take our free Airtable Crash Course!
garethpronovost.com/airtable-...
Getting Stuck? See how we can help!
garethpronovost.com
Get our Airtable Field Type download!
www.gapconsulting.io/airtable...
_________________________________________
Table of Contents: 📖 👇
00:00 - What this video covers
01:14 - When to use a Synced Table
01:41 - Set up an example
03:28 - How to initiate a synced table
05:22 - Creating the shared view
07:35 - Options for synced tables
08:53 - Linking within the secondary base
09:43 - Updating the data at the source
11:18 - Syncing recent data
11:54 - News on two-way syncs
12:29 - Paid tiers for syncs
13:14 - How to Get More Help!
_________________________________________
Software Resources (may contain affiliate links): 💻 👇
Airtable - airtable.com/invite/r/v0eI3ASY
_________________________________________
#nocode #GarethPronovost #Airtable
Пікірлер: 29
Grab my *FREE TRAINING* that teaches the building blocks of automation: 👉www.garethpronovost.com/webinar-registration👈
As always I learned something that wasn't obvious, which was how to force-sync the tables, which is why your videos are so extremely helpful! I noticed when I changed the title of the columns in the source, those did not sync so I manually changed them in the destination table as well with no apparent issues. Thanks again Gareth.
Excellent video, I hadn’t used the open source record button functionality before! Please make a video once the two-way sync functionality is available on Airtable
@GarethPronovost
Жыл бұрын
I will absolutely do that!
Hi Gareth, thank you for the great explanation. Is it possible to establish a sync between different sub plans? For example between pro and plus plans...
@GarethPronovost
Жыл бұрын
It seems to be possible, but I'm not sure which account the syncs count against. 🤔
I am not embarrassed about how excited I got for this video. I love how you explain things and I've had quite a few questions about synced tables. If I have several bases for different aspects of a business and want to link all the tasks into one base for all projects, is this the easiest way? And then from there use a junction table to get them all on a single grid and/or kanban view for my team to work from. Or is there a more efficient way to consolidate multiple bases into a single project view?
@GarethPronovost
Жыл бұрын
Thanks Holly! You can sync multiple tables into the same table. I didn't show this in this video, but you can add multiple sync sources. This might help for your specific case.
Great video as always. Air tables pricing plan absolutely sucks. SmartSuite is going to eat their lunch. 😮
@GarethPronovost
Жыл бұрын
SmartSuite has a lot to offer!
Can you sync between two different accounts?
Thanks ! Does synced tabled is count as new records in the second table ?
@GarethPronovost
Жыл бұрын
Unfortunately, yes. Those records that you sync DO count against your total base record total.
Hi, I've made an automation to create a record with conditions from a sync table, because it was creating one record per collum :disappointed_face: So the first problem is solved, but now i need this record to be updated as long as someone change any info in the row of the other table./base... Could you help me ? Thanks.
Hey @GarethPronovost thank you for this helpful video! I created a sync from another table, but when I try to link to the record from another table in the same base, it doesn't pull the information (even when I specify the correct lookup field). I'm on a free plan. Does that make a difference? I've been trying for like an hour now!
@GarethPronovost
10 ай бұрын
I think you're describing a synced table with a lookup field, which isn't possible. The sync gives you access to one table. If you want to lookup other info, first bring that into your synced table and then include it in the sync
@KailaKrayewski
10 ай бұрын
Thanks!@@GarethPronovost
Thank you for this thorough video, although it didn't cover a mystery question for us. Is it possible to add records to a base that is pulling in synced information? For example, we are pulling in the LA Community Fridges updated list of active community fridges in the county but there are 2 fridges that aren't a part of the LACF network but are fridges that are running and we'd like these to be a part of a list of active fridges we provide for people. Thank you for your help in advance!
@GarethPronovost
Жыл бұрын
Yes you can! You can also sync multiple tables into one. Lots of options
@mutualaidlanetworkinfo2592
Жыл бұрын
Can you let me in on how? Or some keywords to google to figure out how? I've got data being pulled from an outside table and synced to a new table within a database of my own. This database also contains a table of data that I'd like to merge with the incoming synced table but I've gotten a message from Airtable saying that I cannot sync tables within the same database.
@zuraimansg
11 ай бұрын
@@mutualaidlanetworkinfo2592 I think for syncing tables within the same database could definitely be achieved with Automations. For automations to work, you will have to specify the Trigger and Action. A trigger could be when a [source table] gets updated/inserted or to check for a certain specified field having a type of Status or Specified schedule. An action could then be to Create Record into the [target table].
It seems the 2 ways sync feature for october 2022 is still not available. Any idea of release date ?
@GarethPronovost
Жыл бұрын
Sorry for the confusion. The feature was announced in Oct 2022 but is scheduled to release in 2023.
@HeatherHale
10 ай бұрын
@@GarethPronovost Is 2-way sync limited to Enterprise plans?
@HeatherHale
3 ай бұрын
Did the "Sync Now" (@ 11:37) get removed as a feature from the free bases? (I don't see it anywhere on any of my free base synched tables' drop down menus). My whole workflow is set up to sync from my paid team account to free client bases... ;-/
hi, I would like to know if it's possible to link views, for example link the information from the grid view with the gallery view, doing one click on any field from grid view.
@GarethPronovost
Жыл бұрын
Views don't link to one another, instead try linking tables. Views are simply how you look at the data in a table.
@RodrigoMarquez-px7df
Жыл бұрын
@@GarethPronovost thanks
This here is the most stupid thing Airtable could come up with... This is why Airtable is still a joke. :)