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)?[file=10076]MRB_Mitgliederverwaltung_15_Feb_2018_15_30_41.cf6bak[/file]
[file=10077]CFV5_FormsBackup_ON_https___www.mr-basi.ch_15_Feb_2018_15_31_52.cf5bak[/file]
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)?[file=10076]MRB_Mitgliederverwaltung_15_Feb_2018_15_30_41.cf6bak[/file]
[file=10077]CFV5_FormsBackup_ON_https___www.mr-basi.ch_15_Feb_2018_15_31_52.cf5bak[/file]
Hi Peter48,
How are you creating the ID in the CFv6 form? Does it show up in the Debugger output?
Bob
How are you creating the ID in the CFv6 form? Does it show up in the Debugger output?
Bob
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[file=10096]2018-02-16_doku_array.pdf[/file]
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[file=10096]2018-02-16_doku_array.pdf[/file]
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
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
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[file=10102]2018-02-18_doku_array_V02.pdf[/file]
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[file=10102]2018-02-18_doku_array_V02.pdf[/file]
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
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
This topic is locked and no more replies can be posted.
