Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


OlgerDiekstra last won the day on October 6 2019

OlgerDiekstra had the most liked content!

Community Reputation

34 Excellent

About OlgerDiekstra

  • Rank

Profile Information

  • Title
    FileMaker Developer
  • Gender
  • Location
    Gold Coast, Australia

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification

Recent Profile Visitors

9,539 profile views
  1. Set the layout object to display as a numeric with 2 decimals (using the inspector).
  2. Ah sorry, I made a typo with the set field. It should be "set field [fieldname; $sum]" You mentioned in the screenshot you wanted to open a new layout and access the summary field of the previous layout (at least that's how I understood it). To do that you first need to copy the value of the summary field into a variable, then switch to the layout. Then you populate whichever field you need with the summary value from the $sum variable.
  3. In the script that loads the new layout, and before the new layout is invoked, set a variable to the value of the summary field. Then after the layout has loaded, set the field to the value of the previously created variable. set variable $sum = SummaryField go to layout [layoutname] set field $field = $sum
  4. USB is storage just like a hard disk. You should be able to run any runtime from USB storage. Depending on the type of USB port you plug into, performance might be an issue (ie USB2 is a lot slower than USB3, the latter are usually indicated with blue inside the port).
  5. Here's another thread on this forum discussing QF issues (related to popovers).
  6. Can it be reproduced on the customer's system? There's a similar (recent) thread on FM: https://community.filemaker.com/en/s/question/0D50H00006o3znSSAQ/fmp18-unknown-error-8206-after-quick-find, No solution though.
  7. I have seen something similar a long time ago implemented in FM. It's not functionality FM supports out of the box though. From memory, you would have to read the note field into memory, search it, then replace the words you're interested in with the same word but now wrapped in a highlighted background (TextStyleAdd ( text ; HighlightYellow ) ) and write the full text back into the note. The thing to remember with this is that you'll have to undo this every time. Alternatively, you could use a separate table for this with throwaway records/fields that get used once only, and which are ov
  8. Why use container fields for displaying the different colored boxes? FMv11 already had conditional formatting did it not? You could simply use a 31-repeated (or 17 if thats the max displayed) field and set the color depending whether it falls within the booking dates. Change the calculation the be 1 or 0 (true or false) whether the box falls within a booking range and apply conditional formatting based on the true/false state.
  9. Probably an error reported by a plugin or something else that's not FM. Have you tried capturing details using Get(LastExternalErrorDetail)?
  10. Your APC client will need to issue the command "fmsadmin stop server", which will close the databases and stop the server. On Win2012 you probably have to do this from an elevated prompt.
  11. Have you tried comparing packet captures with a working machine? That will tell you whether the faulty system is even trying to communicate with the server. Ideally you'd do this on the switch, but that depends what switch you have. Alternatively, run packet captures on both local machines (on a working one and on the broken one). Probably the easiest way to check this would be to simply move the computer to another port, or better still, another switch. Having said that, it all depends on how the switches or switch stack is configured. Layer 3 switches add another layer of complexity.
  12. Connect a known working client to the same network port and test. If that works, it must be something on the client. If the hardware on the known working client is similar, you could even swap harddisks so that you use the same mac address/computer. It is possible a switch causes issues, either with stored mac info, or with a layer 3 rule (if its a layer 3 switch).
  13. Making sure that Windows doesn't restart after updates would suffice in my opinion. You need to be prepared to recover databases anyway. After all, the power grid can fail (a UPS will only keep the server running for so long, although that should buy you enough time to shutdown DB's), hardware in the server can fail causing a BSOD, disks can fail, ransomware, so there are lots of other issues that can happen that will cause your server to not close DB's properly. Mitigate what you can, at reasonable cost. Make sure you have a recent backup for instances where the server crashes horribly.
  14. Most likely this has to do with the email server you are using not being setup in the SFP record of your email domain. If you are sending emails as joe@mydomain.com and sending using gmail's SMTP server, you need to setup the gmail SMTP servers in your SFP record. Other wise, receiving servers will check the SFP record, see that the sending server is not in it, and mark the email as potential spam. Gmail usually gets around it by setting a flag "sending on behalf of...". But its possible this might not work when using direct SMTP. The downside of including SMTP servers such as gmail
  15. On Windows the tab key cycles from the "Name" field to the "Value" field and then to the "Specify" button. Then "Repetition" field, "Specify" button, "OK" button and "Cancel" button. In some cases, when there are multiple buttons that the tab key should cycle through after on another, I've found that the cursor keys will let me select different buttons. As you're on Mac, it must be different?
  • Create New...

Important Information

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