I am hoping to build a field in one of my QField forms that auto-increments a number associated with a particular value from a different field.
ie. if field "Sampler" has value "AA", a new field, "Station_ID" will auto-populate AA-001. If another point is taken by sampler "AA", the "Station_ID" will auto-increment to AA-002. If another point is taken by sampler "BB", the "Station_ID" will auto-populate to BB-001.
This will allow me to associated a unique station ID with each individual samplers collected data.
I'm working on QGIS 3.22.5
How can I complete this?