Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 09, 2024 05:56 AM
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!
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
Aug 10, 2024 08:47 PM
Ok, I'll try having a look at that,, thank you.
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. 🙂
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:
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
Step 2: Create a Formula Field to Extract the First Image
sql
Copy code
LEFT({All Images}, FIND(",", {All Images}) - 1)
But it only gives me urls of the images.