Excel uploads with User Fields
Hi, I'm having an issue with a user field that someone could shed some light on. We currently upload data through excel csv and one of the fields is designer responsible. Our goal is use this uplo...
Forum Discussion
Catelyn,
I'm assuming that you have a relationship between your Employees table and Projects table and I'm assuming the key field on the Employees table is a field that is defined as a Quick Base user type field.
If my assumptions are correct then if you can use include the email address instead of the designers name in the excel file it should work. Just map the email address column in your file to the Related Employee field in the Projects table.
If my assumptions are not correct and the key field on the employees table is the record id# field then you would need to include the corresponding record id# for each employee in your excel file and map that to the Related Employee field in the Projects table.
Keith
------------------------------
Keith Jusas
------------------------------
I'm assuming that you have a relationship between your Employees table and Projects table and I'm assuming the key field on the Employees table is a field that is defined as a Quick Base user type field.
If my assumptions are correct then if you can use include the email address instead of the designers name in the excel file it should work. Just map the email address column in your file to the Related Employee field in the Projects table.
If my assumptions are not correct and the key field on the employees table is the record id# field then you would need to include the corresponding record id# for each employee in your excel file and map that to the Related Employee field in the Projects table.
Keith
------------------------------
Keith Jusas
------------------------------
