Entry calculations based on other entries - Learning this software - Script Workspace and Script Triggers

September 12, 201114 yr

Hi to anyone that can help,

So I am creating databases that are linked. I'm building this for some video/film editing work

I have two database one for SEQUENCES one for SCENES

in the SEQUENCES database I have fields for SEQUENCE #, SCENE FROM and SCENE TO (plus other parameters that are irrelevant).

in the SCENE database I have SCENE #, SEQUENCE #, SCENE FROM and SCENE TO.

What I want to be able to do is fill out the SEQUENCE list first with all the information then when I go into the SCENE database and enter SCENE # - for example scene 7, it will automatically enter SEQUENCE#, SCENE FROM and SCENE TO into the other fields, eg. SEQUENCE 4, FROM 5 - TO 9.

Does that make sense? If anyone can help with the script I would be most appreciative.

thanks,

Rowan

September 14, 201114 yr

Does that make sense?

Not really, I am afraid. Is sequence a group of scenes - or is it the other way around? And what does SCENE FROM and SCENE TO mean?

September 14, 201114 yr

Author

Hi,

The sequence is a group of scene that start at any particular scene and end at another.

For instance:

Sequence 1 might consist of scenes 1 to 5 (SCENE FROM = 1, SCENE TO = 5).

Does that help?

Thanks for replying. I guess it's a complicated question.

Cheers,

Ro

September 15, 201114 yr

I guess it's a complicated question.

I am not sure of that. It's just not clear why you have all those fields in the Scenes table. If the scenes included in a sequence are determined by the SCENE FROM and SCENE TO fields in the Sequences table, then all you need in the Scenes table is the Scene #.

Note that your method allows a scene to be included in more than one sequence.

September 15, 201114 yr

Author

Thanks. I think I need to delve deeper into the program and try to figure it out.

Can you recommend any tutorials for scripts?

September 15, 201114 yr

Before you do any scripts, you need to understand the relationship of data you are trying to accomplish;

IE>> " I work for a company that needs to be able to edit scenes that start at a particular

frame and end at another frame. There will be users that can blah bla "

get all the nouns and create an ERD (Entity relational diagram) - YOu need to find the parent table and other children tables that "Obey" the parent. When you have a many scenes to many edits - then you need to create a JOIN TABLE> THEre are tons of tutorials on youtube, lynda, vtc..

-i