Skip to content

Changing a property type

You can change a property from one type to another. Values that convert are converted. Values that do not convert are cleared, and one Undo brings every one of them back.

Example: in Books, “Pages” is a Text property with values like 352 and about 400. You change it to a Number. Before you confirm, the dialog says that 1 value will be cleared. 352 becomes the number 352. about 400 is not a number, so it is cleared. Undo, and “Pages” is Text again with both values.

The rules

Rule What it means
One closed table The app has one fixed table of which type converts to which (below). It does not guess.
You see it first The dialog says how many values will be cleared before you confirm.
One Undo The new type and every converted or cleared value are one change. One Undo takes it all back.
Ids stay The property keeps its id, so formulas, views and cards that use it keep working.
The file follows The entry files are rewritten in the new form.

What converts

From To What happens
Number, Stopwatch, Scaler each other The number is kept.
Text Number A text that reads as a number converts: 352 is 352, 3,5 is 3.5. Other texts are cleared.
Number, Stopwatch, Scaler Text The number as text: 42 is 42.
Text Checkbox yes, true, 1, y, on, x, done and taip are ticked. no, false, 0, n, off and ne are not ticked. Other texts are cleared.
Checkbox Text true or false.
Number Checkbox 0 is not ticked. Any other number is ticked.
Checkbox Number Ticked is 1, not ticked is 0.
Text Date A text that reads as a date or a time converts. Other texts are cleared.
Date Text The date as text: 2026-11-08, or the date and time.
Text JSON JSON text becomes JSON. Other text is kept as a JSON string.
JSON Text The JSON as text.
Tags Text The entry’s tag names, in order, with commas: Run, Easy.
Tags Number, Checkbox, Date The tag names, as a text, then the Text row above.
Text, Number, Checkbox, Date, Tags Block page or Dashboard The value as text becomes the first block.
Block page Text, Number, Checkbox, Date The Block page’s text, then the Text row above.
Relation, Media, Children another type Cleared.
Any other pair Cleared.

Empty texts are cleared without a count: there is nothing to keep.

Some settings change the values too, inside one type:

You change What happens
Tags: many → one Each entry keeps its first tag. The others are cleared.
Media: many → one Each entry keeps its first file.
Date: with a time → without a time Each value keeps its day.

Block page and Dashboard

A Block page and a Dashboard both hold blocks, so a change between them keeps every block.

You change What happens
Block page → Dashboard Each block becomes a full-width tile, in the same order. A Columns block becomes tiles side by side.
Dashboard → Block page The tiles become blocks, in reading order: left to right, then top to bottom. Tiles side by side become a Columns block.

Example: the “Today” Dashboard of a diary day has a steps chart and a sleep chart side by side. Change it to a Block page, and it holds one Columns block, with the steps chart on the left and the sleep chart on the right.