How do I update the lists of select one fields directly through the database?

how do I update the lists of select one fields directly through the database? I use a php system in the same database as ODK collect. and I wanted that when changing some lists in the php system the same lists would be changed in odk forms. I use Postgresql

Welcome on the odk forum. Please take some time to Introduce yourself here!

Choices list are not stored in the database. So you will have to update medias on the aggregate server.

In the past I wanted to do such a thing I finally never investigate to automate it.
But I had in mind to generate media files with psql and after push a new form version and media files to aggregate using briefcase (in a cron task)
https://docs.getodk.org/briefcase-using/#push-to-aggregate

And maybe I will need it soon, since we use collect to inventory and follow some hydrolic valves on the field. If a new one is created, I will need it in my choice list to follow its waterlevel later.

Please let me us know if you achieve this.

1 Like