Data upload issue
We have used Google drive to update our employee table for a couple of years. Linked to the employee table is our trucks table. Employees that drive company trucks are assigned to that truck via the e...
Forum Discussion
Hi Steve,
Taking a look at those screen shots it looks like the reference field is looking for employee 55670 but they are listed as 055670 under your reference field. The lack of the 0 is most likely what is causing that reference field to not line up, reference fields are specific and a missing character would do that. When syncing over how is that reference field being populated? Is it via an Automation or some sort based on the data being imported in? If you look at the source is that 0 missing from the record being brought in?
Taking a look at those screen shots it looks like the reference field is looking for employee 55670 but they are listed as 055670 under your reference field. The lack of the 0 is most likely what is causing that reference field to not line up, reference fields are specific and a missing character would do that. When syncing over how is that reference field being populated? Is it via an Automation or some sort based on the data being imported in? If you look at the source is that 0 missing from the record being brought in?