| Author | Column | Total | Published | Scheduled | In Stock | Total Reach |
|---|
| Code | Author | Column | Title | Received | Status | Cover | Scheduled | Platforms | Article File |
|---|
| Name | Publish Day | Frequency | Authors | Description | Active |
|---|
| Name | Role | Notes | Active |
|---|
This HTML file is the entire app. It lives in your SharePoint Site Assets library.
When a user opens it via a SharePoint page, it signs them in with their Microsoft 365 account
(no separate password) and reads/writes data directly to BookBrahma_Tracker.xlsx on SharePoint
using the Microsoft Graph API.
There is no server. No database. Everything lives in the Excel file.
All team members see the same live data.
Create App Registration
Go to portal.azure.com → Azure Active Directory → App registrations → New registration.
Name: BookBrahma Tracker
Set Redirect URI
Platform: Single-page application (SPA)
URI: the full SharePoint URL of this HTML file
e.g. https://yourorg.sharepoint.com/sites/YourSite/index.html
Add API Permissions
API Permissions → Add → Microsoft Graph → Delegated:
Files.ReadWrite · Sites.ReadWrite.All · User.Read
Then click Grant admin consent
Copy IDs & Configure
Copy Application ID + Directory (Tenant) ID from the app overview.
Click Configure SharePoint connection on the login screen and paste them in.
Upload both files to Site Assets
Go to your SharePoint site → Site Contents → Site Assets.
Upload: BookBrahma_Tracker_App.html and BookBrahma_Tracker.xlsx
Create a SharePoint Page
New page → Add web part → Embed
Paste: <iframe src="URL-of-HTML-file" width="100%" height="900" frameborder="0"></iframe>
Publish the page. Share the page link with your team.
First login
Click Configure, fill in Client ID, Tenant ID, site URL, and Excel path.
Sign in with Microsoft — done. Config is saved in browser, not needed again.
📦 Batch Submit — when an author sends multiple articles, enter the count once. All articles are created with auto-generated codes and added to stock.
📄 SharePoint URL — paste the link to the article's source file (the .docx stored in SharePoint). This appears as a clickable link in the articles table.
📱 Platforms — when published, tick each platform, enter reach/views, and paste the live URL. Dashboard updates immediately.
↻ Refresh — if someone else edited the Excel directly, hit Refresh to pull latest data.