BlueConfetti

Guides / Flint Table Filter

FLINT TABLE FILTER · USE CASE

Review vendors and upcoming contract renewals in Confluence

A vendor directory in Confluence can still tell you what renews next, what it costs and who owns it, without scrolling across ten columns.

What you will end with: a compact directory layout with Vendor pinned, the 14 contracts renewing within 90 days of 9 November 2026 (two contracts already ending are left out), and annual values totaled by category: $350,400 in all, led by Infrastructure at $111,300.

Before you start

Annual value uses a currency symbol and thousands separators, such as $84,000. Flint Table Filter reads these as numbers, so the column supports numeric conditions, sorting and totals.

Sample directory: vendor-directory.csv · 24 rows, 10 columns, fictional data.

First 5 rows
VendorCategoryRegionOwnerAnnual valueRenewal dateStatusContract IDNotice (days)Notes
Northwind Cloud HostingInfrastructureNorth AmericaDana Kim$84,0002026-12-01ActiveC-2024-01860Usage-based overage above 10 TB
Bluebird PayrollHR and payrollEuropeGrace Liu$36,5002027-01-31ActiveC-2023-04490Covers two countries
Lumen AnalyticsSoftwareGlobalFelix Wagner$52,0002026-11-30Under reviewC-2025-00730Seat count under review
Harbor Office SuppliesFacilitiesNorth AmericaOmar Haddad$9,8002027-03-15ActiveC-2022-09030Quarterly invoicing
Atlas Security TrainingSecurityGlobalDana Kim$14,2002026-12-20ActiveC-2025-02145Annual course library
Show all 24 rows
VendorCategoryRegionOwnerAnnual valueRenewal dateStatusContract IDNotice (days)Notes
Northwind Cloud HostingInfrastructureNorth AmericaDana Kim$84,0002026-12-01ActiveC-2024-01860Usage-based overage above 10 TB
Bluebird PayrollHR and payrollEuropeGrace Liu$36,5002027-01-31ActiveC-2023-04490Covers two countries
Lumen AnalyticsSoftwareGlobalFelix Wagner$52,0002026-11-30Under reviewC-2025-00730Seat count under review
Harbor Office SuppliesFacilitiesNorth AmericaOmar Haddad$9,8002027-03-15ActiveC-2022-09030Quarterly invoicing
Atlas Security TrainingSecurityGlobalDana Kim$14,2002026-12-20ActiveC-2025-02145Annual course library
Cobalt Legal ServicesProfessional servicesEuropeGrace Liu$48,0002027-06-30ActiveC-2024-03390Retainer with hourly overflow
Fjord TranslationProfessional servicesEuropeFelix Wagner$12,7502026-12-05EndingC-2023-06130Moving to in-house review
Granite BackupInfrastructureGlobalOmar Haddad$27,3002027-01-10ActiveC-2024-00260Off-site copies in two regions
Kite Survey ToolsSoftwareNorth AmericaDana Kim$6,4002026-11-25ActiveC-2025-03030Renews monthly after the term
Meridian TravelTravelGlobalGrace Liu$18,9002027-04-01ActiveC-2024-05760Booking fees only
Nimbus Email DeliverySoftwareGlobalFelix Wagner$11,2002026-12-31ActiveC-2025-01230Volume tier 2
Orchid CateringFacilitiesEuropeOmar Haddad$7,6002026-11-20Under reviewC-2023-08014Berlin office events
Pioneer Laptop LeasingHardwareNorth AmericaDana Kim$96,0002027-02-28ActiveC-2024-07190120 devices
Quartz Design AssetsSoftwareGlobalGrace Liu$4,8002027-01-05ActiveC-2025-04030Team license
Redwood RecruitingProfessional servicesNorth AmericaFelix Wagner$22,0002026-12-15Under reviewC-2025-00330Placement fees capped
Summit Phone SystemsInfrastructureEuropeOmar Haddad$15,6002027-05-31ActiveC-2022-01560Includes desk phones
Tidewater Insurance BrokersProfessional servicesGlobalDana Kim$31,0002027-02-01ActiveC-2024-06660Aligned with the policy year
Umbra MonitoringSoftwareGlobalGrace Liu$19,4002026-12-10ActiveC-2025-01630Alert routing add-on
Vale Facilities CleaningFacilitiesNorth AmericaFelix Wagner$21,6002027-03-31ActiveC-2023-02930Austin office
Willow Benefits AdminHR and payrollNorth AmericaOmar Haddad$28,8002027-01-01ActiveC-2024-00990Open enrollment support
Xenon Print ServicesFacilitiesEuropeDana Kim$3,9002026-11-15EndingC-2022-07230Replaced by digital forms
Yarrow Data LabelingProfessional servicesGlobalGrace Liu$40,5002027-02-15ActiveC-2025-02545Project-based
Zephyr Video HostingSoftwareGlobalFelix Wagner$8,7002027-07-01ActiveC-2024-05030(blank)
Alder Hardware RepairHardwareEuropeOmar Haddad$5,2002026-12-28ActiveC-2023-03730Time and materials
  1. Edit a Confluence page and insert the Flint Table Filter macro.
  2. Inside the macro, add a native Confluence table whose first row is a header row with the column names from vendor-directory.csv, then enter or paste the data rows. If you paste from a spreadsheet, check that the result is an editable Confluence table rather than an image or an embedded file.
  3. Publish the page. Search, Filters, Sort, Columns, Summary, Export, Expand table and Reset view appear above the published table.

The worked examples use Monday 9 November 2026 as today. Relative date presets follow each reader’s device calendar, so on another day the same rule matches different rows. Where it matters, a fixed date range that reproduces the published result is included.

Step 1: Lay out the wide directory

Ten columns rarely fit in a page. Shape the view first so the renewal review is readable.

  1. Choose Columns and clear Contract ID and Notes. The button reads Columns (8/10). Hidden columns still take part in search and filters.
  2. Set Column to move to Renewal date and choose Move earlier until it follows Vendor.
  3. Under Column widths, set Width for column to Vendor and Column width to Standard (200 px).
  4. Open Saved views and presentation. Set Row density to Compact and, under Pin columns while scrolling horizontally, select Vendor. Vendor names stay in view while you scroll to Owner and Status.

Step 2: Find renewals in the next 90 days

  1. Choose Filters, then the Renewal date column. Set Condition to Relative date, Date preset to Next N days and Number of days to 90. On 9 November the window runs to 6 February 2027, including today.
  2. Choose Status, set Condition to Is not one of and exclude Ending. Fjord Translation and Xenon Print Services renew inside the window but are already being ended.
  3. Sort Renewal date ascending.
Expected result: 14 of 24 rows, Renewal date ascending
VendorCategoryOwnerAnnual valueRenewal dateStatusNotice (days)
Orchid CateringFacilitiesOmar Haddad$7,6002026-11-20Under review14
Kite Survey ToolsSoftwareDana Kim$6,4002026-11-25Active30
Lumen AnalyticsSoftwareFelix Wagner$52,0002026-11-30Under review30
Northwind Cloud HostingInfrastructureDana Kim$84,0002026-12-01Active60
Umbra MonitoringSoftwareGrace Liu$19,4002026-12-10Active30
Redwood RecruitingProfessional servicesFelix Wagner$22,0002026-12-15Under review30
Atlas Security TrainingSecurityDana Kim$14,2002026-12-20Active45
Alder Hardware RepairHardwareOmar Haddad$5,2002026-12-28Active30
Nimbus Email DeliverySoftwareFelix Wagner$11,2002026-12-31Active30
Willow Benefits AdminHR and payrollOmar Haddad$28,8002027-01-01Active90
Quartz Design AssetsSoftwareGrace Liu$4,8002027-01-05Active30
Granite BackupInfrastructureOmar Haddad$27,3002027-01-10Active60
Bluebird PayrollHR and payrollGrace Liu$36,5002027-01-31Active90
Tidewater Insurance BrokersProfessional servicesDana Kim$31,0002027-02-01Active60

Look at the notice column before the dates. Orchid Catering renews on 20 November with 14 days’ notice, so its notice date has already passed. The app cannot subtract a notice period from a renewal date; if you need to filter on notice deadlines, keep a Notice deadline date column in the source table.

Step 3: Compare values by category

  1. Choose Summary. Set Summarize column to Annual value.
  2. Set Group rows by to Category and Group order to Highest sum first.

The summary covers the 14 matching contracts: a sum of 350,400, from 4,800 to 84,000. Currency symbols are ignored in totals, so the summary shows plain numbers.

Grouped summary for the 14 renewals
GroupRowsSum of Annual value
Infrastructure2111,300
Software593,800
HR and payroll265,300
Professional services253,000
Security114,200
Facilities17,600
Hardware15,200

Remove both filter tags to compare the whole directory: 24 vendors and 626,150 in annual value, with Professional services highest at 154,250.

Step 4: Keep the review for next time

Save the layout and filters as a personal view named “Renewals 90 days” (see personal views). To make the filtered directory the page’s starting view for every reader, an author can enter these macro settings. Starting view preview reports 14 of 24 rows match.

Macro settings, shortened to the start of each label. One value per line where shown on separate lines.

Default filter column
Renewal date
Default filter condition
Date: next N days
Default filter value or lower bound
90
Default filter 2 column
Status
Default filter 2 condition
Text: does not equal (ignores case)
Default filter 2 value or lower bound
Ending
Default hidden columns
Contract ID
Notes
Default column order
Vendor
Renewal date
Default sort column
Renewal date
Default summary column
Annual value
Default group column
Category
Default group order
Highest sum first (requires a summary column)

Row density and pinned columns are reader presentation settings, not author defaults. To give readers the compact, pinned layout, publish it as a shared view they can apply.

What to know