Edit data in a table
To fill in the data in the table, enter data manually or copy and paste it from a file. You can paste up to 20 items at a time. A toolbar appears at the bottom, which shows the number of changes you made.
You can make multiple changes to the repository data simultaneously. All unsaved changes appear with a blue border. You can choose to hide or unhide the changes using the torch icon at the bottom.
Once you reach the 20-item limit (including pasted values), click Save changes at the bottom to continue adding more.
If you have unsaved changes and you try to leave the page, a pop-up gets displayed to save the changes. If you don’t want to save the changes, you can exit without saving.
Object questionnaire element format
Date: Displays in the format set in language settings in your browser.
For example, if the browser language is set to Dutch, the date is displayed in dd-mm-yyyy format. Refer to Language setting in browser section.Currency and Numbers: Follows the language settings in your browser.
Multi-line text and text: You can add text as much as you have configured in the questionnaire. You can resize the text box and add your content. To resize, double-click the text box and drag the two diagonal lines at the bottom-right corner.
.
NOTE: If you are not in edit mode and the text contains line breaks, the system pastes the data across multiple cells instead of a single cell.Checkbox: Instead of a checkbox, Yes/No is displayed. It is easier for you to copy the value across the column.
Radio dropdown: Select a value from the dropdown list. You can also copy a value from the list and paste it into multiple cells.
To manage the fields in the Questionnaire, refer to the Manage Object Questionnaires article.
Table Menu Options
The repository feature further allows you to customize the columns even further.
Click the three-dot Menu option next to the column name to display the menu options. These options provide flexible ways to organize, view, and analyze table data efficiently.
Menu | Description |
Sort by ASC | Sort the column in ascending order |
Sort by DESC | Sort the column in descending order |
Pin to left | Fixes the column to the left so you can always see it when you scroll across the table. |
Pin to right | Fixes the column to the right so you can always see it when you scroll across the table. |
Unpin | Removes the column from the fixed position |
Filter | This filter is applicable within the table on already loaded data. Currently, this is the only option to add a filter to the questionnaire fields. When you apply a filter to a column, a filter icon appears next to the column name. This helps you identify which columns have filters applied. |
Group by [field name] | Groups the whole table based on that column's values |
Hide columns | Hides the columns from the table |
Manage columns | You can choose the columns you want to show in the table |
Language Setting in Browser
The browser language and regional settings (such as date and time formats) can be different.
For example, in Chrome, you may set the browser language to English, but if Dutch is listed at the top of the preferred languages, Chrome will display dates and times in the Dutch format.
To control the display format, adjust the order of languages in your browser settings.