FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Form Builder - publish only certain form fields online?
#1
Is it possible to only publish certain form fields online in a contact form? I would like to make a contact form that visitors to my website can fill in, and that besides these filled in ‘fields’ there are still other fields that I can fill in later. For example:

Name: (filled in by visitor of website)
Addres: (filled in by visitor of website)
Technical problem: (filled in by visitor of website)
======
Technical Solution (not visible for visitor of website, filled in by me) etc.

If I publish the form, the visitor sees automatically also the field “Technical Solution” and I would like it to be ‘hidden’/ not visible on the contact form, but still available in the form itself, so I could fill in the technical solution later.

I found the option: Forms > Views > Fields > Editable, and if I deselect the field “Technical Solution” it indeed doesn’t show up in the contact form anymore (as I wish), but in that case I also can’t edit it myself anymore (to fill in the technical solution).

I was thinking maybe to make this field ‘not editable’ and change later the name of the form in Mysql where the data is stored, hoping that in that case the contact form on the website isn’t showing the field “Technical Solution”, but, once the database is changed I could still fill it in later myself. But I was wandering if there is a more easy and practical solution for this. Changing database names is always risky…

Thnks for any help!
Reply
#2
Big Grin 
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! Smile
Reply
#3
Still no solution Sad I tried everything: changing the view, changing the columns in Mysql, renaming everything... nothing worked. And in the help I see that changing the view won't help, because everything will be updated:

"Since Views already define all this for us, the Form Builder simply takes that information and renders it with templates, thus creating your form. Any time you change your form View (e.g. add or remove fields to it), any published form that uses it will be automatically updated to show the changes. You don't need to re-save or re-publish the form."
Reply
#4
I'm wondering, what if you create 2 views: one with the fields that you want the others to fill-in and another, where all fields are available. Then, in the Publish window, select the former and publish it at a location that your website visitors can access.

If you want, you can publish the other view, too, at a location that you will use for yourself. Alternatively, you can use the view that you want from the Forms>Views menu.

Good luck,
G.

(Feb 8th, 2015, 4:50 AM)Hellas Wrote: Is it possible to only publish certain form fields online in a contact form? I would like to make a contact form that visitors to my website can fill in, and that besides these filled in ‘fields’ there are still other fields that I can fill in later. For example:

Name: (filled in by visitor of website)
Addres: (filled in by visitor of website)
Technical problem: (filled in by visitor of website)
======
Technical Solution (not visible for visitor of website, filled in by me) etc.

If I publish the form, the visitor sees automatically also the field “Technical Solution” and I would like it to be ‘hidden’/ not visible on the contact form, but still available in the form itself, so I could fill in the technical solution later.

I found the option: Forms > Views > Fields > Editable, and if I deselect the field “Technical Solution” it indeed doesn’t show up in the contact form anymore (as I wish), but in that case I also can’t edit it myself anymore (to fill in the technical solution).

I was thinking maybe to make this field ‘not editable’ and change later the name of the form in Mysql where the data is stored, hoping that in that case the contact form on the website isn’t showing the field “Technical Solution”, but, once the database is changed I could still fill it in later myself. But I was wandering if there is a more easy and practical solution for this. Changing database names is always risky…

Thnks for any help!
Reply
#5
Shocked 
Garof! You are my hero! Smile

This indeed was exactly what I was looking for. After publishing the form in view 2 (a new view I made), the view of the form itself (view 1) also changed, but after updating it again (without changing anything) it was back to the way it was.

You probably really can't believe how happy I am: this cost me at the end approximately 100 hours and at the end there is a easy solution, like I expected, but sometimes you need the input of someone else to get to it... And it took weeks before someone was replying, so I also gave up checking the forum every day (read: every hour in the beginning Wink.

Thanks a lot and it works perfectly now!



(Mar 25th, 2015, 12:00 PM)garof Wrote: I'm wondering, what if you create 2 views: one with the fields that you want the others to fill-in and another, where all fields are available. Then, in the Publish window, select the former and publish it at a location that your website visitors can access.

If you want, you can publish the other view, too, at a location that you will use for yourself. Alternatively, you can use the view that you want from the Forms>Views menu.

Good luck,
G.

(Feb 8th, 2015, 4:50 AM)Hellas Wrote: Is it possible to only publish certain form fields online in a contact form? I would like to make a contact form that visitors to my website can fill in, and that besides these filled in ‘fields’ there are still other fields that I can fill in later. For example:

Name: (filled in by visitor of website)
Addres: (filled in by visitor of website)
Technical problem: (filled in by visitor of website)
======
Technical Solution (not visible for visitor of website, filled in by me) etc.

If I publish the form, the visitor sees automatically also the field “Technical Solution” and I would like it to be ‘hidden’/ not visible on the contact form, but still available in the form itself, so I could fill in the technical solution later.

I found the option: Forms > Views > Fields > Editable, and if I deselect the field “Technical Solution” it indeed doesn’t show up in the contact form anymore (as I wish), but in that case I also can’t edit it myself anymore (to fill in the technical solution).

I was thinking maybe to make this field ‘not editable’ and change later the name of the form in Mysql where the data is stored, hoping that in that case the contact form on the website isn’t showing the field “Technical Solution”, but, once the database is changed I could still fill it in later myself. But I was wandering if there is a more easy and practical solution for this. Changing database names is always risky…

Thnks for any help!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)