How to remove blanks from a dropdown or listbox?

Question:

How to prevent blank entries or lines from displaying in a dropdown form element?

Answer:

Rather than using a table as your lookup, use a View that filters out the blank entries.

See how to create a view to filter records here. Use Comparison type "Is Not Blank" for the field that has the blanks.

Contact Support

Shortlink to this page

Help Topics

Welcome to Caspio Online Help
▶Introduction to Caspio Bridge
- What is the advantage of using a Web Database?
- Why Use DataPages?
- Caspio Bridge Environment
- ▶Caspio Bridge System Requirements
  - Known Issues
▶Videos
- ▶Getting Started Videos
- ▶Full Implementation Videos
  - Social Networking Site
  - Event Calendar System
▶Tables
- How do I Create a New Table?
- About Data Types
- Importing Data
- Managing Data
- Modifying Tables
- Field Re-ordering in Table Design
- Table Relationships
- Lookup Tables
- Exporting Data
- ▶Scheduled Import/Export Tasks
▶DataPages
- ▶Creating DataPages
- ▶Form Elements
- Editing DataPages
- ▶Managing DataPages
▶Deployment
- ▶Deploying DataPages
  - Embed DataPages in the Webpage Header
- ▶SEO Deployment
  - SEO Deployment Guidelines
  - Sitemap Generator for Caspio SEO Deployments
- Block Access to DataPages by IP Address
- ▶Iframe Deployment
- Deploy Caspio DataPages in WordPress
▶Automatic Emails
- Acknowledgement Emails
- ▶Notification Emails
  - Troubleshooting Notification Emails
- File Attachments in Automatic Emails
▶Authentication and Security
- ▶Web User Authentication
- ▶Record Level Security
- Adding Encryption to DataPages
- Blocking Spam with CAPTCHA
- DataPage Folders
▶Styles and Formatting
- About Styles
- Creating a Style
- ▶Layout Options
  - Change the Default Alignment of Field Labels
  - Change the Button Cell Alignment
- ▶Border Options
  - Add Rounded Borders to Fields
- ▶Font Options
  - Design Using Google Web Fonts
  - Creating Glossy Heading Text
- ▶Advanced Style Options
- Exporting and Importing Styles
- Set the Width of a DataPage
- ▶Web Form Columns and Configurations Options
  - Adding Multiple Column Formatting to DataPage Sections
  - Adding Multiple Elements on a Single Line
- Styling for Advanced Reporting
▶Files and Images
- Uploading Files and Images
- Adding a Lightbox to View Images
- Referencing an Image Stored in Caspio Bridge
- Creating Thumbnails with the Image Resizer
▶Localizations
- ▶Creating a Localization
  - Arabic, Hebrew and Other Right-to-Left Languages
- Formatting and Rendering
- Format Types
- International Dates in Calendar Fields
- Exporting and Importing Localizations
- Customize Localizations to Improve Usability
▶Views
- Create a View to Filter a Table
- Creating a View to Join Tables
- Modifying Views
- Importing Views
- Exporting Views
▶Parameters
- Enable Parameters
- Displaying Parameters
- Passing Parameters through Caspio Bridge
- Passing Parameters Using a Query String
- Receiving Parameters
- Resetting Parameters
- Parameters in Dropdowns, Listboxes and Radio Buttons
- Creating Dynamic Labels
- ▶Parameters In Action
▶Account Management
- Account Alerts
- ▶Internal Users and Groups
- Backing Up Your Applications
▶Common Customizations
- ▶DataPage Interface Additions
- Create an Approval Process for New Records
- Hide Fields in DataPages
- Generate Link Menus and Pop-up Windows
- Dynamically Change the Background of a Results Page Record
- Create a Floating Feedback Tab
- Limit the Number of Maximum Submissions
- Vote Up – Vote Down Individual Records
- Create an Auto-Scrolling Record Viewer
- Add a Time Limit to Submission Forms
▶Extensions
- ▶Social Media
- ▶iPhone, iPad and Smartphone Solutions
  - In Action: Using the iPhone Kit
  - How to Add QR Codes to Your App
- ▶Caspio Bridge Plug-In for MS Office
  - Microsoft Office Plug-In (Office 2010)
  - Microsoft Office Plug-In (Office 2003-2007)
- ▶Maps
- Adding a PrintWhatYouLike Link
- Convert Existing HTML Forms to Submit Data to Caspio Bridge
▶Release Notes
- Caspio Bridge 7.2
- Caspio Bridge 7.1.5
- ▶Caspio Bridge 7.1
  - 7.1.1 Patch
- ▶Caspio Bridge 7.0
  - 7.0.1 Patch
  - 7.0.2 Patch
- Caspio Bridge 6.9.5
- Caspio Bridge 6.9
- What’s New in Caspio Bridge 6.9
- ▶Caspio Bridge 6.8
  - 6.8 Interface Changes
- Caspio Bridge 6.7
- Caspio Bridge 6.6
- Caspio Bridge 6.5
- Caspio Bridge 6.0
▶Tech Tips
- Tech Tip: Embed Documents in DataPages
- Tech Tip: Integrate Google Analytics into Submission Form DataPages
- Tech Tip: Dynamically Add Options to Dropdowns and Listboxes
- Tech Tip: Leverage the Power of Social Media in Your Apps
- Tech Tip: Optimize Your Web Forms for Maximum Usability
- Tech Tip: Custom Filter Elements
- Tech Tip: Creating a Floating Navigation Menu
- Tech Tip: How to Validate a User Email Address
- Tech Tip: Creating Collapsible Sections
- Tech Tip: Create Tabbed Navigation for Multiple DataPages
- Tech Tip: Adding a Zoom Window to Images
- Tech Tip: 5 Ways to Customize the Look of Your DataPages
- Tech Tip: 5 Techniques to Create Web 2.0 Style Design
▶Instant Apps
- Classified Ads
- Business Directory
- Vacation Requests
- Resource Scheduling
▼FAQ
- ▶DataHub
  - What IP address range Caspio is using for DataHub?
- ▶Authentication
- ▶Time and Date
  - How to eliminate Time from a Date dropdown?
  - Why Date Fields from Excel Import Incorrectly?
- ▶Map-Mashup
- ▶Deployment
- ▼Web Forms
- ▶Reports DataPages
- ▶JavaScript Issues
  - Why JavaScript is not working with multiple DataPages deployed on one page?
- ▶Auto Emails
  - Why acknowledgement emails are not received?
  - How Many Addresses are Allowed in Notification Emails?
- ▶API and Microsoft Office Plugin
  - How can I get Web Services API and Plug-in for Microsoft Office?
- ▶Styles and Localization
  - How to use an image as form background?
- ▶Errors and Messages
- ▶Security, SSL and Encryption
  - Can I use Caspio SSL without a website SSL?
  - Why I see no SSL lock icon for my web page?
- ▶Parameters
Sitemap

Sitemap | Terms of Use | Privacy Statement

Suffusion theme by Sayontan Sinha

How to remove blanks from a dropdown or listbox?

Leave a Reply

Search

Help Topics

Stay In Touch