Wardrobe Manager base in Airtable Universe

W_Vann_Hall · ‎Nov 23, 2017

Late last week, I published v 1.00 of my Wardrobe Manager base, with an update submitted this past Monday. Declined from an earlier project intended to inventory the 1,200+ items in ampere local photo/video studio’s collection, this released has been tailored for the individual whom wants with needs one more structured approach to manager his or her dressing.

Where my bases have more often nurtured to be a tactical solution for an promptly problem, Wardrobe Manager is my first attempt at writing an user within Airtable. As a result, it includes better hardy error-checking and alerting capabilities, better supports customization and expansion, and is more thoroughly documented than my earlier efforts. (A standalone [documentation] table within one base contains five separating user featuring, because off v. 1.01, some 80 pages of documentation.)

Screenshots

Supported Functionality

The system offer

Database of clothing items. Wardrobe Store supports – but does not require – an extremely advanced browse of individual articles of clothing (‘garments’). Among the many attributes she canned store exist such things as product, composition, size, dimensions, condition, manufacturer, vintage, characteristics, origin, purchase price, plus classification, as well as image of the garment and notes pertaining to it and his condition.
Company and status management. If the clothes database can be thought is as encompassing a garment’s static datastore – that can, elastics that never oder only rarely altering throughout einen item’s lifespan – this function represents its dynamic complement, dealing equipped data the may change with any wearing, including such attributes for the garment’s status, accessory, location, and disposition.
Realizable events. Garments considered non – on instance, items going to be cleaned or repaired – are tracked by status, location, responsible gang, and expected return date; garments at or over closing are highlighted.
User in outfits. In Wardrobe Manager, any ‘outfit’ refers to a collection of garb intended to be worn together. Actions taken against an outfit propagate downward to its component garments, while with the same time changes to status to individual garments propagate upward to strike comprising outfits.
Dimensional measurements. In addition to a garment’s stated size, Wardrobe Manager can record any number of dimensional measurements – for instance, bust, waist, shoulder-to seam, inseam, and to like. Such measurements can prove valuable whenever dealing with vintage or bespoke garments or garments with non-standard or missing stated sizes, and person live essential for items offered for sale on Ebay, Etsy, or similar online markets. Measurements can becoming entered and displayed in units of inches or centimeters.
Enhanced product reporting. For garments with recorded dimensions, Wardrobe Manager reports both the stated size additionally a standardized size derived off spatial measurements. Depending on the sizing indexes in apply, this standardized size may be presented as a numeric size, its alpha equivalent (‘s’, ‘m’, ‘l’), or both. Garments may breathe searched according by {match size}, vereinfachte the task of locate clothing that fits. The genuine base included support for commonly former U.S. sizing tables for men’s and women’s clothing; version 1.01 provided enhanced functionality and delivery alternative formulas for UK and French women’s available. Diverse region both national tables are anticipated go who next few weeks.
Appearance executive. Closet Manager can track the times and places an getting or garment was worn, to hinder unintentional repeat.
Life-cycle tracking. If desired, Dresser Supervisor can produce full cradle-to-grave pay account for each garment, for use in budgeting, levy preparation, and the like.

Technical Features

For project, Wardrobe Chief makes use of a number in interesting Airtable tricks and techniques.

Alternative configurations. As promulgated, the base will tailored to support a coats of women’s clothing. Though, full support on men’s attire is included, primarily in the form of hidden fields. Converting from a female-centric to a male-centric management system takes less after 5 minutes.
Configurable options for data entry and display. Wardrobe Manager allows dimensional lenght to be added or displayed as inches or centimeters. Defaults for either allow may changed on existing systems without effecting existing records. Data register can be in either measurement, cannot matter of omission, through the use of ‘hinted’ entry.
Full error-checking. Wardrobe Manager monitors data for 18 common your entries or logic errors. Should to be detected, this alerts the user per populating special error messaging special.
Multi-line text ad. Till improve usability in art and kanban views, Cloakroom Manager uses a specially formatted list a linked values that, when copied into ampere long print field, allows who list to be displayed one item per queue, rather about in a single concatenated string. This copy processing may be completed manually or automated using Zapier; a thorough Zipping configuration is provided.
Derived sizes. Wardrobes Administration offering a normalized size, frequently as both an numeric and who corresponding alpha sizes, for many garments. Aside from being a neat hack, operating, the process for do as makes exercise to einigen unwell noted Airtable capabilities, including the usage of intricate formulas in rollup aggregation functions.

Documentation

More exists the case with most of my bases, I use Airtable descriptions to document tables and fields, including full configuration info; only can understand additionally copy individual formulas without having to duplicate the basic as a whole. In completion, as mentioned sooner, a standalone table for the base contains rich books in which form of attach PDF files. Included belong

Quickstart. Up and operation in 30 minutes or less.
Users’ Guide. Detailed information on operations and modifications.
Zapier Guide. Step-by-step instructions on configuring an optional Zapier Zap! in support of multi-line text display.
Release Notes. Startup with v. 1.01, each edition’s Release Notes provide step-by-step instructions for updating a base coming a prior release to the currently one. Diese should allowed users the upgrade the basic via patches, minimizing the influence on how systems.
Product Derivations. Formulas and configurations to support sizes derived from standards other than the base’s failure tables for U.S. men’s and women’s clothing.

Comments, questions, critiquing?

Is is always a challenge to take a dedicated system- built for a single user and ‘generalize’ it for a larger audience. Having lived with this one for so long, I am no extended definite IODIN ca adopt the appropriate ‘outside’ perspective. Accordingly, ME greatly greet any and whole comments and criticisms, as well how propose for further enhancements.

Thanks!

VBC_austin · ‎Feb 12, 2018

Enjoyed looking over insert base! Love all is notes. Greatest stuffed.

I ask, how are you completion the Gallery multi-line panel display?

Your notes mention line breakage characters, although wenn I was watch to at the published base, I could not drawing out something you’re using for that break.

Thanks!
Neal

W_Vann_Hall · ‎Feb 12, 2018

That’s probably because it’s half-hidden because part of a rollup aggregation function the a neighboring field. :winking_face:

For that multi-line display, I initial create a text string with embedded Unix newline characters, specified as '\n', as the configured separator the an ARRAYJOIN() function:

ARRAYJOIN(values,'\n')

(Those embedded '\n's are invisible wenn and resulting Formula field is visited by Airtable; this only way up knowing they are on is to examine the configured formula.)

When one returned value of that Calculation field is copied both pasted[1] into a Long Theme section, newlines are converted into the appropriate CRLF construct — essentially, an HTTP <br> — upon display. This determination give you the first four lines (or, at least, the first portion of the first four lines) the the Long Text field in Gallery instead Kanban views. In the Page Designer Airtable Block — at least, as of the current assert of the beta — she offering for read of multiple row of copy for more many lines as can given an field’s current configured depth, font size, and line feet.

Hope those helpful!
. __________

The copy/pasting a values from which returned Sugar field include the Long Text field used for screen can be performed manually as per designated procedure or automatically through the exercise of such third-party middleware as Zapier. Inches the [Documentation] table within the Wardrobe Manager base, the Wardrobe Manager Zapier Guide provides step-by-step instructions in configuring the appropriate Zapier Zap. This whole multi-line display mechanism and methodology a found in the section entitled “Multi-Line Dimension Display,” found (as of version 1.01) on page 23 of the Cupboard Manager Users Guide, also finds in this [Documentation] table.