Article View: comp.sys.mac.databases
Article #410working with FMP blank fields
From: cicone
Date: Fri, 13 Nov 1992 22:25
Date: Fri, 13 Nov 1992 22:25
23 lines
1470 bytes
1470 bytes
Hello, Has anyone out there come up with a work around for FileMakerPro (1.0v2) that would allow the use of the 'If' function in a calculation field that references a date field that does not yet contain a value? The actual calculation I would have liked to use: If (Length (paper accepted) >0 ,"Accepted",If (Length (paper rejected) >0 , "Rejected" , "In Progress")) where 'paper accepted' and 'paper rejected' are both date fields. As the FMP manual states if a field doesn't contain a value the 'If' function is skipped altogether and returns an empty result. If either of the date fields has a value entered into it the calculation works fine; if both fields are blank I get no result. I attempted a few ways around this but it seems that none of the functions available in a calculation field will work with a blank field.... Thanks in advance... --Bob-- ********************** Bob Cicone (cicone@uieea.ece.uiuc.edu) Sys Admin Bioacoustics Research Lab University of Illinois at Urbana-Champaign
Technical Details
Message-ID:
<BxoEAx.DAE@news.cso.uiuc.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!pageworks.com!world!eff!news.byu.edu!gatech!emory!wupost!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!news.cso.uiuc.edu!usenetShow Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases Path: arc1-ca.pugleaf.net!sparky!uunet!pageworks.com!world!eff!news.byu.edu!gatech!emory!wupost!cs.utexas.edu!uwm.edu!ux1.cso.uiuc.edu!news.cso.uiuc.edu!usenet From: cicone@uieea.ece.uiuc.edu Subject: working with FMP blank fields Message-ID: <BxoEAx.DAE@news.cso.uiuc.edu> Sender: usenet@news.cso.uiuc.edu (Net Noise owner) Organization: University of Illinois Date: Fri, 13 Nov 1992 22:25:43 GMT Lines: 23