@Mac Interesting. I did not consider listing an item multiple times. Makes perfect sense!
Took a sec to sort out how a sold green lamp (record 3, Items for sale) would appear as 1 of 4 available items for reserving on the form, and a sold rug (record 3, Items for Sale) would show up in
Buyer Hold: No name in Buyer Hold field next for Sold items.
Testing the form (airtable’s are very jumpy for me), I reserved an item but noticed when it populates in
Items For Sale, a manual switch from Available to On Hold is needed. Adding a filter to exclude Sold items on Available Items view was, of course, an easy fix.
I’ve incorporated elements of your base and borrowed very heavily from @Kamille_Parks’s - again, thank you both.
Main modifications to Kamile’s base:
Grid view: added If Sold field
Available view: Filtered out Sold
Added Reserved view to allow expressing interest in a Reserved item
Linked Release Hold to Stock Table
Added Interested in Reserved
~ Customers / Line Items / Orders tables are carryovers from template I’m still fiddling with.
~ Master Gallery view is theoretically the one I’ll embed into site, but there are challenges (Status, Interested count) described below
Issues / Working on:
~ Right now, when an item is released from hold, it’s returned to inventory but the record is not removed from Reservations field in Stock table.
~ How to set up a Status field (currently a manual step - single select field on
MASTER tables, not linked) in general, and so that: Instead of having an item (Qty 2) display as both Available and Reserved (see Gallery view, Master table) because 1 of 2 happens to be Available while 2 of 2 is Reserved, is (# + Status) format possible?
Qty 1 - item available: Status = 1 Available; Qty 1 - item reserved: Status = 1 Reserved
Qty 2 - items available: Status = 2 Available; Qty 2 - items reserved: Status = 2 Reserved
Qty 2 - 1 reserved, 1 available: Status = 1 reserved, 1 available
~ Master gallery (and website embed) view: Interested field which represents (# Reservations + # people interested in already Reserved) is useful/relevant only to Reserved items - how to hide for other Statuses. I.e. not display Interested (0) for an Available item.
~ How to remove a Sold item of which there are 2 (decouple) so it doesn’t appear in Website/Gallery views.
Neither view is optimal in the way items display when embedded. Grid limits fields displayed to 4, but with a cleaner presentation (rows) while the gallery is clunky.
A month from now a lot of this will seem obvious.