Default value with layer reference NOT on update

Ask the Community
1

Hi,

I would like to be able to auto increment a field (in this case in 15 second steps) when a new line is added (but not updated) that sits in table that is related to a linear feature. It must start from 0 for each new linear feature.

I have tried a number of options but it seems to be a requirement to check the “Apply default value on update” if i am refering to fields but this seems to be a necessity if i am trying to use the group_by/filter parameters, and i only want it to update the when it is created, and not if another value has changed on an update.

In addition I have heard that it is not possible to use the group_by parameter in qfield but i havent got it working yet. Example below:

Does anyone know an alternative?

Thanks

J

image
image1218×760 51.5 KB

Imported from GitHub discussion by @jpnunn on 2022-11-15T14:08:46Z

2

I should add - i have heard it is possible to setup GPKG fields (which i am using) to auto increment but i don’t know where to start here.

Imported from GitHub comment by @jpnunn on 2022-11-15T14:15:11Z