# Single Checkbox Fields Should Not Have Null Values / Create a Boolean field

**URL:** <https://community.hubspot.com/t/single-checkbox-fields-should-not-have-null-values-create-a-boolean-field/118678>\
**Category:** HubSpot Ideas\
**Tags:** properties\
**Created:** [October 18, 2024, 3:11pm UTC](https://community.hubspot.com/t/single-checkbox-fields-should-not-have-null-values-create-a-boolean-field/118678 "2024-10-18T15:11:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kcross8787](https://avatars.discourse-cdn.com/v4/letter/k/43a26b/32.png) [@Kcross8787](https://community.hubspot.com/u/Kcross8787)\
**Post date:** [October 18, 2024, 3:11pm UTC](https://community.hubspot.com/t/single-checkbox-fields-should-not-have-null-values-create-a-boolean-field/118678/1 "2024-10-18T15:11:17Z")

</div>

**Background** :

Per the Hubspot knowledge base, Single Checkbox fields only store 2 options.

 ![9495c664-b1b5-43f1-a065-7e6ecf35f3a7.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/3X/1/d/1da0dd498c839ab15929801d63d6d1109dd422a7.jpeg)

This is not true however, as it can be set as a null value. This makes it no different than a dropdown select field but with limited options.

 ![2.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/3/c/3cd09b122b2fcfcc6cff44e50861863485b7de41.jpeg)

This issue is further proven by the fact that single checkbox field appears as a dropdown in the record UI as it can not be a checkbox if null values are available.

**Solution 1** :

I propose that hubspot set the Single Checkbox field as a boolen value of yes/no as defined in their knowledge base and create a merging tool upon release that allows system administrators to choose whether their existing single checkbox fields should change to the new “single checkbox field” field type or be merged into a dropdown select field.

**Solution 2** :

Alternatively, a new boolean field with options to make it appear as a radio button or checkbox would fix this issue.

**Solution 3** :

Add an option to the dropdown select and single checkbox fields where the field can be set to a default value and where it could be set to manditory.

**Who:** System Administrators

**Goal** : Have boolean yes/no fields

**Value:** Keeps data integretity by having the correct value options for fields. Creates uniformity of properties between UI records and forms.

**Examples:**

Microsoft Dynamics

![Dynamics.JPG](https://d2qpr2jzcazej7.cloudfront.net/optimized/3X/0/2/0208509f448de41d163835c690aa4efc61fe6da7_2_690x64.jpeg)

SAP B1 uses valid values which is the same as a dropdown select field with options to set a default value and to make the field manditory.