How do I make after insert trigger in SQLite persistent across laptop and mobile

I am trying to implement soundex in sqlite database when I connect mobile phone via USB.It affects the data that I pull from opendatakit/default/data/webDB but when check on the mobile data it is still the same.What should I do to effect this change in the mobile phone
I have used after insert trigger

I am a bit confused by your question. ODK-X is not designed for an external system to change it’s database. I would recommend using the APIs to the database to perform your changes as that should maintain state correctly.

1 Like