Discover the latest updates for Retable, designed to elevate your experience to new heights! 🚀 Thanks to your insightful feedback and our innovative spirit, we've introduced some amazing new features. 🤩 Let's dive in and explore them together! 🌟
Table of contents
- Reminder function
- Duration column type
- Aligning cell content to the left/right and center
- Table sync
- New filters for calendar column
- Friendly date format
- URL creation with formula column
- Real-time update for Insert/Update/Delete row actions via API
Reminder function
We are super excited to introduce Retable's latest feature: the Reminder Function! This powerful feature allows you to set reminders for each row individually, ensuring you never miss an important date or task.
With the Reminder Function, you can:
- Set custom reminders: Choose specific dates for each reminder to keep track of deadlines, meetings, and events.
- Personalize reminder messages: Craft custom reminder messages for each row, tailoring notifications to your needs.
- Easy management: Effortlessly manage reminders directly within your tables, enhancing your workflow and productivity.
You can stay organized and on top of your tasks with Retable's new Reminder Function.
![retable reminder function](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665dfabc97d9be84d6b6a1cc_Reminder%20-%20GIF.gif)
Let's see how it works!
- Right-click on any row you want to set a reminder and select "Add reminder" or click on the reminder icon located in the row number column to the left of your first column.
- Select the collaborator to which you want your reminder e-mail to be sent from the "Send" field in the pop-up window that opens, or if there is a collaborator column in your table, select it. If you select the collaborator column, the reminder will automatically be sent to whichever teammate is assigned a task in the collaborator column of the relevant row.
- Select the time you want your reminder to send from the "A reminder" field. For example; today, 1 day before, 7 days before etc.
- Select the date you want your reminder to be sent from the "On" field. For example; If you selected 1 day before in the "A reminder" field and select 31st May 2024 in the "On" field, your reminder will run on 30th May 2024. Also, if you have a calendar column in your table, you can automatically select the date in the "On" field directly from it. Thus, your reminder will run according to the date selected in the calendar column of the relevant row.
- If you activate the "Use custom reminder message" checkbox, you can add a custom message for your reminder.
- After completing all the steps, click the "Add new reminder" button. And that's all, your reminder is ready!
You can only add a maximum of 3 reminders for each row. You can also freely delete or edit your reminders after adding them.
Duration column type
Retable's duration column type enhances your ability to manage and track time easily. Our duration column type is a specialized number field that automatically formats numbers as durations. Whether you're tracking project timelines, logging hours, or managing deadlines, this feature ensures your data is clear and easy to interpret.
![retable duration column type](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665093a1fce3e5f65a78d43f_Duration%20-%20GIF.gif)
Let's see how it works!
- Add a new column and select the "duration" type
- Select your duration format from the "Format" field on the Customize column screen. For example; If you choose the hh.mm format, the numbers you add to this column will be displayed in hour and minute format. (For ex; 11.23)
- Save your column
- Type any numbers in your column and you'll see that Retable will automatically convert it to duration directly as in the format you choose.
Aligning cell content to the left/right and center
Retable's new alignment feature helps you align the contents of some of your column types left, right and center.
Supported column types for this alignment are as follows;
- Text
- Number
- Calendar
- Phone number
- Percent
- Currency
- Duration
- Created time
- Last modified time
- Formula
- Rollup
- Autonumber
- Unique identifier
![aligning cell content](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665dfc1c3db9db5ec462c857_Screenshot%202024-05-24%20at%2013.19.03.png)
Let's see how it works;
- Click the "Format" button from your toolbar
- Navigate to the "Column style"
- In this area, all columns in your table will be listed, and you will see the alignment icon to which you can apply alignment. You can easily align your column left, right and center by clicking on the alignment icon.
Table sync
This feature allows tables within the same workspace, whether in different projects or in the same project, to be synchronized with each other.
To sync tables:
![how to use retable table sync](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6639d66aedc775c657c0cc0a_synctable.png)
- In the "tables" section of your project, click on "add new."
- From the menu that opens, select "Synced table."
![how to use retable table sync](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6639d73946d34ac483e40960_tablesync2.png)
- Choose the project where the table you want to sync is located.
- Select the table you want to sync.
- Select the view you want to sync.
![how to use retable table sync](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6639d7952fab571384166752_tablesync3.png)
- After clicking the "Next" button, you can choose either "All columns in the source (Include columns to be added in the future)" or "Specific columns in the source," depending on your needs.
If you choose "all columns in the source (Include columns to be added in the future)," all existing columns in the table you want to sync, as well as any columns you add later, will automatically be synchronized.
If you choose "Specific columns in the source," a list of columns from the table you want to sync will appear, and you can select the columns you wish to sync.
Remember, in both options, every new data added to the synced columns will also be synchronized to your current table.
![how to use retable table sync](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/6639eb267f4f87f60878c45a_synced%20tables%204.png)
- After making your choice, click the "Save" button.
The table you add as a synced table will be created as a new table within your project and will reflect any changes made to the source table.
You cannot make data changes to a table added to your project as a synced table; you can only modify its data from the source table. Essentially, this feature works like a lookup and shows you the data from your reference synced table.
In summary, a synced table will copy its contents from another table. When the original table data changes, it will stay up to date in the synced table.
New filters for calendar column
With this new feature in Retable, you can apply more advanced filters to your calendar columns. Here are the new filtering options added for calendar columns:
![new filters for calendar column](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665dfef9078cd79fd0127930_filterforcalendar.png)
- Yesterday: Filters records entered as yesterday in the calendar column, based on the current date.
- Today: Filters records entered as today in the calendar column, based on the current date.
- Tomorrow: Filters records entered as tomorrow in the calendar column, based on the current date.
- Last week: Filters records entered as last week in the calendar column, based on the current date.
- This week: Filters records entered as this week in the calendar column, based on the current date.
- Next week: Filters records entered as next week in the calendar column, based on the current date.
- Last month: Filters records entered as last month in the calendar column, based on the current date.
- This month: Filters records entered as this month in the calendar column, based on the current date.
- Next month: Filters records entered as next month in the calendar column, based on the current date.
- This quarter: Filters records entered as this quarter in the calendar column, based on the current date.
Friendly date format
We have added the "Friendly date" format as another date format option to our calendar column. The friendly date format displays dates as "May 06, 2024."
![friendly date format](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665dff28c09fdbaf9885b647_friendly%20date%20format.png)
You can easily set your date format to "Friendly" from the customize column area of your calendar column, allowing you to view all date entries in this format.
URL creation with formula column
Thanks to this new feature, you can use the CONCATENATE formula in the formula column to combine data from multiple columns to create a URL, and you can generate these URLs as clickable links within the formula column.
![](https://cdn.prod.website-files.com/6295d1a43222793065c32b1c/665dff5f12d75f439ece96a8_table%20sync%20-%20GIF%20(1).gif)
Real-time update for Insert/Update/Delete row actions via API
Previously, when you sent any data to your Retable tables via the API, you had to refresh your table for this data to be reflected in your Retable tables. With this development, the data sent via the API in insert/update/delete row operations is now instantly reflected in your Retable tables.
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![Retable free no login online spreadsheet](https://cdn.prod.website-files.com/6295d1a43222795aaac32b12/641e09f082c9bb71ac2df0ce_Group%2026821.png)