Automatically setting a y/n column?

[Rellwood]

I wasnt' sure if this should go in the "Action Chains" or "Bulk Find/Replace" or anywhere else, but I figured it could be asked here.

I am updating my library to match my Story Graph information. The problem is that there are a lot of problems with the matching in Story Graph, and in order to fix many of them I had to go in and add the Amazon ASIN as an identifier. In Calibre I have a y/n column to indicate if a book is currently in The StoryGraph, and for books that I had to go in and add the ASIN in order to get them to match with Calibre I would like to create an action chain that would automatically copy the amazon ASIN identifier to my created sg_isbn_uuid Identifier, and then mark the '#in_sg' column as yes (it's a yes/no column)

I know it's not a huge deal to do it manually, but I was wondering if there was a way to get an automatically marked y/no column some way.

[ownedbycats]

Does it have to be actual boolean? A composite column returning true/false with "show checkmarks" would work, i think. Someone else would have to help with template because I'm a little confused on what you're doing.

[maddz]

I'd be interested in this functionality. I've got a reading position column (null - 100) which is updated from my Kobo and a Read column (Y/N checkmarks). I have never been able to get the Read column to automatically switch to Y if the reading position is 100; I have to do this manually; which is a pain if I've been reading a lot of short stories.

[ownedbycats]

Originally Posted by maddz

I'd be interested in this functionality. I've got a reading position column (null - 100) which is updated from my Kobo and a Read column (Y/N checkmarks). I have never been able to get the Read column to automatically switch to Y if the reading position is 100; I have to do this manually; which is a pain if I've been reading a lot of short stories.

Boolean column - replace with composite:

program:

## Replace with your percent-read column
percent = raw_field('#percentread', -1);

	switch_if(
		percent ==#100, 'yes',
		percent==#-1, '',
		'no'
		)

Remove line 8 if you want nulls to display 'no' instead of empty. Show Checkmarks turns into checkmarks.

[DNSB]

For my Finished column which is likely the equivalent of your Read column built from the Kobo Reading Percentage column, I use the following template and column setup (see image).

{:'cmp(field('#koboreadpct'),100,'','Finished','Finished')'}