🐣
🐣
🐣
🐣
Retable User Guide
Join our DiscordOnboard with us
Search
⌃K
Links

Managing tables

Tables are like worksheets in a spreadsheet. Each table can hold a set of data concerning one subject area. You must use unique names for your tables.

Adding a new table

Adding an empty table

Follow the steps below to create a table.
  1. 1.
    Click the "+Add new" icon on the top left side of the screen.
  2. 2.
    Click “Empty table” to create a Table.
  3. 3.
    When you create an empty table, there is 1 column and 1 row in the table.

Importing a .csv or .xls(x)

Follow the steps below to Import a .csv or .xls(x) files to Retable.
  1. 1.
    Click the "+Add new" icon on the top left side of the screen.
  2. 2.
    Click on “Import a .csv or .xls(x)” to import excel sheet.
  3. 3.
    Click on “Select a .csv or .xls(x) File” and choose an excel file from local desktop.
  4. 4.
    If the first line is the header, you can choose "First row is header."
  5. 5.
    Click on “Upload”.

Importing a Retable file

With Import Retable, you can import the files you exported in .retable format. So the formats in your project or table are not lost.
Follow the steps below to import a sheet.
  1. 1.
    Click the "+Add new" icon on the top left side of the screen.
  2. 2.
    Click on “Import Retable”.
  3. 3.
    Click on “Select a .retable File”
  4. 4.
    Select a .retable format file that you downloaded to your device.
  5. 5.
    Click the "Upload" button.
If you import your file with the ".retable" extension, you can import it with the same properties when you want to import your file.

Importing Google Sheets

That allows you to import an entire Google Sheets file as a new base, or import one into an existing base. Note that once you import data into Retable, any changes made within Retable will not be reflected back to the original Google Sheets you used for importing.
Follow the steps below to import a sheet.
  1. 1.
    Click the "+Add new" icon on the top left side of the screen.
  2. 2.
    Click on “Import Google Sheet”.
  3. 3.
    Connect to your Google account of the file you want to import from the screen that opens.
  4. 4.
    Select the relevant file from the "Choose File" field.
  5. 5.
    Click on “Select” button and choose the file.

Renaming tables

Follow the steps below to rename a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Rename table”.

Editing table description

Follow the steps below to edit a table description.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Description”.
  3. 3.
    Change table name or edit description of the table.

Locking a table

You can lock a table and prevent others from editing it. Only the person who locked the table can unlock it. When a table is locked, an e-mail is sent to inform all shared users. If one of those users want the table to be unlocked, that user can send a request to the person who locked the table to unlock it.
Follow the steps below to lock a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Lock Table”.
Follow the steps below to unlock a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Lock Table".

Duplicating a table

Follow the steps below to duplicate a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Duplicate Table”.

Copying a table

Follow the steps below to copy a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Copy Table”.
  3. 3.
    Select the area you want to copy from the "Selected Project" area.
  4. 4.
    Click on "Save" button.

Moving a table

Follow the steps below to move a Table;
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Move Table”.
  3. 3.
    Select the area you want to move from the "Selected Project" area.
  4. 4.
    Click on "Save" button.

Import an existing a .csv or .xls(x)

You can import an existing table with ""Import a .csv or .xls(x)" option.
Follow the steps below to import a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Import a .csv or .xls(x)”.
  3. 3.
    Choose between "Insert Data" or "Replace Data".
  4. 4.
    Click on “Select a .csv or .xls(x) File” and choose an excel or .csv file from local desktop.
If you select Insert Data;
  1. 1.
    If the first line is the header, you can choose "First row is header, don't include this header." Match the "Imported Column" and "Table Column" fields in the pop-up. You can disable the columns you do not want to import with the "Import" button. If the first line is not the header, you cannot choose "First row is header, don't include this header."
  2. 2.
    Click on “Upload”.
If you select Replace Data;
  1. 1.
    All your data in this table is replaced with the data you imported. If the data has no equivalent in the imported file, this data is added to the end of your Retable table. So, all your data in the table is replaced with the data you imported. It changes with the headers you import with the "Replace the headers as well" option. Match the "Table Column" and "Imported Column" fields in the pop-up.
  2. 2.
    Click on “Upload”.

Exporting a table

Follow the steps below to export a table to your computer.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click on “Export table”.
  3. 3.
    In the pop-up, drop down shows a list of export format options.
  4. 4.
    Select ".csv" or ".retable"
  5. 5.
    Click on "Export" button.
If you export your file with the ".retable" extension, you can import it with the same properties when you want to import your file to Retable again.
When you download the CSV file, it will be downloaded in your computer's default download directory.
​

Deleting a table

Follow the steps below to delete a table.
  1. 1.
    Click on the 3 dots next to table name.
  2. 2.
    Click “Delete table”.

Reordering table

You can be reordered by simply dragging and dropping.
Follow the steps below to reorder table.
1. Hover the mouse over the table you want to move.
2. Drag it to its new location.
3. When you release the mouse, the contents are moved to the new location.

Using table list

Instead of searching for table names, you can use the table names as a list to go directly to the tab you want to view. When the scroll icon appears on the screen (in case the tables do not fit on the screen), the “table list” icon appears. In this case, tabs of the project are listed and all tabs can be browsed quickly.
Check the video below for more information.

Organizing all columns

You can easily organize, order and hide all your columns in one place.
Follow the steps below organize all columns;
  1. 1.
    Click the "Columns" icon from your toolbar.
  2. 2.
    You can add a new column from the "Add column" button.
  3. 3.
    You can change the order of your columns by clicking and dragging the icon in front of your column name.
  4. 4.
    You can show or hide a column, click the switch next to the name of that column name.
  5. 5.
    You can rename your column with the "Rename this column" option from the menu that opens when three dots are clicked.
  6. 6.
    You can customize your column with the "Customize column" option from the menu that opens when three dots are clicked.
  7. 7.
    You can duplicate your column with the "Duplicate column" option from the menu that opens when three dots are clicked.
  8. 8.
    You can delete your column with the "Delete column" option from the menu that opens when the three dots are clicked.
  9. 9.
    You can quickly switch between all your columns from the column list on the left of the column detail window. Thus, you can manage the type, default values and all other details of all your columns from a single window.

Column sorting

Follow the steps below to sorting columns;
  1. 1.
    Click to “Sort” button.
  2. 2.
    Click to "Select" function.
  3. 3.
    Select the columns you want to sort.
  4. 4.
    Then on the column name choose “order ascending” / “order descending”.
  5. 5.
    You can add multiple sort with "Pick another column".
  6. 6.
    The user can switch the sort from active to passive by clicking the eye icon. When the sort is passive and in the field, the sort is not applied.
  7. 7.
    If you want to abandon column sorting, you can click the trash icon in the "Sort" field.
  8. 8.
    If you want to sort the sorts you add, you can sort them with the drag drop icon.
  9. 9.
    Click to "Apply" button.
You can sort by right clicking on the column name and selecting sort ascending or sort descending.

Column filtering

A condition is a rule you set that records must follow to be visible in that particular view.
Try adding conditions when:
  • You're trying to find a record or records that meet certain conditions quickly (e.g., records that have a due date after X date and before Y date).
  • You only need to focus on records that meet certain conditions (e.g., the records that have been assigned to me AND have not been marked as completed).
  • You need to prevent people from seeing certain records in a view share link.
A condition consists of three parts:
  • A field - Any field in your table.
  • An operator - After selecting a field, choose an operator from the pre-populated dropdown menu. Which filter operators are available is determined by the field type.
  • A value - This is the value you compare all of your records against
Follow the steps below to apply a filter to a column/columns;
  1. 1.
    Click “Filter” icon on the left top of the screen.
  2. 2.
    Choose column which needs to be applied filter.
  3. 3.
    Choose filter type which are below;
    • Contains -> Characters included in the value which will be filtered
    • Does not contains -> Characters not included in the value which will be filtered
    • Is -> Value is equal to column value
    • Is not -> Value is NOT equal to column value
    • Is empty -> Column value is blank (NULL)
    • Is not empty -> Column value is not blank (not NULL)
    • Is before -> Filtering returns before the entered value
    • Is after -> Filtering returns after the entered value
    • Between -> Returns the date data between the dates entered in the filtering
    • Difference -> Returns the filtered data that is different according to the hours/day selection after the date selection entered into the filtering or the now selection
    • = -> Returns the equals of the value entered in the filtering
    • ≠ -> Returns the unequals of the value entered in filtering
    • < -> Returns less than the value entered in filtering
    • > -> Returns values ​​greater than the value entered in filtering
    • ≤ -> Returns less than or equal to the value entered in filtering
    • ≥ -> Returns greater than or equal to the value entered in filtering
    • Not authorized -> Filters the data from the form based on the Created by column
    All - Anonymous user and Unauthorized user Form - Anonymous user Other User - not Anonymous user and Unauthorized user
  4. 4.
    User can add more than one filter by clicking “Add Filter” button. Each added filter works as “OR”/”AND” option by selecting from operator dropdown.
  5. 5.
    The user can switch the filter from active to passive by clicking the eye icon. When the filter is passive and in the field, the filter is not applied.
  6. 6.
    With the Lock icon, If you share the views, you create as editable, the people you share will not change the filters you apply
  7. 7.
    If you want to abandon filter, you can click the trash icon in the "Filter" field.
  8. 8.
    Then click the "Apply" button.

Row grouping

Row grouping allows you to show your records grouped together based on one field of your choosing. Grouping is available only in Grid view. You can group for all column types. Groups can also work with hide, sort, filter and format.
Follow the steps below to apply grouping;
  1. 1.
    Click "Grouping" and select the field by which you'd like to group your records from the menu.
  2. 2.
    Once you've selected the field you want to group by, groups will automatically be created based on the unique values in that field.
  3. 3.
    Then click the "Apply" button.
  4. 4.
    If you want to abandon group, you can click the trash icon in the "Group" field.

Expanding and collapsing groups

You can view the groups in your tables more compactly with the expand and collapse structure. So, you can instantly view only the data you want to see.
Follow the steps below to Expand & Collapse Groups;
  1. 1.
    Click on the "Grouping" button on the toolbar.
  2. 2.
    Apply a group to your table by picking a column to group.
  3. 3.
    You can expand or collapse your groups by clicking the arrow near your group names.

Formatting

You can customize your tables with Retable's advanced formatting options. With the special formats that you can apply to your column, row or cell.
You can easily see your column, row or cell more colourful, highlighted or striking.

Formatting step by step

If you want to change the column style follow the steps below;
  1. 1.
    Select the column, row or cell you want to change from the table.
  2. 2.
    Click “Format” icon on the left top of the screen.
  3. 3.
    Choose "B" icon if you want bold styling.
  4. 4.
    Choose "I" icon if you want italic styling.
  5. 5.
    Choose "U" icon if you want underline styling.
  6. 6.
    If you want to change of the cell fill color, choose "A" icon.
  7. 7.
    If you want to change of the cell font color, choose the icon on the right of "A".
  8. 8.
    If you want to delete the styles made, select the cells you want to delete and click the "Reset Style" icon.
  9. 9.
    Click on the last icon in the bar for row sizes and choose desired sizes.
    • Short Row
    • Medium Row
    • Tall Row

Conditional formatting

You can use this if you want to format according to the conditions given in the table.
If you want to add the conditional formatting follow the steps below;
  1. 1.
    Click “Format” icon on the left top of the screen.
  2. 2.
    Open the "Conditional formatting" field.
  3. 3.
    Choose column which needs to be applied format.
  4. 4.
    Choose format type which are below;
    • Contains -> Characters included in the value which will be formatted
    • Does not contains -> Characters not included in the value which will be formatted
    • Is -> Value is equal to column value
    • Is not -> Value is NOT equal to column value
    • Is empty -> Column value is blank (NULL)
    • Is not empty -> Column value is not blank (not NULL)
    • Is before -> Formatting returns before the entered value
    • Is after -> Formatting returns after the entered value
    • Between -> Shows the date data between the dates entered in the formatting
    • Difference -> Shows the formatted data that is different according to the hours/day selection after the date selection entered into the formatting or the now selection
    • = -> Shows the equals of the value entered in the formatting
    • ≠ -> Shows the unequals of the value entered in formatting
    • < -> Shows less than the value entered in formatting
    • > -> Shows values ​​greater than the value entered in formatting
    • ≤ -> Shows less than or equal to the value entered in formatting
    • ≥ -> Shows greater than or equal to the value entered in formatting
  5. 5.
    Choose format type;
    • Choose "B" icon if you want bold formatting
    • Choose "I" icon if you want italic formatting
    • Choose "U" icon if you want underline formatting
    • If you want to change of the cell fill color, choose "A" icon
    • If you want to change of the cell font color, choose the icon on the right of "A"
  6. 6.
    If you want to add more than one format, click the "Add format" button.
  7. 7.
    You can give conditional format on the basis of row and cell.
  8. 8.
    If you want to delete the styles made, click the cross next to the filter you want to delete.
    Note: Conditional format actions override column shaping work.
  9. 9.
    If you want to abandon format, you can click the trash icon in the "Conditional formatting" field.
  10. 10.
    Then click the "Apply" button.

Using column styles

With the special formats that you can apply to your columns, you can easily see your columns more colorful, more highlighted or more striking. So, you don't need to reformat your cells every time you add new data. Any formatting you make for your column is automatically applied to all data in this column.
If you want to add the column formatting follow the steps below;
  1. 1.
    Click on the "Format" button from the toolbar.
  2. 2.
    Open the "Column Style" field.
  3. 3.
    Apply any of the formats on the right side to the column you want from the column list.
  4. 4.
    Choose format type;
    • Choose "B" icon if you want bold formatting
    • Choose "I" icon if you want italic formatting
    • Choose "U" icon if you want underline formatting
    • If you want to change of the cell fill color, choose "A" icon
    • If you want to change of the cell font color, choose the icon on the right of "A"
  5. 5.
    If you want to delete the styles made, select the cells you want to delete and click the "Reset Style" icon.

Using the shortcut to repeat the last format action

The last formatting action can be easily repeated to other cells with the "F4" shortcut.
Follow the steps below to repeat the last format;
  1. 1.
    Format a cell
  2. 2.
    Then, go to another cell where you want to apply your last formatting
  3. 3.
    Click F4 (for Mac Fn+F4)
Quick-Tip; If you double-click the F4 you can undo your last change.

Viewing table history

Undo/redo actions

Follow the steps below to undo/redo action
  1. 1.
    Click on the "Table History" icon at the top right of the table.
  2. 2.
    Click on “Undo” or "Redo".

Snapshots

Snapshot helps you back up a table and restore it to an earlier version. You can also manually take a snapshot. It may be a good idea to manually take a snapshot of your table immediately before restructuring or otherwise making a large amount of changes to your base.
Users can take snapshot of tables or load from snapshots.

Taking a snapshot

Follow the steps below to take snapshot of a table.
  1. 1.
    Click on the "Table History" icon at the top right of the table.
  2. 2.
    Click on “Snapshot” to enter snapshot menu.
  3. 3.
    Click on “Take a snapshot”.

Loading from a snapshot

Follow the steps below to load from snapshot;
  1. 1.
    Click on the "Table History" icon at the top right of the table.
  2. 2.
    Select "Snapshot".
  3. 3.
    There are two options to load from snapshots.
    • Select “Create new table” to load from snapshot to a new table.
    • Select “Restore table” to load from snapshot to the existing table.

Sharing a view

Public view

User can create a share link for the entire view will let anyone with the link see the entire view. Also, table owners may want to share a specific view instead by choosing specific filters and columns from the table. In other words, only the owner of a personal view can customize that view's filters, field visibility, field order/sorts, and export data.
Follow the steps below to set the visibility of a table.
  1. 1.
    Click on the "Share" button in the table bar.
  2. 2.
    If you want to make the table make public, click the "Public View" switch. You can share your data with this link. Hidden fields are not visible.
  3. 3.
    If you want the view data to be edited, you can enable the "Editable" switch. The "All" and "Only Data" options appear when the "Editable" switch is enabled. If the user you are sharing with is logged in, the user can operate on the view according to the "All" or "Only Data" options you choose. If the user you are sharing with is not logged in, the user cannot operate on the view.
  4. 4.
    Disable export feature helps you to hide the export button of Retable tables that you share publicly or embed on your website.
  5. 5.
    If you want the table data to be used, you can enable the "Use Data" switch. If the user you shared with are logged in, user can create new table using this view data.
  6. 6.
    If you have a Team plan, you can customize Retable branding and add your own branding components to Retable. This feature instead of Retable's logos and colors, you can design your organization's workspace in accordance with your own corporate identity. For this you have to add Organization workspace and turn on the Organization switch.
  7. 7.
    If you want, you can copy the link or open the link in a new page. Click on the "Embed" icons next to the links. You can copy the code by double-click the Embed Code.
  8. 8.
    You can hide columns, multi sort, filter or group on via "Public view" and export the table. You can also share the public view.

Data masking with public view

Keep your sensitive information safe and secure with our powerful column-based data masking tool. Whether you're sharing tables with colleagues or presenting data to clients, you can now confidently mask specific columns to protect confidential information. With Mask Data, your private data stays private, and you can focus on sharing insights and making informed decisions without any security concerns.
Follow the steps below to mask data;
  1. 1.
    Click “Customize Column”.
  2. 2.
    Activate the “Mask Data” option.
  3. 3.
    Save your column.
  4. 4.
    If you activate the Mask Data option, when you share your table publicly, the data in this column will be displayed as (***).

Embedding a view

You can embed an Retable base (or just a view from a base) into any web page that supports iframes. Try embedding a base in a public-facing website, or as part of an enterprise wiki (like Confluence).
Follow the step below to embed;
  1. 1.
    Start by clicking the "Share" button. This will open a window with "Share" options.
  2. 2.
    You should open Public view or Public Form key.
  3. 3.
    Click on the "Embed" icons next to the links.
  4. 4.
    You can change the Width and Height.
  5. 5.
    You can hide the Retable logo with the "Hide Retable Logo" switch only Public view.
  6. 6.
    You can copy the code by double-click the Embed Code.
  7. 7.
    Ready to embed.
In the event that you change cell values, add records or fields, or otherwise change which fields and records are visible in the view, the link will automatically update in real-time to show the most up-to-date version of the view.

Public form

Retable forms let you collect information from anyone and save it automatically to a Retable table.
They're perfect for logging expenses, collecting RSVPs, creating polls and quizzes, collecting customer information, and many other purposes.
Unlike other products, which require you to build a form from scratch, Retable forms are automatically generated from your existing tables and then give you the ability to rearrange and remove fields.
When the "Public Form" switch is opened, the "Only logged in users can view and submit" field button appears at the bottom. When this button is opened, only logged in users can view and submit the form. When you add "Created by" columns to your form, you can see who submitted the form.
If you have a Team plan, you can customize Retable branding and add your own branding components to Retable. This feature instead of Retable's logos and colors, you can design your organization's workspace in accordance with your own corporate identity. For this you have to add Organization workspace and turn on the Organization switch.
Follow the steps below to enable the Public Form of a Table;
  1. 1.
    Click on the "Share" button in the table bar.
  2. 2.
    If you want to make the table make public, click on the "Public Form" switch.
  3. 3.
    Turn on the "Only logged in users can view and submit" switch so that only logged in users can view and submit the form.
  4. 4.
    The custom branding that you created for your organization will now also be displayed on the "Thank You" page of your Retable forms. Thus, the people you share your Retable forms with will be greeted with a thank you page directly designed with your custom branding after submitting your form. For this you have to add Organization workspace and turn on the Organization switch.
  5. 5.
    If you want, you can copy the link or open the link in a new page. Click on the "Embed" icons next to the links. You can copy the code by double-click the Embed Code.
  6. 6.
    You can share this link to get submissions from anyone.

Customizing public form

If you want to customize your public form, follow the steps below.
  1. 1.
    Click on the “Share" button in the table bar.
  2. 2.
    If you want to make the table make public, click the "Public Form" switch.
  3. 3.
    Click on the "Edit and preview form" icon on the screen that opens.
  4. 4.
    You can add an image to your form by selecting or dragging from the "Drag or select an image here" field. In other way, you can add a cover image by clicking on the "Cover Image" field on the right hand side.
  5. 5.
    You can add form name and form description. Form name and form description entered in this field appear on the form. Edit your form description as you wish in the Markdown text editor. You can apply various formats to the texts in your form description area, insert links, or add images.
  6. 6.
    If you turn on "Required", the columns become required. In this case, this field cannot be empty in the form.
  7. 7.
    You can change the column name or add a column description. Column name and column description entered in this field appear on the form.
  8. 8.
    There are two different color options for the form name - you can choose one from here.
  9. 9.
    With "Extended Cover Image" you can change the position of the cover images of your online forms to extended or fixed.
  10. 10.
    With "Hide Retable Logo" you can hide the Retable logo at the bottom of your form.
  11. 11.
    With "Send Mail" people who fill out the form receive a copy of their responses by email and can easily review their responses later. "Email me a copy of my responses" option should be selected from the form page.
  12. 12.
    With "Redirect URL" you can direct people who fill out your Retable forms to the sites you want.
  13. 13.
    Columns whose switches are turned off from the Columns field do not appear in the form.
  14. 14.
    The automation field opens with the "Get email notification for new response" button.
  15. 15.
    If you want to preview the customized form, click on the "Preview" button.
  16. 16.
    Click on the "Save" button.
  17. 17.
    At the bottom of the form; You can clear your form with "Clear form". You can return to us with the "Report malicious form".

Asking to update for a row

If you want your row to be updated by your collaborator, follow the steps below;
  1. 1.
    Right click on row and select "Ask to update" function.
  2. 2.
    From the "This row" tab; In the "Email" field, write the email addresses of the users you want to send. In case of more than one account, between the accounts "," , ";" you can use. You can also select your collaborators using the @ symbol.
  3. 3.
    From the "All rows" tab; If Collaborator and Email columns are included in the table, e-mail is sent to the user/email in the columns according to your selection.
  4. 4.
    You can turn off the switch for the columns you don't want updated. This way the update is done for the columns with the key open. It is not possible to update the data of the columns whose key is not open.
  5. 5.
    Click the "Send" button.
You can use the "Columns" switch to toggle all columns on or off. If the Columns key is on, all columns will be open. If the Columns switch is closed, all columns are closed. Remember that meta columns (Autonumber, Created time, Created by, Last modified time, Last modified by) are always turned off.

Find and replace data

You can easily search for the data you want to find in your Retable table and replace that data.
If you want to do this, follow the steps below;
  1. 1.
    Click "Find" on the left of the top bar of the table.
  2. 2.
    Type the word you want to search and click "Find".
  3. 3.
    With "Replace", you can replace only the data you want.
  4. 4.
    You can replace all data found after your search with "Replace All".
Cmd/CTRL + F = "Find" field open
The search results can be navigated with "Enter"
Both English and Turkish characters can be searched in the Find field. In this way, you do not need to distinguish between English / Turkish characters when searching.
If you want to do a case-sensitive search in Retable, just check the case-sensitive box in the "Find" field. Thus, you will only see the same case-sensitive term as you directly write for the search.
If you want to do this, follow the steps below;
  1. 1.
    Click "Find" at the top bar of the Retable.
  2. 2.
    Type of the word you want to search
  3. 3.
    Check the "Case Sensitive" box and click "Find"

Freezing columns

When multiple columns are added, if the columns are not visible on the screen, you can freeze - or lock - a field in order to always keep it in view when you're scrolling through a table horizontally.
To freeze fields, start by hovering over the dividing line next to any field. You'll see a blue bar appear with the indicator to "drag to adjust the number of frozen columns".
Click and hold your mouse and drag this past the field(s) you want to freeze, and then unclick. Now, all the fields to the left of the frozen field divider will remain fixed when you scroll horizontally.
Follow the steps below to apply a freeze to a column/columns;
  1. 1.
    Keep the freeze mark in the first column of the table.
  2. 2.
    Drag freeze up to the column you want.
  3. 3.
    Leave the freeze mark.
  4. 4.
    You can see the columns freeze as you scroll with the scroll. Note that freezing process can be done up to the middle of the screen.

Adding or deleting a row or cell

There are three ways to add a row:
  • Click to plus (+) icon.
  • Press Enter button on the keyboard when mouse cursor is on the last row of the table.
  • Go to the beginning of the row and right click and click "Insert a new row before " and "Insert a new row after"
Follow the steps below to delete a row(s):
  1. 1.
    Select row(s) that are needed to delete.
  2. 2.
    Click right button on the mouse.
  3. 3.
    Select “Delete selected row(s)”
Follow the steps below to delete a cell(s):
  1. 1.
    Select cell(s) that are needed to delete
  2. 2.
    Click right button on the mouse.
  3. 3.
    Select “Delete selected cell(s)”
You can delete it by entering the cell with a double click, or you can delete it with a single click.

Duplicating a row

Follow the step below to duplicate rows;
  1. 1.
    Right-click the row and select the "Duplicate row" functions.
  2. 2.
    Cmd/CTRL + D = Row duplicate directly to the next row.

Adding or deleting a column

Follow the steps below to add a column:
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Type column name under the column title.
  3. 3.
    Choose column type.
  4. 4.
    Click "Save" button.
You can also add columns by right-clicking on the column and using the "Insert a new column after" and "Insert a new column before" functions.
You must use unique names for your columns.
To delete a column, simply select the column and right click on your mouse. From the menu, Select "Delete selected column(s)"

Duplicating a column

Follow the step below to duplicate columns;
  1. 1.
    Right click the column and select "Duplicate column" function.

Column types

There are 28 different column types.
  • Text: User can type alphabetic characters. (A line of text.)
  • Number: User can type numbers. (A line of numbers.) If "Allow negative numbers." is marked, negative values ​​can be entered in the relevant cells.
  • Checkbox: User can check/uncheck the box on the column. (A small box in which to place a check mark.)
  • Image: User can select and upload image. (Image allow you to add images which can then be viewed or downloaded). Image file types can be .png, .webp or .jpeg.
  • Attachment: User can select and upload a file. Attachments allow you to add images, documents, or other files which can then be viewed or downloaded. Attachment file types can be: .jpeg, .jpg, .gif, .png, .xlsx, .xls, .pdf, .gif, .rar, .zip, .svg, .doc, .docx, .csv, .tiff, .eps, .ai, .txt, .html, .htm, .css, .js, .wpd, .xhtml, .ppt, .pptx, .mp3, .mp4, .wma, .flv, .avi, .retable, .exe, .odt, .ods, .aif, .cda, .mid, .7z, .arj, .deb, .pkg, .rpm, .z, .bin, .dmg, .iso, .mdb, .sql, .xml, .email, .apk, .psd, .bmp, .tar.gz
  • Date & time: User can enter only date values from a calendar shown. You can choose "European", "US" and "ISO" formats according to the date format. If you want it to include the time, mark the "Include time" field.
  • Color: User can choose a color for the column. (Pick a color for your cell.)
  • Email: User can enter an email. (A valid email address (e.g. [email protected]).
  • Phone number: User can enter phone number in phone number format. (A telephone number (e.g. (415) 555-9876).). If there is a suitable data entry in the column, a call is performed by clicking on it.
  • Percent: User can enter integer or decimal numbers. % is added to the numbers. If "Allow negative numbers." is marked, negative values ​​can be entered in the relevant cells.
  • Currency: User can use currency amount. (Specific type of number field that formats the number as a currency amount.)User can enter integer or decimal numbers. If "Allow negative numbers." is marked, negative values ​​can be entered in the relevant cells. You can change your currency symbol from the "Currency Symbol" field.
  • Select (Options): User can select more than one option. (Multiple select allows you to select one or more predefined options listed below.)
  • Rating: User can use rate as star icon. (Rate your records.)
  • Formula: Formulas can be easily created in the column. You can easily create simple, row-basis formulas with Retable. Its formulation can be applied in number and text column type. See this link for a list of formulas.
  • Reference Another Table: User can use data from other tables with reference function. (Show other table's datas ​in this table.)
  • Lookup Values: The lookup column type allows the user to pull data from another table by referencing it. It fetches data and change the value of column if the reference column data changes.
  • Rollup: You can now easily summarize and aggregate data from multiple linked records within a single table or across multiple tables. It allows you to create customized views of your data, generate reports, and calculate totals, averages, and percentages with ease.
  • Autonumber: User can use a unique key. (Automatically generates a unique, automatically incremented number for each record.)
  • URL: Formats the text within it as a URL. When the user clicks on a URL in the URL field, it will open the page. You can give button text and button color to URLs with "Show As Button" option. When the button is clicked, it will open the page. There is a special preview bubble URL column type so that you can easily view and copy.
  • Unique Identifier: UUID column type gives you a powerful algorithm to generate unique codes for each of your records. UUID column type, you can create unique codes aka identifiers and use these codes as passwords, product codes or user codes.
  • Geolocation: It automatically shows you the street, neighborhood, city, state, and country in the same cell. Easily do city searches and easily navigate to the city you want to find on the map or easily move your pins around the map by simply dragging and dropping them.
  • Collaborator: User can add users to cells. If "Multiple" is checked, more than one user can be selected in the cell. Also if "send notification" is checked, the changes in the line are sent to the relevant user(s).
  • Created Time: User can see the date the record was created.
  • Created By: User can see who created the record.
  • Last Modified Time: User can see the last date the record was modified.
  • Last Modified By: User can see the last person whose registration was modified.
  • QR Code: You can now create custom QR codes directly within your spreadsheet that can be easily scanned by any QR scanner. Simply input the desired value into the cell, and the QR Code column type will generate a unique QR code for that value, allowing you to quickly and conveniently share information with others. QR Code column type also supports a range of data formats, including Whatsapp, Skype, Phone Number, and Email.
  • GPT: Allows you to generate any data with ChatGPT directly in your Retable spreadsheets. All you need is a Retable account an an OpenAI account, together with OpenAI account key.

Converting to different column types

Follow the steps below for column replacement.
  1. 1.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    You can change the column type from the type field.
  4. 4.
    Click “Save” button.

Row Detail

The row detail window or modal helps you view and manage the row. You can view and manage all the data related to your row by clicking Row Detail from the field that opens when you right-click on the row. With the help of the row detail window on the right side of your tables, you can view and manage all data related to your row in a vertical format. Row detail window or modal helps you quickly switch between rows, add new rows and columns, and easily edit data in your rows.

Expanding a cell

Thanks to Retable's cell expand feature, you can easily expand your cells and view detailed information in the cells. It's especially helpful for multi-line texts. Each record can be expanded to show all of the information in the cell.
Cell expand icon directly next your cell in the Text, Image, Attachment, Email, Select, Reference Another Table, Lookup Values, Collaborator, URL, QR Code, Geolocation and GPT column types.
You can easily manage long texts inside your cells thanks to the text box that opens when you click on the Expand icon. In addition, you can easily work by dragging the opened text box to the place you want on the page.
Follow the steps to expand a cell.
  1. 1.
    Click the blue expand icon directly near your cell.
  2. 2.
    Then, the text box will directly open.
  3. 3.
    You can easily start to write anything in this text box and drag this text box anywhere on the page.

Data validation

There are four options for data validation which are Single Select, Multi Select, Text and Number column types.

Text column validation

User can select multiple allowed values for specific columns.
  1. 1.
    Hover over the column name and right click.
  2. 2.
    Choose "Customize Column" function.
  3. 3.
    Choose “Text” in the column type option.
  4. 4.
    Check "Validation" and click "Add Validation Rule" from the screen.
  5. 5.
    There will be 3 options;
    • Min character
    • Max character
    • Regex
  6. 6.
    If you enter min characters and click the "save" button, "Validation Error" is given next to the cells that do not meet this criterion in the relevant cells.
  7. 7.
    If you enter max characters and click the "save" button, "Validation Error" is given next to the cells that do not meet this criterion in the relevant cells.
  8. 8.
    If you enter regex code and click the "save" button, "error message" is given next to the cells that do not meet this criterion in the relevant cells. For examples;
    • Email check: ^[\w-.]+@([\w-]+.)+[\w-]{2,4}$
    • No whitespace character: \S
    • Non alphanumeric: \W etc.
  9. 9.
    You can add up to 3 controls.
  10. 10.
    Cells that do not comply with the control are marked in red and the message given is: Validation Error: The value must follow these rule(s).

Number column validation

User can select multiple allowed values for specific columns.
  1. 1.
    Hover over the column name and right click.
  2. 2.
    Choose "Customize Column" function.
  3. 3.
    Choose “Number” in the column type option.
  4. 4.
    Check "Validation" and click "Add Validation Rule" from the screen.
  5. 5.
    There will be 2 options.
    • Min value
    • Max value
  6. 6.
    If you enter min value and click the "save" button, "Validation Error" is given next to the cells that do not meet this criterion in the relevant cells.
  7. 7.
    If you enter max value and click the "save" button, "Validation Error" is given next to the cells that do not meet this criterion in the relevant cells.
  8. 8.
    You can add up to 2 controls.
  9. 9.
    Cells that do not comply with the control are marked in red and the message given is: Validation Error: The value must follow these rule(s).

Allowing one value for columns (single select)

User can select only one allowed value for specific columns.
  1. 1.
    Hover over the column name and right click.
  2. 2.
    Choose "Customize Column" function.
  3. 3.
    Choose “Select” in the column type option.
  4. 4.
    Choose "Single Select" from the screen.
  5. 5.
    Data is entered in the "Empty Option" field. New selections are added with "Add an options".
  6. 6.
    If you want to clear data, use the "Clear" button.
  7. 7.
    If you want to insert the data of another table, you can use the "Generate from table column" selection. You can generate data by selecting tables and columns.
  8. 8.
    You can search in option field with "Search in option(s)".
  9. 9.
    If you want to delete option, you can click the "x" icon.
  10. 10.
    Click on "Save".

Allowing multiple values for columns (multi select)

User can select multiple allowed values for specific columns.
  1. 1.
    Hover over the column name and right click.
  2. 2.
    Choose "Customize Column" function.
  3. 3.
    Choose “Select” in the column type option.
  4. 4.
    Choose "Multi Select" from the screen.
  5. 5.
    Data is entered in the "Empty Options" field.
  6. 6.
    New selections are added with "Add an options".
  7. 7.
    If you want to clear data, use the "Clear" button.
  8. 8.
    If you want to insert the data of another table, you can use the "Generate from table column" selection. You can generate data by selecting tables and columns.
  9. 9.
    You can search in option field with "Search in option(s)".
  10. 10.
    If you want to delete option, you can click the "x" icon.
  11. 11.
    Click "Save".

Adding column uniqueness

Follow the steps below to apply a unique to a column/columns;
  1. 1.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    In the pop-up that opens, mark the "Unique" field. Each value will be unique across the table for this column.
  4. 4.
    Click “Save” button.

Setting a required column

‌Follow the steps below to apply a required to a column/columns;‌
  1. 1.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    In the pop-up that opens, mark the "Required " field. This column will be required in forms and table.
  4. 4.
    Click “Save” button.

Column default values

Each time add a row is that cell automatically fills in with the selected data.
Follow the steps below to default value;
  1. 1.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    In the pop-up that opens, mark the "Default Value " field.
  4. 4.
    Click “Save” button.

Formatting in column types

If you want to use formatting on column types, follow the steps below.

Formatting in number column type

When customizing your number field, the "Customize Column" menu contains a couple of options.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Number column from Column Types dropdown.
  3. 3.
    You can select whether you want your numbers to appear as integers (whole numbers) or as decimal numbers.
  4. 4.
    If you've chosen to format your numbers as decimals, you'll also have the option of selecting the precision, up to 8 decimal places.
  5. 5.
    You can also decide whether or not you want to allow negative numbers in this field.
  6. 6.
    Then click the "Save" button.

Formatting in date & time column type

When customizing your date & time field, the "Customize Column" menu contains a couple of options.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Date&Time column from Column Types dropdown.
  3. 3.
    You can choose "European", "US" and "ISO" formats according to the date format.
  4. 4.
    If you want it to include the time, mark the "Include time" field.
  5. 5.
    Then click the "Save" button.

Formatting in currency column type

When customizing your percent field, the "Customize Column" menu contains a couple of options.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Currency column from Column Types dropdown.
  3. 3.
    You can select whether you want your percent to appear as integers (whole numbers) or as decimal numbers.
  4. 4.
    If you've chosen to format your percent as decimals, you'll also have the option of selecting the precision, up to 8 decimal places.
  5. 5.
    You can also decide whether or not you want to allow negative numbers in this field.
  6. 6.
    You can change your currency symbol from the "Currency Symbol" field.
  7. 7.
    Then click the "Save" button.

Formatting in percent column type

When customizing your percent field, the "Customize Column" menu contains a couple of options.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Percent column from Column Types dropdown.
  3. 3.
    You can select whether you want your percent to appear as integers (whole numbers) or as decimal numbers.
  4. 4.
    If you've chosen to format your percent as decimals, you'll also have the option of selecting the precision, up to 8 decimal places.
  5. 5.
    You can also decide whether or not you want to allow negative numbers in this field.
  6. 6.
    Then click the "Save" button.

Formulas

Formulas can be easily created in the column. You can easily create simple, row-basis formulas with Retable. Its formulation can be applied in number and text column type.
When customizing your formulation field, the "Customize Column" menu contains a couple of options.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Formula column from Column Types dropdown.
  3. 3.
    Click the formula area and start to type your formula. You can check the examples to start writing the formula.
  4. 4.
    When you start to type our formula options will appear directly under the formula section, and you can select the formula you want to use.
  5. 5.
    Open your parenthesis.
  6. 6.
    Then all your columns will be listed directly under the formula section. You can select the column that you want to add to your formula.
  7. 7.
    You can add more than one column to your formula by separating the columns with a comma.
  8. 8.
    When you finish adding the columns you should close your parenthesis.
  9. 9.
    Then click the "Save" button.
  10. 10.
    It is fully dynamic so, when you change any data in the columns that you used in your formula, the formula results will be automatically updated.
Examples:
  1. 1.
    You can COUNT cells containing numbers with the Count function. Example: =COUNT ({column_name1}, {column_name2})
  2. 2.
    You can SUM cells containing numbers with the sum function. Example: =SUM ({column_name1}, {column_name2})
  3. 3.
    With the AVERAGE function, you can get the average of cells containing numbers. Example: =AVERAGE ({column_name1}, {column_name2})
  4. 4.
    You can get the smallest of cells containing numbers with the MIN function. Example: =MIN ({column_name1}, {column_name2})
  5. 5.
    You can get the largest number of cells containing numbers with the MAX function. Example: =MAX ({column_name1}, {column_name2})
  6. 6.
    You can combine two cells with the CONCATENATE function. Example: CONCATENATE ({column_name1}, {column_name2})
  7. 7.
    You can use TODAY function. Example: TODAY()
  8. 8.
    You can use NOW function. Example: NOW()
  9. 9.
    You can use DAYS(end_date, start_date, date_format) function to find the days between two dates. Example: DAYS({column_name1}, {column_name2}) DAYS(TODAY(), column_name, US)
  10. 10.
    You can format it with the DATEFORMAT({date}, {current_date_format}, {new_date_format}) function. Example: DATEFORMAT({column_name}, 'MM.DD.YYYY') DATEFORMAT({column_name}, EU, US)
  11. 11.
    You can collect an integer field with ADDDAYS, the date column type and create a finish date. Example: ADDDAYS({column_name1}, {column_name2}, US) ADDDAYS({column_name1}, number, EU)
  12. 12.
    You can calculate working days with the WORKDAYS({start_date}, {end_date}) function. Example: WORKDAYS({column_name1}, {column_name2}) WORKDAYS({column_name1}, {column_name2}, ISO)
  13. 13.
    The percentage of completion of work between two dates is calculated with COMPLETE({enddate}, {startdate}) Example: COMPLETE({column_name1}, {column_name2})
  14. 14.
    The percentage of completion of work between two numbers is calculated with PROGRESS({column_name1}, {column_name2}) EXAMPLE: PROGRESS{column_name1}, {column_name2}
  15. 15.
    You can calculate the difference of "years", "months", "days", "hours", "minutes" and "seconds" between two dates with DURATIONS({column_name1}, {column_name2}, " ") EXAMPLE: DURATIONS({end_date},{start_date},EU(),"day") DURATIONS({end_date},{start_date},EU("time"),"hour,minute")
  16. 16.
    You can include all the columns between the {Column1}:{ColumnN} function and the selected column in the formula. EXAMPLE: SUM({column_name1}, {column_name2})
Formulas in Retable consist of a stripped down version of Excel formulas together with custom formulas developed by the Retable team. See this link to view a list of all formulas supported together with their descriptions.
​https://go.retable.io/view9WsGLebOoyCrBvlo​

Referencing another table column

You can use this column type when you have multiple tables and want to create links between them, known as references. You can create tables that represent relationships with reference tables and can easily get information from columns in another table.
If you want to this, follow the steps below.
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Reference Another Table column from Column Types dropdown.
  3. 3.
    In the window that opens, select the "Table" and "Lookup field" fields whose data you want to use from the "Reference table" field.
  4. 4.
    Click the "Save" button.
  5. 5.
    Click the "+" icon on the cell of the referenced column and select the rows you want to use from the corresponding pop-up window.
  6. 6.
    You can search from the corresponding pop-up window and mark the "Case sensitive".

Lookup values column type

This column type can be used when there are multiple tables and it is desired to create links between them, known as lookup values.
In order to use this column type, first a Referenced Another Table column must be created in the table.
Lookup column type allows you to pull data from from another table by referencing it. It fetches data and change the value of column if the reference column data changes.
If you want to this, follow the steps below;
  1. 1.
    Click to plus (+) icon next to column names.
  2. 2.
    Select Lookup Values column from Column Types dropdown.
  3. 3.
    In the window that opens, select the "Referenced Column" and "Lookup column" fields whose data you want to use from the "Lookup value" field.
  4. 4.
    Then click the "Save" button.
  5. 5.
    By selecting data from the Reference column, the data is pulled into the Lookup Values column.

Rollup column type

You can now easily summarize and aggregate data from multiple linked records within a single table or across multiple tables. It allows you to create customized views of your data, generate reports, and calculate totals, averages, and percentages with ease.
The Roll-up column is designed to be user-friendly and intuitive, with a range of aggregation functions to choose from, including sum, average, count, max, min, and more.
If you want to this, follow the steps below;