Forums

database modify/update

cyberrocker 07 Aug, 2016
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
GreyHead 07 Aug, 2016
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
cyberrocker 07 Aug, 2016
I did try that with the value {id} but didnt work... should I set the value??
cyberrocker 07 Aug, 2016
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
cyberrocker 07 Aug, 2016

This is private content



This is private content

GreyHead 08 Aug, 2016
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
cyberrocker 08 Aug, 2016
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
GreyHead 08 Aug, 2016
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
This topic is locked and no more replies can be posted.