Feature: Tools for Excel

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Monday, April 29, 2013PrintSubscribe
Feature: Tools for Excel

Code On Time Tools for Excel provides an alternative designer that allows rapid changes to configuration element properties. This tool can be used interchangeably with the Project Designer.

List of data fields in Code On Time Tools for Excel.

The picture below shows the default Orders form in a sample Northwind web application. Let’s compare methods of changing the form layout in Project Designer and Tools for Excel.

Suppose that it is necessary to place shipping fields in a second column in the form. The word “Ship” must be removed from the field labels.

Default Orders edit form.

Using the Project Designer, you would create a category and drag all shipping data fields into the new category.

Dropping all shipping fields onto the 'Shipping Information' category.     All shipping data fields moved into 'Shipping Information' category.

Next, you would need to click on every data field, change the Header Text of the data field, and press OK to save.

You may save quite a few clicks using Tools for Excel.

Start Microsoft Excel, and switch to the Code On Time tab. Press Open | Northwind / Web Site Factory to link the project to the workbook, and then select Categories shortcut on the ribbon. Filter down to Orders controller by pressing Filter | Orders.

Filtering Categories project configuration sheet down to 'Orders' controller.

Add another category with the following properties:

ID View Controller Header Text Description New Column
myCat editForm1 Orders Shipping Information This is the shipping info. yes

Adding a new category to Orders controller.

Next, click on the Data Fields shortcut. Make the changes highlighted below:

Field Name Category View Controller Header Text
ShipName myCat editForm1 Orders Name
ShipAddress myCat editForm1 Orders Address
ShipCity myCat editForm1 Orders City
ShipRegion myCat editForm1 Orders Region
ShipPostalCode myCat editForm1 Orders Postal Code
ShipCountry myCat editForm1 Orders Country

Changing the properties for all shipping fields in editForm1 of Orders controller.

On the ribbon, press Sync to apply changes to the application. Then, press Browse to generate and open the web app in the default browser. Navigate to the Orders page and select a record. The shipping fields will now be in a separate category in a new column with new labels.

Orders edit form with shipping information in a second column.

Learn more about Tools for Excel.