Using {fabrik_internal_id) or display of form number

[sanshaar]

I need to display "Registration number" in the thank you page, email, and record it to the DB.

It does not have to display in the initial form.

I tried generating it with eval, but I get the code in the email and the DB, not the result.

I tried using {fabriq_intenal_id} - got nothing. (I don't even see this field in the DB table).

I searched documentation and forums, could not find the answer.

This is URGENT, I am willing to modify php if needed,

Thanks,
Sam D.

 

[amras]

In the thank you message write your note and put the {registration} in betreen where your want your number to be.

The "registration" is the id value for the element.

 

[sanshaar]

I Tried. it does not work.

The registration is not a user input. it is the auto_increment id field from the table. I called it appid, I made an element with this name, and placed {appid} in the thank you. it does not show. it apears on the Db, not on the Thank you or email.

 

[amras]

That is because the id is created after the form is submited, in order to show that number you have to do smoe thing else.

 

[sanshaar]

I understand I have to do something else. The question is what. or to be precise, how do I pull this number, AFTER form is submitted, in order to display it in the thank you page and email. I assume email and thank you are created after submission to the DB.

 

[andrelewis]

As far as I can tell there is no easy way to do this, however it may be possible to do something with the following on form submit:

global $database
$database->insertid();

insertid() returns the index of the last record created with the $database variable.
however my understanding is that if you run any PHP at the end of a form submit it cancels any actions afterwards, so email may not get posted.. ? Perhaps you could do something with CURL?

 

[rob]

Hi

There was an issue with the primary key data not being available for the email templates. This should be fixed in the SVN, and quiet possibly in the 1.0.4 prerelease version thats available here:

http://fabrikar.com/index.php?option=com_docman&task=doc_download&gid=12&Itemid=29

Details of how to install the patch are included in the zip.

Cheers
Rob