Archive | Uncategorized RSS feed for this section

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 { 1 }

Add Duration field to Start Date field

  If you want to add a Duration field to a Date field, that is possible. Just copy paste the following Javascript code to a Calculation field:   var sd = @Start Date and Time; var d  = @Duration; var h  = Math.floor(d); var m ; var s ; var r = d – h; r *= 600000; r […]

Read full story · Comments { 0 }

Create a Date field by using Number fields

You can create a Date field using three different Number fields, which of course will contain the day of the month, the month, and the year. Just copy-paste the following code to a Calculation field:   new Date(@YYYY, @MM – 1, @DD, 0, 0, 0 )  /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with […]

Read full story · Comments { 0 }

Adding days to a Date field

  Given a Date field, and a Number field with the number of days to be added, you can create a Date field with the a new date. Just copy paste the following code to a Calculation field:   moment(@Date).add(@Days to add:, ‘days’).toDate()  /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of experience […]

Read full story · Comments { 0 }

Relationship field: Pull Date

  Let’s say you have used a Relationship field in your app for referencing another app, and you want to pull a Date from the second app. 1) Have you referenced just one item in your Relationship field? That means you will get only one date. All you need to do is copy paste the following javascript in order to get your Date field […]

Read full story · Comments { 0 }

Count the referenced items in the Relationship field

Let’s say you have used a Relationship field in your app for referencing another app, and you want to count how many items reference to the second app. All you need to do is find a field name of the referenced app, it can be any field. Then you should copy paste the following javascript in order to get your item number. @All of […]

Read full story · Comments { 0 }

Filter referenced items with Text field

Let’s say you have used a Relationship field in your app for referencing another app, and you want to filter items by choosing a word and then show a specific field of the referenced app. Then you should copy paste the following javascript:   var s = @All of Status; var d = @All of –; var st = @Select Status:; […]

Read full story · Comments { 0 }