Help with saving multiplier data into DB and email

Hi all,

I need some help about saving the data in multiplier into database and also send to email.

I have tried the tutorial at this link: https://www.chronoengine.com/faqs/70-cfv5/5245-how-can-i-use-the-multiplier-in-cfv5.html

but not working.

Can someone help me how to setting this multiplier so my form able to save in database and the data also can send to email.

I have attached the backup form.

Hi checkwan,

The backup doesn't include the table info so I have no idea how you want to save this data.

A couple of things I noticed:

+ the Custom Code is trying to convert elements that don't exist in your form so generates a string of PHP Warnings (not a big problem - I see them as I have Site Error Reporting set to Maximum)

+ The Handle Arrays action doesn't work because the Multiplier data isn't a simple array - it is an array of arrays. You can see the data using Debugger actions - try adding one before the Handle Arrays action.

Bob

Hi Bob,


thank for the reply.

+ the Custom Code is trying to convert elements that don't exist in your form so generates a string of PHP Warnings (not a big problem - I see them as I have Site Error Reporting set to Maximum)

This custom code I've added because this data also will send to external Oracle database in my internal server using API.
So just ignore this code.


But the main problem is how can I achieve my form so all the data will send successfully to my email.
I appreciate if you can help modify my form to solve the multiplier part.

Hi checkwan,

The code from the last section of the FAQ works OK provided that the Email action is before the Handle Arrays action.

{repeater:addname}
{data}
{/repeater}
{repeater:addemail}
{data}
{/repeater}
{repeater:addmphone}
{data}
{/repeater}

You might get a more useful result by renaming the multiplier elements to use the same parent name e.g. addmore[__N__][name], addmore[__N__][email] and addmore[__N__][mphone] Then you can use

{repeater:addmore}
Name: {name} Email: {email} Phone: {mphone}
{/repeater}

Bob