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:
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.
23 December 2014
28 December 2014
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.
28 December 2014
Oh I see, it was made with Ignition 7.7.2.
10 December 2015
When I install the palatte the new features (calendar and check box) are not there?
Other than that - Great job.
9 February 2017
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.