I believe TB can import data from an Excel spreadsheet. Using this feature, I would like to be able to create links automatically between existing notes and notes that I import from Excel. Here is what I would like to achieve - could anyone point me to the right functions in TB that could help?
- I have several already created notes that each represent a user.
- I have Excel files that contain IP adresses / URLs visited by those users (for simplicity sake, let’s assume that each spreadsheet contains only the IP addresses for one of those users, so I will do several imports - one for each)
- I would like that when I first import a spreadsheet, all the IP adresses it contains appear as notes and are automatically linked to the relevant user (I’ll need to think about a mechanism to indicate which user/note relates to the spreadsheet I’m about to import, or maybe just insert a column in the spreadsheet with the user’s ID)
- Then, when I do the same import procedure for the other users, IP addresses that already exist are not created but only linked, and the others are created and linked to that user.
What should I look into to start setting this up? That would be for me as much as a TB learning project and a useful tool
Thanks a lot!