3 Replies Latest reply on Sep 19, 2009 4:13 PM by jimumbel

    Checking to see if field is empty and if it is going to the next one

    jimumbel

      Title

      Checking to see if field is empty and if it is going to the next one

      Post

      Hi everyone!

      First time poster here so thanks in advance. I'm using Filemaker Pro 8.5, am self-taught and I'v had a lousy teacher! Here's my problem:

       

      I have 10 fields on a template.(actually there may be more but I only need the concept) Each field is blank when a student joins my club (shotokan karate) When they take a test I enter that information into my computer with the date (separate field) the test was given. The first field will be 0 kyu for a new student. If they pass their first test they will be 9 kyu. Next 8 kyu, 7 kyu, 6 kyu,  and so on with each ranking being a separate field. I want to have Filemaker to look at the last field in this group and see if it has information in it. If it does it will fill in that info on another template automatically. If not it will go to the previous field and do the same check until it finds the students last test result and then it will use that. This info will go on a template that prints out a pre-test sheet (think grading) that I will use during the actual test. I will check off (with pen/pencil) how they do in different areas and give a final grade after the test. Now, after the test I enter the results into the computer and print out a new sheet (template) with the old rank (before the test) and the new rank (after the test) and post it on the bullitin board. Is there any way to do this automatically? I would imagine it would have to use the date function to tell if the rank is within 30 days or less (just tested) or more than that for their former rank. This goes on about 3 times a year.

      I don't have any fields pre-defined so feel free to call them whatever makes sense but Rank1, Rank2, Rank3, and Date_Rank1, Date_Rank2, Date_Rank3, and so one seems logical to me. Anyone want to help an old budokai out?

      Thanks!

        • 1. Re: Checking to see if field is empty and if it is going to the next one
          raybaudi
            
          Hi
          budocat wrote:

           

          I want to have Filemaker to look at the last field in this group and see if it has information in it. If it does it will fill in that info on another template automatically. If not it will go to the previous field and do the same check until it finds the students last test result and then it will use that.


          Assuming the each rank field contains a single value, this calculation returns the value of the last NOT empty field:

           

          Let(
          values = List ( Rank1 ; Rank2 ; Rank3 ) ;
          GetValue ( values ; ValueCount ( values ) )
          )


          • 2. Re: Checking to see if field is empty and if it is going to the next one
            jimumbel
              

            Daniele,

            Wow! That was fast! It works perfectly. Now, is there a way to add that last part about the new rank being picked along with the last rank? This would show on the new template that I print out with their rank before the test and after the test. I'm guessing I just need to create another field like you did with VALUES and use the compare dates function with it. Either way you are great and I thank you! Would it be possible to pick your brain on a few more of my program hang-ups?

            Thanks!

            • 3. Re: Checking to see if field is empty and if it is going to the next one
              jimumbel
                

              Daniele,

              Sorry, I don't think I was clear on that last post. Your solution works fine until I enter the newest rank (test) grade and then it becomes the old rank unless there is someway to do your search with the current date involved and without. Now my english is failing me ! Hope I'm making myself clear but if not I'll try again.

              Thanks