# 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](#create-a-row) 2. [Find single row](#find-single-row) 3. [Find multiple rows](#find-single-row) 4. [Update single row](#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

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](#find-single-row "mention") except that it returns up to 500 rows. To be used with [for-each-item](https://guide.plumber.gov.sg/user-guides/actions/for-each-item "mention") 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](#find-single-row "mention") 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 ### Setting a Password for Your Tile

You can set password to your public access tiles. * Under General Access, tick the **Password required** checkbox. A password input field will appear. * Enter your password — it must be **at least 8 characters** long. * Click the **tick button (✔)** to the right of the password field to save your password. Your tile link is now password-protected. **Resetting the Password** To reset or change the password, click the **cross button (✕)** to the right of the password field. This clears the current password so you can enter a new 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.

Is there a limit to the number of collaborators?

No, there is no limit to the number of collaborators. However, keep in mind that having many collaborators can make it more challenging to manage permissions, coordinate changes, and troubleshoot issues when they arise