No one?
Of course I saw this: http://forums.formtools.org/showthread.p...er+publish
But the thing is that I have already an existing database with 20 columns and I would like to publish this one, but only column 2, 4, and 6. The rest is for internal use.
So if I would make a new database with only 3 columns, publish it and add 17 extra columns, the published form will only show these 3 columns, and I could fill in the rest (17). But... The problem is that the information filled in in these 3 columns, will be place in col_01, col_02 and col_03, where it should be in col_02, col_04 and col_06.
Renaming "col_01' to 'col_02' etc. will only change the name: in MySql it will be still the first column. So in that case in new entries the "name of the costumer" will be placed in column 01, where in the existing database (with already 3000+ entries) the "name of the costumer" should be placed in column 02. Column 1 is already used for other information.
So the problem is that after publishing the form the name of the customer is placed in 2 different column, so not searchable any more... The easiest option would be if I could just make some columns 'invisible' in the published form, but I can't find such option. Also I haven't been able to change this in the php-code (just to delete some columns to be published) once it seems to get the information to be published directly from the database. I couldn't find something like:
<table class="table_1" cellpadding="1" cellspacing="1" border="0" width="798">
<tr>
<td width="180" valign="top">
test 1
<span class="req"></span>
</td>
<td class="answer" valign="top">
<div class="pad_left">
<input type="text" name="field1" value=""
class="cf_size_medium"
/>
</div>
</td>
</tr>
<tr>
<td width="180" valign="top">
test 2
<span class="req"></span>
</td>
<td class="answer" valign="top">
<div class="pad_left">
<input type="text" name="field2" value=""
class="cf_size_medium"
/>
Because than it would be possible just to 'delete' one <tr>...
I hope someone has a solution! Thanks!
Of course I saw this: http://forums.formtools.org/showthread.p...er+publish
But the thing is that I have already an existing database with 20 columns and I would like to publish this one, but only column 2, 4, and 6. The rest is for internal use.
So if I would make a new database with only 3 columns, publish it and add 17 extra columns, the published form will only show these 3 columns, and I could fill in the rest (17). But... The problem is that the information filled in in these 3 columns, will be place in col_01, col_02 and col_03, where it should be in col_02, col_04 and col_06.
Renaming "col_01' to 'col_02' etc. will only change the name: in MySql it will be still the first column. So in that case in new entries the "name of the costumer" will be placed in column 01, where in the existing database (with already 3000+ entries) the "name of the costumer" should be placed in column 02. Column 1 is already used for other information.
So the problem is that after publishing the form the name of the customer is placed in 2 different column, so not searchable any more... The easiest option would be if I could just make some columns 'invisible' in the published form, but I can't find such option. Also I haven't been able to change this in the php-code (just to delete some columns to be published) once it seems to get the information to be published directly from the database. I couldn't find something like:
<table class="table_1" cellpadding="1" cellspacing="1" border="0" width="798">
<tr>
<td width="180" valign="top">
test 1
<span class="req"></span>
</td>
<td class="answer" valign="top">
<div class="pad_left">
<input type="text" name="field1" value=""
class="cf_size_medium"
/>
</div>
</td>
</tr>
<tr>
<td width="180" valign="top">
test 2
<span class="req"></span>
</td>
<td class="answer" valign="top">
<div class="pad_left">
<input type="text" name="field2" value=""
class="cf_size_medium"
/>
Because than it would be possible just to 'delete' one <tr>...
I hope someone has a solution! Thanks!