Synced table formats User field to Text field

Topic Labels: Sync
627 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I've got 2 bases, one for managing a list of employees and the other for managing some cars.
I need to assign some tasks to specific Users from the employee base so I decided to sync the Employee details table to the Cars base.
After the sync, the result table in the Cars base shows the User field (of User type) from the Employee details table as an User field (of Text type).
What do I need to do, as I need the User field in User format.

2 Replies 2
Airtable Employee
Airtable Employee

Hi Adrian! This section of our sync FAQs provides a good overview of expected behavior here and the workaround to fix. Hoping this can help!

4 - Data Explorer
4 - Data Explorer

Airtable support suggested that the cause may be a field which was created prior to 2023-03. That was not true in my case, as I created the field a few weeks ago. Instead, I believe the cause was a sync configuration which was created prior to 2023-03.

I went to the sync source and turned off sync sharing. Then I turned it back on and fixed the configuration in the synced table. That resolved the issue. I hope this helps.