Where can I learn more about how to design Typescript office apps, with deployment in mind?

Question

Please point me to other forums if appropriate, I'm not entirely sure where to ask this question.

When I learned VBA it was over multiple years, learning a little bit of coding, then about .xlsb storage, and sharing code with others was pretty straightforward, then I felt like a had some expertise.

For years I've wanted to develop some apps that would have more office functionality, but once the web version of office/o365 was available I didn't see/understand a path to ensure the app/code would be available regardless of what device the user was on (o365, local device, etc.).

It seems like Typescript might be what I've been waiting for. This question is not about how to learn Typescript, I can manage that - what I'm looking for is a really clear overview of where code gets stored, and different implementation options- if I want to share with one person (onedrive?) or if a company admin wants to roll the functionality out to everyone in their company, on all devices... is that possible, and what design factors need to be addressed up front, that sort of thing.

Use case: MS Outlook code that would run whenever the user was creating a new email, regardless of device, and give them feedback on the contents.

Use case: company-wide database that is updated by all users' activity (responses to prompts that they can initiate at any time); and when checked the current database info is checked to provide the users some key data for a work process.

I believe the answer to: 'what are the functional capabilities and limits of Typescript to create office "add-ins" across users and environments' will be too complex to answer in a forum chat, so I'm not asking for comprehensive answers here- but I'm hoping someone has created this type of '10,000 foot overview' and you can point me to pre-existing learning material.

Answer 1

Here is Microsoft's page about deployment options for Office.js add-ins:
https://learn.microsoft.com/en-us/office/dev/add-ins/publish/publish

These options are more restrictive than what you are used to with VBA.

Office.js is still incomplete compared to VBA. Excel has the most developed API, followed by Word, PowerPoint and Visio, in that order. I've never looked into the Outlook API, so I don't know how it fits into this list.
https://learn.microsoft.com/en-us/office/dev/add-ins/outlook/apis

This forum has no experts in Office.js StackOverflow with an Office.js tag is a good place to ask questions:
https://stackoverflow.com/questions/tagged/office-js