I create a trigger (SQL) in the QGIS data GPKG and when packaging for QField, it generates the data.gpkg. This contains the layers that I have configured as offline editing and other log tables. However, it doesn't contain the trigger that I configured in QGIS.
In my case, what the trigger does is: when you cut a geometry, it assigns 1 to the partition value of the original geom and to the rest it adds 1.
I manually insert the trigger in data.gpkg and when I cut a geometry from the project, the changes in attributes modified by the trigger are not recorded in the log table (although they can be seen in QField) and are therefore lost when synchronizing the project.
It would be nice if the export to QField supported the packaging of triggers.
·