Turn Duration field into Text by using Calculation field

  How can you take information from a Duration field? If you put it in a Calculation field simply as @Duration, it is shown as a number, which can be a problem. The best way to turn a Duration field into Text field is done by the following Javascript code. It will then show exactly what […]

Read full story · Comments { 0 }

Turn Email field into Text in a Calculation field

This is a very useful feature, sometimes we need to write all the email addresses of a Email field into a Text field. Just copy paste the following code to a Calculation field: var i; var all_emails = “”; var e = @Email; for(i = 0; i < e.length ; i++){     all_emails += “**” +                    e[i].type.charAt(0).toUpperCase() +   […]

Read full story · Comments { 0 }

Turn Phone field into Text in a Calculation field

  This is a very useful feature, sometimes we need to write all the phone numbers of a Number field into a Text field. Just copy paste the following code to a Calculation field:  var i; var all_phones = “”; var p = @Phone; for(i = 0; i < p.length ; i++){     all_phones += “**” +                    p[i].type.charAt(0).toUpperCase() […]

Read full story · Comments { 0 }

Show a Text field under conditions

If you want to show a Text field under certain conditions, that is possible. Let’s assume that you show the first and last name of an employee and the company that he works for in a field called: Employee info. You also want to show whenever an employee is inactive, by including a warning message in the […]

Read full story · Comments { 0 }

Merging text fields, empty ones will not appear

  Merging Text fields is easy, works in this way: @Text1 + @Text2 + @Text3 Of course, you can merge text that is in ” “, for example: “Here is text 1: ” + @Text1 + “\nHere is text 2:” + @Text2 But what happens if some text fields are empty? We would like to have […]

Read full story · Comments { 0 }

Highlight your text in Calculation field

  Podio Calculation field makes use of Markdown features, so we are free to use them. One of those simple features is to highlight text. Whatever text you include in ` `, becomes highlighted. Just copy paste the following code to a Calculation field: @Text ? “This is a `highlighted` text” : “” /* ——————————————————————————————————- Created by BendixKiel ApS […]

Read full story · Comments { 0 }

Turn Text fields into bold

  Every time you enclose your Text field into “**”, it becomes bold. Just copy paste the following code to a Calculation field: “**” + @Text + “**” /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of experience in helping organizations implement Podio. Please feel free to contact us […]

Read full story · Comments { 0 }

Splitting full name into first and last

This is a very useful feature. Sometimes we need to break a full name into two Text fields that will include the first name and the last name. For example, you are given the full name:  Pedro de la Maria de la Dolores If you want to use first name: Pedro and last name: Dolores, that can be easily done […]

Read full story · Comments { 0 }

Calculate time difference from two Date fields

  Let’s say you have two Date fields, and you want to show their time difference in hours and minutes. We will create a Hours Calculation field, and a Minutes Calculation field. Just copy paste the following code for Hours:   moment(@Departure Time).diff(moment(@Arrival Time), ‘hours’) /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of […]

Read full story · Comments { 0 }

How to show referenced items fields in a list

Let’s say you have used a Relationship field in your app for referencing another app, and you want to show a list with a specific field of each referenced item. Then you should copy paste the following code: var d = @All of -; var i, res = “”; for(i = 0; i < d.length; i++){              res += d[i] […]

Read full story · Comments { 0 }