database modify/update

Hi Bob,
Sorry for another DB question...

On my form

This is private content

I have a multi-page setup. On the first page the form asked for personal details then creates and save those details, the 2nd is an information page with a form button to continue, the 3rd page It asks for some more details (Then is meant to update the recently created data), though I can not get the 3rd page to update the newly created data... It just creates a new line with only new ID, new uniq_id and new created date... How can i get it 3rd page just to update the data created from the first page?

Thanks for now

Ben

Hi Ben,

After the first DB Save ChronoForms add the new record id to the form data, if you add a hidden input with the same name - usually id or cf_id - then that will be carried forward and the same record will be updated.

Add a Debugger action temporarily to see the form data and the database query that is being created.

Bob

I did try that with the value {id} but didnt work... should I set the value??

any way, I did try just a hidden txt a few different ways, just on the first page, as you suggested, then on every page.... The "id" comes over to the 2nd page but nothering I do. can bring it to the 3rd and 4th page which is where the DB save/update is

This is private content

This is private content

Hi cybeerrocker,

Either use a MultiPage action which will carry all the data forward, or add the same hidden input to the later pages.

Bob

I have already tried inserting hidden inputs in to other pages, that has not worked... and i am unaware of what you mean by a multipage action.

Ben

Hi cyberrocker,

There is a MultiPage action in the Utilities action group (not visible with the Simple Wizard). That will load the save/retrieve the current form data from the Joomla! User session so that it can be accessed from different pages.

Bob