This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Duplicating Records in Group View only

Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I am an artist working with various companies in various Markets/Categories (ie: greeting cards, home decor, stationery, and gift).

Some companies are in multiple markets such as greeting cards & gift; whereas other companies just serve one. Think Micheal’s v.s. Hallmark. The former serves multiple markets while the latter is likely just greeting cards (just go with me).

So now that you have the back story, I’d like to be able to Group by Markets/Categories, BUT, I would like a record to duplicate itself in this view to list in BOTH greeting cards and gift. I DON’T want it to be Grouped as “Greeting Cards, Gift” because it could be the only company listed as such.

First screen shot shows my basic table prior to grouping:
Screen Shot 2017-05-30 at 8.38.56 AM.png

Second screen shot shows what it looks like after grouping. I’d like Company 1 to be split (duplicated) into both Gift Bags and then also Party Paper (IN ONLY THIS GROUP VIEW) To be clear: I want Party Paper to be it’s own group without me having to create duplicate listings of the same company.
Screen Shot 2017-05-30 at 8.39.18 AM.png

Is this possible? Thanks!

4 - Data Explorer
4 - Data Explorer

Is there a way to auto-generate an auxiliary table based on having 2 tables with links to each other? It would solve the issues IMO. My problem is that I already have data in the tables and also adding data is much easier if I can specify the relations in the table where I’m adding the data and don’t have to switch to the auxiliary table.

4 - Data Explorer
4 - Data Explorer

I don’t understand what did you do?
would you mind explaine clearly?

6 - Interface Innovator
6 - Interface Innovator

There is! It’s an Airtable app. Here’s the link to the app description: