Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[muzicman0]

I have this close, but not perfect...I need help with an expression that will do the following:

(note: I have a custom library field that will be a value of 1 if the program is over 90% watched...it is 'Watched')

If Watched is 1 and Number plays is >0 then Output 1 (Video is watched)
If Number Plays is 0 (or empty) and Watched is 0 then Output 2 (Unwatched)
If Watched is 1 and Number Plays 'isempty' then Output 1 (Video is Watched - special case...this happens when I convert format)
If Watched is 0 and Number Plays is > 0 then Output 3 (Video is started, but not finished)

This will be going in the 'Video' Name expression field so that I can control how the Recent Shows field looks (bold white for new, different color for started, and grey for watched, plus some special symbols)

If anyone can help, I would appreciate it...here is what I have so far, but this only works on the 1st, 2nd, and 4th scenario.

if(!isempty([Number Plays]), if([watched], <font color="888888">√ [Series] [SeasonEpisode]-[Name], <font color="C3FFB3">! [Series] [SeasonEpisode]-[Name] <//font>), <font color="FFFFFF">>[Series] [SeasonEpisode] - [Name]</font>)

[RJC]

It's a tricky one but this might help:

IfElse(
Math(Compare([Watched], =, 1) & Compare([Number Plays], >, 0)), Watched,
Math(Compare([Watched], =, 0) & Compare([Number Plays], =, 0)), Unwatched,
Math(Compare([Watched], =, 1) & Compare([Number Plays], =, 0)), Special Case,
Math(Compare([Watched], =, 0) & Compare([Number Plays], >, 0)), Started
)

I'll leave you to do the formatting.

[muzicman0]

This seems to work, so thanks!

But, I have noticed that sometimes (I'm guessing when a show is recorded back to back) my watched library field is showing as 1, even though I haven't watched it (so number of plays is 0, which marks is as watched)...so I guess I have to figure that out.  If you have any suggestions, that would be great...I actually am using the following, which I got from another thread:

Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900))

The problem is, I really don't know what it is doing...ultimately, I want to set this up so that is it is <20% watched, it is considered unwatched, but >90% watched, it is considered watched.

[muzicman0]

so why won't this work...I'm trying to create an expression that will determine the percentage watched...what I have is this:

Library Field "Test Duration": Math(formatnumber([duration,0], 2))  <-this converts the duration to seconds...so instead of 2:12, it would be 132.31.
Library Field "Test Bookmark":math(formatnumber([Bookmark], 2)/1000)  <-this converts the bookmark to seconds (I am assuming the bookmark is in milliseconds)
Library Field "Test Calculated Position": Math([Test Bookmark]/[Test Duration])  <-this should return a percentage of how far it has been watched, but instead it returns an expression error.

If I replace the '[[Test Duration]' in the 'Test Calculated Position' with a real number, then it works, which leads me to believe that the problem lies in the Test Duration output not being a number, but a string or something...but I don't know where to go from here...if I could get this working, then I could make my original goal much easier.

[RJC]

You could make it even simpler by using this in a 'Watched' Expression Column.

IfElse(
Compare(Watched(1), =, 0), Not Watched,
Compare(Watched(1), =, 1), Partly Watched,
Compare(Watched(1), =, 2), Watched
)

[muzicman0]

not sure I follow that...my 'Watched' field only currently returns 0 or 1. 

[muzicman0]

so why won't this work...I'm trying to create an expression that will determine the percentage watched...what I have is this:

Library Field "Test Duration": Math(formatnumber([duration,0], 2))  <-this converts the duration to seconds...so instead of 2:12, it would be 132.31.
Library Field "Test Bookmark":math(formatnumber([Bookmark], 2)/1000)  <-this converts the bookmark to seconds (I am assuming the bookmark is in milliseconds)
Library Field "Test Calculated Position": Math([Test Bookmark]/[Test Duration])  <-this should return a percentage of how far it has been watched, but instead it returns an expression error.

If I replace the '[[Test Duration]' in the 'Test Calculated Position' with a real number, then it works, which leads me to believe that the problem lies in the Test Duration output not being a number, but a string or something...but I don't know where to go from here...if I could get this working, then I could make my original goal much easier.

Got it...it needed a space around the '/'.

[RJC]

Watched() is a built-in MC Function which does most of what you want.

[muzicman0]

Thanks...I will play around with it, but my feeling is I will want more control over it, so this is what I came up with.  It appears that the only thing it doesn't do that I would like it to do is if I convert a video, and import it, it is marked as unwatched...which it technically is (but I only convert format once I have watched a TV show and I am archiving)...I just can't seem to come up with a way to reliably detect that scenario without screwing up other scenarios...but here it is...if anyone has suggestions, please let me know!

Custom Library Fields:
SeasonEpisode = if([Episode], <font color="888888">S[Season]EPadNumber([Episode], 2), )
SCW Bookmark = math(formatnumber([Bookmark], 2)/1000)
SCW Calculated = Math([SCW Bookmark] / [SCW Duration])
SCW Duration = formatnumber([duration,0], 2)&datatype=[number]

The expression in the 'Custom File Info Panel|TV Show":

Code: [Select]

IfElse(Math(Compare([SCW Calculated], >=, .92)), <font color="888888">√ [Series] [SeasonEpisode]-[Name]</font>, Math(Compare([SCW Calculated], >=, .07) & Compare([SCW Calculated], <, .92)), <font color="C3FFB3">! [Series] [SeasonEpisode]-[Name] </font>, Math(Compare([SCW Calculated], >=, 0) & Compare([SCW Calculated], <, .07)), <b><font color="FFFFFF">[Series] [SeasonEpisode] - [Name]</font><b>)
Broken out, it is:

Code: [Select]

IfElse(
    Math(Compare([SCW Calculated], >=, .92)), <font color="888888">√ [Series] [SeasonEpisode]-[Name]</font>,
    Math(Compare([SCW Calculated], >=, .07) & Compare([SCW Calculated], <, .92)), <font color="C3FFB3">! [Series] [SeasonEpisode]-[Name] </font>,
    Math(Compare([SCW Calculated], <, .07)), <b><font color="FFFFFF">[Series] [SeasonEpisode] - [Name]</font></b>
    )
The nice thing, is if I manually set the file back to the beginning (rewind), then it marks it as not watched, which is what I want.

I've only done limited testing, but it appears to work fine.

[MrC]

The first Math() function in your expression is a no-op, and can be removed.

The < .07 case can be tested second in the IfElse, thereby leaving the final "everything else" case.

Be sure to escape forward slashes, as in the <//font> closing tags.

IfElse(
    Compare([SCW Calculated], >=, .92),  <font color="888888">√ [Series] [SeasonEpisode]-[Name]<//font>,
    Compare([SCW Calculated], <, .07),   <font color="FFFFFF">;[Series] [SeasonEpisode] - [Name]<//font><//b>
    1,                                                    <font color="C3FFB3">! [Series] [SeasonEpisode]-[Name] <//font>
    )