Help + Forum

SQLite triggers in Mergin Maps mobile app

B
BarryinHelp + Forum
about 9 hours ago

Hi all, Does anyone know if sql triggers work when using the mergin maps mobile app?

I have a non-spatial table linked to a points layer with a form that the scout fills out and saves. They are both stored in the same geopackage. I am trying to use a trigger to update a text column in the points layer (with the date the point got saved) which I can then use to symbolize the point in the points layer as green (scouted this week). The trigger works if I update the attribute table in qgis manually but in the Mergin Maps app it does not update. Is this simply a limitation of Mergin Maps or am I potentially doing something wrong?

  1. Submitted
  2. Planned
  3. In Progress
  4. Completed
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...
Loading content, please wait...