List fields based on checkbox
Hi, I need a formula field that will list some Years if the corresponding Year checkbox is checked. I'm not sure if this screenshot size is ok or not - it looks super tiny when pasting it. ...
Forum Discussion
Is the ultimate goal to have a list of years IF that year ask button is checked? If so:
var text FirstYear = If([First Year Ask]=true, [First Year]);
var text SecondYear = If([Second Year Ask]=true, [Second Year]);
var text ThirdYear = If([Third Year Ask]=true, [Third Year]);
var text FourthYear = If([Fourth Year Ask]=true, [Fourth Year]);
var text FifthYear = If([Fifth Year Ask]=true, [Fifth Year]);
List(",", $FirstYear,$SecondYear,$ThirdYear,$FourthYear,$FifthYear)
Yes, the ultimate goal is to have ONLY THE YEARS FOR FUNDING listed if that ask year is checked.
I put in that formula, but I'm getting an an error that says expecting text but found number. the "first year" et al fields are numeric. I tried wrapping in in To Text but that didn't work.
should I change my year fields that are numeric to text just for this? i don't think it'll mess anything.Did you try this?
var text FirstYear = If([First Year Ask]=true, ToText([First Year]));
var text SecondYear = If([Second Year Ask]=true, ToText([Second Year]));
var text ThirdYear = If([Third Year Ask]=true, ToText([Third Year]));
var text FourthYear = If([Fourth Year Ask]=true, ToText([Fourth Year]));
var text FifthYear = If([Fifth Year Ask]=true, ToText([Fifth Year]));
List(",", $FirstYear,$SecondYear,$ThirdYear,$FourthYear,$FifthYear)Here is that: I get an error that says expecting number but found text, for the list.
(I initially typed the field as First Year, but it's actually Year 1, it was my mistake so i just went with it :D)
