DATE:
AUTHOR:
The Fountain team
Platform

Coming Soon in Platform | shared reference datasets for automations

DATE:
AUTHOR: The Fountain team

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() and dataset.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.

Powered by LaunchNotes