How to Create a Markdown Table on Podio
Jan 09, 2020Podio relationships are super powerful, but displaying the data correctly can be a nightmare! Check out this powerful trick of using “markdown tables” to display and link to related items
Calculation Formula:
var url = "https://podio.com/incomedigscom/rehab-project-mgmt/apps/tasks/items/"
var status = @All of Status
var url2 = "https://podio.com/incomedigscom/rehab-project-mgmt/apps/tasks"
var title = "["+"TASKS"+"]("+url2+")"
var markdownTable = "| "+title+" | Priority|"+"| Assigned To|"
markdownTable+= "\n" +"|------------------------|:--------------:| -------: |";
for(i=0; i<@All of Title.length; i++) {
if(status[i]=="Incomplete") {
markdownTable +="\n |"+"[" + @All of Title[i] + "](" +url + @All of Unique ID (Hidden)[i] + ")" + " | " + @All of Priority[i] + " | " + @All of Assigned to:[i] + "|"
}
};
if(@All of Title.length==0) {""} else markdownTable