Upload CSV and link to project record ID
I have a Project Table (ex project 1, 2, 3) and I also have a products table. I want to bulk import products into my products table. Each product has an associated project (1, 2, 3). How can I uplo...
Forum Discussion
I know the field but I'm having trouble getting quickbase to know the field. Right now it's only allowing one merge field: Record ID#. The record ID I want associated for all is just Record ID # 1 but if I put "1" in the record ID column it still doesn't link anything.
------------------------------
Annie Ryden
------------------------------
------------------------------
Annie Ryden
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThat was like a second nuance to your question. Are you saying you were trying to upload products and update existing products or add products if it is a new product?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Sorry for my delay, Mark. I am trying to add products as new products but I want them to be linked to the Record ID.
So I have projects 199 and 193 right now. I'm adding inventory to them via the csv. I have 193 or 199 in the Related Product column on the CSV but nothing links when I upload.
------------------------------
Annie Ryden
------------------------------- MarkShnier__YouIn your upload, did you upload into the field probably called [Related Project]?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Yes, I did. The products all uploaded but they didn't link to the project. The Project # is just blank on all.
------------------------------
Annie Ryden
------------------------------