Nick Mudge Ignition Software Consulting & Development

After releasing database-backed form components for Ignition, I received several requests for a Form Popup Calendar component for handling dates and times. This has been implemented and is now available.

The FormComponentsPalette.proj download now includes a new Form Popup Calendar component and a Form Check Box component. The Form Example has been updated to use these as well. (Upgrade your Ignition to Ignition 7.7.2 or higher for the import to work.)

Here's what these two new components look like:

Form Popup Calendar

The Form Popup Calendar component is associated with a Datetime column in a database table. When a date and time has not been selected or when the date property is None/null then a label is displayed that says, "Select Datetime". This text can be changed to whatever you like if you want to change it.

A Form Check Box component is associated with a BIT column in a database table. Any number of Form Check Box components can be used on a form.

The two new form components work like other components in the Form Components Palette.

All the form components have been tested on MySQL and SQL Server.

Check out the original blog post about form components to learn more. Don't forget to watch the videos.

Comments

Juan Luis Espinosa
www.grupoestevez.es/
23 December 2014

Thanks Nick

Great job

Merry Christmas
Ranjit
28 December 2014

Nick,

Appreciate your Blog, videos and components.

I have Ignition 7.7.1 and when I tried import your component I got an error "Can not import a project from a newer version of Ignition".

Happy New Year.

Regards,
Ranjit Singh
Nick Mudge
28 December 2014

Oh I see, it was made with Ignition 7.7.2.
Brett Yeomans
10 December 2015

When I install the palatte the new features (calendar and check box) are not there?
Other than that - Great job.
Michael Costello
9 February 2017

Nick,

Great Content. I am having a couple issues and hoped you might have some advice.

First issue is with the dropdown list component. Is there a way to get it to work where your dropdown dataset is using both the label and value columns? IE screen displays the descriptive label info but the value field is updated in the database.


Second, My mysql DB has a date field of type "datetime2" that looks like 2001-08-01 00:00:00 when looking at my table component. When I bring in the form popup calendar and set the custom "Column" property I get the following error at runtime.

Traceback (most recent call last):

File "<event:propertyChange>", line 6, in <module>

File "<module:project.pa.forms>", line 165, in updateFormInputs

File "<module:project.pa.forms>", line 136, in setValue

TypeError: can't convert u'2001-08-01 00:00:00' to java.util.Date

I would appreciate any thoughts.

Thanks,

Michael


Name: (required)
Email: (required)
Website:
What has four legs, rhymes with bat and says, "Meow?" (One word answer.)
Spam Filter: