CALCULATION FIELD

Follow

RAUL GONZALEZ

• December 29, 2016 21:54

Hello, i have a calculation field outcoming a text ( @ticket number) to split the hour as i required  ( 20161229) in the field, is it possible to retrieve this information to use it in the headline of a calendar?  i tried to do it but i could not find the reference @ticket number to create a workflow.

0

• 

  RAUL GONZALEZ

  • December 29, 2016 21:59

  Hello, i have a calculation field outcoming a text ( @ticket number) to split the hour as i required  ( 20161229) in the field, is it possible to retrieve this information to use it in the headline of a calendar?  i tried to do it but i could not find the reference @ticket number to create a workflow.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 05, 2017 15:34

  Hi Raul,

  move that field at the top of your item. The calendar shows the first field with a value.

  1

  Comment actions Permalink
• 

  RAUL GONZALEZ

  • January 05, 2017 16:36

  Thanks Rainer but let me explain a little more, i created a flow on the helpdesk application to create a calendar item. In the helpdesk application i have a calculation field to outcome a text string using the actual date for instance as of today 20170105. When i open a new ticket on the helpdesk application i want a new calendar item to be created but in the headline of the calendar item i want to use the text string from the calculation field created on the helpdesk application, is it feasible? I tried to do it but no reference is shown up.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 06, 2017 13:43

  You  can't add calculation fields in the Flow Creator.
  But the Calendar app and the Helpdesk app are related. So in the Calendar app you can have a calculation field which pulls the data from each field in the Helpdesk app you need (@all of field name ) after it has been created by the flow.
  
  If you need the text field "Headline" in the Calendar app for manual entries you can do this in the calculation field in Calendar:

  var head =  @headline;
  var ticket = @all of calculation field in Helpdesk.toString()
  head ? head : ticket

  This means: If there is an entry in the field Headline, take this entry else pull the data form the related Helpdesk item. There are also options for combining both.

  Rainer

  0

  Comment actions Permalink
• 

  RAUL GONZALEZ

  • January 06, 2017 15:55

  Thanks Rainer, i did what you suggested, in the calendar i created a relationship field to relate the calendar with the helpdesk application but there is a syntyax error ( unexpected token illegal) showing up, would you please give a clue on this error?

  

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • January 06, 2017 19:43

  Hi Raul.

  @all of calculation field in Helpdesk

  was meant as a placeholder. Instead of "calculation field in Helpdesk" there must be the name of that calculation field. Type @all of  (plus some letters of the field name)  and a list of tokens pops up, select that calculation field from the list. After you've selected it, it must be blue ( like @Headline)

  Why did you add a relationship field in Calendar? You already have a relation between Helpdesk and Calendar through the field "Alertas Agenda" in Helpdesk. That's all you need.

  Maybe it's helpful for you to look at this introduction:  https://help.podio.com/hc/en-us/articles/201019358-Calculations

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.