I am trying to fill out a field based on information in a different field in the same layer using a CASE Statement in the Field Calculator. My table structure looks like this:
My goal looks like this:
The Expression I am using and does not work looks like this:
CASE WHEN "Species" LIKE 'Toad' THEN 'T' WHEN "Species" LIKE 'Fish' THEN 'F' WHEN "Species" LIKE 'Plant' THEN 'P' END
The result is that everything in
"SHORT" ends up being
"SPECIES" is a VALUE MAP widget type.
"SHORT" is a TEXT EDIT.
I am using QGIS 3.1