AnsweredAssumed Answered

List usage is not allowed - CALC HELP PLEASE

Question asked by ngarnier on Jan 24, 2014
Latest reply on Jan 24, 2014 by philmodjunk

Title

List usage is not allowed - CALC HELP PLEASE

Post

     I am getting a "list usage is not allowed" error when I add quotes, and "(" expected here error when I don't.  Can anyone please tell me what's wrong with the calculation below?  I am trying to make my audit log automatically grab any field name on the table that's modified.  this is just the first Auditlog1 field.  I'm using FieldNames (filename ; layoutname) to grab the field names, or at least trying to.
      
      
      
      
      
     Let ( [
      
     FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Prev = Substitute ( MiddleValues ( AuditFields1 ; 1 ; 1 ) ; "¶" ; "" );
      
      
     FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Cur = Substitute (FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography) ; "¶" ; "•" ) ] ;
      
      
      
     Case (
      
      
     FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Cur ≠ FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Prev ; Get ( CurrentHostTimeStamp ) & ": " & Get ( AccountName ) & " changed " & Get ( ActiveFieldName ) & " from \"" & FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Prev & "\" to \"" & FieldNames ( Organ Safety DB enc audit 9JAN2014 FINAL ; Demography)Cur & "\"¶" )
      
     )
      
      & AuditLog1
      

Outcomes