Dashboard
Projects & financials overview
Total Projects
0
Active
0
PO Received
0
Total Value
โ‚น0
Recent Projects
Pipeline
New Project
Email sent via marselectricalsolutions@gmail.com
Project Details
Press Enter or , after each email.
All addresses get the same single email (one thread, not separate sends).
๐Ÿ›ก Security System
โšก Electrical Work
๐Ÿ“ Electrical Design
๐Ÿ–ฅ LED Video Wall
๐Ÿ”Š AV Infrastructure
๐Ÿ”‹ UPS / Power
๐Ÿ“ท CCTV
โ‹ฏ Others
Quotation Attachment
๐Ÿ“‚ Upload PDF / Excel
Drive / OneDrive Links (item #9: multiple)
Email Preview
Fill details to preview
Custom Note
Import Old Data
Add existing projects โ€” no email sent
โ„น๏ธ Use this for record-keeping only. No emails will be sent.
Security System
Electrical Work
Electrical Design
LED Video Wall
AV Infrastructure
UPS / Power
CCTV
Others
Projects
All projects
SLClient Region / CompanyProject NameQuot#LocationCategoriesValue๐Ÿ“… DateStatusPOEmailActions
Email Center
Sent
Follow-ups
Templates
Sent Emails
ToSubjectTypeDateStatusOpen in Gmail
Invoices
All invoices sent
Invoice#Client RegionProjectAmountAttachmentSent ToDateGmail LinkDeliveryApprovalActions
Reports
Click a company for full report
Total Value
โ‚น0
Pending
โ‚น0
Total Expenses
โ‚น0
Overall Profit
โ‚น0
Conversion
0%
Company Summary
CompanyQuotationsTotal SalesInvoicesTotal ExpensesProfit / LossProfit %PO PendingInvoice to Raise
Categories
Pipeline
Data Transfer
Move data from old version to this new version
๐Ÿ“‹ Follow these steps to transfer your data from the old version of this app.
Step 1 โ€” Export from Old Version

Open your old version of the app in the browser. Open browser Developer Tools (press F12), go to the Console tab, paste the following command and press Enter:

Click the textarea above to select the command. Copy and paste it into the Console. The browser will show a long text string โ€” copy that entire string.

Step 2 โ€” Import into This Version

Paste the copied data string below and click Import:

Step 3 โ€” Verify

After importing, go to the Dashboard or Projects page to confirm all your data has transferred correctly. Your projects, invoices, and email history should all be present.

Current data in this version:
โš ๏ธ Export Current Data (Backup)

Before importing, you can backup your current data:

Excel Import / Export
Bulk import via Excel template, full data export
๐Ÿ“Š Use Excel for bulk operations: download a blank template, fill it in, then upload to import all rows at once.
๐Ÿ“ฅ Step 1 โ€” Download Blank Excel Template

This downloads an Excel file with the correct column headers. Open it in Excel/Google Sheets, fill your old data row by row, then come back and upload it.

Required columns: Client Region, Company, Location
Optional columns: Quotation No., Project Name, Project Type, Value, Status, PO Received, Date, Categories (comma-separated), Client Email, Drive Link, Notes
๐Ÿ“ค Step 2 โ€” Upload Filled Excel

Once you've filled the template, upload it here. All rows will be imported as projects (no emails sent).

๐Ÿ“‚ Click to Upload Excel File (.xlsx, .xls, .csv)
๐Ÿ’พ Download Complete Data (Item #4)

Export all your projects, invoices, and email logs in one downloadable file. Use this for backup, sharing with your team, or moving to a new device.

Excel format: 3 sheets (Projects, Invoices, Emails) โ€” best for viewing/editing.
JSON format: Best for re-importing into another instance of this app.
CSV format: Simple flat file โ€” projects only.
Drive Backup
Save your data to Google Drive manually โ€” no setup needed
โœ… No Google account setup required. Download your data โ†’ upload to Drive manually. Simple and reliable.
โฌ‡๏ธ Step 1 โ€” Download your data backup

Click one of the buttons below to download all your data. Do this regularly โ€” once a week is a good habit.

๐Ÿ“Š
Excel
3 sheets: Projects, Invoices, Emails. Best for viewing.
๐Ÿ“‹
JSON
Full backup. Re-import into any instance of this app.
๐Ÿ“„
App File
Save the entire app HTML to share or use on another device.
Recommendation: Download the JSON file for backup (it keeps 100% of your data) and the Excel file for viewing/sharing with your team.
โ˜๏ธ Step 2 โ€” Upload to Google Drive

After downloading, open Google Drive and upload the file there. That's it โ€” your data is safely backed up.

On Computer
1 Go to drive.google.com
2 Click + New โ†’ File upload
3 Select the downloaded file
On Mobile (Phone)
1 Open Google Drive app
2 Tap + โ†’ Upload
3 Select the downloaded file from Downloads
โ˜๏ธ Open Google Drive
๐Ÿ” Restore from Backup

Opening the app on a new device or browser? Download the JSON backup from your Drive, then import it here.

How to restore:
1 Download the JSON backup file from your Google Drive
2 Go to Data Transfer in the sidebar
3 Paste the JSON content โ†’ click Import Data
๐Ÿ”” Backup Reminder

Set how often you want the app to remind you to back up.

Team Sync
Real-time sync across all users โ€” powered by Firebase (free)
โšก One-time setup โ€” then all team members sync automatically
Firebase is Google's free database. Setup takes 5 minutes. Once connected, every time any team member adds a project, invoice or expense โ€” all other users see it instantly.
Connection Status
Not connected
Enter your Firebase config below and click Connect
๐Ÿ“– Firebase Setup Guide (5 minutes)
  1. Go to console.firebase.google.com
  2. Click Add project โ†’ name it "Mars Electrical" โ†’ click Continue โ†’ Create project
  3. On the project homepage, click the </> Web icon to add a web app
  4. Give it a nickname (e.g. "Mars App") โ†’ click Register app
  5. You'll see a firebaseConfig block โ€” copy these values into the fields above:
    apiKey: "AIzaSy..." โ†’ paste in API Key
    projectId: "mars-electrical-xxx" โ†’ paste in Project ID
    appId: "1:xxx:web:xxx" โ†’ paste in App ID
  6. In Firebase Console โ†’ left menu โ†’ Build โ†’ Realtime Database
  7. Click Create Database โ†’ choose any location โ†’ Start in Test mode โ†’ Enable
  8. Copy the database URL (looks like https://mars-electrical-xxx-default-rtdb.firebaseio.com) โ†’ paste in Database URL above
  9. Click Connect & Sync โ€” done! Share this HTML file + these 4 values with your team
โœ… Firebase free tier supports up to 100 simultaneous connections and 1GB storage โ€” more than enough for 3โ€“5 users.
๐Ÿ‘ฅ Team Activity
Connect to see team activity
New Invoice
Create and send invoice via marselectricalsolutions@gmail.com
Invoice Details
Press Enter or , after each email.
Invoice Attachment
๐Ÿ“Ž Upload Invoice PDF
Or Drive / OneDrive Link
Email Preview
Fill details to preview
User Management
Control who can access this application
๐Ÿ”’ Admin users can manage other users. Staff users can view and enter data only.
All Users
NameUsernameRoleStatusCreatedActions
Change Your Password
Create Invoice
Send To
Press Enter or , after each email.
Email Preview
Invoice email preview
Fill details to preview
Attachment
๐Ÿ“Ž Upload Invoice PDF
Project
๐Ÿ—‘๏ธ
Delete Project?
This cannot be undone.
Project Expenses
โ‚น0
Project Value
โ‚น0
Total Expenses
โ‚น0
Profit
0%
Profit %
SL
Description
Material
Vendor / Purchased From
Amount (incl. GST)
Purchase Invoice No.
Payment Screenshot
Add Email Record

Add an email record for this imported project so it appears in Email Center with a Gmail search link.

If blank, we'll auto-build a Gmail search link using the subject.
Payment screenshot
โœ•
Default: admin / Admin@Mars2024
Sending...
โœ“
Add New User