First, search the help docs and this forum. Maybe your question has been answered! The debugging steps can help, too. Still stuck? Delete this line and proceed.
What I’m trying to do
I want to display a checkbox property in the result of my dataview query and have it appear as a check or an empty checkbox rather than “true” or “false.”
I suggest starting with formatting the field in the TABLE clause and see if that meets your needs:
```dataview
TABLE
choice(Field1, "☑", "☐") as Field1,
choice(Field2, "☑", "☐") as Field2
WHERE file.name = this.file.name
```
You could also use FLATTEN to create new fields and then refer to them in the TABLE clause. It’s more complicated, but also more flexible:
```dataview
TABLE
Field1Checkbox as Field1,
Field2Checkbox as Field2
FLATTEN choice(Field1, "☑", "☐") as Field1Checkbox
FLATTEN choice(Field2, "☑", "☐") as Field2Checkbox
WHERE file.name = this.file.name
```
Please note that the WHERE clauses in my queries are just to narrow the results; they aren’t needed for formatting the fields.
Here’s what both approaches look like in my vault: