Help

Re: Setting up a design with several colored variations in a roll up or grouped?

971 0
cancel
Showing results for 
Search instead for 
Did you mean: 
lefty777
5 - Automation Enthusiast
5 - Automation Enthusiast
Hi there, I'm new here, was hoping someone could help guide me on a small problem I cannot seem to resolve. I need a simple solution and instructions how to create a roll up of some designs in my list. So that when a design has more than one color, I can leave it rolled up, so when I am scrolling, I am not going through loads of the same design.
So, as you can see [a] is the first one and any after that b, c, d, etc. will roll up underneath. I tried using roll up but really not sure what I am doing. I'm obviously doing it wrong and wondering if there is a simple workaround that I don't know of.
I have many designs I want to do this for too.
The second picture I have moved a, b, c, d, etc. from the SKU to a line of its own but unsure what to do next. I need a step-by-step guide, if possible, please.
5 Replies 5
Alyssa_Buchthal
8 - Airtable Astronomer
8 - Airtable Astronomer

Cool problem, I'd recommend using a different primary field that is truly unique across your entire table (totally fine if it's the current serial code + a, b, c, d, etc.), then take the current serial code CP22037 and turn that into a single select field instead. Then you should be able to group by that field and collapse the groups.

Just as an fyi for datakeeping best practices, you'll want to ensure that primary field is completely unique without any duplicates whenever possible. Having a unique ID will save you a lot of pain as you grow/want to access this data from other tables/places!

Hmm, if your naming pattern stays the same, where:
 - Designs with no colors end with a number
 - Designs with a color end with a letter

Then you could try to use regex in a formula field to filter out any records where your primary field ends with b, c, d, e etc

Ok, I'll try having a look at that,, thank you.

Thank you Alyssa, I'll give that a try. Hopefully it is as easy as you make it sound. 🙂

 

lefty777
5 - Automation Enthusiast
5 - Automation Enthusiast

I've actually fixed the problem now, but the problem I have with it now is that when they roll up I don't see the first image on the Master SKU, they all become hidden. You can see in the 2nd screenshot. Apparently you cannot put an image into the Master SKU. [where the yellow patch is]. This is what I tried...

Displaying the First Design in the "Master SKU" Row

To make the Master SKU row display the first design or an image preview, you can use a Rollup field that grabs the first image of the linked records. Here’s how to do it:

  1. Add a New Field:
    • Field Type: Rollup
    • Field Name: First Design Preview (or something similar)
  2. Configure the Rollup Field:
    • Link to: Linked SKU
    • Field: Attachment (Image) (the field where your design images are stored)
    • Aggregation Function: ARRAY_FIRST(values)
  3. Save the Field:
    • This will show the first image associated with the linked records for each Master SKU.

It said....

ARRAY_FIRST(values) doesn't seem to work, it says "Sorry, there was a problem creating this field. Invalid formula. Please check your formula text."

Then I tried this...

It seems that the ARRAY_FIRST(values) function might not be supported in Airtable directly within a Rollup field. However, we can achieve the desired outcome using a different approach. Here’s how you can display the first design image for each Master SKU:

Step 1: Create a Lookup Field to Gather All Images

  1. Add a New Field:
    • Field Type: Lookup
    • Field Name: All Images
  2. Configure the Lookup Field:
    • Link to: Your Linked SKU field
    • Field: The Attachment (Image) field where your design images are stored
  3. Save the Field.

Step 2: Create a Formula Field to Extract the First Image

  1. Add Another New Field:
    • Field Type: Formula
    • Field Name: First Design Image
  2. Enter the Following Formula:

sql

Copy code

LEFT({All Images}, FIND(",", {All Images}) - 1)

    • This formula extracts the first image from the list of all images by finding the first comma (which separates images) and taking the substring before it.
  1. Save the Field.

But it only gives me urls of the images.