Forums

Hello there,

Sorry if this is a simple question. I'm new to this.
I've got some trouble with the save to spreadsheet function.
I simply would like to save the registrations made through the form.
Unfortunately, nothing happens. Can someone tell me why?

This is the URL: http://web91.login-86.hoststar.ch/index.php/wettkampf-events/anmeldung-clubmeisterschaften

First I tried to create a table. I did create a table, which generates this Error on trying to show the records:
NO TABLES SELECTED

Since I am trying to save to a spreadsheet, this is not my biggest concern. But since I created this table, every time I try to go to system information in Joomla, this Error occurs:
0 SQL=SHOW FULL COLUMNS FROM [table_name]
Can I somehow delete this table?? Looking in PhpMyadmin, I can't even see a database..

Please help.

Thanks
Mirko

Hi Mirko,

Usually the Save to Spreadsheet action is used in a separate form to export many records to a new spreadsheet. I don't think that it can be used with a form like yours to export the form results to a new row in an existing spreadsheet.

My best guess about the error is that you have added the Export action to your form but have not linked it to the table you created.

I suggest that you remove the Export action from your form; add a DB Save action and link that to the form so that the records are saved. Then you can look at ways to export records from the DB to a spreadsheet using a separate form.

Bob

Hey Bob

Thank you for your reply.

I now changed to a database save action. Unfortunately, I still get the Error I had earlier ( "First I tried to create a table. I did create a table, which generates this Error on trying to show the records:
NO TABLES SELECTED" )

I selected the right table in database save action.

Any ideas?
Thanks in advance

Mirko

Hi Mirko,

Just drag the "Spreadsheet save" action to the "on submit" event and configure it correctly then submit the form once, you can add a "debugger" action after the spreadsheet action to check what's going on.

Same rules apply for the "db save".

Regards,
Max

Hi Mirko,

Where exactly do you see this error - there is nothing showing if I submit your form?

Bob

Hey Bob,

I've watched your video "database save" and did everything just like you showed there. The Error occurs when I'm trying to read the records. So I tic the form and select the database, before I can click anything else, the page reloads and the error shows.

I've now added a "debugger" action if you want to take a look.

Thanks in advance
Mirko

Hi Mirko,

You are selecting a tablename in the Connected Tables drop-down by the View Form link? And when you click the table name the error shows? That suggests that the table doesn't exist - not an error that I've seen before :-(

From the Debugger it looks as though the data is saving when the form submits.

Bob

Hey Bob,

I've contacted my hosting provider. You were right. The data is saving when the form submits. I still don't know, why the error occurs, but I can see my records in phpmyadmin.

Thanks for your help. Validation follows soon;)
Great Extension btw.

Cheers
Mirko

Hi Mirko,

Just drag the "Spreadsheet save" action to the "on submit" event and configure it correctly then submit the form once, you can add a "debugger" action after the spreadsheet action to check what's going on.

Same rules apply for the "db save".

Regards,
Max

I use chronoforms v5 Joomla 2.5 and I don't have any "spreadsheet save" action to drag? How can I get that functionality?

Hi icarusno9,

Please upgrade to the latest release of CFv5 for Joomla! 2.5 and you should find it in the Data Management actions group.

Bob