Jump to content

Search the Community

Showing results for tags 'layout'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 75 results

  1. In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played. Also, I would like to have this capability when I move my solution over to FileMaker Go Thanks!
  2. Hi everybody, I recently amended a db from an old Lynda course, controlling shore excursions for river cruise ships. For my limited expertise (I am still a rookie at the very best) the construction is somewhat complex as there is many vessels, different routes, different charterers and consequently different shore excursion programs and prices. In some cases the shore excursion program of different vessels and operators is similar but not the same and so on. I have 7 different tables partly related (pls see graph attached): For every journey ::customers and ::trip are assigned a tour code and date (“tour code” is not unique as journeys repeat themselves during the season, “Tour Code” in conjunction with “Date” is unique) Every tour operator/vessel has many trips on every journey. All table occurences and fields are uniquely defined by unique id. Now I want to create an opening layout reflecting all relevant cruise information such as passenger list from ::customer and ::trip (shore excursions) for the specific journey, as well as other information in text fields. But I seem to be unable to get the right relationship and layout setups together. I tried all possible relations and layout setup combination but nothing worked so far. On the same layout I was able to either retrieve the passenger list from ::customer for each journey or the offered shore excursion (trip) list from ::trip but not both together on one layout. What is it, I am doing wrong? Any ideas are appreciated
  3. Hello I have some buttons which allow me to define some values which will help choosing the kind of report which should be created. The button sets a variable value (for instance to "details", "daily", "monthly") and the script acts accordingly. My questions: • is there a way to show the value of the variable on the current layout? (found it after a much needed coffeebreak... ) • would it be wiser to use a global to store the choice? Thank you for your short answer. Cheers
  4. Hi, I have 2 related questions. I have a portal in my invoice. It is followed by a closing paragraph which slides up to where the portal ends. I am producing a pdf to mail to the user. The portal may grow to 25 lines which would take it across the page break. Q1. How do I get the break in the portal to respect the page margins? It seems to print the first line on the second page half cut off by the top of the page. Q2. If the portal is only a few lines is there any way to eliminate the blank page 2 of the pdf?
  5. I'm coming up with questions on an hourly basis it seems...I've done google searches and still can't seem to find answers, but sometimes asking the right question is the hardest chore. Â Ok, I want to have an concession stand customer ordering system and this made sense "to me" in my graphical way of thinking, HA!: Â I have layouts for each step, such as... Â [step 1] "Select order type..." (OrderTYPE is a field with Value List to choose from via radio buttons: Walk-Up, Delivery, Pick-Up). Â I then made a 'NEXT' button that I thought I'd send to the corresponding Layout calculated by the choice selected---let's say [step 2: Walk-Up], [step 2: Delivery], [step 2: Pick-Up] accordingly. How do I do this? Â Via 'Layout Name by Calculation'? If so, what would this calculation look like (I have a basic programming knowledge, artist by heart tho, of 'if/else' or 'case' arguments) in the correct syntax? Am I even on the right thinking path? Â Reason is some orders don't require needed info compared to others (ie: Delivery vs. Walk-Up) Â [step 2] [step 3] [step 4] etc... Â I'm attempting to make a touch screen UI for iPad that is pretty simple and intuitive for taking orders. Â If there's a better way of doing this, I'm all ears (eyes ). Â Thanks for taking the time! Â
  6. I'm trying to find a way to create a field with a value range of 100-200 (that's the easy part) and I want to use a sliding volume-control type method for the user so they can click on the slider knob or button and drag the slider either left or right to pick the value. I'd like for the user to still be able to enter the value manually as well. FMPro 13's slider doesn't do what I need, so I'm looking for a slider type button or such. Any suggestions or plugin ideas are appreciated. Thanks. I'm using FMP 13 advanced. ~Rich
  7. I searched and couldn't find an answer for what seems like a mighty simple problem.... I have a simple list organized by one sub summary field. There are two tables: taxa and families. Every taxon is a member of a family. There is an integer that I sort families by and taxa by. I then print with a sub-summary in the layout, followed by fields for each taxon. (See attached). It is printed in two columns. When I print (go to Preview mode), sometimes there is a large space at the bottom of one column and a sub-summary break to the next column. Sometimes there isn't. I can see no rhyme or reason why. I have "Allow part to break across page boundaries", but that doesn't seem to affect this problem. I'm using Filemaker Pro Advanced 11.0v4 for Macintosh. Any thoughts?
  8. Apologies in advance for the newbie question, but I really have searched extensively on the web, this site and various tutorials. My only conclusion is that I do not know which question to ask, as I am fairly accomplished in VBA. I am self-learning Filemaker Pro 12 as I need solutions for an Ipad and I like the ease of creation and modification on the fly. Essentially, I have a database where the master might be many hundreds of fields, or I could create myriad tables and keys - this is irrelevant to the problem. What I would like is to create a solution where at the first field of entry, a dropdown allows for a selection of, say, 10 choices. When that field is filled, depending on the choice I would like a specific layout to appear for data entry. These layouts may have some fields in common with others but never all. Put another way, if I have Item_Field, and user clicks A, I would like the layout for A to appear natively or show up in a portal below. When they click new record, it reverts to the main layout again. I might also need this process to be iterative i.e. several levels down. If this involves CASE scripting, that does not scare me, I just need to know what to look for in the reference materials as to what this process is called. Any help would be appreciated. Thanks in advance.
  9. I don't even know where to begin.  I have a db...In every layout for every table—in spite of the fact that their parts all have a white fill—the background turns red in preview mode. I'm using 12, so if I change the theme, this doesn't happen, but if I change the theme back to classic, I get the red background again. I put white rectangles covering the layout parts and that helps; except at the part boundaries, you can still see red and there's nothing you can do about it.  Any ideas where to being troubleshooting? I found out that if I remove the white background fill, the default color is red...in classic...So what that seems to mean, then, is that in preview mode, my white background is being stripped away. The clumsy solution was to select a new theme, turn everything white, remove the alternating body fill, and copy the layout objects onto this new layout. But I want this red background thing to make sense to me!  So thanks for any ideas at all.
  10. I am using FMP13 dark theme as default to design a layout with a tab control set, I insert a container field the last (deepest) tab. Alas! the image in the container is shown in every tab, as if it was on top of the tab control. What's wrong? Thanks for your help
  11. Anyone seen this? My lovely styled fields for iPhone that certain perfectly served from FileMaker Pro 13 and accessed by FM Go 13, look great. But when I run them from my test FM Server 14 or from FMP 14 and access via FMP Go 14 on any size iPhones, the padding is wrong and hard to correct too. Anyone? We are writing up a fancy post at the filemaker.com forum and may have further information from that source which we will post here if not resolved by then.
  12. Hi, I have some layouts presented in table view (only), and with a header that contains a series of buttons arrayed horizontally across the screen. This is to help colleagues that are more accustomed to Excel style data entry. However when a table contains many fields that go beyond the screen it becomes very inconvenient for the users to scroll back to the far left to use those buttons. Is there a way to make the header scroll sideways? Or more likely, an alternative that allows the user to see the button even if they are far far to the right side of the screen? Thanks for your help and advice! MacGuffin
  13. Hi everyone! I am a bit overwhelmed by FileMaker and its capabilities, so I would greatly appreciate some help. Currently, I have a database of contacts throughout the entire United States, with separate groups. (Group A, Group B, Group C, Group D, Group E). I would like to create some kind of "dashboard" or "layout" for FileMaker so that I can see how many members of each group we have in each City and in each State in the country, possibly like a pie chart that adapts to the data. Could someone please explain to me how to go about setting this kind of layout up, so that I may browse these breakdowns on the fly? Best Regards, Jonathan Ross
  14. Hi All, I've been away from FileMaker for a while and just recently came back for a personal project. This means I'm using FM 11, which is pretty old now... Anyway! I have a layout with a picture as a background and I'd like to have a graphic slide up based on the text merge field above it, but it doesn't want to slide because of the graphic it's sitting on. Is there a way to have an object ignore a background object for sliding?
  15. I am trying to freeze a certain portion of my record template so it stays in place while I scroll through the rest of the layout much like freezing columns/rows in Excel for convenient reference. In essence, I want to make sure I can still see things like the patient name/date of entry when I scroll down on the layout. Any suggestions?
  16. I want to have a list of all records (their names and id number) in the found set on the side of the layout and be able to select records and see related information while still being able to see all the rest of the records in the list. Thanks for the time!
  17. As you know, FileMaker 14 included a new widely used feature: button bars. No need to say why they're awesome, but you've probably noticed it wasn't that easy if you wanted to create a lot of similar buttons, or convert your old button objects into button bars. Well, these are not issues anymore, thank's to Federico Basmadyian's ButtonBarTool, available here.
  18. How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html I'm able to grab the content from the first subsummary, not the remaining however. The following: set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.
  19. Hi there I am experimenting on a sample of data in a very simple FM database. I need some help on 'how' FM does things, rather than how to do something myself (although you may scream at my technique below!) I have two customers on Customer_Table with CustomerID and Name as the fields. The only other table is called Data and is joined to Customer via CustomerID_FK. It's a one to many relationship as each customer can have many data rows, around 400 each. Therefore I have around 800 records in the Data table. I have added three text fields to the data table which enable true/false conditions to be set. I use many CASE statements on the Data table to select various values from records depending on the combination of true/false conditions. I then summarise these on a second field to get the grand total per true/false combination. An example of this would be: CustID Text1 Text2 Text3 Amount CaseStatement1 CaseStatement2 10 North Confirmed Bob 11000 11000 10 North Possible Bob 5000 5000 If I want a grand total of Bob's confirmed and possible sales in the north, I'd do: Case ( Text1 = "North" and Text2 = "Confirmed" and Text3 = "Bob" ; Amount) Case ( Text1 = "North" and Text2 = "Possible" and Text3 = "Bob" ; Amount) I then create summary fields for CaseStatement1 and CaseStatement2 to get the specific values I want. As I say, given the details in the data I have and the requirements of the task, there are many similar calculations through my test DB. The next part of my test was to see how I can easily move between customer records to view which sales have happened, ie, view the summary fields. I set up two layouts, one based on Data and one based on Customer. Given the data I have and the volume of summaries, I noticed it was significantly quicker moving on the Customer layout between records 1 and 2 than using the Data layout (which of course has 800 records). What I don't understand is that surely FM still needs to calculate the Case and Summary statements while moving between just the two customer records regardless, so why is it so much quicker one way versus the other? Thanks in advance
  20. Hi from a relative newbie, I have a FMP 13 file that works fine on some computers (both Windows and Mac) but on one Mac computer it works only partially. Several of the layouts work fine, but one layout is "frozen" and does not permit entry in any of the fields. Is there something in the Mac OS that could "lock out" a particular layout, but leave all others normally functional? Should I re-install FMP 13? (I'm not sure how to do that on a Mac. I'm mostly a Windows worker.) Any help or insight would be welcome. Thanks, Tom
  21. Hello everybody, I am working on a Metanalysis DB and I have currently 2 tables: STUDY (Parent) and REFERENCE (Child). The STUDY table has a primary key __pK_StudyID, while the REFERENCE Table has a primary key __pK_RefID and a foreign Key _fK_StudyID. I have set up a relationship one to many between STUDY and REFERENCE so that __pK_StudyID (STUDY) --> _fK_StudyID (REFERENCE), and I have allowed record creation through that relation. Now, as expected, when I create a Portal of REFERENCE fields in the STUDY layout table, I am able to create new records (that is new references for the same study) and fK is automatically populated. What I would like to do though is to be able to auto-populate _fK_StudyID and add new records to the REFERENCE Table using the same layout (i.e. the STUDY layout) but without a portal. If I move the REFERENCE table fields into the STUDY layout (without a portal), everytime I create a new Study, a new reference is created and _fK is auto-populated as expected. The (hopefully silly) problem come when I try to create a new record in the REFERENCE Table (that is to add a new Ref. for the same Study): I have created a simple script that: - Create a variable: $StudyID to store the specific __pK_StudyID - Go to the REFERENCES layout - Create a New Record - Set field _fK_StudyID (of the REFERENCE Table) to have the value stored in $StudyID - Go back to the original (Study) Layout. Now the script works flawlessly, and the new records (i.e. new references) for the specific study are correctly created, so that when I go to the REFERENCES layout I can see them. Unfortunately, in the Study Layout I can see only the first reference I have created, not the additional ones. Of course, when I put the same fields of REFERENCE Table in the STUDY layout inside a portal I can see all new records I have created.... Anyone can give me a reason fro that ? At this time, the only way I have to create study related references (and see them) is changing layout and that is not the most efficient way to face the problem. Thank you always in advance for your help
  22. I think what I need is a portal, but there may be a way to accomplish my objective with a find script. Please see my 'About Me' section for a description of the project I'm referring to. This might help describe it as well: [TABLE]Field 1- [isolation Points]Component, Description, Position, Notes 2- [Equipment]Name, Description, System, Notes 3- [Equip_IsoPnts] Equipment:Name, Isolation Points:Component The 3rd table relates the first field in tables 1 & 2. On my layout, there's a dropdown that allows the user to select a value from the Equipment:Name field. Below that, in the layout, I would like to insert a table that lists all records from the Isolation Point table that are related to the Equipment:Name the user selected. Is a portal the way to go? Does anyone know how to set this up?
  23. Hi, I investigated this when FMP13 was launched and now I see again the very trick layout in the "FMP14 Getting Started" document. Does anyone have any suggestions as to how they are building the collapsable menu? Thanks, Skip
  24. Hi, 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, Claus
  25. Just curious. I know merge field can and are used on reports, but what about using them in a layout that will be in browse mode? Is this wise? The advantages: User can not change the fields. Disadvantages ? Would you recommend the use of merge fields in a layout that will be used in Browse mode only?
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.