Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About adyf

  • Rank

Profile Information

  • Title
  • Industry
  • Gender
  • Location
    United Kingdom

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 10
  1. Strange Portal Behaviour

    Quite recently I upgraded from FM11 to FM16 and converted a bunch of files. I since appear to have a portal that isn't always displaying the correct records. The first screenshot below, shows the layout based on the Route Packs table, with three portals based on different tables stacked down the left hand side. The portal that is displaying strange behaviour is the bottom most portal, although on this record (Armley Jn - Dockfield Jn) it is displaying the correct records. The uppermost portal is showing two records which are the route pack sections that make up the route pack (Armley Jn - Dockfield Jn), the middle portal shows the Train Drivers that have this route pack section records in a competence table, and the bottom portal shows the route pack sections from the competence table including the days to expiry (for competence) together with a Days To Expiry COUNT summary field sorted by EmployeeID in the competence table. In this example, all records are showing correctly, two route pack sections multiplied by six Train Drivers equals 12 records in the competence table. In this record below, there should be 22 records in the lowermost competence table but there's blanks. In the next example there is the required number of records in the competence table portal, but there is four records for David Moorhouse. Two of those records should show for Ian Murray. There doesn't appear to be any rhyme or reason to any of the above examples. I have tried the following to no avail. - Created a new layout and copied and pasted the portal in case the layout was corrupt. - Created a new layout and recreated the portal from scratch in case the portal was corrupt. - Created a new EmployeeID field in the competence table and used this in the sort for the Days To Expiry COUNT summary field which is what the portal is sorted on. I'd be grateful for any suggestions I could try, there doesn't appear to be a pattern to the erratic behaviour and strangely sometimes the portal displays correctly.
  2. Server Busy Error

    Thanks Fitch, that's good to know. I'm too far on with change since the 64 bit version of the software was installed.
  3. Server Busy Error

    If I could get the 32 bit version of the software installed, would that be ok with the files that have been worked on by the 64 bit version?
  4. Is there an equivalent script step for Update Link for *fmp12 files?
  5. Goto Related Record Issue

    The table is below. Mainly text and calculation fields. When creating the record again (CTRL+N) I did copy the text from the route pack field into the new record, perhaps I should type it in manually in case the text is corrupt somehow.
  6. I’m having a really strange issue with a goto related record script step after converting a file from *fp7 to *fmp12. There was no issue with this in FileMaker 11. The script step is linked to a button, to go to a related record (same record) based on the same table to a different layout that contains portals based on different tables. For some reason running the script when a particular record is selected crashes FileMaker 16, and I have to force close the program. I did think the layout may be corrupt in some way, so duplicated it, deleted the original an renamed the duplicate. I still have the issue. Strangely, it only appears to happen with one particular record, the script step works fine with all other records I have tried which adds to the mystery. I have tried deleting the offending record, recreating it (assigned a different uniqueID), yet still the problem. Even if I manually go to the offending layout, then start scrolling through records, as soon as I get to that record FileMaker crashes. I’ve tried recovering the file to no avail. Is there anything else I can try, I was hoping to not have to build the layout from scratch again.
  7. Open URL Mailto

    I haven’t considered a plug-in, is there a cost involved and what would you recommend?
  8. Open URL Mailto

    Still struggling unfortunately, thanks for your continued help. I copied the text from my Open URL script, everything is ok with the resultant email below except there’s no active hyperlink to my file. "mailto:=John Fower;Paul Bowater;Gerarda Hadfield;Josh Parker;Steve Bramley;Neal Fussey;Graham Crosby" & "&subject=Lookahead Report" & "&body=Dear All,%0D%0DPlease find below linked lookahead report.%0D%0DRegards, Adrian.%0D%0D&" & "&file://G:/Large Files With Links/OTM Planning/Lookahead Report.pdf"
  9. Open URL Mailto

    Apologies, the file would be on a network drive.
  10. Open URL Mailto

    What would the syntax for the linked file look like? I can't find an example anywhere.
  11. Server Busy Error

    Thanks Fitch, I'm following this up with our ICT department.
  12. Server Busy Error

    I've spoken to the ICT guy that installed X64 Filemaker Pro 16 and asked him if it came with the X86 installer, he said it didn't. When you purchase the software, do we know if we should get both installers? Also, do you think that the X86 version would be supplied if we explained our situation? I'm not involved in the procurement process, but suspect that the software came from a third party supplier and not direct from Filemaker. I will have to look into the Perform Script on Server script step.
  13. Open URL Mailto

    It does, but I was hoping I could get a double line break like the below: "Dear All, The attached route(s) have been added to the route competence database. TOP 006 paperwork received. Regards, Adrian."
  14. Open URL Mailto

    Is there any way to achieve a double line break using the open url mailto script step? I have achieved a single line break using the following: "&body=Dear All,%0D%0AThe attached route(s) have been added to the route competence database. TOP 006 paperwork received.%0D%0ARegards, Adrian." Also, is there any way to add mail attachments?
  15. Server Busy Error

    It turns out there's a known compatibility error between 32 and 64 bit versions of FileMaker Pro 16 and MS Outlook 2016 with regard to the send mail script. Both software require the same bit version. Below FileMaker describe the workarounds: WORKAROUNDS: Use 32-bit Outlook Use SMTP settings to send mail instead of the E-mail client Use the Open URL script step with the following syntax: "mailto:someone@example.com?subject=This%20is%20the%20subject&cc=someone_else@example.com&body=This%20is%20the%20body" Firstly I'm awaiting a response from our ICT department regarding a 64 bit version of MS Outlook. With regard to SMTP, how easy is this to configure with a corporate MS Exchange email account? Lastly, with regard to the open URL script step, does this have to be kept simple as in the above example? Can you send to multiple people and also insert calculations into the email body?

Important Information

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