ŠAKAL Workshop

Floor

Records

Business

Closed

Ready

Floor

Invoices

Sort

Due

Fitting

Garment

Stage

Ordered →

Due →

Held at

Show only

New Delta order

The charge follows the canvas and the add-ons, so it works itself out.

Delta no.

Give the order its Delta number.

Due back

Canvas

Add-ons

Bring Delta across

The HQ dashboard keeps its orders in that page's own storage, which this app cannot reach. Export them from there and load the file here.

1Open the HQ dashboard and press ⬇︎ Back up data on the Home tab.

2Load the file it saves here. On an iPad or iPhone it will be in Files → Downloads.

Backup file

Or paste the JSON

Replace makes this tab an exact copy of the dashboard. Merge keeps anything here that the dashboard does not have, and updates the rest.

Assistant settings

The assistant needs an Anthropic key to think with. Two ways to give it one.

Where the key lives

1Open Connect sheet and make sure the script is in place.

2In Apps Script, go to Project Settings → Script Properties and add a property named ANTHROPIC_KEY with your key as the value.

3Redeploy as a new version. Every iPad and phone on the shop's sheet can then use the assistant, and the key never leaves Google.

Anthropic API key

Kept in this browser only, never sent anywhere but Anthropic. Anyone who can open this device's browser storage can read it, so use the sheet on shared iPads.

Model

Leave as it is unless Anthropic tells you otherwise.

Everything else

Archive this order?

Delete for good?

Record fitting

Which day did this happen?

Date

Edit order

Order no.

Client

Phone

Email

Fitting date

Due date

Notes

Garments & cloth

Add to price list

Pick a tier and the five garment prices fill themselves in.

List

Fabric brand

Give the fabric a brand.

Collection / bunch name

Cloth type

Price tier

Cost per metre (S$)

Selling price by garment (S$)

2 piece

3 piece

Jacket

Vest

Trousers

Shirt price (S$)

Charge (S$)

Jacket lining (S$)

Jacket + vest (S$)

Bunch in the shop

Add stock item

Item

Give the item a name.

Group

Held at

Brand

Item code / colour

Purchase price

Last purchased

Supplier or link

Note

Reordering

New lead

Log the enquiry now; fill in what happens as it happens.

Name

Give the lead a name.

Enquiry date

Phone

Email

Came from

Where it got to

Consultation on

Purchased on

Follow up on

Remarks

Invoice

Invoice no.

Order no.

Handled by

Client name

Phone

Email

Issued

Fitting date

Due date

Line items

Workshop

Discount (S$)

Remarks

Bring invoices onto the floor

Every invoice number is an order number. These invoices have no matching order yet, so the workshop side of them is missing.

Invoices issued on or after

Close off anything older than

Write to the Google Sheet

Recommended. The sheet is where orders live — anything not written there disappears the next time the app refreshes.

New customer

Name, phone and email. Everything else lives on their orders.

Name

Give the customer a name.

Phone number

Email

Note

Add a card

The cards the shop runs on, and who is carrying them.

Type

Number

Give the card a number.

Provider

Held by

Expiry date

Last amount (S$)

Last top-up

Note

Suit order form

The form could not open here

Some browsers block a page inside a page. Open it in its own tab, design the jacket, then press Attach to order.

Connect the Google Sheet

1Open the Apps Script project behind your ŠAKAL sheet — in the sheet, Extensions → Apps Script.

2Copy the code below and paste it at the bottom of the existing file.

3At the very top of your existing doPost(e), add the two hook lines shown in the code's comment. Do the same for doGet(e).

4Deploy → Manage deployments → edit the live one → Version: New version → Deploy. The web app URL does not change.

5Come back here and press Save all to sheet.

Code to paste

Put ŠAKAL on the home screen

Saved