Displaying and updating data from chronoforms elsewhere

I am wanting to collect data from customers in what we call a "service request form." It has their registration number, name, date of arrival and services requested.

I would like the create a page that lists data from all the request form for certain day in a table.

Also, can a form be created with javascript to pull name, address and phone information from the database after the registration number is entered even for people who are not registered users of the site?


Thanks,

Paul

Hi Paul,

I would like the create a page that lists data from all the request form for certain day in a table.

This is a typical ChronoConnectivity application. ChronoConnectivity lets you display a list of records (filtered if necessary) from any database table.

Also, can a form be created with javascript to pull name, address and phone information from the database after the registration number is entered even for people who are not registered users of the site?

This one is more complicated but is equally possible.

The easy answer is to create a multi-page form, grab the registration code on the first page then get the existing data and display that on the following page. If you have some confidence with JavaScript you can do it on the same page using Ajax.

Bob

One last simple question and then I will hit the tutorials and work this out, but does chronoforms let you save data to multiple forms? I need a table, customerInfo, and a table, ServiceRequest, where CustomerInfo is within the ServiceRequest.

If this can be done ChronoForms and ChronoConnectivity will save me a lot of time and I will soon become a subscriber!

Thanks for helping a noob!

Paul

Hi Paul,

Saving to multiple tables, yes, no problem. You can either use separate forms or, with a little planning, save to multiple tables from the same form.

Displaying from a compound query in ChronoConnectivity is a little trickier, The release version will only accept a single table. However, there is a hacked version here, and also a code workaround that will get you past this.

Bob

GREAT! Sounds like I need to lock myself in a room for a week and get this worked out.

Thanks for your quick response!

Paul