UniQ Booking MIS

Bulk Booking Excel

Fill many new bookings in Excel. Do not enter Serial Number or Drive Link — the app creates both automatically.

Template

Workflow: download template → fill one booking per row → upload here → preview → Create Bookings. Serial Number, Drive Link and Audit Trail are system fields and are intentionally excluded from the template. For NABL, every uploaded sample creates the normal NABL serial plus its paired 26N row, exactly like New Booking.

No file selected.

Select Booking Rows

Use filters first. Select All takes a maximum of 50 matching rows at one time.

Checking rows…

You can still tick/untick individual rows. For a continuous block on the visible page, click one checkbox and then Shift-click another checkbox. Hard limits: 50 rows per bulk action and 500 bulk-updated rows per approved device per India calendar day.

Replace All / Paste

Works only on selected columns and explicitly selected booking rows (maximum 50 rows/action).

Choose columns and filtered rows first.

or click below and press Ctrl+V / Cmd+V

Values from Excel / Google Sheets

Reason / note

Flexible paste: one cell fills every selected cell; one pasted row repeats across every selected booking; an exact rows × columns block maps cell-for-cell. If the first pasted row matches the selected column headings, it is treated as a header and ignored. Serial Number, Drive Link and Audit Trail cannot be replaced. Daily safety: maximum 500 bulk-updated rows per approved device.

Multi-Column Bulk Correction

Filter first, then correct up to 50 selected rows together. If nothing is selected, the first 50 matching filtered rows are selected automatically.

Checking filtered rows…

Columns & corrected values

Reason / note

One save per booking: all chosen columns are changed together, written into one Audit Trail / Amendment entry, and sent to the Live Database once. Serial Number, Drive Link/Link and Audit Trail remain protected. In All Bookings, Bill Number/Bill Date aliases are mapped to the correct source sheet. Limits: 50 rows/action and 500 bulk-updated rows/device/day.

Excel-Style Formula / Fill

Create +1 series, copy values, or calculate formulas. Results are saved as normal values with Audit Trail and one-second Live Sync.

Click one editable table cell first, or choose a target column below.

Target column

Rows to fill

Fill method

Starting value

Increase step

Fast drag: click a cell, then drag its small green corner down or up. Numbers, dates, months and text ending in a number increase by 1; other text copies.
Formula references: use a heading inside square brackets, such as [UniQ Amount]. Excel column letters such as N or N2 also mean that column in the current row.
Functions: IF, IFERROR, AND, OR, NOT, SUM, AVERAGE, MIN, MAX, ROUND, ROUNDUP, ROUNDDOWN, ABS, CONCAT, UPPER, LOWER, TRIM, LEN, TODAY, DATE, YEAR, MONTH, DAY, DAYS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and XLOOKUP.

⚠ Urgent Incomplete Booking Rows

Checks every field from the first booking column through Due Date across all 4 booking tabs.

Checking…

Bulk Correct by Incomplete ReasonGrouped by reason, column and booking tab · only matching incomplete cells are updated

Page 1

Blank, Pending, Not Filled, Awaiting, In Progress, Under Process, TBD and similar values are treated as incomplete. N/A is allowed.

Bulk Correct · Incomplete Reason

Select an incomplete group.

Corrected value (applied to the same column only)

Only currently incomplete cells in the reviewed group will be changed.

Audit reason (optional)

Never modifies serial numbers, completed cells or unrelated columns.

Who is using this device?

Security identity · your name will appear beside this browser's Device ID.

Permanent Device ID —

Person Name *

It will be shown as Device ID (Person Name) in Active Devices and Admin security records.

Required once for each new login session.

Active MIS Devices

Devices currently using this Booking MIS

Checking active devices…

No active-device information loaded yet.

Active = device seen within approximately 2½ minutes.

NABL Scope Parameter Selector

Live source: NABL PARAMETER SELECTOR 2026 27 FOR BOOKING

1. Manual Parameter EntryUse this first when the required parameter is not available in the inbuilt NABL scope selector.

OR choose from approved NABL scope

Discipline

Product

Search Parameters

Scope Import Pending

Choose Discipline and Product.

0 selected

Open this selector from NABL → Test Parameters.

Manual entry is available first; inbuilt scope parameters remain available below for Discipline + Product selection.

Booking

Multiple Filters · Any Column

Add filters in any order. Different columns combine together; repeated values for the same column are treated as OR choices.

No additional filters applied.

Every stored booking-data column is available (including Serial, dates, billing, client, sample, report, manager, amounts, payment and Drive-link fields). Action is not a data column. Values can be selected from suggestions or typed exactly. Repeat the same column to choose multiple customers/dates/statuses (Customer A OR Customer B). In a normal column filter, separate alternatives with ;. Date filters also accept a range such as 01-08-2026..31-08-2026. Use (Blank) for empty cells. These filters work together with Search and the normal per-column filters.Example: Client filter = ABC Foods; XYZ Foods · Booking Date = 01-08-2026..31-08-2026 After filtering, tick specific serials if Bulk Correct should affect only selected rows.

Correction / Amendment

Hostinger Live Database + Google Backup

Hostinger MySQL is the live shared database. Every changed, new, or deleted booking syncs as a protected delta. A separate Google Sheet keeps the same four booking tabs as a readable backup, while booking attachments stay in Google Drive. The Google backup Sheet is reference-only; edit bookings in this app, not in the backup Sheet.

Built-in Hostinger API · Fixed

Permanent Device ID

—

Devices

Not connected

Sync Queue

0 changes waiting

Last Live Sync

Never

Required Backend

Local-Sync V76 · Delta Sync + FY Business Dashboard

Hostinger MySQL Baseline

Waiting for sync

Same-Row Collaboration

Timestamped delta queue · latest changed rows only

Stale Version Policy

Different cells merge · stale same-cell value cannot overwrite newer server data

Google Backup Mode

Checking automatic incremental backup…

Daily Drive Backup ZIP

Waiting for first 18:30 IST archive

Backup Method

One baseline only · immediate deltas + automatic idle cross-check of missing/edited rows

Realtime Push

~0.1s queue after settled edit

Other Users

Live changes pulled every 1 second

Google Backup Sheet

Automatic one-way backup · missing/edited-row repair runs in background while system is idle

The app works normally even without internet. Saved bookings/edits are kept locally and queued. When internet returns, queued changes are pushed automatically.

Automatic booking protection is active: Save pushes immediately; every open device performs a 10-second server safety check and auto-recovers missed new-booking sync/collisions.

Hostinger MySQL is authoritative: new bookings and later edited/saved records are delta-synced. Google Sheets receives the same four operational tabs only as a readable backup/reference copy. Google Drive stores the serial-wise booking attachments privately; staff use the in-app Attachments portal to list/upload files without Drive permission. Internal restore snapshots remain separate from the readable Google backup.

Bills Due Finder

Find every blank-Bill entry by Client, Sub Executive / Manager, or Agent if Any. In Client mode you can also apply one Bill Number + Bill Date to all loaded rows for that client.

Find Due Bills By

Client

Bill Number

Bill Date

Choose a client.

	#	Stream	Serial	Client	Report Number	Sample Name	Batch Number and ETC	UniQ Amount
Choose a client to load all unbilled entries.

Firm-wise Pending Bills

Blank Bill Number only · searchable · opens the exact firm's pending rows. Viewer has no access.

Search Firm

0 firms

Firm / Customer	Pending Bills	Pending Business	Monthly	Final	>10 Days	Remaining	Open
Open Firm-wise Pending Bills to load.

For performance, at most 60 matching firms are rendered at a time. Search narrows instantly.

Devices · Approval

Approved devices and Pending login requests are separated. Revoked devices are hidden from the Approved list and can return only by submitting a Re-verification request.

Approved Devices0

Pending Requests0

Approved0

Open Devices to load Approved devices and login requests.

Pending Device Approval / Re-verification Requests · approve here before the device can enter MIS.

No pending login requests.

Approved Devices · only Approved devices are listed below. Revoked devices are intentionally hidden.

No Approved devices loaded yet.

After-hours special access requests · Finance / Booking Executive cutoff is 6:30 PM–9:00 AM IST. Admin and Account are exempt.

No after-hours requests.

New/Revoked browser: enter Person Name + Browser Name → request reaches Pending above → Admin approves. Revoked devices remain revoked until that approval.

Admin Panel · User Roles & Passwords

Only Admin can open this panel.

Role restrictions are based on the supplied User Role sheet. Passwords are never displayed here; Admin can replace them.

Admin Approval · User Power Control

Select an approved device/user and click the powers it may use. Powers are saved centrally in Live Database → Device Approval.

Open Admin Panel to load Device Approval and user powers.

User powers not loaded yet.

Live Database Restore Points · Admin

Create a database restore point or load any saved point into this app and automatically sync that restored version back online.

Open Admin Panel to load database restore points.

Restore points not loaded yet.

Hostinger Inode & Old File Cleanup · Admin

Delete obsolete UniQ deployment archives/build folders and old safety backups without touching the running app, live MySQL, uploads or newest recovery copies.

Keep newest backups

Open Admin Panel to scan old Hostinger files.

Password changes are central and invalidate active sessions for that role immediately.

Bulk Action Points · Serial Range

All approved users · only existing booking serials · MySQL verified · no booking fields changed

Booking tab From Serial Number To Serial Number Action Update to Include matching 26N companion serials (NABL only)

The start and end serials must exist and belong to the same stream, financial year and number series. This special action-point tool is separate from the 50-row booking-cell correction limit.

Enter serial range, then Preview. Nothing is changed until you confirm.

Booking MIS · Shared To-Do

Enter and track work for all approved users · live Hostinger MySQL tasks

Show

Open To-Do to load shared tasks.

Tasks do not alter booking rows or Google backup sheets. Completion history is retained.