FileMaker Pro

FileMaker is a powerful program that is teaching me basic scripting and database management skills. It can do much more than I can take advantage of. I’m really enjoying making a solution that acts a key part of our team’s database. There are tons of tutorials on the web that outline the basics of working with FileMaker. With every video I watch I feel that I gain a better understanding of what is possible with FileMaker. I aim to use these skills and tools so that I may apply them to the database we have built for our website.

Script & Search by Field Contents

Script & Search by Date Range

Script & Loop by Repetition

Relationships & Portals

Conditional Value DropDown

Create Popover Button

Identify Image Color Profile

I’m having an issue where select images I’m importing to the web are missing the sRGB color profile. This is resulting with the color getting massively altered on the web to the point that the product color is unrecognizable–a brown shoe on a white background appears as dark green shoe on a light grey background. I believe a batch or 2 of photos were processed in photoshop and by accident the color profile was not converted. Normal procedure is to batch edit and convert to the required color space for web photos: sRGB.

I was frustrated I could not organize my files by color profile with the built in finder on my Mac. Nor would “Get Info” show me the associated color profile for an image. If I were working on PC the “Properties” inspector would allow better functionality and certainly show this tag. As a workaround, I begin investigating and the internet was suggesting ExifTool as a possible solution. This is a free source coding program that I learned about. I hoped to use it to view and change the color profile on images to make sure they would be compatible with sRGB color profiles required for web pictures.

Hours of searching and reading other websites went by, and I learned just enough to know I really didn’t know anything.

I found this guide to install and use ExifTool on Mac or pc. ExifTool allows you to script with the “terminal” app on Mac OS X. Once installed you can drag and drop your files and click enter/return to view corresponding tags and metadata.

I still needed to learn how to batch edit the color space tag for .jpg files that are undefined.

Stack Overflow Solution 

How to set a color profile with exiftool

For exiftool to add a color profile, you need a profile.file 
You can extract this from any JPEG image by:

exiftool -icc_profile -b somefile.jpg > profile.icc

Then attach this profile by using

exiftool "-icc_profile<=profile.icc" yourfile.jpg

–Lelouch Lamperouge


Alas, Photoshop ignores the color profile and calls it invalid. Reading the same “undefined color space” as before when the file is opened.

The Adobe Solution

Ideas that don’t involve scripting on Mac via the terminal app, namely Adobe functionality:

Advice to batch edit photos with Adobe Bridge:

Create a Action in photoshop that converts to sRGB not assigns and then select photos in bridge and tools> photoshop> batch and run the action.

 Doug R

My normal process to save images for web with the correct color profiles is to use the built in photoshop script, the image processor. This allows you to use an action, save a specific file size, save in a specific location, add ICC color profile and convert image to sRGB color space. In Adobe Bridge, you can run this batch edit script by going to the top menu and selecting, “Tools > Photoshop > Image Processor”

Another answer from the internet points to Adobe Bridge:

Since you have Photoshop, you have Bridge. Open Bridge, point it at your folder of images to sort, and open the Filters panel. It has Color Mode and Color Profile categories, with a count of each type of image in that folder. You can click check marks in the left column to hide/show each type. From there you can isolate each type so you can do mass tagging or dragging into other folders for organization.

That’s all. No need to install any other applications or plug-ins, no need to create smart collections (though Bridge can do that too).

Adobe Bridge – Organization by Color Profile

how to sort images by color space in adobe bridge

So there you have it, after countless hours attempting to learn ExifTool to write color space tags with the terminal … I have completely given up on the script workaround. Luckily, I own Adobe products and Adobe Bridge is an app I can use to sort images, as well as batch edit color profiles when using in tandem with photoshop actions. The end result is to save all images with the save for web format and color space “sRGB” so that all browsers are able to view the intended hues in the image. Additionally, the importer won’t distort the color of product photos when publishing them to the web.

Adobe Bridge also allows you to add metadata to your images without learning a new scripting language like ExifTool. Industry Dev outlines this process in their post, Adding Metadata to Photos Using Templates in Adobe Bridge.

Web Style Curation

Variation Guide

There are 8 types of curations–indicated by number–for Web Styles based on item card attributes, (color/attr1, size run & alt size/attr2). An additional curation is needed–indicated by letter–for other elements that affect the functionality of a product page. The curation of the Web Style will be indicated at the end of the name. Web Style formula starts with the brand code, followed by the item number or alt style abbreviation, and ends with the curation code. 

Format

Code_Style_Curation

Code_Unique_Curation

 

Examples

Group: TNF_123_2Y

Unique: TNF_123_Red_2N

Number Curation

  1. Unique (Cannot Group)
  2. A (Color / Attr1)
  3. B (Size Run)
  4. C (Attr2)
  5. AB (Color & Size Run)
  6. AC (Color & Attr2)
  7. BC (Size Run & Attr2)
  8. ABC (All 3)

Letter Curation

Y = color image added

N = color image missing

D = past seasons / discontinued

Web Style Curation Practice

Apparel (1) Color and Size Run Attributes; (2) Has Color Image; (3) Past Seasons

  • TNF_123_5YD

Apparel (1) Color and Size Run Attributes; (2) No Color Image; (3) Past Seasons

  • TNF_123_Red_5ND

Sell on Web

Styles that are unique (curation 1) will be marked “sell on web.”

Web Style groups will have one parent style that will be marked “sell on web.”

All child styles will share a Web Style with the parent style but they will not be marked “sell on web.  

Illustrator to Embird Tutorial

I spent weeks researching the best amateur hour program that would allow me to use my design skills and apply to my embroidery sewing machine. finally I came to the conclusion that these programs are spendy, and included a bunch of features I didn’t need, and they are not intuitive, so you would need to spend even more on lessons. Post research, I purchased the Embird Base Program, the Digitizing Studio, and the Font Engine Plug-In for about $500.

This trio allows you to convert your vector art into shapes (in your design program of choice), save the file as SVG, and import it to the Embird Studio. Once it is imported there are a series of steps needed to prepare the design for printing on the embroidery machine. However, this tutorial is about how to prepare the vector design / logo for Embird.

My design program of choice is Adobe Illustrator. There are a few changes necessary to convert vector art to a compatible embroidery file. Each shape / path needs to be on it’s own layer. The order of layers will be the opposite as you imagine the design should stitch out.

To accomplish this:

(1) Outline all strokes in your vector design, so they become shapes instead of lines. 

(2) Separate all shapes into their own layer with the “Release Layers to Sequence” option. 

** Before saving the file as a SVG I recommend selecting all your new layers and, from the same menu as step 2,  choose “Reverse Order.”

Outline all strokes in your vector design, so they become shapes instead of lines. 

Separate all shapes into their own layer with the “Release Layers to Sequence” option. 

Batch Resize Product Photos for Web

In the last year, I learned how to automate images in Photoshop with the “Actions” panel. This has been a learning experience for me. At first I was really frustrated that the batch automate was hit or miss, this was mainly due to the images being various shapes and sizes. I didn’t quite understand that landscape and portrait orientation photos would require different actions. What I have learned to streamline the process is to not only use actions, but to also use photoshop scripts, namely the image processor. Which was a lot easier than I thought it would be.  

The tutorial “How to Batch Resize in Photoshop” found on Digital-Photography-School.com, taught me how to easily apply photoshop scripts. When combining the actions and the scripts I was able to achieve my goal, and resize all product images to the google shopping approved size. My output is required to be 800×800 pixels, if necessary add padding and save them for web. The script and the actions work together to resize the photos, add padding and make them square with the desired pixel ratio. 

First save all photos to a single folder. This is what your folder structure will look like when you are done.

folder orientation at the end

Create 3 Actions in the Photoshop Actions Panel, when your done it will look something like this:

Padding Action:

  • Open a test photo and create a new action, and name it “115 padding”
  • Now you are recording that action. Go to “Image > Canvas Size” (Shortcut: Cmmd + Alt + C). 
  • Change the type of adjustment to “percent” and change both fields to “115” then click “OK”
  • Stop the recording by clicking the Square in the bottom of the actions panel

Square Landscape Orientation Action:

  • Open a test photo and make the longest side 800px wide 
  • Create a new action, and name it “sq-canvas-land”
  • Go to “Image > Canvas Size” (Shortcut: Cmmd + Alt + C). 
  • Change the type of adjustment to “pixels” and change the heigh to 800px tall
    • This will create a square canvas 800x800px 
  • Stop recording

Square Portrait Orientation Action:

  • Open a test photo and make the longest side 800px wide 
  • Create a new action, and name it “sq-canvas-port”
  • Go to “Image > Canvas Size” (Shortcut: Cmmd + Alt + C). 
  • Change the type of adjustment to “pixels” and change the width to 800px tall
    • This will create a square canvas 800x800px 
  • Stop recording
 

Open images and create 115% padding

  • Make sure your background color is set to white, or the color of boarder you want to add
  • Go to “File > Automate > Batch” and choose the action “115 padding” 
  • Select “Folder” for source and click “choose” navigate to the folder you prepared and click “OK”

Run Script for all open images to save and resize at 800px as a PSD file, in the same location in a new folder called “PSD”

This is only a good method for images bigger than 800x800px (another action could be made for images that are smaller than 800x800px).

  • Go to “File > Scripts > Image Processor and Select the following options:
    1. “Use Open Images”
    2. “Save in Same Location”
    3. “Save as PSD” | “Maximize Compatibility” | Resize to fit W:”800″ & H:”800″
    4. “Include ICC Profile”

Run Script for all landscape orientation images to save as a square image 800x800px

  • Go to “File > Scripts > Image Processor and Select the following options:
    1. Click “Select Folder” choose the folder with all the landscape photos in the newly created “PSD” folder
    2. “Save in Same Location”
    3. “Save as JPEG” | “Quality: 10” | “Convert Profile to sRGB”
    4. “Run Action” choose “sq-canvas-land” | “Include ICC Profile”
  • When you Run the script a new folder will be created inside the fodler with all your images. It will be called “PSD” organize your photos into 3 different folders.
    1. Square photos “DONE” folder
    2. Landscape photos “LAND” folder
    3. Portrait photos “PORT” folder

Run Script for all portrait orientation images to save as a square image 800x800px

  • Go to “File > Scripts > Image Processor and Select the following options:
    1. Click “Select Folder” choose the folder with all the portrait photos in the newly created “PSD” folder
    2. “Save in Same Location”
    3. “Save as JPEG” | “Quality: 10” | “Convert Profile to sRGB”
    4. “Run Action” choose “sq-canvas-port” | “Include ICC Profile”

My inspiration for this tutorial is from: 

 

How to Batch Resize in Photoshop

At the end I usually compile all the final photos to one folder called “Crunched” or “DONE”

Product Photo Tips & Tricks

What is the easiest way to change the image background in Photoshop? 

 

Wiki How – this seems like the old way to change a background color. I’m looking for a more efficient way to accomplish a task needing to be done in repetition. Ideally something we could do with a batch edit… but lets not get ahead of ourselves. >_^

 

How to Select and Change Colors in Photoshop by PHLEARN on Youtube

This tutorial is quick and easy and uses photoshop magic. 

Steps: 

Select Color Range

  1. Create New Layer
  2. Go to: “Select” > “Color Range”
  3. Select dropdown: Sampled Colors
  4. Use eyedropper on the background of the image
  5. Selection Preview: Grayscale (anything white/#ffffff is selected)
  6. Drop the Fuzziness slider & use + and – eyedropper tools to refine selection
  7. Click “OK” when the background is selected

Add a Hue/Saturation adjustment layer 

  1. Go to: “Layer” > “New Adjustment Layer” > “Hue/Saturation”
  2. Click “OK” (Selection is now applied to a mask on a layer that controls color)
  3. Change sliders for desired color / effect.. 

This tutorial uses the hue slider to change the blue background to a teal background. Upon testing I learned that lightness slider helped me achieve the desired effect. The goal is to change the background color to white background for all product photos.

However, the photos I hoped to remove the background from have a beige backdrop with lots of wrinkles and shadows .. so I’m still looking for a better way to remove the beige and get a white background for the product photos. Regardless, it was a cool trick and a great place to start. I may still need a combination of other selection tools. Putting this brand on the back burner for now…

Steps above learned from the video posted below (0:55-3:55)

 

 

Featured Brands

Apparel

Aventura Clothing

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

ExOfficio

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Arc'teryx

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Haiku Bags

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

The Original BUFF

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

HippyTree

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Columbia Sportswear

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

KAVU

Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Featured Brands (Accordion)

I am item content. Click here to view more brands. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am item content. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am item content. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

I am item content. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Embroidery with Illustrator

Friday, I should have been playing the FML theme song. I found a plugin that is compatible with illustrator, and it only works with the PC version of my CS6 license exclusively for Mac … FML!!!

The tutorial seems like what I wanted, but it’s more expensive than the Bernia software: 

After some research I was able to answer the question: How much would it be to get a CC license and buy the Embroidery i2 plugin? Looks like it would be $20/mo for a year for Ai CC. Two years of that would exceed the price I paid for multiple programs, but they are only licensed for use on my Mac, not my PC … even so. DANG!

There was someone asking about the Embroidery i2 plugin a few years ago on the Adobe forum.. my response is as follows: 

I’ve been heavily researching this topic… The tutorial video looks like it would be perfect .. However, it’s not compatible with my version of illustrator on the operating system my license is for… so to pay $20/mo for a program I already have and pay $3500 for the plugin PLUS annual fees of $1500… *sigh* it’s everything I’ve been looking for and “surprisingly” its NOT affordable (for an amateur such as myself). Figures, I think more and more every day Embird Embroidery Software is winning. In response to the other comment, Embird and programs that are compatible with vector drawing don’t auto convert. Certainly, auto conversion/ auto tracing is not ideal… just like in Illustrator. However, when you import your vector file the goal is to use the vector paths/curves to make the design the way you want it sewn.. without having to re-draw a logo (which is not advised). Embrid PLUS Font Engine Plug-in = $400-$500 (How to Import Vector Graphics with Embird. Unfortunately, the trial version of the software doesn’t let you try it out and I have yet to see a decent tutorial on it). However, my findings are that this combination is the obvious choice. Even with this illustrator embroidery plugin; you would still need to learn how to use the plugin like any other embroidery software. So you might as well buy a new program, built for the trade, that fits your budget. Additionally a software with numerous free tutorials available to help you learn how it works. Sadly, Embroidery i2 for Adobe Illustrator was too good to be true 

Sounds like I need to buy Embird. I don’t think my 2003 Embird license and my 2003 Font Engine is compatible with the vector import feature. The menu is totally different now, and I can’t figure it out if it does or not..  which is a bummer. Perhaps, I could buy the base program and Font Engine Plug-in (with vector import feature) for my birthday, at which point I would feel better about spending that kind of money.  In the end, it would be worth it. 

Embroidery Software and Getting Started

Lately, I’ve had a need for a creative outlet. Recently I was inspired to look into how embroidery sewing machines work. More specifically, what would be needed to turn a vector drawing from Adobe Illustrator into an embroidery design compatible with my machine. I recently got a Bernina Artista 200, and it has been upgraded to be flash drive compatible. The upgrade turned my machine into a Bernina Artista 730. The internet alludes to the fact that these machines are more particular on what size of drive it wants to work with. In fact, the .exp files are quite small and do not need much space. So I was left with the question, what can you do to convert a large flash drive (from a trusted brand/ aka not a cheap one from China) into a small flash drive that is compatible with the sewing machine?

IMPORTANT note: most small flash drives–especially the ones that come from China or a similar areas–are NOT safe, and could contain computer viruses. I have many flash drives from trusted brands that I use all the time. A workaround this problem, is to format your flash drive and “partition” the available space to the size you need. I took an 8GB flash drive and told the drive it only has 256MB to write to. This way the flash drive acts like a small drive that will be compatible with machines that only want a smaller flash drive, like the Bernina Artista 730. I found a WordPress blog called Time Science that walks through how one might accomplish this, How to Downsize a Flash Drive..

I learned that the Official Bernina USB Stick is not necessary from Hoop Lah Carolyn Keber’s Blog, in her article Bernina USB Data Pens. Carolyn uses an Embroidery Program called Embird and she saves her designs as .exp files. I learned about Embroidery File Formats on youtube from Ultimate Stash Embroidery. He taught me that the embroidery master files types are .dst or .exp and they will work using any embroidery machine as well as the file type that is specific for your machine, in my case that would be .art, .pec, or .pes.

I also learned on Carolyn’s Blog about the free software available on the Bernina website for design transfer. It’s called ARTlink 8, I downloaded it and have yet to play with it. Seems like a promising way to write the file to the drive vs. drag and drop. My attempt to download .art files from the Bernina website and drag them to the flash drive I formatted was unsuccessful. I’m thinking the “write to machine” function is necessary for the files to be visible to the machine. I also don’t think I plugged in the drive before tuning my machine on, which was recommended.

My quest started by wondering if I could take a design I created with Adobe Illustrator and use an embroidery plugin to automate the design and not need an expensive hard to use embroidery software. I’ve learned that an embroidery software is needed and I can use my Illustrator skill set to trace a design with the Embird Studio and using the digitize tools. I’ve learned that this program is capable of auto trace, and if the density map shows green and yellow vs. red it will work OK. Just like in Illustrator the trace option is not as good as re-drawing your points with the pen tool. Embird has a tool like the pen tool that will help you define the outline of your design, and then add stitching to fit the design. It also has shape tools and layers similar to the Adobe Illustrator workspace. Once you are finished you can save the .exp file. Then use a program that can transfer the .exp file to your memory stick, like ARTlink 8. Turn off the machine and plug in the drive (Use flash drive as a transfer device, do NOT store your designs on it.. This tip is based on–the amount of time the drive takes to transfer depends on how many designs are on your stick. Keep it Simple Silly!). Turn on machine an click the USB button, on the Bernina this will be on the touch screen. Now use you machine to print the design to the hoop size it was created for.

I’ve learned on the internet Embird is the embroidery software I have been looking for. Instead of investing in the $2,500 Bernina Software (Version 8). Embird also seems more intuitive for someone who already is experienced with Adobe Illustrator, such as myself. All the programs I’ve found have a trial version, so you can always try it out and see if it’s worth a couple hundred dollars. If you only need it sporadically you can keep using the trial version on a virtual computer, or format your computer when you want the trial program again. Embird also has packages you can buy on top of the base program. However, if you don’t need it you don’t have to buy it. Where as, the Bernina Software comes in a big intimidating package; they expect you to get lessons from your local dealer, on top of all the fees you’ve already been hit by…   If I bought all the features Embird offers it might add up to $1,000. Again, I don’t need all the tools Embird has because I have design tools that I am already competent at using. Who knows, maybe later down the line I will feel the need to try the other perks Embird offers.

I found several tutorials on youtube helpful to decide on Embird Embroidery Software. So far, I really like the tutorials by, OML Embroidery. Here’s one of many tutorials I found helpful, Embird Quick Tip: how to digitize like a pro!

Happy Sewing!

Concatenate Formulas with HTML

The following post is to test Concatenate formulas with added HTML to import vendor data for long descriptions. I am going to include several examples that can be used depending on the provided info. 

 

Demo formula:

=CONCATENATE(E6," ",G6," ",H6," ",I6," ",T6," ")

 


 

I’m going for something like this: 

This is a product description. This is a product description. This is a product description. This is a product description. This is a product description. (E6). 

FEATURES

  • Feature 1
  • Feature 2
  • Feature 3

 

FABRICS

  • Fabric

Continue Reading

 

 

The HTML will look like this: 


 

IF there is 1 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 1 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 1 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 2 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 2 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 2 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 3 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li></ul> ")

IF there is 3 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li>",T6," </li><li> ",U6," </li></ul> ")

IF there is 3 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6," </li></ul> ")

 


 

IF there is 4 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 4 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 4 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 5 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 5 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 5 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 6 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 6 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 6 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 7 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 7 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 7 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6,"</li></ul> ")

 


 

IF there is 8 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 8 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 8 features and 3 fabrics the formula could be:

=CONCATENATE(E169," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G169," </li><li> ",H169," </li><li> ",I169," </li><li> ",J169," </li><li> ",K169," </li><li> ",L169," </li><li> ",M169," </li><li> ",N169, "</li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T169," </li><li> ",U169," </li><li> ", V169,"</li></ul> ")


 

IF there is 9 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 9 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 9 features and 3 fabrics the formula could be:

=CONCATENATE(E205," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G205," </li><li> ",H205," </li><li> ",I205," </li><li> ",J205," </li><li> ",K205," </li><li> ",L205," </li><li> ",M205," </li><li> ",N205," </li><li> ",O205," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T205," </li><li> ",U205," </li><li> ",V205," </li></ul> ")

 


 

IF there is 10 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 10 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 10 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ", V6, "</li></ul> ")

 


 

IF there is 11 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 11 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 11 features and 3 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li><li> ",V6, "</li></ul> ")

 


 

IF there is 12 features and 1 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li></ul> ")

IF there is 12 features and 2 fabrics the formula could be:

=CONCATENATE(E6," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G6," </li><li> ",H6," </li><li> ",I6," </li><li> ",J6," </li><li> ",K6," </li><li> ",L6," </li><li> ",M6," </li><li> ",N6, " </li><li> ",O6," </li><li> ",P6," </li><li> ",Q6, " </li><li> ",R6, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T6," </li><li> ",U6," </li></ul> ")

IF there is 12 features and 3 fabrics the formula could be:

=CONCATENATE(E197," <p>&nbsp;</p><h3><strong>FEATURES</strong></h3><ul><li> ",G197," </li><li> ",H197," </li><li> ",I197," </li><li> ",J197," </li><li> ",K197," </li><li> ",L197," </li><li> ",M197," </li><li> ",N197, " </li><li> ",O197," </li><li> ",P197," </li><li> ",Q197, " </li><li> ",R197, " </li></ul><p>&nbsp;</p><h3><strong>FABRICS</strong></h3><ul><li> ",T197," </li><li> ",U197," </li><li> ",V197, "</li></ul> ")

 


 

This reference list should work for my current Columbia spreadsheet. Keeping in mind the letter will be the same but the numbers will change depending on the row they need to apply to. Excel will color code selected cells, if the cell ID is not colored this is an indication of where you made a mistake in your formula. 

 

Finished Reading