| 
			
			 | 
		#1 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				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 05:51 PM.  | 
| 
		
 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| 
			
			 | 
		#2 | 
| 
			
			
			
			 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.  | 
| 
		 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
| Advert | |
| 
         | 
    
| 
			
			 | 
		#3 | 
| 
			
			
			
			 Custom User Title 
			
			![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 11,359 
				Karma: 79528341 
				Join Date: Oct 2018 
				Location: Canada 
				
				
				Device: Kobo Libra H2O, formerly Aura HD 
				
				
				 | 
	
	
	
		
		
		
		
		 
			
			I can do that then. Thank you.
		 
		
	
		
		
		
		
		
		
		
		
		
		
	
	 | 
| 
		
 | 
	
	
	
		
		
		
		
			 
		
		
		
		
		
		
		
			
		
		
		
	 | 
![]()  | 
            
        
    
| Thread Tools | Search this Thread | 
            
  | 
    
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
| Adding a % to an integer column. | ownedbycats | Library Management | 2 | 11-01-2020 01:55 PM | 
| Customize the positive and negative number format on an integer column | Sandwich | Library Management | 5 | 10-13-2020 06:15 AM | 
| Integer Column | Quetico | Reading and Management | 0 | 07-10-2017 12:27 AM | 
| [SOLVED] Remove value accidentally added to custom integer column | macnab69 | Library Management | 11 | 07-07-2013 08:58 AM | 
| Method to set Date from user integer column | macnab69 | Library Management | 9 | 07-07-2013 08:52 AM |