Forum Discussion
ArchiveUser
9 years agoQrew Captain
Hi Dmitry,
The way I ended up resolving this was to modify the source data itself.
You can create a relationship between two connected tables so long as the field you need to associate already exists in the csv that you are importing. Quickbase just can't do this through formulas for whatever reason (For QB admins: feature request :smile: ).
So the best way for you to fix this is going to be to script up something that can concatenate the fields you need in the csv before importing it into QB. Once it's imported, then you should be able to easily create the relationship between the tables.
The way I ended up resolving this was to modify the source data itself.
You can create a relationship between two connected tables so long as the field you need to associate already exists in the csv that you are importing. Quickbase just can't do this through formulas for whatever reason (For QB admins: feature request :smile: ).
So the best way for you to fix this is going to be to script up something that can concatenate the fields you need in the csv before importing it into QB. Once it's imported, then you should be able to easily create the relationship between the tables.