3 Replies Latest reply on Mar 30, 2016 3:08 AM by innodat

    scheduled events

    qkarmark

      I'm pretty new so bear with me if this sounds entirely obvious:

       

      If I have a listing for a tenancy property in our online solution, and I know its status will go from For Lease to Leased at a certain future date, (A) can I schedule Filemaker to automatically update the online listing status or do I have to wait for that date to occur and do it live?  And (B) likewise for the reverse when the listing's lease expires, can I create an automatic alert that sends a message to someone noting that the expiry is pending and to contact the landlord regarding re-listing the vacancy?

        • 1. Re: scheduled events
          innodat

          Assuming that

           

          A) the data source for your website is a FileMaker database and

          B) it's hosted on a FileMaker Server

           

          you would have to look into server-side-scripting. In the FileMaker Server Admin Console you can create schedules that run as frequently as every minute, 24/7. These schedules can call scripts from within your FileMaker databases. The topic is too extensive, I can't provide step by step instructions here. But almost everything that you can do manually in a FileMaker client can be scripted server side with current versions of FileMaker/FileMaker Server (check server compatibility of individual script steps in your version of FileMaker). You can definitely send reminder emails this way, and you can definitely manipulate data in FileMaker fields, such as the status of a listing.

          • 2. Re: scheduled events
            qkarmark

            Thanks Michael... I appreciate the time you took to answer that so thoroughly.

             

            So as far as scheduling a script is involved (assuming the Filemaker database source and server are as you stated) it might be along the lines of 'Check database records daily for listing's tenancy LEASE DATE FIRST and LEASE DATE LAST field', with an if > then statement requiring it to do any number of things such as alerting someone of an event and/or manipulate data in another field accordingly regarding it's status.... sound about right?

            • 3. Re: scheduled events
              innodat

              Yes, precisely.

               

              You might work with a find request that produces a found set of records which need action first (faster than looping through all of them, checking each one's fields with "if" statements). Once you have extracted those records which need action, you can then loop through them and perform any number of - server compatible - script steps.

               

              For actions such as sending emails your routine might also need to include information on whether the action has already been executed for a particular record or not. You can then include that information in your search and avoid sending out emails multiple times.