MySQLi insert record doesn't show a color picker field in my form

I'm trying to insert a record into my database using a form that contains a text field and a color picker field. The MySQLi Insert Record doesn't show my color field under Column Bindings tab. I'd prefer to have it take the hex color and only submit the last 6 characters (ignore the #), but if it had to submit all 7 characters that would be fine. But, right now it's not seeing the field at all. The page is attached. Thanks!

change:
type="color"

to:
type="text"


to do the binding, then change it back after you have done the binding.

Yup that worked! Any way to get it to drop the # at the beginning (So it would insert FFFFFF instead of #FFFFFF into the database?

add this code at line 1:

<?php
if(isset($_POST['nameofcolorpicker'])) $_POST['nameofcolorpicker'] = str_replace("#","",$_POST['nameofcolorpicker']);
?>

where nameofcolorpicker is the name of the color picker element

PERFECT! Thanks so much for the awesome and timely responses Jason. Have a great weekend!