Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×


  • Content Count

  • Joined

  • Last visited

  • Days Won


Fitch last won the day on June 28

Fitch had the most liked content!

Community Reputation

175 Excellent


About Fitch

  • Rank
    Imaginary friend

Profile Information

  • Title
  • Industry
    Public health
  • Gender
  • Location
    Portland, Oregon

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra and Win 10

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. It sounds like you want a horizontal portal? That's not a built-in option, but you can simulate it by creating single-row portals, each one starting at a different row. I think you will find this much easier to manage than a bunch of duplicate fields.
  2. Here's a better search for you: filemaker email attachment loop Your script will need to use a loop to create the individual PDF and send it.
  3. conculcate (obsolete): to tread or trample underfoot You're probably right. I thought they wanted a list of all states. I've re-read the post but it's still not clear to me.
  4. Agree 100% about ExecuteSQL -- only use that in scripts, not field definitions. Not sure what's the point of Substitute ( FilterValues ( List ( TABLE2::STATE) ; [states] Why not just the text? If ( COUNTRY = "USA" ; "Alabama; Alaska; ... etc" )
  5. Or you could use ExecuteSQL. Or just hard-code the list of states in your script, or in a value list, or a custom function.
  6. The missing piece here is a field that stores the "level." With that in place you could approach this in various ways. For example, a Level table with a number field and a container for your graphics. When you set the level field in record, it could simply display the related graphic from the Level table. Welcome to the forums.
  7. Context is key in FileMaker. As comment suggested, go to a layout that's based on the Images table and run your loop/export there. You can make Go to Layout the first step in your script; then Show All Records if you want to export them all; then Loop.
  8. No, but rather than using a field, you can set a variable and base the hide condition on that. Make sure to name the variable with two dollar signs so it's global. E.g. $$hide https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Fset-variable.html%23
  9. The Database Design Report (DDR) mentioned above is under the FileMaker Tools menu if you have enabled the advanced options in your preferences. This is in FM17 and newer. In older versions, FileMaker Advanced was a separate product. Please set your version and OS in your profile here so we can better answer your questions. Once you have the DDR, as Ocean West says there are various tools you can use to work with it. My go-to is BaseElements.
  10. Maybe the fields aren't actually inside the portal? An easy way to check is, in layout mode, click the portal and then nudge it with an arrow key. Did the fields move along with the portal?
  11. Nice! Now it looks like a ransom note though...
  12. I see today a banner on an old topic: ""This topic has 2683 days old and we rather you open a new topic instead of post it here." This is a great feature that's new to me. The grammar is wrong and awkward, though. I'd suggest something like: This topic is 999 days old. Please don't post here. Open a new topic instead. Also, maybe we could just auto-lock threads older than a year or two? Don't know if that's possible.
  13. I have never heard of a bank that allowed 3rd-party software to move money.
  14. If you're interested in iOS deployment, this could be a good option: https://www.24usoftware.com/xgode This is a reputable vendor (I am not affiliated) that's been in the FileMaker community for many years.
  15. A couple of things: - in layout setup you can choose which views are available. Be sure to explore the table view properties options - in layout mode you can select all fields on the layout and then in the inspector disable field entry > browse mode For text-based training, the FileMaker Training Series is still probably the best, even though version 15 is the last one available. Most of it is still valid, especially for the basics: https://www.filemaker.com/learning/archived-learning-resources.html Welcome to the forums.
  • Create New...

Important Information

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