field order

i made a form with a lot of fields. when ik display the data the order of the fields is not the same as in the form. Also in the administration , in display data, the order is not the same as in form. And also when exporting the data to a csv file, the order is not the same as in the form. Can you help me with this problem?
What is the maximum amount of fields in a form?

At this moment, when a field is left blank, you see -1 in the data (frontend and backend) and also when exporting. Is it possible to leave this blank?

i read another posting about this, and i got it working on the backend. changed the visdata.php file in de administration. How can i change it on frontend?

Hi imkejoemarati,

thanks for your post.

1) Fieldorder in backend dataview and export

open file administrator/components/com_visforms/models/visdata.php

find function getDatafields (about lin 263)

replace

$query = ' SELECT * from #__visfields as c where c.fid='.$this->_id.' ';

in this function with

$query = ' SELECT * from #__visfields as c where c.fid='.$this->_id.' ORDER BY c.ordering asc';

2) Fieldorder in frontend dataview

open file components/com_visforms/models/visformsdata.php

find function getDatafields (about line 181)

replace

$query = ' SELECT * from #__visfields c where c.fid='.$this->_id." and (c.frontdisplay is null or c.frontdisplay = '1') ";

in this function with

$query = ' SELECT * from #__visfields as c where c.fid='.$this->_id.' order by c.ordering asc';

There is no maximum amount of fields per form.

Fields, when left blank, are set to NULL in Database and are displayed empty in dataview (backend and frontend). I don't now, why they show up as -1 on your website but I assume that's a setting of your mySql rahter than of visforms.

Regards,
Aicha

thank you, it works