MobileRead Forums - View Single Post - How do I modify this existing custom column?

theducks · 12-12-2019, 03:56 PM

#1 You can't change a column type... So Migrate it

If you care about the lookup name, then step 1 is to rename the existing.
Just change the names MyTemp, #mytemp. Save. (this will make the Last_modified column update to Now.) now create your new Read, #read (Date Type).

In Kobo Utilities CONFIGURE, adjust the setting % is now blank, Last Read is #read

Then we need to Migrate the existing (%read column) to a date in #read

We will select the books (search for those that need updating )
In my TEST I used the Last Modified (if year was 19) as MY trigger USE YOUR 100% column and value
In the Replace field: yours will be #read ,
and you will put a valid date (your choice: eg 01 Jan 2019 as a flag that it was migrated and you do not know the actual date?) into the replace with

That help?

12-12-2019, 03:56 PM	#3
theducks Well trained by Cats Posts: 31,095 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	#1 You can't change a column type... So Migrate it If you care about the lookup name, then step 1 is to rename the existing. Just change the names MyTemp, #mytemp. Save. (this will make the Last_modified column update to Now.) now create your new Read, #read (Date Type). In Kobo Utilities CONFIGURE, adjust the setting % is now blank, Last Read is #read Then we need to Migrate the existing (%read column) to a date in #read We will select the books (search for those that need updating ) In my TEST I used the Last Modified (if year was 19) as MY trigger USE YOUR 100% column and value In the Replace field: yours will be #read , and you will put a valid date (your choice: eg 01 Jan 2019 as a flag that it was migrated and you do not know the actual date?) into the replace with That help? Attached Thumbnails