Skip to main content
Question

Excel uploads with User Fields

  • January 23, 2020
  • 0 replies
  • 123 views
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 upload data to link back to their employee table so that we can see all their projects or jobs in their employee table. 

When we upload the data it doesn't connect the name to the user. We've been told it's not possible because Quick Base can't match text name to a user. I've thought about automation, dynamic rules, or even having a field that was a formula that read the name in our designer name text field and selected the appropriate user. Any ideas on how this could work?

Thanks!

------------------------------
Catelyn Atkinson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You can have a table of employees where the Key field is set to employee name.  Add a field to that table for the Userid.

Then make that table a parent in a relationship to your jobs table that you are uploading to, and the name will match up with the Employees table and then it can pull down the user field as a lookup.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • January 24, 2020
Catelyn,

Does you application look like this?



When you load the CSV data to the Jobs table, the Designer Responsible must match 100% with one of the Employee Full Name records in the Employees table.   

If it does, then the Job record will now know the User from the Employees table.  That obviously empowers reports and workflows where as the Employee name is for UI consumption.

Where is your CSV data coming from? What system is generating that data?  Can you make it any richer with the Record ID# of the Employee?   As Mark mentioned characters before or after will break this trick.   "Catelyn" is not " Catelyn" is not "Catelyn " and so on.

Another way to do this is email address.  If you put the Employee email address in both tables as an Email field, it will correct for trailing spaces on the import.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement