Jump to content

Search the Community

Showing results for tags 'formatting'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

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 19 results

  1. I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, ev
  2. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that
  3. When on webdirect I copy/paste text into a box, but when I click away the text is automatically reformatted with double spacing. Is there a way I can prevent this from happening. If I copy/paste into the desktop software, or even via webdirect on the computer hosting the server, the double spacing doesn't happen. Thanks!
  4. Folks I'm having a bit of headache with a search script. I want to search a date range from today to 90 days in the future. Currently I've made a script with a step saying: Insert Calculated Result [Select; "date field"; ( Get (CurrentDate) & "..." (Get (CurrentDate) + 90)] Being in the UK, I'm working with a file that was created on a US computer - the month and day are the wrong way round. I've changed the text on the system to use system settings but that still doesn't solve it! Frankly, that's quite ridiculous! Surely a bug like this that has been around for a VERY lon
  5. john9210

    Using grids

    I can't figure out how to set the grid for my layouts. Major grid spacing and minor steps? Are there any good general rules to follow? Should the spacing be a function of the font size I want to use?
  6. Hi. I built a database about a year ago but it wasn't required at the time, a year later and it is needed so I'm pretty rusty at present ref FMP but need to is user friendly. All I want to do is add a slight tint to the background colour of certain fields in list view when the row is not active but try as I might I just can't seem to do so. In the active state yes, but not when the row isn't active. I have made a little video that might help the reader understand my predicament, any help would be appreciated. https://drive.google.com/file/d/0B687aT8LAHKmRHEyZjh5OFdlSnM/view
  7. 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
  8. 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.
  9. I'm using Filemaker 11. I have a table called Computers with fields:UID, Computer Name (MacBook0001, MacBookAir00002 ect.) this is a parent of the Hard Drives table which lists Hard Drive size and Hard drive type (SSD, or SATA) along with UID. I have a portal on the Computer layout which lists Hard Drive size and type that were assigned to the computer on the Hard Drive layout. I have setup basic report just listing the Computer name. I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD. test.fp7
  10. Hi all, Apologies if this in the wrong place, but it seems like the best fit. Just wondering if anyone can help me out with a script I'm struggling with. The background: I have a button I'm using to launch a new window with another layout, then create a new, related record. This action will only happen if the user has completed a specific field in the original layout (__pkCollectionRef), step one of the script. With the new window open, the user will then make a selection from a checkbox set and close the window, which will put their selections into a field in the original layout. This par
  11. Hi - I have several fields that I want to show zero if the value is zero (rather than be blank). Some are calculated fields and some are user editable. On the data tab of the inspector, I have left UNCHECKED the option Do not display number if zero. Yet, they remain blank if zero. The fields are formatted as currency with fixed decimal set to 2. Is there some simple option I'm missing?
  12. FileMaker 14 is here! To celebrate, FileMaker Weetbicks has written 14 articles all about FileMaker 14. Over the next few weeks we will be releasing these articles to the community. We cover all the cool new features (and some hacks!) and take things further as we usually like to do Stay tuned! Click here to read the full article…
  13. Anyone else having this problem? When I format the fill and/or borders on fields, they: Only show up in browse mode for the active record (none of the others) Formatting disappears completely on Preview Mode I have Alternate Row and Active Row states set to off. I'm hoping it's something simple that I just can't seem to find. I've uploaded the Browse, Layout, and Preview mode screenshots of a layout where this is a problem, Thanks!
  14. Okay… here’s a toughy. I’ve got a corrupt file, so we need to get all the data into a clone of a known-good backup. Obviously I can import it directly, but to be absolutely certain we’re getting rid of all corruption, my supervisor has requested that I export the data to merge files and then re-import it into the known-good clone, which sounds great to me. Unfortunately, there’s a snag: a lot of the data includes formatted text, which is very important to maintain. So, here’s the solution I came up with, repeated for each table in the solution: 1) Export all modification information (mod a
  15. I have a layout that displays a chart of the current found set, the user can choose to copy the chart or export the data to excel for more advanced charting options. It's a simple line chart, temperatures by date taken from two fields. The first data point the symbol is cut off and the last data point is cut off. Seems like it should be simple..... I must be missing something. Below is an example.
  16. We have a message in the database that is sent out to end users at certain times. Filemaker used to properly format the line break tag <br> at the end of the lines where it was needed. Now it sends them along in the message which is confusing a lot of our non-technical users. I have removed them but now the message is not properly formatted and comes in on large chunk of text. Has anybody experienced this as well and have any advice for a solution to restore formatting the way we would like? Thanks in advance.
  17. I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field. Chapter Title Sentence ABC aaba ABC abac ABC efgdf ABB bdc ABB cdfegdf . . . What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1 For examp
  18. I'm not sure what the best way to do this is.... We have data that is created within an FMP based system. One department would like to be able to regularly export found sets into excel, however since the resulting excel documents are forwarded on to clients they are fairly heavily formatted. There are some breaks and color etc. On the formatted excel sheet the first 30 rows or so are taken up with header type information. I'm not aware of a way to apply substantial excel formatting within FMP. I'm looking for workflow suggestions. Perhaps once records are exported into an excel
  19. I have a file which I am setting up preferences for my client to change the look of the file without entering layout mode of course. So I'm using conditional formatting on the backgrounds and text field labels. Nine of the tables are the main data entry screens. However, on 2 screens I can't get conditional formatting to work. I used container fields that provide the backgrounds where they can select a color from a repeating field of 24 choices. This works like a champ, including the 2 screens in question. I used radio buttons to select from a value list of colors. The condition is
  • Create New...

Important Information

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