Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


JLanclos last won the day on February 3 2011

JLanclos had the most liked content!

Community Reputation

2 Neutral

About JLanclos

  • Rank
  • Birthday 08/04/1967

Profile Information

  • Industry
    Real estate
  • Gender
  • Location
    houston tx

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I want to build a filmmaker solution where multiple employees/users could be able to send text messages via SMS from their file maker database – does anyone know an efficient way to do this? Or what plugins or SMS services are available?
  2. I have a need to archive documents that of been uploaded years ago into our container fields which Are stored by reference on our file maker server 17 - Does anyone in efficient way to do this? Can we store documents in a cloud setting via Filemaker server ?
  3. Does anyone know if there is a problem with FX.php and PHP7? I installed PHP7 yesterday and the it is up and running but I cannot display and record data after a find. I turned on error checking and there is no errors and on a simple find, I get a found count of 1 which is correct, but the array containing the record data is empty. It was working find before the conversion to PHP7
  4. I am looking for a filemkaer solution for connecting to banks (any) or API's and sending them electronic payments to process and pay from our financial institution - they are saying to just create a NACHA file - has anyone created a NACHA formatting solution for filemaker?
  5. So I have am update script running at night - it does use a webviewer to look up internet data - the application of filemaker 15 is crashing at night during the run and the appllication is running out of memory - I checked Activity Monitor and filemaker was using 62 gb (yes GB) when it crashed - is there a script step I need to employ so that the application will not use so much memory during the run? - flush disk cache? Thanks
  6. Did you ever find an answer to this question?
  7. Has anyone come across a way to have filemaker execute an online trade with a brokerage account? I want a DB to place a trade buy or sell with a brokerage house - probably thru an API Thanks in advance J
  8. I am trying to have FMS run a script in a db server side by the client pushing a button which runs a script from the client machine. I had the idea of using a URL to accomplish this - cannot get it to work - anyone have any ideas? http://ipaddress/fmi/xml/fmresultset.xml?-db=DATABASE&-script=SCRIPTNAME
  9. I have statistics logging turned on - scaled back cache ram - mac is a Mac Tower - 2.8 ghz quad-core intel xeon - 16 gig ram running 10.9.5 - 1T HD half full - what statistics should I be interested in checking? thx
  10. ok I will try to explain it another way - I don't want to do a find for past due invoices - I want users, while doing other tasks in the database, to recognize that the invoice they are working on is past due and how long it has been due - therefore I need the currentdate field to be accurate everyday so I can use it for aging and to perform other thing using it - my original question was how can i have the currentdate field be accurate to the current day everyday on every record - thanks
  11. yes users are complaining of slow performance - I have 25 users during the day - a couple at night - I have a two machine deployment with the Worker machine doing CWP - ram reserved for cache on server 14,000 - thanks Wim
  12. I would like help designing a drop down value list which filters the list based on what is already type in the input field. See example - admin 1234 - When they click on the field the drop down menu appears and would be filtered by the first letter of what they typed in so the user can correctly match up with the exact name - the field data comes in from a web form and I do not want to change the web form - just the value list - thanks ValueLists.fmp12
  13. Sorry fellas - the login is admin 1234 for the demo file - I uploaded the file last night to Filemaker Server to see if the date would change after midnight - it did not - so I would to perform a script or function on it to make the date change - we use a similar database in our clients system - the client DOES NOT want to perform a search to find past due invoices because they use a dashboard which tells them what is past due - they want the dashboard to update automatically each day to populate the correct number of past due invoices - thanks InvoicesEx.fmp12 rwoods - in your reply, this is what I'm doing if understand you right - I have it as a simple date field and im running a script to update every record each night - this is what I want to change since it is over 100,000 records
  14. I have a database that I created for someone to help me with this example - I want my filemaker database to update a field called CurrentDate in filemaker via the server everyday. If I use a date field and run a server side script once a night (current solution), then I have to wait for it to finish and it can take a while with 100,000 plus records. If I used a calculation field set to get(current date) then the server does not update it nightly - each morning I was to do a find on what invoices are past due and everyday that find should change depending on today related to the due date on the invoice - any suggestions? InvoicesEx.fmp12
  • Create New...

Important Information

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