Fields order and totals Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using PHPRunner
Working with projects
Templates
What are templates
Cars
Classified ads
Events
Jobs
Knowledge base
News
Paypal
Real estate
Sporting
Vacation houses
Connecting to the database
Datasource tables
SQL query page
About SQL query designer
Query Designer
SQL
Results
Charts
Creating chart and setting parameters
Chart appearance
Using SQL to shape chart data
Reports
Creating report and setting parameters
Report totals and layout
Choose pages
Login page
User login settings
Advanced security settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
"View as" settings
"Edit as" settings
Validation types
Lookup wizard
Events
Output directory settings
After you are done
FTP upload
FrontPage Publishing
Advanced topics
Events
More info about events
Global events
Table events
Page life cycle overview
Predefined actions
Send a simple email
Send an email with new data
Save new data in another table
Insert a record into another table
Check to see if a specific record exists
Display a message on the Web page
Redirect to another page
Custom code
Sample events
Show list of customer orders
Check if start date is ealier than end date
Before deleting a record check for related records
Speed up data entry using events
Publishing PHP application to the remote Web server
Using FTP client to publish PHP pages to the remote Web server
Using FrontPage to publish PHP pages to the remote Web server
Demo Account
What is the Demo Account?
Terms and Conditions
Connect using PHP
Master-details relationships
Using JOIN SQL queries
AJAX-based Functionality
PHPRunner session variables
Debugging tips
Template files processing rules (Files.txt)
Multilanguage support
Useful functions and links
Smarty templates
Stylesheets
Template language
How to control Inline Add/Edit functionality from script
Rich Text Editor plugins
Upgrade Guide from PHPRunner 3.0 and older
PDF view settings
Order PHPRunner online

 
  PHPRunner manual


Fields order and totals

 

This page allows to set fields order on each page. To change fields order on specific page make this field or several fields selected and click on Up/Down buttons to move it up or down. Also you can use Drag & Drop to move fields.

- to apply changes to all tables click this button.

Menu tab - Allows to change the order of tables on the menu.php page. This tab is available when more than one table had been chosen for this project. On the ..._list.php page Quick jump box will appear which contains list of tables for quick jump between tables.

On the list and printer-friendly page you can choose between horizontal and vertical layouts. To switch layout check off or uncheck Vertical layout checkbox.

Records per row - put any number greater than one there to display several records per row on list and printer-friendly pages.

Also you can add totals calculation to some fields on the list/printer-friendly pages. Totals calculation is available with horizontal layout only. You can choose between TOTAL, AVERAGE and COUNT aggregate functions. To do it select the field/fields you want to add totals calculation to and choose function type from drop-down box.

 

The CHM file was converted to HTML by chm2web software.