🔷Tiles

What is Tiles?

Tiles is a platform designed for storing and sharing flat data, providing a seamless experience similar to using a spreadsheet application like Excel. With Tiles, users can easily organize and store their data. The platform offers the convenience of sharing data through simple links, making collaboration and data sharing effortless. Whether it's for personal use or team collaboration, Tiles simplifies data storage and sharing, empowering users to efficiently manage their information.

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 allow seamless sharing of responses between you and your colleagues.

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

3. Task Management: Integrate Tiles to automatically create tasks or update task lists based on changes or updates in Tiles. This allows for seamless coordination between data management in Tiles and task execution, ensuring that relevant actions are promptly reflected in the task management system.

Feature walkthrough

Tiles creation

You may create a Tile table by accessing to the left side menu after logging into Plumber.gov.sg. After the creation of a table, feel free to return to your pipe to configure automation with it or use it without any automation.

Setting up automations with Tiles

There are a total of 3 actions under “Tiles”

Creating table in Tiles

After accessing https://www.plumber.gov.sg, click on “Tiles” on the left side of the page

Find single row

This action will allow you to find a single row and return based on the value you’ve insert.

1. Under “Select Tile”

2. Select the table you wish to connect

3. Under “Lookup conditions”

4. Select the column you wish to look up

5. Select the conditions

6. Enter the value you wish to look up, this can something you’ve typed or a variable from previous actions.

1. Under “Return most recent row instead?”, select the option you desire.

   1. “No (Returns oldest row)” will return the row that resides in the table the longest, it may not be the first row that has existed depending on your workflow.

   2. “Yes (Returns most recent row)” will return the latest row.

1. Test the pipe to see if your automation makes sense

Getting row count

This uses the Find single row action to get a row count based on certain conditions. This is similar to COUNTIF in excel.

1. Select TIles > Find Single Row

2. Select your Tile and set up your conditions. Use AND to add multiple conditions. Example:

1. Test step

2. You can use the ROWS FOUND variable for your subsequent actions

Create row

This allows you to create row with the desired column and value

1. Select the table you wish to connect

2. Under “column” , select the column you wish to insert the data into

3. Under “value” , you may type the value or insert variable from previous actions

4. Test action to see if the output makes sense

Update single row

This will allow you to update row, do note that you’ll require “Find single row” action before this action.

1. Select the table you wish to connect under “Select Tile”

2. Under “Row ID”, select the row id you wish to manipulate, row id can be retrieve with “Find single row” action.

3. Under “Row data”, select the column you need to edit and insert the value. Either key in the value or use variable retrieve from previous actions.

Adding collaborators to Tiles

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

FAQ

Q: What is the data classification for Tiles?

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

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

A: Yes! As long as our product improves your life, you may use it however you like (of course, it must be legal :P).

Q: How many rows can be handled now?

A: It's unlimited, but we can only guarantee performance for up to 10k rows for now.

Q: Is there any mechanism to prevent editing collisions?

A: No, the latest write will override the row data.

Q: Is the data stored encrypted?

A: Yes, like all AWS databases, it’s encrypted at rest.

Q: Where is the data stored?

A: The data is stored on the AWS Singapore region.

Q: What are the backup options for this?

A: We have PITR (point in time recovery), which allows us to recover all lost data up to 35 days.

Upcoming features for Tiles

For each (Rinse and repeat) - this will allow a feature to look through your entire table

Anything you have in mind? tell us!