[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.