Buy Now
Sign in

Display ID (unique key) in confirmation mal after insert

Peter48 , February 15 at 14:55
P
Peter48

With Chronoforms V5 I realized a member administration. When a new member is inserted, an ID (unique key) is automatically released at the time of the insert. This ID will
also appear in the confirmation email as well as on the confirmation screen automatically.

I have now implemented the form with Chronoforms V6. This works so far with the exception that with the new entrance the ID (unique key) is not indicated on the
confirmation email and not on the confirmation screen.


Is there a possibility to have the automatically solved ID displayed in the confirmation email and on the screen confirmation with a new entry (insert)?

2018-02-15_insert01.jpg
GreyHead
Hi Peter48,
How are you creating the ID in the CFv6 form? Does it show up in the Debugger output?
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
Peter48
Hello Bob
How do you create the ID in the CFv6 form?
-> The ID (mitgliednr) is by definition an INTEGER field, Primarykey, AUTO_INCREMENT
Is it displayed in the debugger output?
-> Unlike CF5, only when updating the table "x_mrb_mitgliederverwaltung". In the appendix, I leave you a comparison of the debugger output
Peter
Attachments
2018-02-16_doku_array.pdf
(166.67 KiB)
28 Downloads/Views
GreyHead
Hi Peter,
The new record id is in the [aid] => 16 line in the CFv6 Debugger output. I think Max posted how to get this value in the last day or two, I'll see if I can find that post.
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
Peter48
Hi Bob​
​​
​I do not agree with your statement. The "new record id is in the [aid] => 16 line" is the update of the table in which I log the mutations. For simplification I have adjusted the form again. It has the task:​
​​
​• Updated the table «x_mrb_mitgliederverwaltung» (Key = mitgliednr). With a new entry a new ID is solved, with an update the existing one is taken over.​
​​
​• Creating a Screen Confirmation (when adding an new address, automatically the new ID (mitgliednr) should be displayed here.​
​​
​• Creating a confirmation email (when an address is added, the automatically resolved ID (member number) of the table «x_mrb_mitgliederverwaltung» should be displayed here.​
​​
​As mentioned before, this worked correctly in CF5, where as in CF6 the new ID (member number) does not appear in the email and on the confirmation screen.​
​In the attachment, I send you a new debugger for the new form.

​Peter
Attachments
2018-02-18_doku_array_V02.pdf
(110.95 KiB)
19 Downloads/Views
GreyHead
Hi Peter,
My apologies. I can see the value of mitgleidnr now. Evidently that is not being added to the array of form data you are saving to the next table. I think that you should be able to use a PHP action between the two DB actions to copy it from one place to the other.
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much