πŸ”·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

  1. Test step

Create row
  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.

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

Collaboration - this will allow whitelisted users to edit your table

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

Anything you have in mind? tell us!

Last updated