Welcome to the community, @Mike_Jackson! :grinning_face_with_big_eyes: A straight import from a CSV file won’t get you what you want. My suggestion is to import the CSV data into a temp table, then run a script in the Scripting block to process it and put the date into your primary tables.
I would also suggest changing the design of your base slightly. Instead of using a multiple-select field for the investors, add an eInvestors]
table, and link each investor to one or more records in a eCompanies]
table. That will allow you to track more info about each investor besides just their name, and also make it easier to link new investors to companies without messing up existing links.
With that setup, the script in the Scripting block would parse the records you’ve imported into in the temp table, add any necessary investors and/or companies to their respective tables, and create the appropriate links along the way. Such a script wouldn’t necessarily be simple to create, but it would give you a much better result than a straight import ever would.
If you’d like help creating such a script, post a new thread in the #developers:work-offered category, and include a link to this one so you don’t have to retype so much of your background info.
Welcome to the community, @Mike_Jackson! :grinning_face_with_big_eyes: A straight import from a CSV file won’t get you what you want. My suggestion is to import the CSV data into a temp table, then run a script in the Scripting block to process it and put the date into your primary tables.
I would also suggest changing the design of your base slightly. Instead of using a multiple-select field for the investors, add an eInvestors]
table, and link each investor to one or more records in a eCompanies]
table. That will allow you to track more info about each investor besides just their name, and also make it easier to link new investors to companies without messing up existing links.
With that setup, the script in the Scripting block would parse the records you’ve imported into in the temp table, add any necessary investors and/or companies to their respective tables, and create the appropriate links along the way. Such a script wouldn’t necessarily be simple to create, but it would give you a much better result than a straight import ever would.
If you’d like help creating such a script, post a new thread in the #developers:work-offered category, and include a link to this one so you don’t have to retype so much of your background info.
Rock on! Thanks for the feedback Justin, I’ll give that a try.