🔷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:

Data collection: Pipe responses collected from Forms directly into Tiles and allow seamless sharing of responses between you and your colleagues.
Ease of sharing data: Easily share your data with a click of a button.
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.

Under “Select Tile”
Select the table you wish to connect
Under “Lookup conditions”
Select the column you wish to look up
Select the conditions
Enter the value you wish to look up, this can something you’ve typed or a variable from previous actions.

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.

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.

Select TIles > Find Single Row
Select your Tile and set up your conditions. Use AND to add multiple conditions. Example:

Test step
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

Select the table you wish to connect
Under “column” , select the column you wish to insert the data into
Under “value” , you may type the value or insert variable from previous actions
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.

Select the table you wish to connect under “Select Tile”
Under “Row ID”, select the row id you wish to manipulate, row id can be retrieve with “Find single row” action.
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.