What's new in Retable - August 2023

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! 👇🏻

• July 2023
• June 2023
• May 2023
• April 2023
• March 2023
• February 2023
• January 2023
• December 2022
• November 2022
• October 2022
• September 2022
• August 2022
• June 2022
• Check our roadmap to explore upcoming product updates!