I would like to sync fields from one table to another table in the same base. And I don’t mean link the records. It appears the only way you can do this is between bases, however then you lose the ability to link records back to the source base.
I must be missing something and would appreciate help.
For example, what I am trying to accomplish : I have a table named “Active Pipeline” and it contains fields with last name, and first name. I want another Table named “Master Client Contact List” in that same base and I want those 2 fields to sync over to the other table. Thus, I am not manually duplicating data entry. I want that Master Client table to grow via syn from the Active Pipeline table.
Can you help me understand why you would not want to use Linked records?
Once the person is created in Master Client Contact List, you just select that linked record in Active Pipeline, lookups will pull in other details like phone and email. You do not need to do double data entry.
No, it will not push the entire list, you can do that with an automation if that is what you want, but the records will be linked and changes made in Master list will reflect in Pipeline. Is every record in Master list relevant to Active Pipeline?
Give it a try:
Make 2 tables
One table called Jobs one table called People
In the jobs table add a linked record to people.
Now add a person in People and add more details like email address
Go back to the Jobs table and in the new linked field, pick the person you just made. You can add a lookup field to get the email address.
Then go and change the person’s name in the People table. You will see the change reflected. You can also directly edit the People from the Pipeline table by clicking on the linked record and the editable view for that person will open.