![scriptcase grid application scriptcase grid application](https://www.scriptcase.net/tutorials/wordpress/wp-content/uploads/2020/09/create-grid2-1024x522.png)
By accessing the Tools menu you are able to build new SQL scripts, change the current theme and template and group buttons.
![scriptcase grid application scriptcase grid application](https://www.scriptcase.net/tutorials/wordpress/wp-content/uploads/2020/09/remove-pswd.png)
![scriptcase grid application scriptcase grid application](https://forum.scriptcase.net/uploads/default/original/2X/1/1fc3c652c5b527e011ebadfa7496f7932d4d3000.png)
The Project menu enables you to generate source code, export or import applications, as well as create reports. In this manner, you are able to build various forms and detailed reports, group records dynamically, create filters, sort fields in real time, design charts using HTML5, build calendars in order to manage events using the drag and drop feature, as well as create rich Master-Detail applications. When it comes to creating a new project, you are able to choose one of the predefined templates from the left panel or create a blank project by specifying its name, description and version.
![scriptcase grid application scriptcase grid application](https://www.scriptcase.net/tutorials/wordpress/wp-content/uploads/2020/10/06_filter_modal-1024x550.png)
The main window of ScriptCase enables you to create a new project, or simply connect to your favorite database such as MySQL, PostgreSQL, Oracle, Sybase, Interbase, Firebird, MS Access, SQLite or SQL Server. Additionally, you can create your own dashboard where various apps can be attached such as charts, forms and grids. This way, you are able to create forms using options such as layout of blocks and tabs, automatic validation of data etc. Since it works with any web browser, be it Internet Explorer, Chrome, Firefox or Opera, either on your local network or on the Internet, ScriptCase enables you to generate applications and work simultaneously with your team. Choose the Field positioning option in the application menu and choose ProductID, ProductName.
#Scriptcase grid application registration#
It helps them to build applications in an intuitive manner, including registration forms, dynamic menus, calendars and dashboards, to name a few. Create a new grid application using the product table. When executed inside the events of a grid (e.g.ScriptCase is a comprehensive and reliable program especially designed for web developers who need to build complete systems and create reports effortlessly. And, as I said, ScriptCase also uses $_SESSION to store the state of the applications. Solutionįor better or for worse, ScriptCase is heavily dependant on PHP’s $_SESSION global, using it to store a lot (and I mean it!) of information: general and database settings, states of applications, dictionary of (language) strings, errors status, and even HTML content for things such as buttons.
#Scriptcase grid application how to#
With that in mind, I had to find out for myself a way to present a different content for that column when exporting to XLS.Īfter some time analysing the code generated by ScriptCase I found out how to detect what triggered the onRecord event - and it also works for PDF, CSV, XML and RTF. To this day, ScriptCase (latest is v9.0.029) doesn’t provide any macro or documented steps to check if onRecord event is running for a “normal grid webpage” or for an exportation. Besides not working as expected, that image/icon wasn’t really desired inside the XLS file and for this case a simple text would be much better: it would allow the status to be used in formulas, functions, searches, etc. When exported to XLS using ScriptCase’s exporting option, the status column showed just an empty cell - and no images at all. In the onRecord event I checked the status and set the content of that column - an IMG tag, i.e., plain HTML - and everything worked fine, except when exporting that grid to XLS (or PDF). A while ago I created a grid application using ScriptCase to list all not-completed orders, and because each order could have different status, I added a column to show an image/icon based on its status: