Forums

Help needed :)

Elita 28 Feb, 2017
Hello, Bob, recently switched from RS Forms to Chronoforms because of the better functionality and wider possibilities.
For couple of days I am working on the form that has pretty advanced options and with one of that function I got stuck:
I have a multiplier with 6 fields + file upload. Everything seems working fine; files are being uploaded and those that are not in the array (outside multiplier) I managed to save in DB its name and attach to the email. However with the multiplier files i did not succeed.😟 Debugger seems to print those file names but further tey "dissapear". see attached file.
I defined the multiplier file uploader as
komanda[__N__][seja]
komanda__N__seja

So. My question is - could you help me, please with this?
It would be great that we got the filename in the table and link to the file in the email.

In addition, I created a table for Array info - cf_komandas where goes all multiplier data. My problem is that i cannot connect the records for one submission. I would really appreciate if you take a look what i am doing wrong.

Thank you in advance -
Elita
Elita 02 Mar, 2017
Khm. I probably misunderstood how this works - how can i get professional paid services from here? or at least some guidance? its been several days since i posted this message here....
GreyHead 02 Mar, 2017
Hi Elita,

Sorry for the delay in replying, it's been a busy week and I must have missed your post.

It looks as though only one file is being uploaded by ChronoForms (though PHP is uploading all of them). You need to add an entry in the Arrays box of the Upload Files action - though I'm not certain that will work with the komanda[__N__][seja] structure - you may need to use komanda[__N__] for the files and then use a Custom Code action to merge the file data with the rest of the komanda data.

Best wishes

Bob
Elita 03 Mar, 2017
Dear Bob, sorry for hearing that you've been busy - hopefully it will bring the lot of moneyπŸ™‚

Thank you for your answer; i will try to implement that and ask your permission to bother you if I will not succeed.

However I do need another favor from you - please explain or give the link on explanation about how to connect two databases together - that of submissions and other for multiplier (not physically, but so it would be clear which multiplier is for what submission). I put the column in the multiplier DB that is named cf_id (it is supposed to be submission ID - I have that column in the main submissions table) and somehow hoped that it will be automatically, but it seems that it is not so easy... Tried to search the forum, but did not succeed.

Thank you in advance,
Elita
Max_admin 03 Mar, 2017
Hi Elita,

You need to loop over the files array and save the data, ChronoConnectivity v6 has the features suitable for this type of data processing, if you can check it then you may find it easier there.

in case you want to use Connectivity and keep your form in Chronoforms then you can change the action url in your form to point to the Connectivity v6 save event and process the data, you can also send the emails in v6.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Elita 05 Mar, 2017
Thank you, Max for the answer - i definitely use that later. However, my concern is that even that will not help me since I have probably some root problem in my form - It seems that second DB save does not save the first DB Save entry ID (cf_id). Hope that you get my problem. Just point the direction what am i doing wrong or have missed.... Thank you in advance, Elita
Max_admin 06 Mar, 2017
Hi Elita,

The cf_id of the first record will be available under $form->data["Model"]["cf_id"] and you can set this in the data of the 2nd db save using a "custom code" action:

<?php
$form->data["2nd_model"]["first_id"] = $form->data["Model"]["cf_id"];


in Connectivity v6 an issue like this can be solved by writing a single string (not php code) and this is one of the reasons I suggest using it instead until Chronoforms v6 is ready.

Best regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
This topic is locked and no more replies can be posted.