Update terbaru PHPRunner, ASPRunner.NET dan ASPRunnerPro - Nov 2017

while we are working on version 10 of PHPRunner, ASPRunner.NET and ASPRunnerPro here are some updates you may find useful.    MassMailer template v3 released SnapshotCam plugin updated SignaturePad plugin updated Updated online manual and how you can create one for your own app Web hosting deal How to make sure your maintenance is current Recent Windows 10 update issues 1. MassMailer template v3   More info, screenshots and buy/upgrade links New functionality in version 3: Bootstrap-based appearance Can send both emails and SMS via Twilio Scheduling by day of the week And the most important one - you can attach one of project pages like a report or a list page as HTML or PDF. Works with password protected pages as well. You can even make it work with 'Users can see and edit their own data only' feature and each user will receive their own copy of report in the mail. Isn't it amazing?   2. SnapshotCam plugin   SnapshotCam plugin was released for ASPRunner.NET and ASPRunnerPro plus a few more bugs fixed.    More info   3. SignaturePad plugin   SignaturePad plugin was updated to support background images. Also allows you to edit your signature. Apparently it has more applications than just a signature, i.e. a pain map. This plugin is a already a part of he software, just make sure you have the latest build of PHPRunner or ASPRunner.NET. Unfortunately this new functionality is not available in ASPRunnerPro. 4. Updated online manual   You may have noticed the new format of our online manual. We recently switched to the latest version of Help+Manual software that allows us generated CHM, PDF and online version of the manual from a single source.    If you need to build a manual for your website or web application give them a try. We managed to arrange $100 discount only available to our newsletter subscribers. Valid tillNovember 16, 2017.   Get $100 discount Help+Manual software.   We are not affiliated with this company, just happy to spread a word about a great software.    5. Web hosting special  If you are looking for a web hosting for your web application check our offering athttp://www.inspirunner.com. You can receive $25 OFF if you sign up for 6 months service (use coupon code 2012SEMI) or $50 OFF if you sign up for 12 months service (use coupon code 2012ANN).   We support PHP (5.6 and 7.1), ASP, ASP.NET, MS Access, MySQL and SQL Server. Also new Plesk Onyx 17.5.3 control panel provides access to Wordpress toolkit, Let's Encrypt, Git, Docker and much more. Do not hesitate to ask if you have any hosting related questions.    6. How do I make sure my maintenance is current   It is important to keep your maintenance up to date. Otherwise you will have to purchase version 10 at the full price. To make sure that you are current logon to customer portal, proceed to 'My purchases' and see what your last purchase or upgrade order for PHPRunner, ASPRunnerPro or ASPRunner.NET was placed.    If your latest order was placed less than 12 months ago that means your maintenance is current. In other case you need to renew it before November 15th. Maintenance renewal links: PHPRunner  ASPRunner.NET ASPRunnerPro 7. Latest Windows 10 update breaks things   Customers running Windows 10 and 64-bit version of our software may noticed that software may crash when you close the project. As a temporary solution you can switch to 32-bit version of the software or uninstall the latest Windows update. We are looking for a permanent solution.

Version 9.7 of PHPRunner, ASPRunnerPro and ASPRunner.NET

Beta version of PHPRunner 9.7, ASPRunnerPro 9.7 and ASPRunner.NET 9.7 is here. Downloads links:

PHPRunner 9.7

ASPRunner.NET 9.7

ASPRunnerPro 9.7

Here is the list of new features in this update.

1. Improved password hashing

Option to use industry standard bcrypt hashing algorithm. Send password reset link to user's email, link expires in 24 hours.

2. Code snippets in dashboards

You can insert any sort of code snippet as dashboard element. This can be some code that displays current weather, calculates order totals, displays number of active users or even displays a Youtube video.

See this live demo for inspiration.

3. 'Sort by' dropdown control

When this option is useful:

• Vertical or columns List page mode that previously didn't have sorting options
• 'Sort by' control in mobile mode
• Need to setup application specific sort modes

You can also choose if users still can sort data by clicking on column headers.

Here is how it looks in generated application.

4. Grid row/field click actions

This one is pretty cool, you can assign actions like open a certain page, make record selected, expand/collapse details or run a custom code to row/cell click.

Check this live demo.

Click CustomerID cell to open Orders view page in popup.

Click OrderID field to retrieve current order total and display it in OrderID field.

Code for this example:

Client Before event

1. // pass OrderID to Server event  
2. params["OrderID"] = row.getFieldValue("OrderID");  

Server event

1. // run SQL Query to retrieve order total  
2. $result["total"] = DBLookup("select sum(Quantity*UnitPrice) from 
3. `Order Details` where OrderID=".$params["OrderID"]);  

Client After event

1. // change cell background  
2. row.fieldCell("OrderID").css('background', 'yellow' );  
3. // add order total to OrderID cell content  
4. row.fieldCell("OrderID").html(  
5.    row.fieldCell("OrderID").html()+"<br>Total: "+result["total"]);  

5. New APIs

If you enjoy pushing your web applications beyond built-in functionality you going to love this update. We have added five new APIs in this version that will help you build modern applications. Here are some highlights and use cases. See full list of functions each API provides in updated manual.

Security API

Get username or user group of current user. Get or set OwnerID or permissions for any specific table. Verify username and password. Log user in automatically from your code. Check if user is logged in, if user is an admin, if user is a guest.

Labels/Titles API

Things like change project logo on the fly, modify table captions, modify breadcrumbs display format, modify field label or tooltip etc.

Tabs/Sections API

Make a tab active, enable/disable a tab, add a tab in runtime, change tab header or content, expand/collapse a section etc.

Search API

Lets you run a totally custom searches. For instance you have Order and OrderDetails tables setup as Master-Details. With the help of Search API you can display all orders that include a specific product in OrderDetails.

Ajax row click API

You can see an example of this API usage in previous code sample where we dynamically display order totals in OrderID column. You can change any field visual appearance or content using this API. Besides using it in 'Click action' event you can also access this API from any button added to the grid.

6. Improved appearance of cross-tab reports

Try scrolling down and right to see freezing columns and header.

Live demo

7. Form field placeholders

Placeholders are in-place tooltips that disappear as soon user starts typing something in that field.

Live demo

Enjoy!