How to create a drill down form with Lizmap?

Hi all,

I ask the question on github (How to create a drill down form with Lizmap · Issue #4898 · 3liz/lizmap-web-client · GitHub) but didn’t get any ewnser yet. Github might probably not the good place.

I would like to create in Lizmap a dropdown list that the content depends on a value in the form. The use case is described below :

For a lizmap project I need to report damages made to bus stop furniture (example : the bin has been destroyed). To create a new damage report, users have to click on a bus station and then select one of the furniture linked to this bus station.

To only link the furniture related to this bus station, I must create a linked drop-down lists.

So I’ve three tables :

  • bus_station : geolocalized postgis table point
  • furniture : PostgreSQL type with an FK link to bus_station
  • damages : PostgreSQL type with an FK link to furniture and bus_station (a damage is linked to a a furniture and to a bus station).

I’ve configured the relationships in QGIS and set up the QGIS form id_arrets_bus and id_mobiliers fields.

QGIS form id_arrets_bus id_mobiliers parameter

image

QGIS form id_mobiliers field parameter
image

In QGIS, the furniture is correctly filtered according to the selected stop.
image

But in Lizmap, the drop down list remains empty
image

The drop down list works in QGIS and Mergin Maps but not in Lizmap. I have read that Lizmap is able to use QGIS Expression and filters but it doesn’t seems to work in my case.

Have you ever had to create nested drop-down lists? If so, could you please explain me how to do it ?

Thanks

Moving this to Lizmap - OSGeo Discourse

In future you can ask there, but need to join the Lizmap - OSGeo Discourse group before you can.

Thanks @robe. I’ve subscribe to the Lizmap channel !