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 […]
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() + […]
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() […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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] […]