Long text columns containg multiple items

Rellwood · 04-08-2019, 04:01 PM

Is there a way of creating a long text column that would allow items being automatically added to not be overwritten and perhaps be shown with hard breaks between items. Maybe format it so that all items are appended rather than overwritten? Appended with hard breaks?

Would like to use one column to hold multiple instances of original file paths, original file dates, and multiple add and read dates. Unless I use copy/replace and format it so that each item contains a hard break after it, and that the items are appended I don't know if just importing data will overwrite it.

BetterRed · 04-08-2019, 05:12 PM

If you format as HTML perhaps you could use a table, there's no wysiwyg support for tables so you'll need to hand code it - I have no idea if long text HTML columns support tables. Suck it and see, or read the code.

Or if you format as Plain Text you could simply maintain a separated list - maybe using ; or | as a separator.

FWIW: I would maintain the lists in a OneNote .one file, which does support tables, check lists etc etc. I have an empty proforma template .one file on my desktop that I add to a book as a format file as and when needed.

BR

04-08-2019, 04:01 PM	#1
Rellwood Library Breeder (She/Her) Posts: 1,159 Karma: 1900479 Join Date: Apr 2015 Location: Fullerton, California Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)	Long text columns containg multiple items Is there a way of creating a long text column that would allow items being automatically added to not be overwritten and perhaps be shown with hard breaks between items. Maybe format it so that all items are appended rather than overwritten? Appended with hard breaks? Would like to use one column to hold multiple instances of original file paths, original file dates, and multiple add and read dates. Unless I use copy/replace and format it so that each item contains a hard break after it, and that the items are appended I don't know if just importing data will overwrite it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom long text columns duplicating headers	Rellwood	Server	7	01-30-2019 01:38 AM
Need more help with searching multiple columns at once	beckyt	Library Management	3	06-19-2016 06:35 PM
How long does kobo.com take to ship items?	like00111	Kobo Reader	8	06-29-2015 02:53 AM
Is it possible to edit metadata in bulk for columns with long text, like comments?	GustavoB	Library Management	3	04-14-2013 09:39 PM
Is Heirarchy of Multiple Columns Possible?	Steve Bradford	Library Management	4	11-24-2012 09:35 AM

04-08-2019, 05:12 PM	#2
BetterRed null operator (he/him) Posts: 20,575 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	If you format as HTML perhaps you could use a table, there's no wysiwyg support for tables so you'll need to hand code it - I have no idea if long text HTML columns support tables. Suck it and see, or read the code. Or if you format as Plain Text you could simply maintain a separated list - maybe using ; or \| as a separator. FWIW: I would maintain the lists in a OneNote .one file, which does support tables, check lists etc etc. I have an empty proforma template .one file on my desktop that I add to a book as a format file as and when needed. BR

Advert