MAIN FEATURES PRODUCT CONTACT DEMO Demo PROJECT 1: Our Solar System Our Task: Create an input form listing the planets in our solar system that is read only. Create a second input form that allows the data to be updated, deleted, or added.   Result: This task was simple and took only a few minutes. Most of the time was spent finding a public domain source of information. I found it at NASA.   1.   I created a table by typing five fields (Name of Planet, Orbit from Sun (millions), Diameter, Mass, Satellites (moons)) into the table builder and selecting data types.   2.   I created an input form by entering a title and selecting the above table in the input form builder. I clicked the update, delete and add options off.   3.   I created a second input form with the same table.   4.   I clicked the single view settings at the bottom of the settings page in both input forms and generated a special hyperlink. Normally users would use input forms inside the secure role based login. The administrator chooses the level of security, which we turned off to display here.   Here is the result.      The First Solar System Input Form (View)      The Second Solar System Input Form (View, Update, Delete, and Add) Your Task: Remove Pluto from the planet list. Add it back.   1.   Click on the first input form and copy the Pluto row for your second task by selecting it (click on row number on left) then copy (ctrl-c)   2.   Click the delete toggle only for the Pluto row and click submit.   3.   Open the second input form and paste (ctrl-v) into the first cell. Notice that the input form pastes the entire row, which also works when coping and pasting rows from Excel. Click submit.   4.   Open the first input form to see that Pluto is back.   For more information contact me:  support@MythicalLogic.com PROJECT 2: Ecosystem History of South Florida Estuaries This data is an analyses of paleontology, palynology, geochemisty, hydrology, and sedimentology of cores taken from the South Florida region as part of a three hundred million dollar environmental project. The data is available from the government in an Microsoft Access Database at SOFIA. Our Task: Create input forms for the tables and move the data from Microsoft Access to the web.   Result: With forty tables and several reports this task could take a developer several months. Our tester took twenty minutes to create and transfer the data for each table. Our user said If we made the paste faster it would reduce the task by half. We found we could make it five times faster if we did validation on submit instead of paste. Valuable feedback like this allows us to continue to improve the automation.   Sub-Aquatic Vegetation      Pelecypod Other Dataset      Vegetation Dataset      Vegetation Description Biscayne Bay      CORE Bisc Bay Black Point N GLW603 BPN_A Forams      CORE Bisc Bay Black Point N GLW603 BPN_A Mollusks      CORE Bisc Bay Black Point N GLW603 BPN_A Ostracodes      CORE Bisc Bay Card Bank GLW402 CBA Pollen      CORE Bisc Bay Card Bank GLW402 CBB Ostracodes      CORE Bisc Bay Card Bank SEI0297 CB1 Mollusks      CORE Bisc Bay Card Bank SEI0297 CB1 Ostracodes      CORE Bisc Bay Chicken Key GLW0603 CKA Mollusks      CORE Bisc Bay Chicken Key GLW603 CKA Forams      CORE Bisc Bay Chicken Key GLW603 CKA Ostracodes      CORE Bisc Bay Chicken Key GLW603 CKA Pollen      CORE Bisc Bay Featherbed Bank GLW0402 FBB Mollusks      CORE Bisc Bay Featherbed Bank GLW402 FBA Pollen      CORE Bisc Bay Featherbed Bank GLW402 FBB Forams      CORE Bisc Bay Featherbed Bank GLW402 FBB Ostracodes      CORE Bisc Bay Featherbed Bank SEI0297 FB1 Mollusks      CORE Bisc Bay Manatee Bay SEI1196 MB1 Mollusks      CORE Bisc Bay Middle Key GLW0603 MKA Mollusks      CORE Bisc Bay Middle Key GLW603 MKA Forams      CORE Bisc Bay Middle Key GLW603 MKA Pollen      CORE Bisc Bay Middle Key GLW603 MKB Ostracodes      CORE Bisc Bay No Name Bank GLW0402 NNB Mollusks      CORE Bisc Bay No Name Bank GLW0402 NNB Ostracodes      CORE Bisc Bay No Name Bank GLW402 NNA Pollen      CORE Bisc Bay No Name Bank GLW402 NNB Forams Florida Bay      CORE Fla Bay and Bisc Bay Compiled Data Forams      CORE Fla Bay and Bisc Bay Compiled Data Mollusks      CORE Fla Bay and Bisc Bay Compiled Data Ostracodes      CORE Fla Bay and Bisc Bay Compiled Data Pollen      CORE Fla Bay Compiled Data Dinocysts      CORE Fla Bay Pass Key FB596_CORE37 Diatoms      CORE Fla Bay Whipray Basin FB697_CORE25B Mollusks      MODERN Fla Bay Push Cores Mollusks Location Information      Location Information for Cores      Modern Field Information      Modern Location Information Reports      Locality Information Florida Bay      Locality Information Biscayne Bay      Locality Information Southwest Coast   For more information contact me:  support@MythicalLogic.com   Input Web Wizard   Copyright © 2010 Mythical Logic Inc., All rights reserved.