add date/time emailed (connect/share) to a custom column

hillcountryfare · 07-15-2023, 06:40 PM

I can't quite wrap my head around how to populate a custom column with the date and time that a book was emailed. I believe I can log the date / time with today() in a plugboard, but unsure of the exact code or where to store the value.

If it's too difficult to populate with a date and time, I'd settle for a boolean field. This can trigger when it's emailed to any email address / device.

Thanks all.

kovidgoyal · 07-15-2023, 08:04 PM

templates dont have access to the database without some major hackery.

ownedbycats · 07-16-2023, 06:11 AM

I've used Action Chains to run an arbitrary action and then populate a custom column with the current datetime. Pretty much anything available as a menu item can be used.

You'll need to always run it from Action Chains, though.

chaley · 07-16-2023, 06:27 AM

Quote:

Originally Posted by ownedbycats

I've used Action Chains to run an arbitrary action and then populate a custom column with the current datetime. Pretty much anything available as a menu item can be used.

You'll need to always run it from Action Chains, though.

Some more detail to use Action Chains to make this automatic.

Create a chain with 2 actions:
1. send the selected book(s) by email (Calibre actions / Connect share / Email to ...)
2. set the custom date/time column to today (Single Field Edit of your custom column).
If you wish, give the chain a keyboard shortcut.
Then use the chain to send your book(s) instead of the standard Connect / share option.

If you need help, ask in the Action Chains thread.

07-15-2023, 06:40 PM	#1
hillcountryfare Member Posts: 12 Karma: 10 Join Date: Jul 2023 Device: KPW, Fire Tablet 8	add date/time emailed (connect/share) to a custom column I can't quite wrap my head around how to populate a custom column with the date and time that a book was emailed. I believe I can log the date / time with today() in a plugboard, but unsure of the exact code or where to store the value. If it's too difficult to populate with a date and time, I'd settle for a boolean field. This can trigger when it's emailed to any email address / device. Thanks all.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Capture email/share date in column?	Allreader	Library Management	2	10-02-2019 04:33 AM
Custom column that lists date AND time a book is added	cscoley	Calibre	14	05-01-2019 04:20 PM
Custom column date	MerlinMama	Library Management	6	08-01-2014 09:49 PM
custom date column from two state column	Dopedangel	Library Management	7	01-03-2012 08:20 AM
Custom column for date added	Gunnerp245	Calibre	2	07-08-2011 04:39 PM

07-15-2023, 08:04 PM	#2
kovidgoyal creator of calibre Posts: 45,319 Karma: 27111242 Join Date: Oct 2006 Location: Mumbai, India Device: Various	templates dont have access to the database without some major hackery.

07-16-2023, 06:11 AM	#3
ownedbycats Custom User Title Posts: 10,936 Karma: 74999999 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I've used Action Chains to run an arbitrary action and then populate a custom column with the current datetime. Pretty much anything available as a menu item can be used. You'll need to always run it from Action Chains, though.

Advert