Calculation: create matrix from selected values of 2 multi select categories

Follow

Admin BVOT

• April 20, 2022 05:53
• Edited

hi folks,

i have 3 category field:

- Weekday (multi select): 2,3,4,5,6,7,8

- Role (multi select): director, staff, manager, freelancer

- Type (single choice): A, B, C

My current code:

var weekday = @weekday 
var role = @Role 

var type = @Type

result = weekday+role+type

and my current result, eg:

2,3director,staffA

How can i get correct result:

2directorA,2staffA,3directorA,3staffA

Thank you so much

1

• 

  Rainer Grabowski

  • April 20, 2022 15:28
  • Edited

  The multi select category fields are returned as an array. So you can use a function:

  var weekday = @weekday; 
  var role = @Role ;
  var type = @Type;
  weekdays.map(function(e,i){return e + role[i] + type;}).join();

  or a for-loop:

  var weekday = @weekday; 
  var role = @Role ;
  var type = @Type;
  var result = [];
  for(i = 0; i < weekday.length; i++){
      arr.push(weekday[i] + role[i] + d);
  }
  result.join() 

  Rainer

  0

  Comment actions Permalink
• 

  Admin BVOT

  • April 20, 2022 22:55

  Rainer Grabowski thank you. but something not like my wish :( 

  i use your above code:

  var type = @Tần suất thực hiện
  if (type =="Hàng ngày")
  {type = "daily"}
  var weekday = @Thứ
  var role = @Dành cho (english)
  var result = [];
  for(i = 0; i < weekday.length; i++){
      result.push(weekday[i]  + role[i]+ type);
  }
  result.join() 

  but no luck with My output is 2mdaily,3adaily 

  Need Correct ouput = 2managerdaily,2freelancerdaily,3managerdaily,3freelancerdaily

  form 3 fields: 

  • my role (field calculation from multi category) = manager,freelancer
  • my type (single category) = daily
  • my weekday (Multi category field) = 2,3

  Please help, 

  thanks again

   

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • April 21, 2022 10:36
  • Edited

  var i,j,
  role = @Dành cho (english),
  weekday = @Thứ,
  type = @Tần suất thực hiện,
  type = type == "Hàng ngày" ? "daily" : type,
  result = [];
  for(i = 0; i < weekday.length; i++){
     for(j = 0; j < role.length; j++){
         result.push(weekday[i] + role[j] + type);
     }
  }
  result.join()

  0

  Comment actions Permalink
• 

  Admin BVOT

  • April 21, 2022 15:19
  • Edited

  Thank you Rainer Grabowski

  This output includes many small element but not correct ( desired result: 2managerdaily,2freelancerdaily,3managerdaily,3freelancerdaily)

  

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • April 21, 2022 16:48

  Check your code, for me it works

  

  0

  Comment actions Permalink
• 

  Admin BVOT

  • April 21, 2022 22:53

  super thank you

  0

  Comment actions Permalink

Please sign in to leave a comment.