This is a truly simple question. I want to make a phone book with fields first name, last name, and phone number. I want a form with just those three fields. I then want to input names and numbers, one after the other, by hitting a submit button, after which the cleared form pops up again. I then want to be able to (1) list all names and numbers in tabular form, with an edit icon next to each and (2) be able to page through each entry using the input form display, so that I can edit each entry one-by-one. I assume this is all possible with DynamicForms. Can you point me to a demo where this is done? Thanks!

Many many thanks! I look forward to Demo 14!

David,

Hi. We are still in the works of finishing Demonstration 14 but I thought I would give you an advanced look. Click on the link below to preview the demonstration:

Dynamic Forms Workflow Demonstration  - Add, edit, update, delete records

Basically the demonstrations covers your specific 'Simple phone book' solution to add, edit, update, delete. It should be noted however that this is more of an advanced solution using a database table outside of the Dynamic Forms. Future versions of Dynamic Forms will already have more directly build in edit/delete/save for later features that are directly within its own tables.  I still have to post the full solution with the IPORTABLE file and also the SQL to add/update/delete. The next full release of Dynamic Forms should have the ability for the Administrator at least to perform these  same steps without needing to use a  seperate table if you didn't want to.

-Chad

Troy,


Hi. Well we actually have not posted this demonstration yet (I know its available from that link but its not on the list yet, you will also notice that the description has not really changed from 13 but we are working on it). The reason it has not been posted is because during the implementation we added some features to the upcoming 2.7 release (specifically direct SQL Binding and easy to use wizards for creating flat tables and inserting/updating/deleting from those tables) so... We are waiting for the full 2.7 release to be published before posting these demonstrations (very close, still pending some minor testing and Aleksandar is finishing up the documentation this week).


You can accomplish what you are wanting to do with 2.6, however you have to use SQL Defaults for each field. The binding feature that is added in 2.7 allows for a single SQL statement that can be enabled based on a querystring variable and can also pull in all records based on a single query instead of using one for each field.


-Chad

Waiting eagerly for this release as it will be very helpful in creating a Helpdesk ticketing system. When is 2.7 expected to go live?