- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 09, 2024 05:56 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 09, 2024 09:44 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2024 07:35 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2024 08:47 PM
Ok, I'll try having a look at that,, thank you.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 10, 2024 10:00 PM
Thank you Alyssa, I'll give that a try. Hopefully it is as easy as you make it sound. 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 12, 2024 07:49 PM
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:
- Add a New Field:
- Field Type: Rollup
- Field Name: First Design Preview (or something similar)
- Configure the Rollup Field:
- Link to: Linked SKU
- Field: Attachment (Image) (the field where your design images are stored)
- Aggregation Function: ARRAY_FIRST(values)
- 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
- Add a New Field:
- Field Type: Lookup
- Field Name: All Images
- Configure the Lookup Field:
- Link to: Your Linked SKU field
- Field: The Attachment (Image) field where your design images are stored
- Save the Field.
Step 2: Create a Formula Field to Extract the First Image
- Add Another New Field:
- Field Type: Formula
- Field Name: First Design Image
- 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.
- Save the Field.
But it only gives me urls of the images.
