Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. For fields edvisit2 to edvisit5, branching logic was added to show field only if preceding field is not null. For example, show edvisit2 if edvisit1<>"".
  2. To count how many visits have been recorded, a calculated field was added and an equation using if then statement was written to count how many fields had a visit date. See image B.
  3. Equation uses the function if([edvisit1]<>'', 1, 0) which reads if the field edvisit1 is not null, then the value is 1, if null, then the value is 0. 
  4. An if then statement is added for each field and then added together to provide a count of how many fields have data. See image C.

 

Info

 

Image A

Image Modified

 

Image B

Image Modified

 

Image C

Image Modified

 

 

 

 

...