MobileRead Forums - View Single Post

chaley · 07-08-2020, 03:46 AM

Use the template

Code:

program: 
	test(check_yes_no('#mybool', 0, 1, 0),  test(field('#mydate'), 'Yes', ''), '')

Be sure to change the lookup keys to the ones in your database.

Note that this template returns "Yes" or empty. If you want "No" then change the empty strings ('') to 'No'. You can also distinguish between the Yes/No column set to False when there is no date by changing only the first ''.

You might want to check the box "Show checkmarks" in the definition of your composite column.

07-08-2020, 03:46 AM	#2
chaley Grand Sorcerer Posts: 12,447 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Use the template Code: program: test(check_yes_no('#mybool', 0, 1, 0), test(field('#mydate'), 'Yes', ''), '') Be sure to change the lookup keys to the ones in your database. Note that this template returns "Yes" or empty. If you want "No" then change the empty strings ('') to 'No'. You can also distinguish between the Yes/No column set to False when there is no date by changing only the first ''. You might want to check the box "Show checkmarks" in the definition of your composite column.