5 Replies Latest reply: Sep 22, 2016 8:57 PM by Marcus Sommer RSS

    refer to current field in expression

    Brian MacDonald

      I have a series of table objects for which I am developing a somewhat complex background color format expression.  All of the fields in the tables will use the same format.  Is there a way to refer to the field in which the expression resides without having to specify it by name?

       

      For example my expression might be:

      if(field1<0, do_somethign, do_somethign_else)  : this is fine but the expression needs to be change for every fieldx in the table

       

      or is there some syntax like:

      if(current_field<0, do_somethign, do_somethign_else)  : which acts on field1 if the expression is in field1 and so on...


      Thanks in advance.