Questions tagged [valuerelation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

Value Relation Widget not working in QField; QFIeld not displaying values

I am setting up many Value Relations Widgets in QGIS to have drop-down selections that can be used in QField for data collection. The Widget works perfectly in QGIS, but when synced to QFeildCloud and ...
Georgia Slim's user avatar
2 votes
2 answers
59 views

QGIS Value Relation Widget saves not the KEY COLUMN values but the VALUE COLUMN values in the attribute table

As far as I know, the "Value Relation Widget" is supposed to store the records from the field designated as KEY COLUMN in the attribute table, while the records from the field designated as ...
Chavdar Kirilov's user avatar
2 votes
1 answer
55 views

Getting the result automatically when only one match with Value relation in QGIS

I have a project that comprises three crucial layers: A SpatiaLite layer named 'HABITATS_POLY' A layer without geometry named 'CORRESPONDANCES' A database named "BD_CORINE" When a code is ...
Giene's user avatar
  • 669
3 votes
1 answer
100 views

Filter Value Relation dropdown list based on canvas visibility/zoom level in QGIS 3.28

I have a point feature (Pontos_de_monitoramento) and another non-spatial table (ficha_campo). I am adding new features to the non-spatial table (ficha_campo) and one of the fields to be filled in is ...
Denilson's user avatar
  • 695
0 votes
0 answers
47 views

Getting value from another table using Form-Qgis

I am creating this form. But here I need to create a filter expression using by a field that is in another table. When the field is in the same table , I usually use an expression like this: "...
Leonardo Rodriguez Silva's user avatar
2 votes
2 answers
112 views

QGIS load dynamic dropdown list from the content of another field, using separator

I would like to dynamically populate a dropdown list based on the content of another field. While one approach involves using relations and querying a database, it can be time-consuming. Currently, my ...
Giene's user avatar
  • 669
0 votes
1 answer
90 views

QGIS value relation dropdown filter by overlay_nearest

I have in QGIS 3.28.8 two point layers: source_p and target_p I want in source_p layer to create a dropdown to "TargetFID" field with Value Relation to target_p layer with only 3 nearest ...
Rii Pii's user avatar
  • 411
2 votes
1 answer
144 views

QGIS Value relation bracket removal

When using Value relation fields and multiple selection QGIS adds {} brackets in the table. When exporting the data to be used in reports and the like these brackets are not desirable. Is there a way ...
Niklas's user avatar
  • 35
2 votes
1 answer
206 views

QGIS form: relation value

I'm building a form to collect observation data of species. I have a layer called "observation" (point) with a field called "observer", it is the name of who sees the species. ...
katagena's user avatar
  • 1,624
1 vote
1 answer
90 views

QGIS - Value relation relative to other field

I've been trying to search for a solution for this to no avail. I have a value relation set up and want another field connected and relative to this. Example: Field 1 (Value 1) Field 2 (Value 2) Value ...
Niklas's user avatar
  • 35
1 vote
0 answers
51 views

QGIS 3.22.6 Add letters to check boxes instead of ticks when using value relation widget

I am using QGIS 3.22.6. I have added a species list to a polygon layer using the value relation widget. For each feature I am able to tick/select which species are present within the polygon. Rather ...
Laura Bennett's user avatar
2 votes
3 answers
1k views

Search for values in an attribute field based on a value relation in QGIS

I have a main postgresql table called "site" and another non geometrical local table called "values". I used the value relation widget on a text[] column named "choices" ...
tonyduky's user avatar
  • 547
4 votes
1 answer
452 views

QGIS filter a 'value relation' to show only intersecting features

I am trying to model the 'splicing' of cables (Table 1) together at a splice point (Table 2). Table 1 - "Cables" (linestring) Table 2 - "Nodes" (point) Table 3 - "splices&...
pmwill's user avatar
  • 67
0 votes
0 answers
43 views

Exporting layer with Values set by Cascading Value Relations tables are converted to strings

I have cascading Value Relations tables for data entry and they work fine. Except I need to "Export" the layer in order to keep the displayed values instead of the key values. Except when ...
Mikeoramma's user avatar
2 votes
1 answer
209 views

Value Relation in QGIS keeps defaulting to the first value in the list no matter what pull down value I select

Value Relation in QGIS keeps defaulting to the first value in the list no matter what pull down value I select! I have 3 value tables in PostGres and the relations and filters all work but when I ...
Mikeoramma's user avatar
3 votes
0 answers
187 views

Using FieldValueConverter() in PyQGIS to export table with displayed values option (ValueRelation), get ValueRelationCache error

I'm trying to export the content of various tables and use displayed values (stored in a ValueRelation) instead of the raw value. Following the comments, I realized I had to create the ...
Horizen's user avatar
  • 567