Integer column: Defining range of numbers

ownedbycats · 02-25-2021, 03:19 PM

I have a #percentread integer column with the current format {0}%. I'd like to limit it to numbers from 0 - 100 (can't exactly read -50% or 130% of a book

). I checked the reference and used Google but I'm not sure how to do this.

chaley · 02-25-2021, 05:36 PM

There is no way to limit the range of values in an integer column.

You can get part way there by defining color/icon rules to flag out-of-range values.

ownedbycats · 02-25-2021, 05:44 PM

I can do that then. Thank you.

02-25-2021, 03:19 PM	#1
ownedbycats Custom User Title Posts: 11,313 Karma: 79528341 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Integer column: Defining range of numbers I have a #percentread integer column with the current format {0}%. I'd like to limit it to numbers from 0 - 100 (can't exactly read -50% or 130% of a book ). I checked the reference and used Google but I'm not sure how to do this. Last edited by ownedbycats; 02-25-2021 at 04:51 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding a % to an integer column.	ownedbycats	Library Management	2	11-01-2020 12:55 PM
Customize the positive and negative number format on an integer column	Sandwich	Library Management	5	10-13-2020 05:15 AM
Integer Column	Quetico	Reading and Management	0	07-09-2017 11:27 PM
[SOLVED] Remove value accidentally added to custom integer column	macnab69	Library Management	11	07-07-2013 07:58 AM
Method to set Date from user integer column	macnab69	Library Management	9	07-07-2013 07:52 AM

02-25-2021, 05:36 PM	#2
chaley Grand Sorcerer Posts: 12,525 Karma: 8065948 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	There is no way to limit the range of values in an integer column. You can get part way there by defining color/icon rules to flag out-of-range values.

02-25-2021, 05:44 PM	#3
ownedbycats Custom User Title Posts: 11,313 Karma: 79528341 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I can do that then. Thank you.