Cascading select QGIS forms (aka drill down select) | burdGIS

[@burdGIS]

Are you just getting started with #GIS and #QGIS? This online course will teach you the basics and then you can come back to the #burdGIS channel to improve your skills! :) www.udemy.com/course/an-introduction-to-gis-and-qgis/?referralCode=E39701D884A9EB2B5831

[@jamespotts5853]

Exactly what I was looking for! I've got plans for using this to pull through into automated carbon storage outputs for tree survey layers 😁

[@burdGIS]

Glad I could help!

[@Grimjow470]

Hi, thank you for this video, great work. I was wonderful if it’s possible to link those tables directly to the layer so I only need to send the gpkg layer to my coworker without the entire project. Thank you !

[@burdGIS]

Thanks fo rthe question and the for supporting the channel! :-D It;s possible to save your .qgs or .qgz project file to the gpkg too and to save default styles for every layer there as well. This means you could just fire across the gpkg and everything required would be there. If you're doing this with Mergin Maps I'm not sure how it would handle it as it needs a .qgs or .qgz in the project folder.

[@ManuelHernandez-sz3rz]

Hello, thanks for your excellent video. Just one question... it works for creation of new features but when you try to edit one the filter looks does not work and the drop down menu show all the options. Do you know how to fix it?

[@burdGIS]

Check my post on gis stack exchange on this topic.

[@Wildlifeimpulse]

Another great video. Thanks for sharing your knowledge.

[@burdGIS]

Cheers Sam!

[@messaoudirabah3878]

Very elegant work, thank you ...

[@burdGIS]

Thanks messaoudi. I hope you find it useful. Feel free to share your implementation

[@1raskumar]

Wow.great trick.thank you!

[@pabloantonioolivaresmanzan8589]

Hi, thanks for your video, nice job, it's amazin how QGIS is improving! I have a question: I am trying to do "the same thing" but with several conditions involved. For example, if I have field A with values 1 and 2, field B with values 1, 2, 3, 4, and field C with values 1, 2, 3, 4. If I choose in field A the value 1, in field C I should be able to select only 2, 3, 4. But if then in field B I choose 2, field C should be able to select only 3 and 4. I have many conditions and I need to implement them in the QGIS form so that when adding the information these conditions are respected. I hope I have been sufficiently clear

[@burdGIS]

Thanks Pablo. I got your email too. I've replied so f you can send me an example of the data I might be able to help you out (or some dummy data if you can't share actual data)

[@pabloantonioolivaresmanzan8589]

@@burdGIS thanks, I send you an example!

[@mattsully5949]

Great Video. I will be expanding on this in our National Park, Where can I find your examples to this you have used? Thanks very much.

[@burdGIS]

Thanks Matt. I haven't used Input in a live project yet apart from an ecological survey techniques course for Oxford University. I've used ODK in live projects in the past. It'd be great to hear more about how you're using it in the National Park!

[@StefanoVerugi]

Excellent job, very much appreciated. Thank you

[@burdGIS]

No problem Stefano. It was a fun one to do and I'm hoping QGISQuick can be developed to integrate this functionality soon. Cascading selects is so useful for field data collection. I've used it before with ODK but Input's handling of lines and polygons seems far better.

[@ernestocarreras7652]

Thanks for the excellent video! Just what I was looking for. Can you share your geopackage and CSV tables? Doing something similar with tree/plant inventories.

[@burdGIS]

Ernesto! Thanks for the watching. I think these gpkgs and csvs have been consigned to the digital bin in the sky. Check out the GIS SE page for the complete solution ;-) I'm working on a full tree solution with Mergin Maps at the moment which might be of interest too.

[@ernestocarreras7652]

@@burdGIS can you share the link here? I go to you site but I am not sure where exactly it’s located.

[@burdGIS]

Sure, here you go gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis

[@naeemahmed1078]

Very informative to the point!

[@burdGIS]

Glad it was helpful!

[@jd6393]

Hi, I can’t figure out the homework for this. I’ve followed through well, but can’t quite figure this last bit out on how to populate the JNCC code automatically. Can you help please??

[@burdGIS]

Hi JD, apologies for the late reply. Things are busy here. Feel free to email me if you're still stuck with this

[@aliciaavril1865]

Thanks for this tutorial but I still have a question, could it be possible do a multiple drill down ? As an example, if I take your fields "Code", "Class" and "Habitat" is it possible to program that "Code" filter "Class" and then filter "Habitat" ? Sorry if my question is a bit misexplained I'm French and I'm not sure of my English langage 😅

[@burdGIS]

Yes I think you could. It's the same principle, just cascaded onto other form entries. If you send me a sample of your data I can set one up.

[@StuartVenn-b2k]

Just stumbled across this video, really informative, exactly what I am trying to do, I am having real difficulty working out the homework answer as I am really new to Qgis, is theri a solution video or guidance please.

[@burdGIS]

Check the stack exchange post in the comments / description

[@JamesPotts-k2p]

This has been really helpful but I'm having some trouble applying it to my survey layers. I'm trying to pull a 'cascaded' value through a case statement of an expression in another field but the expression seems to be using the 'primary' value rather than the 'cascaded' one. I know this probably isn't the clearest explanation but hopefully it makes enough sense to provide a couple of a pointer or two :)

[@burdGIS]

Check this gis stackexchange post for the fix gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis

[@ThePaullosse]

This is really useful - and what I've been trying to work out how to do with exactly the same data. However I'm struggling with your 'homework' i.e. how to populate 'code' automatically. Any chance you could go through this?

[@burdGIS]

Thanks Paul. I'm releasing an update of this video soon as there's an error iin this one. I'll included homework answer ;-)

[@ThePaullosse]

@@burdGIS Thanks. I did finally manage to work it out.

[@joeljambalos4982]

@@ThePaullosse Hi! May I know how did you populate it automatically? I'm having a bit of trouble transferring it to other qgis projects since I have to populate it manually and place the delimited layers on the working layers again

[@jefwesb]

@@burdGIS Hi, is the video out? I am struggling with the homework too :/

[@jarekjakub]

@@ThePaullosse Hi, Can you please explaing how did you make it work?

[@nabazgharib]

Thanks for this great content, and I have a question, if I have a layer from PostgreSQL and add a dropdown to a column, would that dropdown be saved in the server? I mean if someone else opened that layer, would he/she see the dropdown list??

[@burdGIS]

Hi Nabaz, I think this would only persist if they were accessing the layer through the project you had saved with the dropdown. If they started a new project and added the layer the drop down would not exist.

[@vierminus]

Useful, thank you!

[@burdGIS]

Happy to help marius 😀

[@jonathanswart7928]

Thank you for this useful insight! I have followed the procedure you showed with a geopackage containing point file and two csv tables, that I am aiming to use for field data collection, and it works great when I populate the form, similar to what you show in your video. The problem I am having though is that when I look in the attribute table after I have saved the edits, each entry has defaulted to the first item in the list, no matter which other item I have selected. This means that for each group or class all the selections end up the same. Any ideas what is causing this?

[@burdGIS]

Hmm, difficult to troubleshoot without seeing the project. Are you able to send it over? Http://www.burdgis.com/contact

[@jonathanswart7928]

@@burdGIS Sure, will do.

[@burdGIS]

Upon further investigation it looks like cascading selects within QGIS aren't working in 3.12 or 3.13. I'll have a look to see if any issues have been raised in the git repos. Lutra consulting have confirmed that cascading selects won't work in input until the Quick library has been updated.

[@jonathanswart7928]

@@burdGIS Thank you for the clarity on this, I look forward to the bug fixes.

[@burdGIS]

Hi Jonathan, I made an error when testing your project. There's a full description of the set up and what I was doing wrong here: gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis I also learned a thing or two about sharing gpkgs :-)