[dummy title body text appended to avoid empty title body]
IvanDrago replied
I have a database with two tables with a large amount of rows each. I’d like to add a LinkToAnotherRecord column from one to the other so that I can create a few other lookup columns. Instead of adding them manually, is there a way to import an CSV or Excel file that has the values that I need to link?
you may take a look if this s your case. if u hv the existing project, n u want to have a lookup
https://docs.nocodb.com/setup-and-usages/lookup#lookup
That’s what I want to do, however, it’s my understanding that before I can do that I have to do a Link To Another Record (https://docs.nocodb.com/setup-and-usages/link-to-another-record/)
If your existing DB has the corresponding relations, then nocodb will create LinkToAnotherRecord column.
if u already hv a nocodb project, I’d suggest u to add it manually n it ll get the corresponding data
The DB doesn’t have them. Before I went ahead and did anything I wanted to see if Nocodb can do it.
I’ve tried importing an Excel spreadsheet and setting that column to LinkToAnotherRecord but when I do that Nocodb imports the column as blank. I wasn’t sure if I was doing something wrong.
before importing an excel, u can fine tune the column to choose the column type. hv u done that ?
besides, adding LinkToAnotherRecord in GUI directly seems the easiest way to do it. any concern for this approach?
