Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About wattmhite

  • Rank
  • Birthday 04/08/1986

Profile Information

  • Title
    Business Owner
  • Industry
    Aircraft Insurance
  • Gender
  • Location
    Corona, CA
  • Interests

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra
  1. Data cloud backup

    Just a few questions: my database is now 85 gb and growing every day. What is the best way to back this up, is there a cloud service you would recommend? also, I have a table with a container field and it holds all of our companies pdf copies of documents. I’m considering storing that fields data on an external drive since it makes up the bulk of the 85 gigabytes. Is this a good idea or do you all have any recommendations? thank you!
  2. Thank you OlderDiekstra. But how would you implement the " (Quotation Marks) every time I write a script with those it thinks what follows is comments?
  3. I'm working on a script that sends an email to a customer with a custom link. Is there a way to create the name of the link (what the customer sees) as Name (for example) but have the address actually different IE the real address? The problem I',m having is my custom URL is very long and I would like to make it easy and simple for the customer and for them only to see a blue line with the title "Click here" Thoughts? Many thanks in advance
  4. Not sure if there is a location feature within filemaker or a list I can build into a table but I am trying to set up system where if I type in a zip code (92881) for example, the 10 closest zip codes in that area are shown. Any ideas? Thank you in advance!
  5. I am trying to create a script that sets a global field with a certain value so all users connected to the server can see this value in the global field. Is there a way or script that tells the server to set a field rather than the connected user?
  6. Is there a script to detect when other users are currently in a particular layout? I have a layout I use to bind accounts but I only want one user at a time to be able to access that layout. When the first person leaves the layout then another person can enter. Can this be done? Thanks
  7. Does anyone know if this is supported in filemaker go or support soon to come? It would completely change my business if this were possible. Thanks
  8. Search within a portal?

    I have a portal within my main layout that I use for all phone log comments and documents. Is there an example or a (best practice) way to create a search field that searches within that portal only and shows the correct records searched?
  9. Hi All, I'm familiar with the middle words function but I'm looking to separate individual letters. I have a table with values the first 2 letters of which I do not need. I'm looking to create a field or function that skips the first 2 letters and displays everything after the first 2 letters. Is this possible or is the middle words the only way?
  10. We're using Macs here at the office (not sure if it matters) but I have a search field that you can type search terms into and currently the user has to exit the field then click on a separate search button. Is there a way to perform the search script when enter is pressed? Thanks
  11. Import XML to file from container?

    Hi All, Happy Sunday! I'm trying to build a layout that contains 5 containers so my employees can drag and drop XML files into each container and then I can run a script to export those XML files and import them into my filemaker database. I'm struggling to get the data exported from the containers and imported back. What is the best way to do this? Export container via $path then import $path file? Thank you so much in advance.
  12. Hi All, I have a data set that includes about 300k records. Each record includes 3 fields: Year, make, Model. I'm looking to set up the 3 fields in my main database so I can start selecting the year, which will limit what makes are displayed. Select the make and based on the year and make show the available model options. What is the best way to set up tables and or relationships so this is sorted properly? Thank you!
  13. I'm trying to create a script that emails to a customer and sets the subject line automatically as the customers name or business name. The problem I'm having is when a business or customer has the AND or & symbol in the name it completely messes up the script. Is there a character or way to ignore an instance of the & or and symbol?
  14. If using the week number function to define a field, is there a way to get the first date of week 25 (for example) and last date of week 26. I'm using this for payroll so I can show on the pay slip for weeks 25 and 26 include dates June 19th - July 2nd.
  15. I have a time table and every time an employee logs into filemaker a record is created, the field Time In is set to get current time, date is set to get current date, account name is set, the record is given a record number and an $$variable record number is created. When the user exits filemaker a script is run: to to time layout, enter find mode, set field $$variable, find record, set Time Out field as Get Current time. This creates the time in and time out record overtime an employee uses our system and I have a time field that calculated time out - time in = time elapsed. Every day an employee will typically have 2 records, morning time in, time out for lunch. A new record when back from lunch and time out for the day. How can I create a calculation that finds both of these records for each account name and adds the time elapsed together so I can create a layout saying Monday Account #1 worked a total of 8 hours, Tuesday 7.5 hours, etc etc.

Important Information

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