Skip to main content

Questions tagged [valuerelation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
49 views

QField: Vice-versa auto-fill of two fields using value relation

I am setting up geopackage in QGIS (LTR 3.28.15) to be used in the field with QField (3.2 - Congo) for mapping birds. My geopackage has the following layers: Brutvoegel: Point geometry for saving my ...
lzo_mrn97's user avatar
1 vote
1 answer
26 views

QGIS - Filter value relation by crossing 2 arrays

I'm working on a value-relation to filter a list based on the content of 2 fields. The value relation is based on the field "IDC". I want to compare the content of the field "IDC" ...
Giene's user avatar
  • 753
0 votes
1 answer
46 views

Value relation defaults to form's first value [duplicate]

I'm still learning QGis and I stumbled on an issue for which i can't find a solution in existing ressources online. I'm currently working on a layer on which I'm mapping fruit tree plantations. There ...
Masema's user avatar
  • 1
0 votes
0 answers
31 views

QGIS - Dropdown list for multi-select value-relation widget

Some fields in my project are currently configured using the value-relation widget. While everything is functioning correctly, my colleagues and I are used to working with the attribute table, row by ...
Giene's user avatar
  • 753
0 votes
0 answers
20 views

Is it possible to select multiple selections from different categories in a value relation drive down list?

I have used the following instructions to create a drive down list in the 'value relation' widget to allow a category to be selected in one attribute which filters the options in another. This has ...
Laura Bennett's user avatar
0 votes
0 answers
97 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
93 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
62 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
  • 753
3 votes
1 answer
108 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
77 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
3 votes
2 answers
158 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
  • 753
0 votes
1 answer
111 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
  • 464
3 votes
1 answer
250 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
  • 45
2 votes
1 answer
326 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,678
1 vote
1 answer
118 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
  • 45
1 vote
0 answers
52 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
  • 567
4 votes
1 answer
515 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
45 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
280 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
203 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