Jump to content

Timecode Again...


This topic is 5659 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I attached a file that calculates timecode summaries, the only issue I have the addition between frames1+frames2 are wrong and also I have a auto enter calculation for TC in and TC out but when I want to change one digit in the already entered field it displayes it wrong! Like "00::0:0::01"

Could someone please help me figure this one out? Thanks a bunch!

TMAS :

TC.fp7.zip

Link to comment
Share on other sites

TC In (number) has auto-enter data of: 00:00:00;00

That is not a number (ie, FM numbers don't recognize colon or semi-colon). And with the semi-colon, it's not even a time field. You then also have an auto-enter (replace) calculation converting it to a number. But they are timecodes right? So they should possibly be time fields? Can you explain what you are trying to do with the format fields? Why are you prefilling with 00:00:00;00? FileMaker does a wonderful job of adding time fields all by itself and I think we can get you there if we know where *there* is. :wink2:

Link to comment
Share on other sites

Working with timecode is a bit more complex than your file would suggest.

For simple formatting of numerical entry as timecode, see here.

For a more complex formula that includes entry validation, see the file attached here.

Note that I have not checked the calculations this file uses to compute the duration.

Adding and subtracting timecode values is pretty straightforward for all frame rates - except 29.97, which is anything but straightforward. See e.g. here, for a basic introduction to the problem (I have not checked the solution offered there).

There's also a TimeCode for Filemaker plugin which might still work with current versions.

Link to comment
Share on other sites

What I am trying is a tool for videographers that want to log their scenes with TC in and Out. It should then display the Duration of the clip in frames and time. He also should be able to change the frame rate!

Link to comment
Share on other sites

Thanks comment for your links! I went through most of them already! I have the one code working im my solution:

Replace (

Replace (

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

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

It is not working, I enter the data end it formats to the code but if I change the entry it will screw it up! It is a number field, time field wont work at all!

For the second example "spotting new layout" file there are no hours in his TC! Wont really work for me! This whole thing is a big mystery for me and even there is some info on the web with FM and TC t is hard to understand and find useful hints! Beginner problems! Thanks for your help!

Link to comment
Share on other sites

The timecode entry fields need to be Text fields.

BTW, most people don't want to bother with frames when logging. This way it's much easier to implement in Filemaker, since it's pure time, so the frame rate becomes irrelevant.

As I mentioned, timecode, especially the drop-frame issue, can be a bit complex - I'm afraid there's not much I can do about that.

Link to comment
Share on other sites

This topic is 5659 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.