1 Reply Latest reply on Jan 28, 2010 1:51 PM by philmodjunk

    Email issue and scroll wheel.

    jennetravers

      Title

      Email issue and scroll wheel.

      Post

      Hello, 

      I am using Filemaker Pro 10 with Windows XP. 

       

      I work in a medical billing office and I was given the task of creating a database to keep track of patients and their information and run reports, but also the manager would like for the team to be able to send an email out which contains certain information from the database. We would have to be able to send out an email drawing a few things from the patients record, along with a form letter letting the doctor know the patient’s status. The old database the team was using had been set up so all you would have to do is select the doctor’s name from a drop down list, click an ‘Email’ button and the email would pop up with all the information, ready to send out. I have tried to replicate this in the Filemaker database, but it is not working the same way, because the information is not showing up in the email. I have read a little about calculations and i’m thinking that might be the way to go, however I have never done anything like it before. Additionally, does anyone have a solution for the mouse scroll wheel – the way it goes through the records when you try to scroll down a page? 

       

       I have not had much training with Filemaker, but I catch on quickly, and I really appreciate any help that is offered. Also, please excuse me if I have worded something incorrectly. 

       

      Thanks!

       

      Jenne

        • 1. Re: Email issue and scroll wheel.
          philmodjunk
            

          I have read a little about calculations and i’m thinking that might be the way to go, however I have never done anything like it before.

          Yes, calculations will be the way to go. You'll need to learn how to do this in order to include data from your fields in your emails. How you do this could be simple or complex--depending on your database and what you need to do.

           

          "...does anyone have a solution for the mouse scroll wheel – the way it goes through the records when you try to scroll down a page? "

          Do you want to keep it from scrolling through the records? If you give a field or button the focus while in form view, the thumbwheel will not scroll from record to record.

           

          You could use a layout script trigger, OnRecordLoad, to place the cursor in a field--but be careful that's an easy way for someone to bump a key and accidentally modify a field they didn't expect. Or you can use object info to give a button the name and use go to object in your script to give it the focus. If you're in list view, this trick doesn't work.