AnsweredAssumed Answered

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

Question asked by bromero on Apr 4, 2017
Latest reply on Apr 4, 2017 by 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

Outcomes