Return first value of a multiselection category field

Follow

Pedro Guede

• May 24, 2022 10:21
• Edited

Hello! 

I need to return the first field selected on a category buttons to get a starting date. 

Example

The categories mark the weeks in use. So each week have a starting date. 

You can mark week 1, 2 , 3 or week 3, 4, 5. I need this calc to return the starting week. So, in the first example will be "week 1" and the second one will be "Week 3". With this, I can assign a concrete date to each week. 

Week 1 (2 Junio/30 Junio)

Week 2 (2 Julio/31 Julio) 

Week 3 (2 Julio/31 Julio)..... 

0

• 

  Rainer Grabowski

  • May 24, 2022 13:56

  Hi Pedro,

  it's:

  @week.sort()[0]

  where "week" should be replaced with the real name of the category field. 

  Rainer

  0

  Comment actions Permalink
• 

  Pedro Guede

  • May 24, 2022 16:00

  Hello! 

  Thanks for the response, and the last one. I would like to add a rule to assign a Podio Item Id for each week 

  Week 1 = Podio Item id 1

  Week 2 = Podio Item id 2

  And res = if First week is Week 1; Podio item id 1 

  And the same for the last one. 

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • May 25, 2022 06:56

  "Podio Item ID" isn't available in the calculation field (only if you have a text field where a flow added the Podio Item ID), available is the "Unique ID".

  The way to get conditinal results:

  var week = @week.sort()[0];
  week == "1" ? id1 : week == "3" ? id2 : ""

  read as: IF week equals 1 show id1, if week equals 3 show id3 else show "nothing" (field is blank)

  0

  Comment actions Permalink

Please sign in to leave a comment.