I wish to create a virtual field that will automatically update when new attributes are added; the equation is for working out the 10 figure grid reference of a point shapefile in SpatiaLite:
floor(((round($x)/100000)-floor(round($x)/100000))*100000) || floor(((round($y)/100000)-floor(round($y)/100000))*100000)
However, some of the rows appear with
'NULL' values - when I tried making a new field without virtual field selected they all came with a value but then this would not update when new points were added.
How can I fix this?
Also, this SpatiaLite layer will be shared across many projects, therefore will the virtual field be updated within each project?