5 posts in this topic
Can I make a layout containing a card and a list simultaneously from the same table??
I was wondering if it is possible with FileMaker Pro Adnvanced (12 my version) to create a layout containing a list and a card (details view displaying a whole record) in the same layout, i.e.:
- on the left side, see a list of all records (and a scrollbar maybe)
- if I click on a line, in the right column, a details view is shown to edit the details.
It does not work with the referenced records tool - they are not records from other tables, but the same table.
(and sorry for maybe some odd words - I have the German version and I am not sure about the correct English ones)
Does that work? Many thanks for your help,
Returning to same Scroll Row on Layout
I am using Windows OS for my solution. I have a layout in list view showing events. An admin user is to add groups of people as attendees of these events by pressing a button to run a script. The script Freezes the window, changes layout, adds the attendees in the relevant table and returns the user to the original layout.
This all works well, except for when the script returns to the original layout and unfreezes the window, the scroll position of the active row (the record that the user is editing) jumps to the bottom of the screen. I would like the scroll position to remain static or be returned to where it was before the script changes the layout - so a change is imperceptible to the user.
The Window Scroll options seem limited to top, bottom, pg up, pg down. I have also tried having the script open a new window before changing the layout, but you then see the script working - if only briefly - as the new window comes to the front.
Has anybody got any suggestions on how I can return the scroll position to exactly where it was before the script executes?
Thanks in advance,
How to, on the layouts, relate two many-to-many records
I have two entities, that have a many-to-many relationship.
I have my Computers entity, and a Users entity. One user can have many computers, and one computer can be used by many users.
I created my Computers and Users tables, plus a join table to have the relationship. The tables are OK, and work fine, I manually tested with setting IDs.
My problem is that, on the layouts, I don't know how to technically and concretely relate two records from each table. I tried with external portal, but when I tried, it also creates records that I don't want.
Simple: I would like to be on the Computers layout for example, and set a field so this computer is linked to one given user. And the opposite.
With what tools can I do that. What related field to put on which layout so I can relate a Computer with a User.
Thanks a lot for your help !!
formatting merge fields
How can I set and change the font of a merge field that will appear in a mail merge letter? Especially when it is a different font from the font as used in other layouts?
I am having special difficulties with merge field numbers that are dollar amounts. I cannot get Filemaker tout commas in the right places of the merged 5 or 6 figure number.
Footer Text Too Long
We are developing a contract layout for a client. There is a modestly long header (260 its.), short body (26pts), but a very long footer that is one large text box detailing terms and conditions. Its boiler plate but they need it there. Since it is one large block it won't print on the first page. Instead in preview mode the bottom half of the page, below the body, is blank and the boiler plate starts on a second page.
Is there a way to have this last large text block start on the first page and spill over onto a second page?
How can I get this to format correctly as one cohesive document?