Is there a way to populate a column based on the contents in a tag column?

[1ily]

I have a separate column for my tags and my shelves, and my shelves are automatically imported to my kobo as collections.

I want to populate my shelf column based on the tags that get pulled from any download metadata.

I use the tags column to populate the subtitle on my kobo, so I want it separate from my collections. Anyone have any ideas?


So some example tag column values:
Book 1: Fantasy, Humor, Adult
Book 2: High Fantasy
Book 3: Comedy, First Love, Young Adult
Book 4: Fairy Tales; Folk Tales; Legends & Mythology; Legends & Mythology

Example collection values:
Book 1: Fantasy, Comedy
Book 2: Fantasy
Book 3: Comedy, Romance
Book 2: Fantasy

[BetterRed]

User Category perhaps, this is how you get to it (afaik, there's no toolbar/menu item):



This is what it presents:



There's also a similarly named optional plugin that provides additional capabilities that make it more accessible ==>> User Category

BR

[ownedbycats]

Originally Posted by 1ily

I have a separate column for my tags and my shelves, and my shelves are automatically imported to my kobo as collections.

I want to populate my shelf column based on the tags that get pulled from any download metadata.

I use the tags column to populate the subtitle on my kobo, so I want it separate from my collections. Anyone have any ideas?

Here's a simplified version of the template I use to populate my #kobocoll column using Action Chains' single-field edit.

program:	

subjects = $#subjects;
admintags = $#admintags;
existing_colls = $#kobocoll;

	new_colls = strcat(	
		if 'omnibus' inlist admintags then 'Omnibus,' fi,
		if 'OVERDRIVE' inlist approximate_formats() then 'Loans,' fi,
		if $#booktype=='Fanfiction' then 'Fanfiction' fi,
		if '^Cozy Mystery$' inlist subjects then 'Cozy Mysteries,' fi,
		if '(Juvenile|Young Adult)' inlist subjects then 'Juvenile & Young Adults,' fi,
		if '^(Fantasy|Paranormal|Science Fiction)$' inlist subjects then 'Fantasy & Sci-Fi,' fi,
	);

	merged_colls = list_union(new_colls, existing_colls, ',');

[ownedbycats]

For your example, you don't need to match every specific tag - without the anchors (see the 'cozy mystery' line in the above post), 'fantasy' will match both fantasy & high fantasy, for example.

program:	

subjects = $tags;
## Replace this with your collection column
existing_colls = $#kobocoll;

	new_colls = strcat(	
		if '(Comedy|Humor)' inlist subjects then 'Comedy,' fi,
		if '(Fantasy|Mythology)' inlist subjects then 'Fantasy,' fi,
		if '(Romance|Love)' inlist subjects then 'Romance,' fi,
	);

	merged_colls = list_union(new_colls, existing_colls, ',');

[1ily]

you guys are amazing, thank you!