Calculation: create matrix from selected values of 2 multi select categories
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
-
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
-
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
-
Thank you Rainer Grabowski
This output includes many small element but not correct ( desired result: 2managerdaily,2freelancerdaily,3managerdaily,3freelancerdaily)
Please sign in to leave a comment.
Comments
6 comments