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:
Data collection: Pipe responses collected from Forms directly into Tiles and easily search and filter for responses.
Ease of sharing data: Easily share your data with a click of a button.
Supercharge your pipes: Store data across different executions or even pipes or use it as a reference table.
Actions
Create a row
This allows you to add a row to the bottom of your specified Tile.
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
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
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.
Update single row
This action updates the data of the row based on a row ID. Usually used after the Find single row action.
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.
Open the Tile you want to add collaborators to
Click the 'Share' button in the top-right corner
Enter the collaborator's email and select the desired role Example:
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
Last updated
Was this helpful?