Nesting 'if'
Maybe if I knew which script launguage ninox uses I'd have better luck with Google.
I think I want to nest an if
Following on from my previous
if 'Year Code'.Year < 1996 and 'Film Location' = 2 then
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
else
if 'Year Code'.Year < 1996
'Year Code'.'Year Code' + "-" + Folder.Book + "-" + Page
else
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
end
end
I want to add a leading zero to the 'Page' so I get AB-C-01 not AB-C-1
The formula editor just tells me I'm wrong when trying
if 'Year Code'.Year < 1996 and 'Film Location' = 2 then
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
else
if 'Year Code'.Year < 1996 and Page <= 9 then
'Year Code'.'Year Code' + "-" + Folder.Book + "-" + "0" + Page
else
'Year Code'.'Year Code' + "-" + Folder.Book + "-" + Page
else
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
end
end
end
How do I nest my ifs!
1 reply
-
Seem to have worked it out myself....
if 'Year Code'.Year < 1996 and 'Film Location' = 2 then
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
else
if 'Year Code'.Year < 1996 then
if Page < 10 then
'Year Code'.'Year Code' + "-" + Folder.Book + "-" + "0" + Page
else
'Year Code'.'Year Code' + "-" + Folder.Book + "-" + Page
end
else
'Year Code'.'Year Code' + 'Month Code'.'Month Code' + Day + 'Day Sequence'
end
end
Content aside
- 3 yrs agoLast active
- 1Replies
- 87Views