Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


OlgerDiekstra last won the day on October 6 2019

OlgerDiekstra had the most liked content!

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,743 profile views

OlgerDiekstra's Achievements


Proficient (10/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  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 overlaid over the normal note field. If there are multiple notes to search through, and you also want other (normal) text fields to be searched, it gets messy very quickly. In that case you'd probably want to use a temporary record (using global fields) that has all the fields the normal record has and duplicate everything before showing the data on the layout. You can then use a save button to save any altered data. But you'd first have to clean the data of any highlighted text.
  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. There are also switches that can be configured to dynamically manage perceived threats. In such a case, a power down won't help much. It all depends on what brand/model switch you have.
  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. FMS will shutdown DB's before it shuts down itself. Windows however can forcefully shutdown closing processes, regardless whether they are finished. There are some configuration options whether you allow to forcefully close frozen processes (I think the default is 2 minutes), but don't count on that staying the same after updates. Microsoft doesn't have the best track record when it comes to updates. They fix a lot, but they often also break a lot of stuff that worked just fine prior.
  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 [email protected] 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 in your SFP record is that anyone can then send emails on your behalf using gmail SMTP servers (if they know you've set that up).
  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.