- DATE:
- AUTHOR:
- The Fountain team
Coming Soon in Platform | shared reference datasets for automations
One source of truth for the mapping tables your automations rely on.
Datasets are shared reference tables that automations can query, filter against, and use to translate values. Replace the spreadsheets, lookup tables, and external translation tables you maintain on the side with a CSV-backed dataset that lives inside Fountain and is editable from settings.
What’s new
Store CSV datasets inline in Fountain settings, up to 50,000 rows per dataset with no column limit.
Reference datasets in automation filters (for example, “applicant is in the location allowlist”).
Translate values inside pipelines: a new VLOOKUP-style mode on the “Update worker attribute” action looks up an attribute against a dataset.
Query datasets from Custom Scripts with
dataset.lookup()anddataset.contains(), including across multiple datasets in a single script.A Dataset Search API for programmatic queries from Cue or external tools.
Why it matters
The lookup tables that drive your automations — HRIS code translations, allow lists, location mappings — usually live outside Fountain in third-party tools or spreadsheets. That means edits go through a different team and breakages are hard to trace. Bringing those tables into Fountain centralizes the data, shortens the edit loop, and removes a category of integration brittleness.
What to expect
Up to 50,000 rows per dataset; CSV upload only for the largest tables.
At this time, edits happen inline or via a fresh upload that replaces the dataset.
Datasets surface in automation filters, the "Update worker attribute" action (Dataset / VLOOKUP mode), Custom Scripts, and Data Pipeline transforms.
Availability
Release type: New feature
Generally available now to all customers.
Help Documentation
Datasets — Covers importing datasets via CSV, viewing and searching dataset contents, inline row editing, deleting datasets, and referencing datasets in custom scripts. Includes a placeholder for the upcoming automation filter and action integration.