It is also possible to spotlight search by code ID in filters, meaning searching for dimension items by their IDs, if the user has selected the Labels->ID or Labels->Both option.
Stat Suite JS 8.0.0, the option is also applied to all filter titles and filter values.
To format a column data, click the Dropdown icon and click Format menu.
This section will learn how to define Background & Text Colors for a Column. Tap the data, DbFace will popup a smart toolbar that you can
To export the current data, choose format, and click the corresponding button, you can export data to CSV, PDF and email. Now you apply the "timestamp_to_date" function to an unix timestamp field. We define a function that convert timestamp to readable date string.įunction timestamp_to_date ( UNIX_timestamp ) You can code your own formatter functions for fields in DbFace.Ĭlick "Settings" and open the "Customization" page, select the "Functions(javascript)" tab, here you can code global javascript functions, DbFace will load these codes while page loaded. You might want to navigate to other tables by value, this feature helps you to do this easily.Ĭlick the "Field Settings" link at the column, at the "Field Settings" page, select the table column your want to link, click "Save" button to apply this change.Īfter this change, the value will convert to link, click value to navigate to other table with the selected data value. You can save your frequently-used filter conditions. Filter #Ĭlick the "Filter" button to open the filter condition editor. Insert Row #Īt the table editor page, click the "New Record" link to open the row data editor, you can select a single row of data, DbFace will copy the seclected row data to the editor automatically.Īfter edited the row data, click "Save Change" button to apply this new row data.
The database table require a primary key to make update function work.
How to use Form variables in applications.