6 Replies Latest reply on Apr 4, 2017 5:58 PM by bromero

    how to use "if" or "case"on filemaker blank space

    bromero

      Hi, im complete newbie on filemaker and im trying to do a log where i save all backups on my file. but i started this year then i completed my table "last_backups" with logs from 01/02/2017, 03/03/2017, etc. of course, "may" can not have register here.

      then im doing it:

       

      If ( Get ( CurrentDate )  ≥ B_LAST_BACKUP; "ok"; "    ") where field will be completed with "OK" but if this is not correctly will show a blank space.

       

      in my logs i will complete backups from 18 machines every month, then i will create a chart where i will list my 18 machines and will show what machine already have backup in the current month: Captura de pantalla 2017-04-04 a la(s) 19.10.06.png

      thats why i created 12 rows where i put the condition if and in my image every slot iswith a condition:

      If (SYSTEM_CONTROL::B_MARCH = "ok"; "X"; "   ")

      my brain will burn because all day i triend all on filemaker panel ^_^"

      Captura de pantalla 2017-04-04 a la(s) 19.14.18.png

      thats my logs:

      Captura de pantalla 2017-04-04 a la(s) 19.15.31.png