how to format a numerical field to show as SMPTE

[mikkelbreum]

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

[mikkelbreum]

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

[mikkelbreum]

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

[Søren Dyhr]

S

[Søren Dyhr]

S

[Søren Dyhr]

S

MikkelBreum.zip

[mikkelbreum]

how?

[mikkelbreum]

how?

[mikkelbreum]

how?

[Lee Smith]

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

[Lee Smith]

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

[Lee Smith]

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

[mikkelbreum]

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

[mikkelbreum]

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

[mikkelbreum]

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

[comment]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

[comment]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

[comment]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

[Ugo DI LUCA]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...

[Ugo DI LUCA]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...

[Ugo DI LUCA]

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...