Return first value of a multiselection category field
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.
-
"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)
Please sign in to leave a comment.
Comments
3 comments