If you are still using the legacy tools, it’s time to move forward. The legacy tools will soon disappear from the WP Data Access dashboard. Although you can stay on an older version, we recommend moving forward as soon as possible. The App Builder contains many more features than the legacy tools and has a much more intuitive user interface. Once you start updating, you will soon experience the power and ease of the App Builder.
Getting Started #
The App Builder contains several builders:
– Table Builder
– Form Builder
– Map Builder
– Chart Builder
– Dashboard Builder
Each legacy tool had its own user interface. That is different with the App Builder. Although the App Builder contains multiple builders, each performing its own specific tasks and specific functionality, they all share the same user interface. This makes understanding the interface and working with it much easier. The best approach is to update your current applications one by one, starting with the simplest ones. We’ve described the steps necessary for each builder below.
A video tutorial to get started is available here:
https://docs.rad.wpdataaccess.com/getting-started-video-tutorial.html
The full and extensive App Builder documentation can be found here:
https://docs.rad.wpdataaccess.com/
Tables #
This section describes how you can convert a legacy table to a Data Table or Data Administration app.
To convert a legacy table to an app, you first need to recognize the main purpose of the table:
– Is it a read-only table? > Create a Data Table app.
– Does the table allow inline editing? > Create a Data Administration app which supports transactions.
Converting a legacy table:
– Open two browser tabs or windows, one for the legacy table and one for the App Builder.
– In the App Builder, click the “Create New App” icon on the toolbar.
– This opens the App Wizard.
– Select app type Data Table or Data Administration.
– Enter an app name and description.
– If you have a premium license, you can also change the language. The App Builder contains 35+ languages.
– Click the NEXT button to move to the Data Source tab.
– In your legacy app, check the database and table name.
– Enter the database and table name in the App Wizard.
– Check which column names are used in the legacy table.
– Select these columns in the App Wizard.
– Click the NEXT button to move to the Authorization tab.
– For Data Table apps you will typically select anonymous access.
– For Data Administration apps we recommend configuring authorized access.
– Save your app.
You can change your app configuration settings at any time later in the App Manager. The table layout and behavior can be configured in the Table Builder, which is accessible through the builder icon on the table toolbar.
Configuring the table:
– Click the Run & Builder link or icon in the App Builder to open your app.
– Click the builder icon on the table toolbar to start configuring the layout and behavior of your table.
– Check the table specific settings in your legacy table and find the similar options in the Table Builder.
Extensive documentation is available here:
https://docs.rad.wpdataaccess.com/table-builder/menu/menu.html
If you cannot find options, use the search option or ask for support.
Most commonly used options in legacy tables:
– Default where
Available from the table menu, section default where.
– Default order by
Available from the table menu, section default order by.
– Server-side versus client-side processing
Available from the table menu, section performance.
– Column filters
Available from the table menu, section column filters.
– Responsiveness (default = responsive)
Available from the table menu, section layout & responsiveness.
– Column visibility
Available from the columns menu. Can be updated inline.
– Column labels
Available from the columns menu. Can be updated inline.
– Column alignment
Available from the columns menu. Can be updated inline.
– Column ordering
Available from the columns menu through drag and drop.
– Dynamic hyperlinks
Are called computed fields in the Table Builder. Available from the columns menu. See the documentation for more information:
https://docs.rad.wpdataaccess.com/table-builder/menu/columns/computed-fields.html
– Custom queries (now also available for free users)
Following a different approach now as explained here:
https://docs.rad.wpdataaccess.com/table-builder/custom-queries.html
– Styling
Via the theme menu for premium users. Custom styling is available from the table menu, section css table editor.
– Export
Available from the table menu, section bulk actions.
– Lookups
Available from the columns menu, section lookup.
– Advanced settings
Now much more powerful, called hooks, available from the hooks menu.
Many options in the Table Builder are new and have no equivalent in the legacy tools.
Forms #
The App Builder supports two types of form apps:
– Data Administration apps
– Registration Form apps
Legacy forms managed their own table settings. The Form Builder, however, does not manage table settings. This is done by the Table Builder, which is naturally integrated for a seamless user interface and much more powerful table features in data administration apps. When converting a legacy form, the table configuration is defined in the Table Builder and the form configuration in the Form Builder.
Converting a legacy form and its templates:
– Open two browser tabs or windows, one for the legacy form and one for the App Builder.
– In the App Builder, click the “Create New App” icon on the toolbar.
– This opens the App Wizard.
– Select app type Data Administration.
– Enter an app name and description.
– If you have a premium license, you can also change the language. The App Builder contains 35+ languages.
– Click the NEXT button to move to the Data Source tab.
– In your legacy app, check the database and table name.
– Enter the database and table name in the App Wizard.
– Check which column names in the template. Select all columns enabled on the list table and data entry tabs.
– Select these columns in the App Wizard.
– Click the NEXT button to move to the Authorization tab.
– For Data Administration apps we recommend configuring authorized access.
– Save your app.
Table configuration as well as the most commonly used options in the table configuration were explained earlier in section Tables.
Configuring the form:
– Click the Run & Builder link or icon in the App Builder to open your app.
– Click one of the action icons that brings up the form (view, edit, or new).
– Click the builder icon on the form toolbar to start configuring the layout and behavior of your form.
– Check the form specific settings in your legacy template (tab data entry) and find the similar options in the Form Builder.
Extensive documentation is available here:
https://docs.rad.wpdataaccess.com/form-builder/menu/menu.html
If you cannot find options, use the search option or ask for support.
Most commonly used options in legacy forms:
– Column visibility
Available from the columns menu. Can be updated inline.
– Column labels
Available from the columns menu. Can be updated inline.
– Lookups
Available from the columns menu, section lookup.
Many options in the Form Builder are new and have no equivalent in the legacy tools.
Maps #
Maps was a premium feature in the legacy tools. The App Builder contains a limited version now available for free users.
Converting a legacy map and its templates:
– In the App Builder, click the “Create New App” icon on the toolbar.
– This opens the App Wizard.
– Select app type Map.
– Enter an app name and description.
– If you have a premium license, you can also change the language. The App Builder contains 35+ languages.
– Click the NEXT button to move to the Data Source tab.
– In your legacy app, check the database and table name.
– Enter the database and table name in the App Wizard.
– Check which column names are used in the legacy map.
– Define the latitude and longitude columns.
– Select these columns in the App Wizard.
– Click the NEXT button to configure authorization.
– Save your app.
Maps require a Google Maps API key:
– Open the App Builder.
– Click the Manage link or icon of your Map app.
– Navigate to menu access.
– Open section Google Maps API key.
– Enter your key and save your settings.
Your map is now ready. Maps have many new options documented here:
https://docs.rad.wpdataaccess.com/map-builder/
Charts #
Charts was a premium feature in the legacy tools. The App Builder contains a limited version now available for free users.
Converting a legacy chart and its templates:
– In the App Builder, click the “Create New App” icon on the toolbar.
This opens the App Wizard.
– Select app type Chart.
– Enter an app name and description.
– If you have a premium license, you can also change the language. The App Builder contains 35+ languages.
– Click the NEXT button to move to the Data Source tab.
– In your legacy app, check the database and table name.
– Enter the database and query in the App Wizard.
– Your old chart query should work here as well. You can also import a saved query from the Query Builder.
– Select these columns in the App Wizard.
– Click the NEXT button to configure authorization.
– Save your app.
Your chart is now ready. Charts have many new options documented here:
https://docs.rad.wpdataaccess.com/chart-builder/
Dashboards #
Dashboard was a premium feature in the legacy tools. The App Builder contains a limited version now available for free users. Dashboard apps are completely different from legacy dashboards. You cannot convert them, but you can add any app to a dashboard app.
Check the extensive documentation for Dashboard apps here:
https://docs.rad.wpdataaccess.com/dashboard-builder/