Hello all! I hope to get some help on Frankensteining my own version of Stylebook and Pureple that creates outfits BUT is based user preferences instead of random chance, and doesn’t require the torture of photographing clothes.
My Method So Far:
I created a database of my wardrobe across three tables so far based on garment category:
- Tops
- Bottoms
- Outer Layer
Each table has columns that describe a garment’s color, fit, fabric, length, collar/neckline, embellishments, closures, etc.
Then I:
- Created views in each table based on Outfit Proportion.
- Copy+pasted those individual lists into a combination generator to create outfits
- Manually weeded out outfits that didn’t look good based on mismatches (eg denim on denim, black and red, etc.).
What I’d like to happen:
- Outfits table that takes records from the garment tables & views to populate individual records
- Go through those Outfit records to find something I’d like to wear.
I’ve tried the Junction app but that only combines tables without conditions, and only does 2 tables at a time.
I’ve tried Find Records Based on Views but that doesn’t create rows of outfits, just a list of matching items in a field.
Is there a way, without scripting, to combine their powers?