Adding fields to a form

Creating and using forms

Adding fields to a form

Postby Lucie54321 » Tue Nov 03, 2009 8:04 pm

I set up a very simple Form using the Wizard to add entries to a mailing list, and added lots of data. Now I've realised that I need an extra field so I have added it to the Table but I cannot (after looking at numerous tutorials and searching forums and just playing around) add the new field to the end of the Form. I found the button called "Add field" but it doesn't seem to work in any intuitive way. Is there a way to go back into the Wizard? It would be a matter of two clicks in the Wizard but seems to be surprisingly technical in the Edit Form screen. I tried dragging it from the Data Source as suggested somewhere but it didn't seem to work on a Mac

Thank-you
NeoOffice 2.2.5 with MacOS 10.5
Lucie54321
 
Posts: 1
Joined: Tue Nov 03, 2009 7:42 pm

Re: Adding fields to a form

Postby eremmel » Tue Nov 03, 2009 10:49 pm

When your form is very simple and just the result of the form wizard, just make a new form with the wizard and delete the current one. If this is not acceptable, you need to study some tutorials or documentation. Please have a look to the getting started guide of Base at OOo 3 user manuals.
Please, edit this thread's initial post and add "[Solved]" to the subject line if your problem has been solved.
OOo 3.1.x on MS Windows XP SP2 and SP3
eremmel
Volunteer
 
Posts: 126
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Adding fields to a form

Postby evwool » Sun Nov 15, 2009 11:01 pm

You may have already discovered the answer to this but just in case you or anyone else doesn't want to trawl through the entire instruction manual:
I'm guessing that you are trying to add a field to a table grid in a form - and it's not intuitive at all, I quite agree.
In Design View of the form, right click on a blank bit of the top area of the table grid where the other fields are.
Choose Insert Column. Choose the type of Control you need to match the type of field you have added eg if you have added a currency field then choose Currency Field.
A new control will appear, called Col1 usually.
Right click on it and go to Column. A Properties window will open.
On the General Tab type a name of your choice for the control.
Underneath, in the Label box, type the name you want to appear in your form eg. MyDate.
Click on the Data tab and click the down arrow next to the row that says Data Field and choose your new table field from the list.
OpenOffice 3.1 on Windows XP
evwool
 
Posts: 136
Joined: Fri Oct 09, 2009 9:40 pm
Location: UK

Re: Adding fields to a form

Postby evwool » Tue Nov 17, 2009 9:23 am

Or better still, ignore my last post and, in Form Design View, press the Add Fields button and drag the field onto the top of the Table Grid, next to another field :oops:
OpenOffice 3.1 on Windows XP
evwool
 
Posts: 136
Joined: Fri Oct 09, 2009 9:40 pm
Location: UK


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests