We've seen how to create a drop-down field, both by using the Studio and manually, but you're probably wondering how to create other field types. Some (such as radio buttons) follow the same route as drop downs. Other types (such as dates) are simpler to create, since the process is the same except that you don't have to start by creating the drop-down box itself. So, if you want to create a date box (for instance) then go straight to the custom field editor:
From there on the process is exactly the same as creating the dropdown that we've already dealt with.
And if you're going to do this manually (using SQL) then you just need to know the data type—obviously in this case it would be date, so use an SQL insert query to do that:
insert into fields_meta_data
( id,
name,
label,
help,
custom_module,
data_type,
date_modified,
mass_update
)
values
( 'Opportunitiessurv_start_c',
'surv_start_c',
...