admin

Introduction In Table Editor, you can easily change the order of columns in your DataTables using the drag-and-drop feature. This allows you to rearrange the columns as desired without modifying the underlying data.

Introduction In Table Editor, you can use the IF function in the renderer to display content based on conditions, similar to how you use the IF function in Excel. For example, if you have a column containing license types (user, concurrent, site), you can display the corresponding description using an IF condition in the renderer. … Read more

Introduction In Table Editor, you can concatenate data from any two columns when using JSON as a data source. This works similarly to using formulas in Excel to merge two cells. For example, if you have 8 fields from A to H, you can merge data from columns A and B to create a new … Read more

Introduction This feature allows you to automatically convert cell data into clickable links. For example, if a cell contains “TokyoStation,” it will be displayed as a link leading to a Google Maps search for that location. Steps to Implement Step 1: Access Column Settings Step 2: Add Code to the “Renderer” Field Step 3: Save … Read more

About formatting numbers with thousand separators, you can achieve this in Table Editor by using the following JavaScript function in the Renderer field Here’s what each parameter does: Displayed Output: 1,200,000 $

How to Create a Table from Google Sheets

To create a Google API key for accessing Google Sheets, you need to follow these steps: Step 1: Go to the Google Cloud Console Step 2: Create a Project Step 3: Enable Google Sheets API Step 4: Create Credentials (API Key)