close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

email form not sending

Thread began 6/13/2018 12:07 pm by s.joiner74419001 | Last modified 6/14/2018 11:57 am by Ray Borduin | 118 views | 3 replies |

s.joiner74419001

email form not sending

I have many email behaviours I am using on my site, most which work fine except one. it basically is used with a form that is complete by the user to request an estimate. all the correct data is sent to the database but the email is not being sent to the user.

I have attached details in a PDF

Sign in to reply to this post

Ray BorduinWebAssist

The email doesn't get sent until the button on the next page: "send_quote" is pressed.

The update should not have a redirect or it could prevent the second from sending. That might be the issue.

Sign in to reply to this post

s.joiner74419001

Thanks Ray. I did have an unnecessary redirect you're right. But I realised also had the wrong database password reference in the email template.

I still have an issue with this. as follows.

The reason why I have two stages to this is because I need certain values ( 'num_of_blocks' and 'total_flats' ) that the user enters in the modal form ( index.php ) to calculate the value in the hidden field ( 'quote' ) in the 'send_quote_form' on the quote-result.php page. when the 'send_quote_form' is submitted the quote value is sent to the database and is placed in the email template that is sent to the user.

Here is my problem:

Our price formula is as follows:

- Price per block £500 / Price per flat £75 /
- Total cost would be: ( £500 x total amount of Blocks ) + ( £75 x total flats )


example: 14 flats in 2 blocks / ( 14 x 75 ) + ( 2 x 500 ) = £2050.00

This is not a problem and have this in the hidden field that is used to send the value to the database record in an update record behaviour:

<input type="hidden" class="form-control" name="quote" id="quote" value="<?php echo ($row_rsQuotes['total_flats'] * 75) + ($row_rsQuotes['num_of_blocks'] * 500); ?>">

BUT!!

We have a minimum charge of £1000.. So if the user was requesting an estimate/quote for 6 flats in 1 Block, which totals £950… the quote would be wrong.

So basically when ever the details are 1 Block and 6 or less flats I need to send a value of £1000 to the database and not the calculation in the hidden field.

I have tried to create access rules to do this using two hidden fields but with no success. because I would need two conditions to be true for it to pass.

So for example:

Rule 1 - IF num_of_blocks = 1 AND totlal_flats <= 6 ( this would send an update behaviour using hidden field value of £1000 )

Rule 2 - IF num_of_blocks >= 2 ( this would send an update behaviour using hidden field value with calculation

I hope you understand this.

Thanks in advance!

Sign in to reply to this post

Ray BorduinWebAssist

You can use:
<?php
$totalQuote = ($row_rsQuotes['total_flats'] * 75) + ($row_rsQuotes['num_of_blocks'] * 500);
if ($totalQuote<1000) $totalQuote = 1000;
?>
<input type="hidden" class="form-control" name="quote" id="quote" value="<?php echo($totalQuote); ?>">

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...