Skip to content

Customize the output of a LIST query to fit your needs and to display more than one additional meta data value

How to create custom outputs in queries

String concatenation

You can create custom outputs with something called string concatenation. Basically, that means that you are adding strings - texts - and meta data together to one output, just like numbers.
How you do this looks always the same, for example:
"Hello! This is file " + file.name
The part in "" is a text, where you can type anything you want. Then, with a +, you can add to this text a meta data value, so it gets "summed up" and displayed as one value.
You can add as many texts and variables as you want. See the examples below!

Basic

LIST "from " + author 
FROM #type/books 

With more elements

LIST "from " + author + " (Progress: " + pagesRead + "/" + totalPages + " pages)"
FROM #type/books 

Variants

Add formatting

LIST WITHOUT ID "$" + price + " / **" + file.name + "** / " + genre + " / _" + publisher + "_"
FROM "10 Example Data/games"

Usage in tables

TABLE "Call under: " + contacts.phone AS "Phone" 
from "10 Example Data/people"

Add HTML formatting

TABLE contacts.phone + "<br>" + contacts.mail AS "Contacts", "<span style='color:red'>" + relationship + "</span>" AS "Relationship"
from "10 Example Data/people"
WHERE relationship