TOPIC:

Record ID in Email Subject 6 years 11 months ago #97275

  • Topic Author
  • anate
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 2
  • Thanks: 0
Thanks for the Breezingforms. How do I change the Email subject "Form record received" to use the actual database RECORD ID. I see this number in the body of the email. I tried to use the following code from one of your soultions but it returns record count in the database. I delete the data from the database from time to time. Could you please help with this issue? I appreciate any suggestions.

<?php $db = JFactory::getDBO(); $db->setQuery("SELECT count(*) FROM #__facileforms_records where form=16"); return $db->loadResult() + 1; ?>

Please Log in or Create an account to join the conversation.

Record ID in Email Subject 6 years 11 months ago #97314

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9270
  • Karma: 167
  • Thanks: 747
Hi,

add the name of the field like this in the custom email subject: {record_id}
So if the name of the field you are passing this php to is "record_id", add it like I did above.

Regards,
Markus

Please Log in or Create an account to join the conversation.

Record ID in Email Subject 6 years 11 months ago #97367

  • Topic Author
  • anate
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 2
  • Thanks: 0
Thanks Marcus. But the PHP code from my post doesn't provide me actual record_id from the database. The body of the email says "Record saved to database with ID: 28". But the PHP code {record_id} gives me the count as '10' because there are only 10 records in the database. I deleted the remaining records. How can get the Subject line as '28'? Please let me know if this is not clear.

regards
nate

Please Log in or Create an account to join the conversation.

Record ID in Email Subject 6 years 11 months ago #97407

  • TheMuffinMan's Avatar
  • TheMuffinMan
  • Offline
  • Developer
  • Developer
  • Posts: 9270
  • Karma: 167
  • Thanks: 747
Hi,

make sure you are using the correct form id. In the sample above it is 16. Maybe you are addressing the wrong form there. You can determine the right ID by looking into Manage Forms => Column "ScriptID"

Regards,
Markus

Please Log in or Create an account to join the conversation.

Record ID in Email Subject 4 years 4 months ago #165670

  • FlyRide
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 6
  • Thanks: 0
Is this valid for all info of the form?
Seems it doesn't work for the title of the form using {Title}.

Please Log in or Create an account to join the conversation.

Record ID in Email Subject 4 years 4 months ago #165671

  • tomeperica's Avatar
  • tomeperica
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 6478
  • Karma: 170
  • Thanks: 667
@FlyRide

Maybe you are looking this:
crosstec.org/en/support/online-documenta...using-mail-tabs.html

Let us know if that worked for you.

Regards
Regards,
Tome
==========================================
Need to renew Pro Support?
Buy Here!
==========================================
Satisfied?
Consider a membership!
==========================================
Like us on Facebook
==========================================
Support Crosstec and get ALL EXTENSIONS and professional support for just $5
Here!

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.052 seconds

Summer Sale!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!