Tiles

What is Tiles?

Tiles is a platform designed for storing and sharing flat data, providing a spreadsheet experience - think Excel without formulas. With Tiles, you can easily organise and store data, maintain state across pipe executions or use it as a lookup table. You can also generate simple sharing links or add other users to your tiles, making data sharing and collaboration simple.

How can Tiles help me?

Since Tiles is a feature under Plumber, it can integrate with other products such as FormSG, Telegram, and other products available on Plumber.

You can also use Tiles as a standalone feature without any automation set up. Are you looking to share data with external users outside of the department? Tiles can help with that too.

Other examples include:

1. Data collection: Pipe responses collected from Forms directly into Tiles and easily search and filter for responses.

2. Ease of sharing data: Easily share your data with a click of a button.

3. Supercharge your pipes: Store data across different executions or even pipes or use it as a reference table.

Actions

1. Create a row

2. Find single row

3. Find multiple rows

4. Update single row

Create a row

This allows you to add a row to the bottom of your specified Tile.

Field	Description	Required
Select Tile	Select the Tile you want to create a row in. You may select an existing Tile you have or Click + Create a new tile to create an empty one directly from the editor.	✔️
New row data	Enter the row data you want to insert. Column (Left input) Select the column name for the corresponding cell value. You can also type in a new column name to create a new column. Cell value (Right input) Input the value or variable you want to insert as cell value.	✔️

Check Step

Checking step will insert the test row into your Tile. Feel free to delete this row when you're done testing.

Find single row

This step allows you to retrieve a row from your Tile based on your lookup conditions

Field	Description	Required
Select Tile	Select the Tile you want to want search from.	✔️
Lookup conditions	Column (Left input) Select the column name you want to search from. Operator (Middle input) See Lookup operators for more info. Cell value (Right input) The value to compare to.	✔️
Return most recent row instead?	No (Returns oldest row) - If more than one row satisfies the conditions, this option will return the oldest row (highest up in the Tile). Yes (Returns most recent row) - This option will return the newest row (lowest down in the Tile).	Defaults to No

Lookup operators

Operator	Description	Good for
Equals to	Looks for the exact value (Case Sensitive)	All non-empty data
Greater than Greater than or equals to Less than Less than or equals to	> >= < <=	Numbers Dates in specific format (ISO string, YYYY-MM-DD) Not used for dates that cannot be sorted lexicographically such as 24 May 2025
Begins with	Looks values beginning with a certain prefix	Text
Contains	Looks values containing certain text	Text
Is empty	Looks for empty cells	Empty cells

Check Step

Checking step will look for a row matching your conditions as well as return the number of rows that satisfies them. To test this properly, you can add some test data into your Tile first.

Find multiple rows

This step is similar to Find single row except that it returns up to 500 rows. To be used with For each item action.

This means if you have 10,000 rows in your dataset and you're searching for something that should return 600 results, the system can only retrieve the first 500 results

Update single row

This action updates the data of the row based on a row ID. Usually used after the Find single row action.

Field	Description	Required
Select Tile	Select the Tile you want to update.	✔️
Row ID	Obtain the Row ID from a Find single row action. OR If it's a fixed row or just for testing purposes, you can right click on the row in your Tile to copy the Row ID like so:	✔️
Row data	Enter the row data you want to update. Columns not selected will be left unchanged. Column (Left input) Select the column name for the corresponding cell value. Operator (Middle input) Available options = : sets the value as-is + : increments the value by a specified value (only for numbers) - : decrements the value by a specified value (only for numbers) Cell value (Right input) Input the value or variable you want to update to.	✔️

Tiles collaboration

Adding collaborators

You can add whitelisted users as Editors or Viewers to your Tile.

1. Open the Tile you want to add collaborators to

2. Click the 'Share' button in the top-right corner

3. Enter the collaborator's email and select the desired role Example:

   
4. Click on 'Add collaborator' to confirm

Generate public access link

Generate a shareable link to let others view your data. Note that anyone with the link can access the data. For security, generating a new link will automatically deactivate the previous one

FAQ

What is the data classification for Tiles?

The data classification for data on the Plumber platform is Restricted and Sensitive (Normal).

Can I use Tiles without using any of the automation in Plumber?

Yes! As long as our product improves your life, you may use it however you like.

How many rows can be handled now?

Tiles (created after 1 Sep 2025) can safely handle up to 200k rows. Anything beyond that may result in degraded performance and we strongly advise against that. If you a use case that requires storing more than 200k rows, let us know!

Is there any mechanism to prevent editing collisions?

No, the latest write will override the row data.

Is the data stored encrypted?

Yes, as with all of OGP's databases, it’s encrypted at rest.

Where is the data stored?

The data and its backups are stored on the AWS Singapore region.

What are the backup options for this?

We do not have version controls or user-generated backups yet. However, in times of catastrophic failures, we have PITR (point in time recovery), which allows us to recover all lost data up to 35 days.