Breezingforms is a joomla extension that creates forms for users to enter data.
I want to create tables from the data.
However, Joomla forms creates datatable records for each place the person can type into (e.g. element) and ties them together with a record number.

So I have in the sql query in the ARI data table module

Select title, value, record FROM #__facileforms_subrecords where name = "sparkname" or name = "initwi" or name = "Week1WI"


I get a table that looks like (I put - dashes in to make it easier to see where the columns are).

title-----------------value-----------record
Initial Weigh In-------195--------------36
SparkName-----------2berunning----------36
First week Weigh In-----190-------------36
Initial Weigh In--------180-------------39
First week Weigh In-----175-------------39
SparkName------------HILLRUNNER---------39
SparkName-------------JaneTest----------40
Initial Weigh In--------200-------------40
First Week Weigh In-----195-------------40

I want a table that looks like:
Sparkname----------Initial Weigh In------First week WI(etc.)
2berunning--------------195---------------------190
Hillrunner--------------180---------------------175
JaneTest----------------200---------------------195

How can I do this?
Thanks, Jane

In case you need to know, I am using ARI data table.
I will have (if this works) about 30 rows and 15 columns, I want to be able to see them all or scroll easily keeping sparkname visible at all times.

Hello,

Use the following SQL query:



Set "SQL -> Graph transformation -> Enable" parameter to "Yes", "SQL -> Graph transformation -> X axis column" parameter to name value, "SQL -> Graph transformation -> Y axis column" parameter to record value, "SQL -> Graph transformation -> Enable" parameter to value

PS: Similar solution solution for "RS Form" extension can be found here.

Regards,
ARI Soft

Thanks for the reply, but I am confused.
It looks like you sent me to a product I have to pay for (ok, I just found the free version).

I thought that ARI DATA TABLEs would produce charts and graphs for me.

Does it not do this?

I have seen nothing in ARI Data Tables that creates the pictures that you show in your "demos".

Does Ari data tables create those pictures in your demo? Or only when other products are also bought. And please tell me how all the parts (products) fit together and what Ari Data Tables does and what it doesn't do.

I really don't want to be using 5 pieces of software when I could be using only 1 or 2.


Thanks

We described how to configure the module for BreezingForms and provide the link to the post about "RS Form" only for example because their table structure has similar structure with your "#__facileforms_subrecords" table.

"ARI Data Tables" supports several graph and charts widgets (set "Choose table type" parameter to "ARI GChart" or "ARI Data Visualizer" value). It doesn't require any additional extensions.

Regards,
ARI Soft

OK, got it, thanks.

Thanks for the specific examples, they really help. Once I get one example to show, it is then easy for me to change them to get all the ones I want.

I put in the changes you recommended. But the last one - , "SQL -> Graph transformation -> Enable" parameter to value
I am not sure what you mean by this. I have a field in the ari data module called value column & and default value, did you mean one of these? And what goes in there?



I got this error:
500 - JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT title, value, record FROM jos_facileforms_subrecords ' at line 3 SQL=Select title, value, record FROM jos_facileforms_subrecords where name = "sparkname" or name = "initwi" SELECT title, value, record FROM jos_facileforms_subrecords WHERE name IN ("sparkname", "initwi", "Week1WI") ORDER BY record DESC,name ASC