Removing "undefined" from markdown table in a calculation field

Follow

Richard Hedger

• April 01, 2019 19:49

Hi All, 

The table below was created using a markdown table in a calculation field. How do I replace an "undefined" result with something like "-"?

 

 

0

• 

  Rainer Grabowski

  • April 08, 2019 17:44

  Hi Richard,

  I assume you have 
  .join("\n") in your table calculation . 
  Add
  .replace(/undefined/g,"-")
  right behind .join("\n")
  
  Rainer

  0

  Comment actions Permalink
• 

  Richard Hedger

  • May 13, 2019 11:38

  That did the job - thanks.

   

  A little bit on the same theme, is there a way to not display the column titles is there is nothing to display? In other words, the field is empty.

  

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • May 13, 2019 12:23

  Declare the table as a variable: 
  
  var table = 'date |  etc (all the code for the table)

  and then: 

  lines == "" ? "" : table

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.