dateqgisqt-designerspatialitetime
For my attribute table I created a custom form in Qt Designer. The table has a date field and a time field.
In Qt Designer there are widgets for entering date and time but what data type is expected for the fields in my attribute table in QGIS?
The values always stays NULL in every case, when I choose date, datetime or text. Under Layer properties when I choose the edit widget "calendar" there is a calendar popup even when I use my custom form.
You can use the following code which connects the attributeValueChanged event to a function we can define which inserts the results of the $now expression. Highlight your layer and copy/paste the following into the Python Console:
layer = qgis.utils.iface.activeLayer()
def update():
field = layer.fieldNameIndex('mod')
e = QgsExpression( " $now " )
e.prepare( layer.pendingFields() )
for feat in layer.selectedFeatures():
feat[field] = e.evaluate( feat )
layer.updateFeature( feat )
layer.attributeValueChanged.connect(update)
Select the feature by clicking the row number (shown in the red box in the image) or from the map canvas and edit any attribute for that feature. The attribute in your mod field should update:
Note: I used a string field instead of date in order to get the time, otherwise the date field only records YYYY-MM-DD.
Best Answer
You need to edit the properties of yours fields Date and Time in QGIS.
If the properties are the same in your Qt form and in the fields parameters of your layer, the binding will be done automatically.