What's new in Retable - August 2023
Hello there! We are incredibly excited to present to you the enchanting highlights of the latest product updates from Retable for August! Get ready for a dose of wonderful news. We warmly welcome you to join us on an exciting journey to discover these fresh updates. Without further ado, let's delve into the details and embrace these fantastic enhancements together!
Retable's August 2023 updates include several features that our users have been requesting lately. We searched for new ways to make things more effective for you. Let's dive into what the Retable team has developed for you in August!
Table of Contents
- Rich Text Column Type
- Coloring Calendar View Based on the Select Column Type
- Webhooks
- Adjust the Width of the Row Detail Window
- Import File via URL
- Hide Organization Info for Members
- Automation Logs
- Customize Form Submit Button Text
- URL Column Protocol Configuration
- Alignment of the Percentage and Currency Icons
- Automation Parameters
- Search Function for API
Rich Text Column Type
Retable's rich text column type allows you to choose between multiple formatting types and empowers you to customize your texts.
The rich text column is text that is formatted with common formatting options, such as bold and italics, that are unavailable with plain text. Besides the common formatting options, you can create titles, bullet points, in-text links or bullet points with the rich text column type.
Let's explore how to use Retable's rich text column type! 👇🏻
- Create a new column
- Select the "Rich Text" column type
- Expand your cell and add your text
- Customize your rich-text using the formatting options in the rich text editor's toolbar
Coloring Calendar View Based on the Select Column Type
If your spreadsheet has a select column type, you can set a custom color for each option. With this improvement, you can display your select column records in calendar view with their select column type colors.
For example:
Let's say your select column type has 3 values "To Do, In Progress and Done"
And you used blue for To Do, yellow for In Progress and green for Done. You can display these records with the same colors in the calendar view.
Let's see how it works! 👇🏻
Webhooks
Webhooks is a mechanism used in web development to enable one system or application to send real-time data to another system or application whenever a certain event occurs. Retable's Webhooks allows you to be notified in real-time about changes in your projects, from new records to a column being updated in an existing row, to a row moving in or out of a view.
Webhooks are an action type that you can send an HTTP request in case automation is triggered.
To learn more about webhooks and how to use Retable's webhooks, visit this URL.
Adjust the Width of the Row Detail Window
You can now adjust the width of the row detail window displayed on the right side of your spreadsheets as you wish. The width you set is automatically saved and you can continue to use your row detail window with the same settings when you enter your spreadsheet again.
Let's see how it works! 👇🏻
Import File via URL
You can import .csv and .xlsx files into your projects directly with the URL. Thus, you can transfer any .xlsx or .csv file on the internet to Retable with just a URL without downloading them to your device.
Let's see how it works! 👇🏻
- Open your project
- Click the +Add New button in the table's area
- Select the "Import File URL" option
- Paste the URL of the file you want to import
That's all!
Hide Organization Info for Members
Organization admins can now hide organization info for other organization members. Thus, organization members cannot view the teams and other members in the organization, they can only view summary information about the organization.
Let's see how it works! 👇🏻
- Go to your account overview
- Click the "Organization" tab
- Click the "Settings"
- Click the "Hide organization info for members" box
- Save it
That's all!
Automation Logs
You can now monitor all logs of your automations from the logs section in the automations window.
Let's see how it works! 👇🏻
- Go to your project
- Click the automation button to open your automation window
- Click your existing automation
- Switch to the logs tab
That's all!
Customize Form Submit Button Text
You can now customize the text of the 'Submit' button in forms from your form customization screen.
Let's see how it works! 👇🏻
- Go to your form view
- Go to the bottom of your form
- Click on the edit icon inside the Submit button
- Change your text
- Press Enter
URL Column Protocol Configuration
Previously, the URL column was required to have https at the beginning of the URL. All URLs are clickable in the URL column, regardless of the protocol.
Alignment of the Percentage and Currency Icons
You can now adjust the position of your currency and percentage icons in the cell. Thus, your icons are displayed on the right or left according to your choice by default.
Let's see how it works! 👇🏻
- Go to your "Account Overview"
- Click "Settings" tab
- Change your currency and percent symbol placement
- Save it
That's all!
Automation Parameters
You can now use your column names as parameters in the Mail Subject and Mail Content fields of the send mail and send records actions in your automations. For this, it is sufficient to write your column names in curly brackets. Example; {columnname}
Let's see how it works! 👇🏻
- Go to your project
- Click the automation button
- Add a new automation
- Set your trigger and action
- Select the 'To' for your automation email
- Type one or multiple {columnname} to your 'Subject' and 'Content' section.
- Save it
That's all!
Search Function for API
Retable's API search function helps you to get specific information about a specific Retable
The response is going to be row data which is exactly the same as the term. Term parameter accepts input with space. Example requests and responses are given below.
https://api.retable.io/v1/public/retable/jKN7x47LLjHZcXAv/search?column_id=eLfL2NyPMPrviXbn&term=Red%Rose%
{
"data": {
"rows": [
{
"row_id": 4,
"created_at": "2023-08-03 10:08:01",
"updated_at": "2023-08-15 11:01:47",
"created_by": {
"id": "lQ2vhlFYlgrXkAGe",
"name": "John",
"surname": "Doe",
"email": "johndoe@retable.io"
},
"updated_by": {
"id": "lQ2vhlFYlgrXkAGe",
"name": "John",
"surname": "Doe",
"email": "johndoe@retable.io"
},
"columns": [
{
"column_id": "eLfL2NyPMPrviXbn",
"title": "Name",
"cell_value": "Red Rose"
}
]
},
{
"row_id": 5,
"created_at": "2023-08-03 16:08:01",
"updated_at": "2023-08-15 17:01:47",
"created_by": {
"id": "lQ2vhlFYlgrXkAGe",
"name": "John",
"surname": "Doe",
"email": "johndoe@retable.io"
},
"updated_by": {
"id": "lQ2vhlFYlgrXkAGe",
"name": "John",
"surname": "Doe",
"email": "johndoe@retable.io"
},
"columns": [
{
"column_id": "eLfL2NyPMPrviXbn",
"title": "Name",
"cell_value": "Red Rose"
}
]
}
]
}
}
Check our detailed API documentation to learn more!
If you're curious about the previous product updates check them out below! 👇🏻
more
Related Resources
Create your smart data management solution
Plan, track, and analyse with your ease. Transform your data with an all-in-one platform, collaborate with your teammates.
Try for Free