Table properties pane¶
Toolbar > New project¶
Click on this icon to start a new empty project. This is the starting point for any AppGini application. You will have an empty project that contains only an empty database and predefined default styles.
Table properties > Table view title¶
The table view title is the title of the table as it will appear in the pages of the generated PHP application.
Toolbar > Open Project¶
Click on this icon to open a previously saved project.
Toolbar > Save Project¶
Click on this icon to save the currently open project. If you haven't saved your project before, you'll be prompted for a file name and location.
Toolbar > Project Properties¶
Click on this icon to bring the Project Properties area where you can specify the database connection parameters.
Toolbar > Application Theme¶
Click on this icon to preview (and edit) the theme of your application.
Toolbar > New Table¶
Click on this icon to add a new table to your database.
Toolbar > New Field¶
Click on this icon to add a new field to the current table.
Toolbar > Delete Selected Table/Field¶
Click on this icon to remove the highlighted field or table from your database.
Toolbar > Move Table/Field up¶
Click on this icon to move the highlighted field down/up in the current table.
Toolbar > Move Table/Field down¶
Click on this icon to move the highlighted field down/up in the current table.
Toolbar > Generate PHP Code¶
Click on this icon to let AppGini generate the PHP code for your web database application based on the database, tables and fields you defined in your project. You'll be prompted for a location to save the generated files.
Toolbar > Preferences¶
Click on this icon to open the preferences window, where you can set various AppGini options.
Toolbar > Help¶
Click on this icon to view the online help.
Toolbar > About AppGini¶
Click on this icon to view version and contact information for AppGini
Toolbar > Ideas and tips on our Twitter page¶
Click on this icon to visit (and optionally subscribe to) our Twitter feed, which includes a lot of helpful resources and tips to get the most out of AppGini.
Toolbar > Learn to use Appgini through our YouTube playlist¶
Click on this icon to visit (and optionally subscribe to) our Youtube channel where you can watch many short video tutorials explaining various features of AppGini.
Toolbar > Exit¶
Click on this icon to quit the program. If you have an open project, you'll be asked to save your work first.
Project Browser Window¶
This is the project browser window where you can see a list of the database, table and field names in the current project arranged in a hierarchical view. Click on any item on the window to view and edit its properties in the Properties window.
Table properties > Table view title¶
The table view title is the title of the table as it will appear in the pages of the generated PHP application.
Table properties > Description¶
If you provide a description for the table, this description will be displayed in the home page of the generated application. You can use HTML code in this description.
Table properties > Records per page¶
The number of records that appear on one page in the generated PHP application. Records are displayed as horizontal rows of a table. If you put a large number here, your application user might have to scroll down the page to view records.
Table properties > Show quick search box¶
If you want to display a quick search box above the table view, check this option. When the user enters a word in that search box and clicks the search button or presses Enter key, the table is searched for matches in any field. This is much easier than the advanced filters if you want a simple search technique.
Table properties > Default sort by,Descendingly¶
If you'd like records in the table view sorted by default, select the field that you want to sort by from the 'Default sort by' drop down. The default sorting direction is ascendingly (A-Z, 0-9) unless you check the 'Descendingly' option. If you don't want any default sorting, select 'None' from the 'Default sort by' drop down.
Table properties > Allow sorting¶
This option controls whether users are allowed to sort records in the table or not. Note that this doesn't affect the table in the database, only the query that displays data to the user.
Table properties > Allow filters¶
This option controls whether users are allowed to filter records in the table or not. Note that this doesn't affect the table in the database, only the query that displays data to the user.
Table properties > Allow saving data to CSV files¶
If you check this option, users will see a Save button above the table view that allows them to save data as a CSV file (Comma-Separated values).
Table properties > Allow print-view¶
This option controls whether users are allowed to view the table data as a printer-friendly page.
Table properties > Allow users to save filters¶
If you check this option, users will see a Save button in the filters page. If they click this Save button, they will view some HTML code that they can copy and paste to any external web page. This HTML code creates a button linking users to the filtered table view (without having to redefine filters). TIP: Usually, you would want to allow this option temporarily till all users have determined which preset filters they want to save. Later on, you can disable this option and regenerate the code.
Table properties > Hide link in homepage¶
If checked, this table will not have a link to it in the homepage of the generated application. Usually used with the option 'Hide link in navigation menu' checked as well. This is useful for example if this is a child table and you want users to access it only from its parent table rather than directly through a link.
Table properties > Allow mass delete¶
This option controls whether users who have permission to delete records can delete multiple records at once.
Table properties > Filter before showing table view¶
When this option is checked, users see the filters page first before seeing the table data. This is useful if you want users to search the table and display the search results to them.
Table properties > Hide link in navigation menu¶
If checked, this table will not have a link to it in the navigation menu of the generated application. Usually used with the option 'Hide link in homepage' checked as well. This is useful for example if this is a child table and you want users to access it only from its parent table rather than directly through a link.
Table properties > Show record count in Homepage¶
Check this option to display the count of accessible records of this table in the application homepage.
Table properties > Table group¶
Click this button to open the Table group dialog, where you can group tables for easier navigation.
Table properties > Table template¶
Click this button to open the Table view template dialog, where you can configure layout options of the table view for this table.
Table properties > Detail view title¶
The title of the detail view form. The detail view form is where users can edit and add data to the table.
Table properties > Redirect after insert¶
If you type a web address here, users will be sent to that address after they insert a new record. If you leave this box empty, users will be sent to the table view page. If you add the characters #ID# as part of the web address, they will get replaced by the primary key value of the newly inserted record. For example, these are valid addresses that you can put into the box: thanks.html
Table properties > Display a link to children records from¶
If you have lookup fields in other tables whose parent table is set to the current table, you'll find them listed here as children tables. If you check any of the children tables listed here, users will see a link to that table displayed in the detail view when a record is selected from the current (parent) table. This link displays records of the child table related to the current parent record. For example, you may have an artists table, and a songs table. The songs table has an 'Artist' field whose parent table is the artists table. Using this feature, users who select an artist from the artists table will see a 'songs' link in the detail view of the selected artist. Clicking on that songs link, users will see all the songs that belong to the selected artist.
Table properties > Default focus field¶
Specify which field (if any) is focused by default when the user opens the detail view.
Table properties > Enable detail view¶
Use this option to control whether users can see the detail view or not.
Table properties > Allow detail print-view¶
If you check this option, users will see a 'Print preview' button in the detail view when selecting a record. Clicking that button would display a printer-friendly view of the selected record.
Table properties > Hide 'Save As Copy' when editing¶
By default, when a user selects a record for editing, the 'Save As Copy' button is displayed in the detail view so that the user can save a copy of the selected field. Checking this option would disable this behavior and the 'Save As Copy' button won't be displayed.
Table properties > Allow adding new records from Homepage¶
If you check this option, users with insert permission can directly add records to this table from the homepage, without having to navigate to the table and click the Add new button in there.
Table properties > Delete records even if they have children records¶
The default behavior when a user tries to delete a record is that the AppGini-generated code will check to see if this record has one or more child records (records that have lookup fields pointing to the record to be deleted). If one or more children are found, the record is not deleted.
Table properties > Display detail view in a separate page¶
If you check this option, the detail view (the form where users can add or insert records) will be displayed in a separate page instead of below the table view.
Table properties > Keep action buttons visible while scrolling down¶
For long detail view forms, we recommend checking this option so that the action buttons (Save changes, Back, Print preview, Delete, .. etc) are always visible to the user, without having to scroll up/down to find them.
Table properties > Table technical documentation¶
This section is where you can edit and preview the technical documentation of this table. The technical documentation is useful for adding notes and technical descriptions for your project, tables and fields. It's not visible to your app users, but can be viewable in the admin area if the option Show technical documentation page in the admin area under project properties is checked.
Table properties > Edit Technical Documentation¶
Click this button to open the technical documentation editor for this table.
Table properties > Technical documentation preview¶
Here you can see a preview of the technical documentation for this table.
Table properties > Parent/Children settings¶
This feature is enabled only if the current table has children tables. Displays settings for showing the children records in the detail view.
Table properties > Table icon¶
Click this icon to select a new icon for the table. The table icon is displayed in the homepage and the navigation menu of the generated application.
Search box¶
You can use this box to search for a specific table/field by typing its name or part of it then clicking the lens icon. Click it again to move to the next matching table/field.
File menu¶
Includes commands for starting a new project, opening an existing one, importing from an existing MySQL database or a CSV file, and saving current project.
Tables menu¶
Includes commands for adding and deleting tables and fields from the current project.
Project menu¶
Includes commands for generating the web application, and for changing the application theme.
Add-ons menu¶
Open this menu to see a list of available AppGini add-ons and plugins that can enhance your project and add more functions to it.
Help menu¶
Includes various help resources
Copy¶
Copies the selected table or field to the clipboard
Paste¶
Pastes a copy of the field or table in the clipboard to the project
Toggle Highlight¶
Marks/unmarks the current table or field with a yellow background for easily returning to it later on.
Activate/deactivate help for toolbar icons¶
Click this icon to switch to help mode where clicking any icon would show its help rather than execute its action. Click again to switch to normal mode.