Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Fitch last won the day on January 22

Fitch had the most liked content!

Community Reputation

170 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. Have you looked at their API? Welcome to the forums.
  2. Something like: Case( IsEmpty(Start Date) ; "" ; not isEmpty( Departure date ) ; Departure date - Start Date ; Get(CurrentDate) - Start Date + 1 ) Welcome to the forums!
  3. Run FileMaker on a computer, perhaps in kiosk mode, and plug the TV into the HD port of the computer? Welcome to the forums.
  4. Looks like 18.0.4 update is meant to fix that: https://support.claris.com/s/answerview?anum=000034744&language=en_US
  5. On the server I'd suggest trying Get ( DocumentsPath ) instead. Then you could check the server documents folder and verify the file is there. If it still doesn't send, it might be an issue with your mail server. How big is the PDF?
  6. Fitch

    Email attachments

    Save the PDF path in a variable and then use that variable in the Send Mail step. Set Variable[ $path ; Get(DesktopPath ) & "untitled.pdf" ] Save Records as PDF[ $path ] // don't create email Send Mail[ ... ; $path ] Welcome to the forums!
  7. Like Steve said, your script has no Find. Are you wanting to do something like: If[ Tasks::Status = "In Progress" ] Set Field... etc. End If Notice that you don't need GetField. Welcome to the forums!
  8. Don't forget the other functions available to you. You could set the ExecuteSQL field separator to a carriage return, or take your result and use Substitute -- and then get the first value, so the whole thing would be: GetValue( Substitute(result;", ";¶) ; 1 ) That said, I would highly advise you not to use ExecuteSQL in any hide condition, tooltip, conditional format, etc. In a hosted, multi-user file, an uncommitted record can cause the client to attempt to retrieve the entire database. Performance will suffer to say the least. Welcome to the forums!
  9. I agree with Steven and Wim. Regarding Mac/Windows, no conversion is needed, FileMaker files open on either platform. You may encounter issues with fonts, which is why most of us tend to stick with the common ones like Arial, Verdana, etc. And for converting from FM9 to 18, all you have to do is open the files with 18 and it will handle the conversion. In general you should have no issues.
  10. Making an action happen at startup is done using File menu > File Options then click the Script Triggers tab and the OnFirstWindowOpen option. This prompts you to select a script. You'll need to think about what exactly you want that script to do. I'd recommend going through some of the tutorials here: https://www.filemaker.com/learning/ E.g., your script might include something like: Enter Find Mode Go to Layout[Tasks] Set field[ completed ; "<>1" ] Perform Find etc.
  11. You can have each button specify a script parameter, and then your script can use the Get(ScriptParameter) function, so you could do it with one script no problem. As @comment noted if it's just one line then you don't necessarily need a script. But maybe there's more to it. I'm still not clear. Are you trying to compile each bit of text into a single field? What do you want it to look like? An example might help.
  12. There's a Set Field script step. Beyond that I'm not sure what your issue is.
  13. No, you can't control the size of the browser window. Welcome to the forums.
  14. One method would be to use security. Assuming each user has a unique account (which they should), if you auto-enter the account name on each record, and set the security options to a calculation like Get(AccountName)=createdByField ... voila, users will only see records that they created. https://fmhelp.filemaker.com/help/18/fmp/en/#page/FMP_Help%2Frecord-access-privileges.html%23ww1028797
  15. This issue has been around for a while: https://support.filemaker.com/s/answerview?language=en_US&anum=15419 Welcome to the forums!
  • Create New...

Important Information

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