Auction — Harlow

Current bid (Last updated: —)

$

Place your bid

Harlow is as mischievous as the day is long—and somehow, that day just keeps getting longer. People assumed they’d grow out of it, but nope. Harlow’s mischief has matured like a fine cheese: sharper, smellier, and more likely to cause a scene at a family gathering. They’ve graduated from harmless pranks to full-blown hijinks that somehow involve glitter, a garden hose, and plausible deniability. Teachers, neighbors, and even the family cat all keep one wary eye open. The thing is, even when Harlow’s caught red-handed, their grin is so disarming you start to wonder if maybe you were the one in the wrong.

Large Scary Monster
8.75" x 5.25" x 4.5"

gold luster, matte glaze finish, matte sealant finish
* cowboy hat

One of a kind scary monster sculpture made with cone 6 white stoneware clay. Scary monsters are made from slabs of clay that are pushed and manipulated into their monster shapes. They are all fired in a kiln for 3 firings (thats 3 trips into the abyss of 2000+ degrees) depending on the final finish.

IMPLEMENTATION DETAILS:
- setting up an auction page:
  - duplicate this page
  - edit monster's name at the top of the page
  - edit form to set monster's slug asinput[type=hidden][name="SQF_ITEM"][value=SLUG>]
  - edit form to update submit CTA with monster's name
  - connect form to google sheet
  - add monster's slug, label, and reserve price to SlugMap in Google Sheet
  - rename first tab to FormRaw
  - change formatting for FormRaw:$D (BidAmount) from Number -> Automatic to Number -> Plain text
  - copy SlugMap from "Scary Monsters Auction" sheet into the new auction sheet, rename from Copy of SlugMap to SlugMap
  - copy Normalized from "Scary Monsters Auction" sheet into the new auction sheet, rename from Copy of Normalized to Normalized
  - copy PublicSummary from "Scary Monsters Auction" sheet into the new auction sheet, rename from Copy of PublicSummary to PublicSummary
  - IF CELLS ARE NOT CONNECTED: ensure tab names have "Copy of" removed and the formulas in row 2 have been refreshed (navigate to cell, hit ENTER key twice, then navigate to next column)
  - publish PublicSummary tab as TSV (Google Sheet -> File -> Share -> Publish to Web)
  - update script block with URL for TSV

TODOs:
- [x]: handle starting bid
- [x]: handle lastUpdated with no updates
- [ ]: update top bid on successful submission
- [x]: remove static content
- [x]: test multiple auctions running on same spreadsheet
- [x]: prettify page and UI
- [x]: clean up/comment out console.logging
- [ ]: test on small device/mobile

NICE_TO_HAVES:
- [ ]: user-friendly copy for error state when fail to fetch the auction bids (currently "Error loading data.")
- [ ]: prepoulate form with the current bid + increment
- [ ]: "remember" user by storing form values in a cookie
- [ ]: placeholder text/value for Current Bid while we're fetching

NOTES:
- form must be exactly the same to share a google sheet