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
QGIS form id_mobiliers field parameter
In QGIS, the furniture is correctly filtered according to the selected stop.
But in Lizmap, the drop down list remains empty
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