I have what is probably quite an easy problem, however I'm not able to figure it out by myself. I work as a field researcher doing bird inventory. I collect the data via QGIS on an android-tablet, which works fine. For the later evaluation and display of the collected data, I need certain columns in the produced shapefile, which I want to be (at least partly) filled out automatically.
There is one column with the bird common names, another on with the scientific names and a third one with abbreviations.
What I do in the field is fill out the common names by drop down menu (value map) from a csv table, which also contains the scientific names and abbreviations.
The csv looks like the following example:
Common name;Scientiffic name; Abbreviation
Golden Plower;Pluvialis apricaria;Glpl
Later I complete the other two columns at the office.
What I now would like to do is to get the columns, which shall contain the scientific names and abbreviations, to be filled automatically by the associated values from the mentioned csv.
Does anybody knows a way to do that? It would make work way much easier for me and save lots of time during the evaluation of the data...