BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · HOW-TO

Fix number and date filtering when formats are ambiguous

09/11/2026 is 9 November in one office and 11 September in another. 1.250 is one and a quarter in one locale and twelve hundred fifty in another. Tell the table which you mean before you filter, sort or total.

What you will end with: the Received column read as day-first dates, so a 1 to 15 November range matches 4 samples, and the Weight column read with comma decimals, so its total is 2,271.25 g from 8 readable cells instead of 3.25 g from 2.

How the app detects types

In the sample, Received and Weight (g) are detected as Text, and Cost as Number.

Sample measurements: mixed-formats.csv · 10 rows, 5 columns, fictional data.

All rows
SampleReceivedWeight (g)CostNotes
S-012026-11-031,5$1,234.50ISO date
S-0209/11/202612,75$89.00Day first: 9 November
S-0328/10/20260,8$310.25Day first: 28 October
S-0411/12/20261.250$45.10Day first: 11 December
S-052026-11-142$1,005.00ISO date
S-06(blank)(blank)(blank)Not received
S-07TBCn/a$62.40Placeholder text
S-0831/11/20263,25$18.00Impossible date
S-0905/11/20261.000,5$740.00Day first: 5 November
S-102026-10-300,45$9.99ISO date

Dates: choose the format before filtering

  1. Choose Filters, then Received.
  2. Set Treat column as to Date and Date format in table to DD/MM/YYYY.
  3. Set Condition to Between, then enter 2026-11-01 and 2026-11-15 in From (inclusive) and To (inclusive). Values can be typed as YYYY-MM-DD or in the selected format.

The same range gives different answers depending on the format you choose:

Received Between 2026-11-01 and 2026-11-15
Date format in tableSamples between 1 and 15 November
YYYY-MM-DDS-01, S-05
DD/MM/YYYYS-01, S-02, S-05, S-09
MM/DD/YYYYS-01, S-04, S-05
How each Received value is read
SampleReceivedRead as DD/MM/YYYYRead as MM/DD/YYYY
S-012026-11-033 Nov 20263 Nov 2026
S-0209/11/20269 Nov 202611 Sep 2026
S-0328/10/202628 Oct 2026Not a date
S-0411/12/202611 Dec 202612 Nov 2026
S-052026-11-1414 Nov 202614 Nov 2026
S-06(blank)(blank)(blank)
S-07TBCNot a dateNot a date
S-0831/11/2026Not a dateNot a date
S-0905/11/20265 Nov 202611 May 2026
S-102026-10-3030 Oct 202630 Oct 2026

YYYY-MM-DD values read the same under every setting. Cells that are not valid dates, such as TBC or 31 November, never match a date condition.

Sorting

Sort Received ascending after setting DD/MM/YYYY: S-03, S-10, S-01, S-09, S-02, S-05, S-04, S-08, S-07, S-06. Valid dates come first in date order, then cells that are not dates, and blank cells stay at the bottom in either direction. Left as Text, the same sort compares characters: S-09, S-02, S-04, S-03, S-08, S-10, S-01, S-05, S-07, S-06, which puts 5 November before 28 October.

Numbers: choose dot or comma decimals

Choose Weight (g) in Filters, set Treat column as to Number, and choose Number format in table and values. The format applies to cells and to the values you type, to sorting and to numeric summaries.

How each Weight (g) value is read
Weight (g) cell1,234.56 (dot decimal)1.234,56 (comma decimal)
1,5Unreadable1.5
12,75Unreadable12.75
0,8Unreadable0.8
1.2501.251250
222
(blank)(blank)(blank)
n/aUnreadableUnreadable
3,25Unreadable3.25
1.000,5Unreadable1000.5
0,45Unreadable0.45

With comma decimals, Weight At least 1 matches 6 samples (S-01, S-02, S-04, S-05, S-08, S-09); with dot decimals only S-04 and S-05 match. A tag above the table, Comma decimals: “Weight (g)”, reminds readers which format is active. Type filter values in the same format: with comma decimals, enter 1,5, not 1.5.

Totals

Choose Summary, set Summarize column to Weight (g) and Summary number format to 1.234,56 (comma decimal):

Weight (g) summary for all 10 rows
Summary number formatSumCells counted
1.234,56 (comma decimal)2,271.258 numeric · 1 blank · 1 unreadable
1,234.56 (dot decimal)3.252 numeric · 1 blank · 7 unreadable

Totals display in your browser’s number format. Blank and unreadable cells are excluded, and the counts show how many were left out, so an unexpectedly small total is easy to spot. The Cost column, detected as Number, totals 3,514.24 from 9 cells.

Relative dates use the device calendar

Relative presets compare against a reference date shown under the condition, for example Reference date: 2026-11-09 (your device’s local calendar). On that date:

Relative date presets on Monday 9 November 2026
PresetMatches dates fromTo
Today2026-11-092026-11-09
Yesterday2026-11-082026-11-08
Tomorrow2026-11-102026-11-10
Last 7 days2026-11-032026-11-09
Next 7 days2026-11-092026-11-15
This week2026-11-092026-11-15
This month2026-11-012026-11-30

Last and next day windows include today, weeks run Monday through Sunday, and Last N days and Next N days accept 1 to 3650. Readers in different time zones can be on different calendar days.

Messages you may see

Invalid values appear under Check your filter values, and that condition matches no rows until corrected:

Publish the right formats

An author can store number formats for every reader in Default numeric columns, one exact header per line, such as Weight (g) = comma. Date formats are chosen per default filter in its date format in table and values setting. The most reliable fix is in the source: use native date chips or YYYY-MM-DD, and one decimal style per column.