🐣
🐣
🐣
🐣
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.

Add New Table

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.

Import 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 Retable

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.

How to organize 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 change the order of your columns by clicking and dragging the icon in front of your column name.
  3. 3.
    You can show or hide a column, click the switch next to the name of that column name.
  4. 4.
    You can change the name of your columns by clicking the "edit" icon.
  5. 5.
    You can open the column detail window by clicking the "Settings" icon.
  6. 6.
    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.

How to columns 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.

How to filter column

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.

Expand & Collapse 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.

How to 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 colorful, more highlighted or more striking.

How to use format

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 "clear" button.
  9. 9.
    Click on the last icon in the bar for row sizes and choose desired sizes.
    • Short Row
    • Medium Row
    • Tall Row

How to use 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.

How to use column style

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 "clear" button.

How to use 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.
    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.
  5. 5.
    If you have a Business Unlimited 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.
  6. 6.
    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.
  7. 7.
    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 (***).

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.
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".

How to find and replace data in table

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"

How to use find customization

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 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".
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.

How to add or delete row

How to add row

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.
  • Get to the beginning of the row and right click and click "Insert a new row before " and "Insert a new row after"

How to delete row

Follow the steps below to delete a row;
  1. 1.
    Select rows that are needed to delete.
  2. 2.
    Click right button on the mouse.
  3. 3.
    Select “Delete selected row(s)”

How to add or delete column

How to add 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.
When you try to add multiple column with the same name, column will sort them for you or give you an alert. If you have a column named "Phone Number" and try to create another "Phone Number", we'll give you an alert as "Column title must be unique."

How to duplicate column

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

How to delete column

Follow the steps below to delete a columns;
  1. 1.
    Right click on the column name which will be deleted. (Hold “SHIFT” button on the keyboard for multiple column selection)
  2. 2.
    Select “Delete selected column(s)”.
  3. 3.
    Click the “Delete” button.

How to column basic 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.)
  • Attachment: User can select and upload file. (Attachments allow you to add images, documents, or other files which can then be viewed or downloaded.)
  • Date&Time: User can enter only date values from a calendar shown. (Enter a date (e.g. 11/12/2013) or pick one from a calendar.) 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).).
  • 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.
  • Select: User can select more than one option. (Multiple select allows you to select one or more predefined options listed below.)
  • 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.
  • 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.)
  • 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.
  • Rating: User can use rate as star icon. (Rate your records.)
  • 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.
  • 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.
  • Formula: You can easily create simple, column-basis formulas. The formulas can be applied in the number and text columns.
  • 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.
  • 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: Allow you to generate any data with ChatGPT directly in your Retable spreadsheets. All we need is; a Retable account an an OpenAI account
​

How to convert 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.

Cell Expand

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;
  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.

How to 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-.][email protected]([\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).

How to 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).

How to 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".

How to 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".

How to unique column

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.

How to 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.

How to default value

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.

How to format in column types

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

How to format in number column type

When customizing your number field, the "Customize Column" menu contains a couple of options.
  1. 1.
    You can select whether you want your numbers to appear as integers (whole numbers) or as decimal numbers.
  2. 2.
    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.
  3. 3.
    You can also decide whether or not you want to allow negative numbers in this field.
  4. 4.
    Then click the "Save" button.

How to format in date&time column type

When customizing your date&time field, the "Customize Column" menu contains a couple of options.
  1. 1.
    You can choose "European", "US" and "ISO" formats according to the date format.
  2. 2.
    If you want it to include the time, mark the "Include time" field.
  3. 3.
    Then click the "Save" button.

How to format in percent column type

When customizing your percent field, the "Customize Column" menu contains a couple of options.
  1. 1.
    You can select whether you want your percent to appear as integers (whole numbers) or as decimal numbers.
  2. 2.
    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.
  3. 3.
    You can also decide whether or not you want to allow negative numbers in this field.
  4. 4.
    Then click the "Save" button.

How to reference another table column type

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.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options
  3. 3.
    You can choose "Reference Another Table" from column types.
  4. 4.
    In the window that opens, select the "Table" and "Lookup field" fields whose data you want to use from the "Reference table" field.
  5. 5.
    Click “Save” button.
  6. 6.
    Then click the "+" icon on the cell of the referenced column and select the rows you want to use from the corresponding pop-up window.
  7. 7.
    You can search from the corresponding pop-up window and mark the "Case sensitive".

How to 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.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    You can choose "Lookup Values" from column types.
  4. 4.
    In the window that opens, select the "Referenced Column" and "Lookup column" fields whose data you want to use from the "Lookup value" field.
  5. 5.
    Click “Save” button.
  6. 6.
    By selecting data from the Reference column, the data is pulled into the Lookup Values column.

How to roolup 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;
  1. 1.
    Right click on the column heading created.
  2. 2.
    Select "Customize Column" from the options.
  3. 3.
    You can choose "Rollup" from column types.
  4. 4.
    In the window that opens, select the "Referenced Column" and "Rollup column" fields whose data you want to use from the "Rollup" field. Choose a column that you want to rollup; this column will be used to bring in information from the other table you've linked to into the table where the rollup column is being created.
  5. 5.
    Select a way to aggregate the column values from the linked records. When you start editing the aggregation input, you will see suggestions for potential roll-up functions with a brief description.
  6. 6.
    You can insert various functions in this area; for a complete reference of rollup aggregation functions
  7. 7.
    Click “Save” button.
  8. 8.
    By selecting data from the Reference column, the data is pulled into the Rollup column. You'll see any values that can be rolled up from the linked table.

How to format in currency column type

When customizing your percent field, the "Customize Column" menu contains a couple of options.
  1. 1.
    You can select whether you want your percent to appear as integers (whole numbers) or as decimal numbers.
  2. 2.
    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.
  3. 3.
    You can also decide whether or not you want to allow negative numbers in this field.
  4. 4.
    You can change your currency symbol from the "Currency Symbol" field.
  5. 5.
    Then click the "Save" button.

How to format in URL column type

When customizing your percent field, the "Customize Column" menu contains a option.
  1. 1.
    You can give button text and button color to URLs with "Show As Button" option.
  2. 2.
    Then click the "Save" button.
  3. 3.
    Converts the URLs in the cell to the button text and button color in the customize column field.
  4. 4.
    When the button is clicked, it will open the page.

How to formulation in table

Formulas can be easily created in the cell. After adding "=" to the cell, the dropdown list appears at the bottom of the cell, the formulas are listed in this area. Its formulation can be applied in number and text column type.
If you want to create the formulation, follow the steps below;
  1. 1.
    Select the cells you want calculated after typing = in the cell.
  2. 2.
    Then select the relevant mathematical sign and select the corresponding cell.
  3. 3.
    After that select the corresponding cell and exit the cell.
  4. 4.
    If columns or rows are inserted between columns using the formulation, the formulas will be revised automatically.
Examples:
  1. 1.
    You can count cells containing numbers with the Count function. Example: =COUNT (A1: B6)
  2. 2.
    You can sum cells containing numbers with the sum function. Example: =SUM (A1: B6)
  3. 3.
    You can sum cells containing numbers with the sum function. Likewise, you can do the addition with commas. Example: =SUM (A1 + B2 + B6)
  4. 4.
    With the Average function, you can get the average of cells containing numbers. Example: =AVERAGE (A1: B2)
  5. 5.
    You can get the smallest of cells containing numbers with the min function. Example: =MIN (A1: B2)
  6. 6.
    You can get the largest number of cells containing numbers with the max function. Example: =MAX (A1: B2)
  7. 7.
    You can do it according to the priority of the four processes in the cell, regardless of the columns. Example: =((2 * 5) + 1-2) / 3
  8. 8.
    You can combine two cells with the Concatenate function. Example: =CONCATENATE (A2, B2)
  9. 9.
    You can format it with the DATEFORMAT function. Example: =DATEFORMAT(B2,'MM.DD.YYYY')
  10. 10.
    You can use TODAY function. Example: =TODAY()
  11. 11.
    You can use NOW function. Example: NOW()
  12. 12.
    You can use DAYS(end_date, start_date, date_format) function to find the days between two dates. Example: =DAYS(C4,B4)
  13. 13.
    You can collect an integer field with the date column type and create a finish date. Example: =ADDDAYS(C1,D1,US)
  14. 14.
    You can calculate working days with the WORKDAYS(start_date,end_date) function. Example: =WORKDAYS(C1,B1)

How to leave a comment, question or suggestion about the retable product

If you want to leave comments, questions or suggestions about retable, follow the steps below.
  1. 1.
    While in the table, click the "Feedback" button in the upper right corner of the screen.
  2. 2.
    Fill in the relevant information via the "Contact us" form that opens.
  3. 3.
    Then click the "submit" button.
  4. 4.
    If you want to rearrange the data in your submitted form, click the "Update Your Submission" button.

How to use mentioning

You can leave comments in different ways on Retable. Comments are useful to communicate changes, elaborate on issues, and collaborate with other people who have access to the base.
  • If you want to leave a comment for the row, you can mention it by opening the row detail pop up and come to the comment tab and use the @ symbol in the relevant field and send it.
  • If you want to leave a comment while chatting, you can open the chat window and use the @ symbol in the relevant field and send it.
  • If you want to leave a comment for the editing of the row, you can right click on the row, click the "Ask to update" function, select the relevant person using the @ symbol in the relevant field and send it.
@mentioning them will send them notifications and email.

How to split column data

To split a cell into multiple cells with delimeters, follow the steps below;
  1. 1.
    Select the column.
  2. 2.
    Hover over the column name and right click.
  3. 3.
    Choose "Split Column Data" function.
  4. 4.
    Select the Delimiters for your data. For example, comma and space.
  5. 5.
    Select "Preview", you can see a preview of your data in the Data preview window. Click "Save".

How to send selected data as email

If you want to send your selected data to collaborators via email, follow the steps below;
  1. 1.
    First of all, select the cells you want to send on the table.
  2. 2.
    Right click on row and select "Send as email" function.
  3. 3.
    In the "To" 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.
  4. 4.
    You can also select your collaborators using the @ symbol.
  5. 5.
    Click the "Send" button.

How to ask to update for 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.