Bug report #14932

"NULL" text in null field should disappear as soon as a field gets the focus

Added by Patrick Dunford over 3 years ago. Updated 8 months ago.

Status:Open
Priority:Normal
Assignee:-
Category:Forms
Affected QGIS version:3.7(master) Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:22883

Description

When I enter a value into a form or table all the fields are set to Null to begin with. When I type into the field the displayed word NULL turns into the text NULL. This means I have to select and delete that text if I don't want NULL appearing in that field.

The display of the word NULL in an empty field should not be with actual text that just makes extra work when entering data into fields.

null_values.gif (3.86 MB) gcarrillo -, 2018-03-12 05:47 PM

null_values_2.gif (85.6 KB) gcarrillo -, 2019-04-29 10:21 PM

History

#1 Updated by Matthias Kuhn over 3 years ago

  • Status changed from Open to Feedback

In "Settings" -> "Options" -> "General" -> "Data Sources" the representation for NULL values can be changed (to e.g. an empty string).

Does that fix your issue?

#2 Updated by Harrissou Santanna over 3 years ago

  • Operating System deleted (Linux Mint)
  • OS version deleted (17.3)

It might do the trick but having NULL shown in a field can be handy.
Is that not possible to clear the field content (if NULL) once the user begins typing value (or clicks inside the cell) instead of appending the new text to 'NULL'? This will ease attribute filling imho.

#3 Updated by Giovanni Manghi almost 3 years ago

  • Resolution set to fixed/implemented
  • Category set to Attribute table
  • Status changed from Feedback to Closed

This seems to have been anyway addressed in QGIS 2.18. Here on 2.18.2 when I move with TAB or click on a cell that has "NULL" this automatically disappear, with no need to select and delete it before filling the cell with actual content.

#4 Updated by gcarrillo - about 2 years ago

  • Resolution deleted (fixed/implemented)
  • Subject changed from "NULL" text in null field should not be actual text to "NULL" text in null field should dissapear as soon as a field gets the focus
  • Description updated (diff)
  • Status changed from Closed to Reopened
  • Affected QGIS version changed from 2.14.2 to master

Reopened as this still happens in QGIS master (v2.99).

This happens in forms as well. You end up easily entering values like NULLmy value because of this issue.

#5 Updated by gcarrillo - about 2 years ago

  • Subject changed from "NULL" text in null field should dissapear as soon as a field gets the focus to "NULL" text in null field should disappear as soon as a field gets the focus

#6 Updated by Giovanni Manghi about 2 years ago

  • Status changed from Reopened to Feedback

gcarrillo - wrote:

Reopened as this still happens in QGIS master (v2.99).

This happens in forms as well. You end up easily entering values like NULLmy value because of this issue.

I cannot confirm on the latest master on osgeo4w.

#7 Updated by Giovanni Manghi almost 2 years ago

  • Status changed from Feedback to Closed
  • Resolution set to not reproducable

Closing for lack of feedback, please reopen if necessary.

#8 Updated by gcarrillo - almost 2 years ago

Still happening in master (ea0c7058a5ca0e4589f67a0b757c139837755246).

I attached a GIF to illustrate the issue.

#9 Updated by Giovanni Manghi 9 months ago

  • Resolution changed from not reproducable to end of life
  • Status changed from Reopened to Closed

#10 Updated by gcarrillo - 8 months ago

  • Resolution deleted (end of life)
  • File null_values_2.gif added
  • Category changed from Attribute table to Forms
  • Status changed from Closed to Reopened
  • Affected QGIS version changed from master to 3.7(master)

Just tested this in QGIS master 3.7 and it's still happening.
I attach a GIF showing the issue, which seems to be solved for string fields but not for numeric and date fields.

Reopening, since BSF Swissphoto will fund this fix.

#11 Updated by Giovanni Manghi 8 months ago

  • Status changed from Reopened to Open

Also available in: Atom PDF