Brand new to FileMaker Pro ... I'm creating a form whose entries may be
one line in one record, and many lines in another record. How can I
create each field so that it expands with the amount of text in it?
In other words, I'd like to have the field show up as a ten line field
on one page, but on the next page, where the text for that field is
shorter, have it be a one line field, and not have a large space between
it and the next entry.
|
|
0
|
|
|
|
Reply
|
robarre (1)
|
4/1/2007 12:55:11 AM |
|
In article <460f02fe$0$24745$4c368faf@roadrunner.com>, "R. Barre"
<robarre@hotmail.com> wrote:
> Brand new to FileMaker Pro ... I'm creating a form whose entries may be
> one line in one record, and many lines in another record. How can I
> create each field so that it expands with the amount of text in it?
>
> In other words, I'd like to have the field show up as a ten line field
> on one page, but on the next page, where the text for that field is
> shorter, have it be a one line field, and not have a large space between
> it and the next entry.
FileMaker Pro doesn't have "expandable" fields.
For on-screen use they would be a waste of time since you'd have to
leave enough empty space under the field for it to expand into anyway.
You can set the field to an "average" height that may be needed and
then give it a scrollbar (Format -> Field) so that users can access any
data "off the bottom". Technically you don't need a scrollbar since
when you click in the field FileMaker will automatically make it bigger
to see all the text (or at least as much as fits on the screen size),
but it does look messy that way.
For printouts and Preview mode you can use Sliding. Make the field to a
"maximum" size that may be needed. Next select that field and ALL the
fields and objects below it (within the same Layout Part) and set them
all to Slide Up (Format -> Sliding Printing) and to "shrink the
enclosing part".
Sliding can be tricky to get working properly, but remember you will
not see any change in Browse Mode or Layout Mode - only in Preview mode
or when printing out the Layout.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
|
|
0
|
|
|
|
Reply
|
helpful_harry (1511)
|
4/1/2007 1:55:19 AM
|
|
You can do that using the "Merge field" and you data will only take place it
need
OR
use the "sliding/printing" in the Format menu to make object slide up.
JF
"R. Barre" <robarre@hotmail.com> a �crit dans le message de news:
460f02fe$0$24745$4c368faf@roadrunner.com...
> Brand new to FileMaker Pro ... I'm creating a form whose entries may be
> one line in one record, and many lines in another record. How can I
> create each field so that it expands with the amount of text in it?
>
> In other words, I'd like to have the field show up as a ten line field on
> one page, but on the next page, where the text for that field is shorter,
> have it be a one line field, and not have a large space between it and the
> next entry.
|
|
0
|
|
|
|
Reply
|
bizouman_takethisout (48)
|
4/1/2007 2:10:44 AM
|
|
R. Barre wrote:
> Brand new to FileMaker Pro ... I'm creating a form whose entries may be
> one line in one record, and many lines in another record. How can I
> create each field so that it expands with the amount of text in it?
>
> In other words, I'd like to have the field show up as a ten line field
> on one page, but on the next page, where the text for that field is
> shorter, have it be a one line field, and not have a large space between
> it and the next entry.
If you want it to work like an invoice, where an invoice can have any
number of lines,
follow these steps:
1 Two tables are needed, Invoice and LineItems for example
2 Create a number field for each table. Called id_invoice and
id_lineItem
3 Link the tables with a relationship using the id fields =
4 On the LineItem side of the relationship check "Allow records to be
created" (double click link icon)
5 Create a portal in your original layout (invoice) and link it to
lineItems
6 Add the fields you want to view in LineItems to the portal. Don't
use the id field
6 In the portal settings window, (double click the portal), check
"Show scrollbar"
7 In the field, id_invoice, set it to auto enter a serial number, to
give each new invoice an id
Back in browse mode, an empty line will appear in the portal. Enter
any data in the field
and exit the field. When you exit, a record is created in lineItems
and the field id_LineItem
will automatically have the same id as the parent invoice. If you open
another window to
view the lineitem table you can watch the record being created.
Good Luck
Mike Phalen - Developer
|
|
0
|
|
|
|
Reply
|
mikerobeer (3)
|
4/5/2007 4:47:30 PM
|
|
|
3 Replies
66 Views
(page loaded in 0.122 seconds)
Similiar Articles: How do I create a Multi-page Invoice - comp.databases.filemaker ...My company invoice has provisions for six separate items on each invoice with fields for Quantity, Class (Labor, Material, Travel, Misc. and Payment ... Create Table with multi-column constraint(unique) - comp.databases ...Then you can check each index's Fields collection to see which fields and their properties make up the index. (I've never tried it, but I suppose there is a way to do ... Printing multiple fields from individual records - FMP 5.5 - comp ...Printing multiple fields from individual records - FMP 5.5 - comp ..... how to do >this, do I need to create ... Printing multiple fields from individual ... concatenate data from multiple fields into one - comp.databases ...From what I have been reading it is possible to copy data from one field into another by doing something similar to this: UPDATE table SET field2... create url shortcut on desktop with login script - comp.lang.misc ...I don't know the significance of that, nor if there were any other optional fields). So all you have to do to create a shortcut on the user's desktop is to find out ... horizontal separators - comp.lang.java.guiHow do I create horizontal separators in the middle of a JPanel like in the picture ... This involves including in the body a horizontal string of text and number fields ... get or query creation date of an record? - comp.databases ...Hello, I could not find a command that delivers me the creation date of an record. Under define Data base --> create record --> options for fields the... Printing from field 14 to end of record - comp.lang.awkHi, How do I print from from a certain field to the end of the record? For example, I have an input record that has data I want starting at field 14... Can a query return both a count and ensure that a particular value ...I have a table with fields id, parentid, userid, and rowtype. I have joined it with itself where one parent row has a one to many relationship with... EBCDIC packed fields conversion - comp.unix.programmerI have a specific file layout that I need to create which > : > contains some packed fields. My question is how to create an EBCDIC > : > based file on a Unix platform ... How to Do Expandable Fields in Adobe LiveCycle | eHow.comLiveCycle is a PDF-form developing application from Adobe Systems. It may be purchased individually or as part of the Acrobat Pro or Pro Extended applications ... How do I create an expandable field in Adobe LiveCycle ES - JustAnswerQuestion - How do I create an expandable field in Adobe LiveCycle ES. Find the answer to this and other Computer questions on JustAnswer. 7/16/2012 12:30:01 PM
|