Hello,
I have a table in Wix that is attached to a database. The database has a list of URLs that attach to external sites. Some of the entries do not have a website to link to. I need them to show up blank instead of with the word “null” in its place. See the attached example. How can I do this?
Are the dataset fields blank already as you might just simply need to put something in them like a simple dash ‘-’ for the table to not register the field as null (empty) and therefore thinking that it should not be and displaying null instead as there was no value for that field.
Hello,
While I thought this would work too, Corvid seems to add a http://- instead of just a “-”. Is there any other work around?
Yes there is, so for example I just have a blank dataset with the default title field and I add a url field to it.
If you right click on the url field in your dataset, you should get the option to open in form.
Choose the open in form option and add the title of your website and then website url underneath and save it.
So you can add ‘-’ in the website name if you wanted to and simply leave the url field blank.
Now your dataset will add the name of the website to the title field and the url will be saved into the url field.
If you get the exclamation mark on the blank field, then don’t choose ‘Convert’, simply choose ‘Clear’ or delete the ‘http://-’ if it gets added.
The dataset should then save itself, if not you can simply save yourself from top right of the editor.
Then when you add a table and the dataset to your needed page, simply connect the dataset and add the url field to the table.
It will add both the website field, which will be the website name and in my case the default title field, and the actual website url field.
So, simply go to manage table and delete the website field for the website title which will just leave you with the website url field itself.
Do all this and it should only show you a blank cell like below.
Or, seeing as you already have your dataset all setup, simply just try to clear content on the empty fields that have the exclamation mark on them, without having to go through the whole procedure above.
Just remember to save it and sync it to your live version.
