I tried to create triger in geopackage so one layer would get updated by data from the other, both in the same geopackage. It worked perfectly within deskop Qgis but I get this error message in Qfield:
Trigger i added to layer 1:
CREATE TRIGGER "insert_trigger" AFTER INSERT ON "layer1" BEGIN UPDATE "layer1" SET "grid" = (select "col1" from "layer2" where st_intersects(new."geom","geom")) WHERE new."fid" == "fid"; END
I used qfield sync plugin to package project using "copy" layer configuration. When using "offline editing" configuration i get no errors, fields are updated on sync as expected.
Trigger should be ok since it works in desktop. Geopackage is "mini database" with triggers in it by default that do work in qfield so trigger support shouldnt be a problem. What else could be wrong.