Wikilinks in Obsidian are a wonderful tool for writing and research. I'm still investigating the best way to use Obsidian (& et al) for my writing, in particular looking for the best method for organising and manipulating longer pieces of writing.
One option is very long documents and using headings. Headings produce outlines and can be linked directly.
Another option is multiple documents with a MOC/Index. This makes manipulating and re-sequencing very easy.
Another is simply using files and nested folders - the way most writer's programs do it.
However, all are very linear. And I inevitably find linear constricting.
I have always used spreadsheets as part of my planning process, and am aware that many writers have constructed complex systems using multiple spreadsheets.
Tables can help as a cutdown way of doing the same, but their limited functions restrict what can be done. And markdown tables are a PITA (though Typora's are more usable than most).
Ideally I wanted to continue to use spreadsheets. Obsidian allows links to the files which can then be opened in the default spreadsheet program, which is manageable.
But I have worked out a much, much better solution.
- I use a spreadsheet. Scenes, people, places, concepts (anything I choose) get put in wikilinks if I think that I might want to link to them. I can switch and move things around however I want.
- I copy the spreadsheet and paste it in Typora (doesn't work if I try pasting in Obsidian or WriteMonkey, but haven't tried anything else).
- I copy the Typora table and paste it into Obsidian.
- Obsidian will automatically link to any notes that already exist and will offer to create notes for the wikilinked titles that don't already exist.
This gives me a supercharged index that isn't simply sequential. If I hover over the link, I can see the content. I can use the spreadsheet itself (I'll stick a link in as the title of the table) for analysis and development.
The one fly in the ointment is that this seems to be unidirectional - you can't take the markdown table and paste it into a spreadsheet. I assume It might be possible with a few conversions, but that doesn't feel like a productive workflow in normal circumstances. It's not a major issue - it means always making changes in the spreadsheet and copying back into Obsidian, but that's all.
Probably of no interest to most people, but I find the possibilities exciting.