With H2O, you can quickly build forms that are associated with a table in your DotNetNuke database.  (This is optional, you can have forms that are not associated with a table).  You can also build a form over a View in your SQL Server database, but when you do this you will not be able to update records the View is associated with.  Click here for more information on creating forms that are associated with tables.

H2O will automatically update the associated table when a change is made using the H2O Form.  If you have a process outside of H2O that also updates the same table, then you will need to synchronize the data with H2O using one of the methods below.

There are two methods you can use to keep data synchronized between your H2O Form and the associated Table.  You can do this manually, or through a scheduled job in DotNetNuke.  To schedule a job to automate the synchronization, use the steps below:

1. Log-in as Host into your DotNetNuke Portal
2. Click on Schedule in the Host menu
3. Click Add Item To Schedule
4. In the Full Class Name and Assembly field, enter Onyak.H2O.Scheduler, Onyak.H2O
5. Check the option to enable the Schedule
6. Set your time lapse and other options to fit your needs and click Update. 

To run this process manually, open the Form in the H2O Forms Designer and click either the Import New Records Only or the Import/Update From Table to Projects links.  Clicking one of these links will initiate the data import process and display the status of the process in real-time as shown below.