Help Center
Search for the articles here or browse the categories below.
Browse by topic
Find guides, tutorials, and answers organised by category.
Getting Started
Browse
templates
Browse
views
Browse
Column Types
Browse
Data Formats
Browse
Dashboards
Browse
Notification
Browse
Roles & Permissions
Browse
Guest Users
Browse
Workspace Administration
Browse
Super Admin
Browse
integration
Browse
Mobile Application
Browse
Product Terms & Polices Documents
Browse
Terms of Service
Browse
Popular articles
What other people are reading right now.
Form View
Form View in DataLexing offers a streamlined method for gathering information. Forms are automatically generated based on your existing table, allowing you to customize fields without the need to create a form from scratch. Creating a Form View To create a new Form View: 1. Within the table, click on the "+" sign above the search bar. 2. From the drop-down menu, select Form view. 3. A box will appear to enter a name for the viewโchoose a descriptive name that reflects its content. 4. Click "Add" to save the new view. Once the Form View is created, you can structure the displayed information in multiple ways. You can modify field visibility, adjust the order, and customize how users interact with the form. Survey Mode The Form View offers two display modes: - Form Mode: All fields are visible in a vertically stacked layout. - Survey Mode: Only one field is visible at a time, enhancing focus. Switching Between Modes To select a mode: 1. Click the Paper icon at the view editing bar. 2. Choose Form Mode or Survey Mode. Customizing the Form Submit Button Display To change the Submit button text: 1. Click the pencil icon next to the 'Submit' button. 2. Enter the desired text. Adding Fields/Questions you can think of fields as questions in form view. Adding fields to a form is straightforward: 1. from the left sidebar to select and add the required fields. 2. Click Add All to insert all available fields. 3. To create a new field that isnโt already in the table, select + Add new field from the Fields sidebar. Unsupported Field Types the following field types are not compatible with Form View: - ๐พ Created on - โ๐ป Last modified - ๐งฎ Count - ๐ฆ Rollup - ๐ฆ Lookup - โจ AI - โ Formulas - ๐ฅ Collaborators Reordering Fields You can rearrange questions in your Form View: 1. Drag fields using the drag handle (โ ฟ). 2. Drop at the desired Location. Removing Fields To remove a field from the form: 1. Locate the field. 2. Click the Trash icon to remove it. To Remove all the fields: Click Remove all button in the left fields side bar. Custom Branding to enhance form with branding elements: Add a Logo: 1. Click the Grey Circle at the top of the form. 2. upload an image from your device. Add a Cover: 1. Click the Grey Area at the top of the form. 2. upload an image from your device. To replace or remove an image, simply select the current image and upload a new one. Custom Context Enhance form context by adding form title and descriptions for form and fields. Add Form Title 1. Click the Title written in grey, in the beginning of the form. 2. Write a Form Title. Add Form Description 1. Click the Description written in grey, in the beginning of the form. 2. Write a Form Description. Customize Form description via text editor provided. add headers, links. Add Fields Description 1. Click the Description written in grey, under fields name. 2. Write field Description. to describe the field required. Required Fields Required fields are essential in form design because they ensure that users provide critical information before submission. This helps maintain data accuracy, completeness, and consistency. To make a Field mandatory to fill: 1. Locate the Desired Field. 2. Turn on the toggle for Required. Form Conditions (Conditional Logic) Form conditions help tailor the user experience by dynamically showing, hiding, enabling, or requiring fields based on user input. They improve efficiency, reduce clutter, and ensure relevant data collection. To Allow Conditions: 1. Turn on the toggle for Show when conditions are met. 2. Apply 1. ๐ต Choose a field. to show a certain fields in conditions, you should add the column that you are filtering on before the filtered column 2. ๐ข Choose a Condition. 3. ๐ด Choose a Value. For example, if you want to collect additional feedback when a user submits a very low score. Configuring Post-Submission Actions After a form is submitted, you can choose what happens next: Show a Custom Message 1. Choose Show a message, at the end of the form. 2. Enter a message in the Show a message box. 3. This message will appear AFTER submission. Redirect to a URL 1. Choose Redirect to URL, at the end of the form. 2. Enter the URL where users should be redirected after submission. Previewing a Form Before sharing a form, preview it: - Click the eye icon to open the form in a new tab. - Alternatively, copy the private link and paste it into a browser. Sharing a Form to Share form internally with users that have access to the forms table: 1. Click Share Form icon at the top corner of the view. 2. Copy the link. 3. Share it. note: Only people with access permission to this view can see it using this link. You can use. to learn more about access click here. Publishing a Form Once your form is designed and tested, publishing it involves making it accessible to audience while ensuring security, usability, and data collection efficiency. to Publish a form: 1. Click Share Form icon at the top corner of the view. 2. Go to publish tab. 3. Click Publish. 4. Copy the link. 5. Share it. note: there are options to Restrict Access with Password, Change the Link or Unpublish the Link. For more details, visit the public sharing section in DataLexing. Viewing Submitted Form Data Submitted form data automatically generates a new record in the original table. Entries appear at the bottom of the Grid View, if they are not hidden or sorted in a way that excludes them. Changing Form Language this option is available for users (audience) felling the form. Change Language to English 1. Click the Arabic Icon , in the right upper corner of form page. 2. Change the Language to English. Change the Language to Arabic 1. Click the English Icon , in the right upper corner of form page. 2. Change the Language to Arabic. Conclusion With DataLexingโs Form View, you can effortlessly collect and manage data, apply branding, automate processes, and customize user interactions. Whether using Form Mode or Survey Mode, the flexibility ensures an efficient data collection experience.
๐๏ธ viewsSheet View
Sheet View provides a spreadsheet-like interface for managing tabular data efficiently. Key features include: - Replace Excel with dynamic tables that integrate permissions and collaboration tools. - Filter and sort data to focus on specific information. - Publish filtered data or tables with hidden columns as view-only. - Import data with smooth mapping and export it as needed. - Apply row coloring to visually organize and highlight data. - Interact with tabular data seamlessly for efficient management. ๐ก By creating a new sheet, you can share a specific portion of your data with your colleagues. Create New Sheet 1. Within the table, click on the "+" sign above the search bar. 2. From the drop-down menu, select Sheet view. 3. A box will appear to enter a name for the viewโchoose a descriptive name that reflects its content. 4. Select who can edit: - Collaborative for team access and editing. - Personal for individual use. 5. Click "Add" to save the new view. Filter Sheet View Sheet views can be filtered to quickly find tasks matching multiple criteria. Select two or more filters from the available list to refine your results. For example, you can limit the inbox to display only "Demo Call" tasks. To apply custom filters: Filter Sheet View 1. Within the table, click on the funnel icon in the view bar. 2. A box will appear; click on "Add filter." 3. Three fields will appear: 1. Choose a Column 2. Choose a Condition 3. Choose a value to Filter by. 4. The filter will be applied directly to the view, updating the displayed data according to your selected criteria. Sort Sort Sheet View Sorting data is essential for organization and workflow efficiency. DataLexing simplifies this by allowing sorting based on selected fields. Sorting can be done automatically to control rows order. - Default Sorting: New tables are initially sorted by row creation time. - Automatic Sorting: Sort Sheet View 1. Click the Sort button in the view bar. 2. from the dropdown list, Choose a field to sort by. 3. Choose a Sorting Criteria 4. Rows will be automatically ordered based on the selected field. 5. Add multiple sorting criteria if needed, ensuring they are arranged in the correct sequence. 6. To remove a sorting option, click the trash button next to it. Another way to manage Sorting is by opening an expanded view or clicking on the field header and selecting Sort field from the dropdown menu. - Manual Sorting: Users can manually reorder rows by grabbing the handle next to the row number and moving it to the desired position. Share After creating a sheet view, you can share it via a link with anyone who has access or publish it on the internet. You also have control over how the shared data appears by using filters or hiding fields. To learn more about sharing, click here. Show/hide - Hide Fields: - This feature allows choosing which fields remain visible in a shared view. - The primary field cannot be hidden. - How to show/hide fields: 1. Click the Eye button in the view bar. 2. Use the toggle switch next to each field name to show or hide it. 3. Click Hide all or Show all for quick adjustments. 4. A preview will indicate the number of hidden fields. If dealing with numerous fields, use the Search fields box to locate specific ones quickly. Another way to manage field visibility is by opening an expanded view or clicking on the field header and selecting Hide field from the dropdown menu. Adjust Columns width By default, sheet views display columns with a fixed width. However, to view more data within each cell, the column width can be adjusted. This feature allows customization based on the content within each column. Adjust Columns width To adjust a Column width: 1. Click and hold the dividing line next to the field title. 2. Drag the line to increase or decrease the width. A grey bar will appear as an indicator. 3. Release the mouse at the desired width to display more information in each cell. Reorder Columns By default, sheet views arrange columns in the order they were created. However, you can reorder them by: - Clicking and dragging the column to the desired location. - Using the Show/Hide Fields option to click and drag columns according to the desired location. Footer Aggregations Footer aggregations calculate values based on a specific field in a table. By default, footer summaries are empty, but they can be customized for insights. For more details, click here
๐ Column TypesFormulas
Formulas Datalexing formula fields let you calculate a value automatically for every cell in a field, based on a formula you define. The syntax works much like the formulas you already know from spreadsheet tools โ combined with a fast, growing function library built for tables. A formula is built from two building blocks: - Operators โ symbols (+, =, >, etc.) that act directly between two values. - Functions โ named, predefined calculations (e.g. SUM, IF, LEFT) that take arguments, do something with them, and return a result. On this page - Operators - Function categories at a glance - ๐ Text functions - ๐ข Number functions - โ Logical (True/False) functions - ๐ List & Aggregation functions - ๐ General & Reference functions - ๐๏ธ Date & Time functions - ๐ Link functions - Editor's notes โ what changed Operators Operators are symbols that perform arithmetic, comparisons, or text joins directly between two values, without needing to write a function name. Most operators have a matching function that does the exact same thing (listed below) โ use whichever reads better in your formula. Operator Function equivalent Description Example + ADD Adds two numbers and returns the sum. 1 + 2 = 3 - MINUS Subtracts the second number from the first. 10 - 2 = 8 * MULTIPLY Multiplies two numbers together. 10 * 3 = 30 / DIVIDE Divides the first number by the second. 10 / 5 = 2 = EQUAL Returns TRUE if the two values are equal, FALSE otherwise. 10 = 10 โ TRUE != NOT_EQUAL Returns TRUE if the two values are not equal, FALSE otherwise. 10 != 10 โ FALSE > GREATER_THAN Returns TRUE if the first value is greater than the second. 10 > 11 โ FALSE >= GREATER_THAN_OR_EQUAL Returns TRUE if the first value is greater than or equal to the second. 10 >= 10 โ TRUE < LESS_THAN Returns TRUE if the first value is less than the second. 10 < 11 โ TRUE <= LESS_THAN_OR_EQUAL Returns TRUE if the first value is less than or equal to the second. 19 <= 1 โ FALSE Function categories at a glance Every function in Datalexing belongs to one of the categories below, shown by an icon. Here's what each one actually covers: Category Covers Text Reading, cleaning, and transforming text strings. Number Arithmetic, rounding, and mathematical calculations. Logical Comparisons and conditions that return TRUE or FALSE . List & Aggregation Summarizing values pulled in through a link/lookup field (sums, averages, counts, filters...). General & Reference Functions that pull in or combine data across any type โ a field's raw value, a linked table's value, a row's ID โ rather than being limited to text or numbers. Date & Time Creating, formatting, and measuring dates and timestamps. Link Building and reading clickable buttons and hyperlinks. *Related: Column Types ยท Formulas Guide ยท *Score Cards
๐๏ธ viewsViews Settings
How to Duplicate View 1. From the view setting in the right corner 2. From the view list. click the ellipsis next to the view name 3. Choose "Duplicate" 4. Click "Duplicate" How to Rename View To rename a view: 1. From the view setting in the right corner 2. Click on the three dots (...) next to the view you want to rename. 3. Click "Rename" 4. Double-click the "Enter view name" field. 5. Write the new view name 6. Click "Save" 7. As you can See the View has been renamed from "All Projects 2" To "Projects Overview" How to Delete View To delete a view: 1. From the view setting in the right corner 2. From the view list. click the ellipsis next to the view name 3. Choose "Delete view" 4. Click "Delete"
๐ Getting StartedWorkspaces
Overview You can join multiple workspaces and switch between them from the dashboard. When you create a DataLexing account, a default workspace is provided for free. If a colleague invites you to their workspace, you can join it as well. Users on Trial, Pro, or Growth plans are limited to one workspace but can still be invited to other workspaces created by other members. Important Notes: - Each workspace operates independently, meaning data cannot be transferred or linked across workspaces. - It is recommended to keep related applications within the same workspace for better organization. - You can switch between workspaces via the sidebar. Collaborating in a Workspace Managing Access & Permissions Workspaces allow you to define access levels for team members by assigning roles. You can specify who can: โ View, edit, or comment on Applications, tables, views, and records. โ Create or delete Applications. โ Invite new members and manage external sharing. Inviting Members Collaboration is easy in DataLexing. To invite team members: 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace. 3. Click the ellipses (...) next to the workspace name. 4. Select "Add Members" and enter their email addresses. 5. Invited users will receive an email with instructions to join. For further details, refer to our support article on inviting collaborators. Setting Up a Workspace When you sign up for DataLexing, a default workspace is automatically created. Applications belong to a workspace, meaning you must either create a new workspace or be invited to an existing one to start building applications or tables. Creating a Workspace Only Enterprise plan users can create new workspaces. To create a workspace: 1. from the sidebar, Click on Arrow next to workspace name 2. at the bottom of the list, click + Add new workspace. 3. Enter a workspace name to reflect its purpose (e.g., team activities, product launches, or project management). 4. You can rename the workspace at any time. Once created, you automatically become the workspace admin, allowing you to: - Add Applications and tables. - Invite Members. Workspace Settings To access workspace settings: 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace. 3. Click the ellipses (...) next to the workspace name. Renaming a Workspace (Only available to workspace admins) Rename Workspace 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace. 3. Click the ellipses (...) next to the workspace name. 4. Choose "Rename" 5. enter the new name 6. click Save. Leaving a Workspace How to Leave a Workspace If you wish to leave a workspace: 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace. 3. Click the ellipses (...) next to the workspace name. 4. Select "Leave Workspace", then confirm by clicking "Leave". Once you leave, you will lose access to all applications within that workspace. However, the workspace will remain accessible to other members. To regain access, a workspace admin must re-invite you. Leaving as the Last Admin If you are the only admin, you cannot leave the workspace unless: 1. Assign another member as an admin via the Members settings page. 2. Delete the workspace (if you donโt want others to retain access). Deleting a Workspace (Only available to workspace admins) To permanently delete a workspace: Delete Workspace 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace from the dashboard or sidebar. 3. Click the ellipses (...) next to the workspace name. 4. Select "Delete Workspace", confirm the warning message, and click "Delete". โ ๏ธ Note: Deleting a workspace is permanent. If you no longer need a workspace but want others to retain access, consider transferring ownership instead. Copy Workspace ID To copy workspace ID: Copy Workspace ID 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace from the dashboard or sidebar. 3. Click the ellipses (...) next to the workspace name. 4. Select "Copy Workspace ID". Viewing Deleted Items (Trash) To access the workspace trash: View Trash 1. from the sidebar, Click on Arrow next to workspace name 2. Select the workspace from the dashboard or sidebar. 3. Click the ellipses (...) next to the workspace name. 4. Select "View Trash" from the pop-up menu. โ ๏ธ Only Workspace Admins can See & Restore workspace trash. For details on restoring deleted items, refer to our support article. This version improves clarity, structure, and flow, making it easier to read and understand. Let me know if you need any refinements! ๐
๐ Column TypesNumber Functions
๐ข Number Functions Arithmetic and mathematical calculations. Function Description Syntax Parameters Example ADD Adds two numbers together. Same as the + operator. ADD(Number, Number) Number 1 โ the first number. Number 2 โ the second number. ADD(1, 2) = 3 MULTIPLY Multiplies two numbers together. Same as the * operator. MULTIPLY(Number, Number) Number 1 โ the first number. Number 2 โ the second number. MULTIPLY(2, 5) = 10 DIVIDE Divides the first number by the second. Same as the / operator. DIVIDE(Dividend, Divisor) Dividend โ the number to divide. Divisor โ the number to divide by. DIVIDE(10, 2) = 5 ROUND Rounds a number to a given number of decimal places. ROUND(Number, Digits) Number โ the value to round. Digits โ how many decimal places to round to. ROUND(1.12345, 2) = 1.12 TRUNC Truncates a number to its integer part, discarding any decimals (no rounding). TRUNC(Number) Number โ the value to truncate. TRUNC(1.49) = 1 FLOOR Rounds a number down to the nearest integer. FLOOR(Number) Number โ the value to round down. FLOOR(1.51) = 1 FLOOR(-1.49) = -2 CEIL Rounds a number up to the nearest integer. CEIL(Number) Number โ the value to round up. CEIL(1.49) = 2 CEIL(-1.51) = -1 ABS Returns the absolute (non-negative) value of a number. ABS(Number) Number โ the value to convert. ABS(-1.51) = 1.51 SIGN Returns 1 for a positive number, -1 for a negative number, 0 for zero. SIGN(Number) Number โ the value to evaluate. SIGN(-9.0) = -1 GREATEST Compares two numbers and returns the larger one. GREATEST(Number, Number) Number 1 , Number 2 โ the values to compare. GREATEST(1, 2) = 2 LEAST Compares two numbers and returns the smaller one. LEAST(Number, Number) Number 1 , Number 2 โ the values to compare. LEAST(1, 2) = 1 MOD Returns the remainder after dividing the first number by the second. MOD(Number, Number) Number 1 โ the dividend. Number 2 โ the divisor. MOD(5, 2) = 1 MOD(-3, 2) = -1 POWER Raises a number to the power of an exponent. POWER(Number, Exponent) Number โ the base. Exponent โ the power to raise it to. POWER(3, 2) = 9 POWER(25, 0.5) = 5.0 SQRT Returns the square root of a number. Returns NaN for negative or invalid input. SQRT(Number) Number โ the value to find the square root of. SQRT(9) = 3 SQRT(-4) = NaN EXP Returns Euler's number (e โ 2.718) raised to the power of the given number. EXP(Number) Number โ the exponent to raise e to. EXP(1) = 2.718 EXP(0) = 1 LOG Returns the exponent to which a base must be raised to produce a given number. LOG(Base, Number) Base โ the base of the logarithm. Number โ the value to find the exponent for. LOG(3, 9) = 2 EVEN Returns TRUE if a number is even, FALSE otherwise (including for invalid input). EVEN(Number) Number โ the value to check. EVEN(2) = true EVEN(5) = false TONUMBER Converts a text value into a number, if possible. TONUMBER(Text) Text โ the text to convert. TONUMBER('10') = 10 IS_NAN Returns TRUE if a value is NaN (Not a Number), FALSE otherwise. IS_NAN(Number) Number โ the value to check. IS_NAN(1 / 0) = true WHEN_NAN Returns a fallback value if the first argument evaluates to NaN ; otherwise returns the first argument. WHEN_NAN(Number, Fallback) Number โ the value to check. Fallback โ the value to use if it's NaN . WHEN_NAN(1 / 0, 4) = 4 WHEN_NAN(1, 4) = 1