Turn off "null" display in table

Ask the community
,
1

Two questions:

  1. I would like to know how to turn off the “null” that is displayed in a table connected to a collection where some of the fields may have a null value. Is this possible?
  2. Can the table be set to only show “yes” on boolean fields = true and a blank with the field is not true?

Here is a screenshot showing the problem:

970×191 27.2 KB

The 5th column “Pur.” shows “No”. The preference would be to only show “Yes” and have a blank value for the "No"s to help the true value stand out.

The actions value is a text field. When the data was imported, many of the action columns were blank for each of the records. Can the table be setup to only show text if there is text in the field?

2

Hi Kevin,
Sorry to jump into this conversation and change the topic a bit… But I can’t help to notice that you have the columns formatted in fixed widths. How the heck you got that done?..

And just to cooperate with your problem, I do suggest to initialize the fields before you insert them to avoid the NULL. It is always a good practice to initialize ALL OF THE FIELDS, do not wait or expect the database engine to do it for you, that way you will have full control of the data type inserted.

Hope this helps,
-Luigi

3

Luigi,
Thanks for your suggestion. Formatting the table columns is done with the table Layouts option. Scroll to the bottom of the dialog and you will see the option to manually set the column widths.

4

Hi Kevin,

What does the data in the “Actions” column look like in your collection? Typically tables simply display nothing when the corresponding field is blank.

5

Hi Kevin,
The 2 mentioned issues are as affect of the import to the collection. when you will create new records it will show as you described (no null for empty text, and no “No” in the Boolean field)

6

What do you mean by “Initialize the fields”

7

HI- I would also like to understand what to do to initialize. I am listing artists and their studio names. Some don’t have studio names and they show as null. Before I import the file, what do I need to do? Thanks!

8

Hi,
I need to know too. I imported the CSV and one of the columns do not have a value on multiple rows. I was expecting blank however it’s showing “null”.

What are my options?

9

Putting a space in an empty cells in the WIX database works as workaround to suppress the “null” , have not tried it yet if it works when you fill spaces in empty cells in a spreadsheet but expect it will. But would be nice if it can be fixed permanently

10

This worked for me.