Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Mike_FM

  • Rank
  1. Hi all, I would like to create a page count for a found set of records when I am in preview mode and when I export to PDF ie if a found set of records has 3 pages then the first page would contain a field that reads '1 of 3' Can anyone help with how to achieve this? Any help is much appreciated Thanks Michael
  2. This is awesome! So I used the Left and Right function to split out the scan filename string into new fields; cVersion and cSubGroup, I then duplicated the scan table and and created a relationship between the new cSubGroup fields - I didn't realise you could duplicate table and do a self join To further my understanding of the calculation you used in the portal filter: In layman's terms I understand that 'Scans::cVersion = Max' means show the highest number in this field (?) But what does ( ScansInSubgroup::cVersion ) part of the calculation mean? Thanks again
  3. Ah yes, apologies calling it a found set is a mistake and also upon further testing the calculation: Scans::Scan Versions = Max ( Scans::Scan Versions ) doesn't quite work for what I need. Diving in a little deeper... I have two tables in my database; 1 called Counts and 1 called Scans and they are related using a match field called VFX_ShotCode (Counts table is the parent and Scans is the child) Within the scans table I have created a field called 'scan filename' and it contains the names of all the scans in my project; they all follow this naming convention- episod
  4. Hi all, I have created a portal in a related table and I want to apply a filter to it so that it only shows the latest versions from a found set of records and to hide the others. There is a related field within the portal called 'scan version' which displays the version number as eg 'v001' 'v002' 'v003' etc I've been hunting around online to find a calculation that fits my needs and have played around with the 'Max' function but to no avail If anyone can give me some pointers that would be awesome, I'm still very new to this and learning so any help is always appreciated!
  5. Actually please ignore the above I have managed to work around this. Thanks so again for the calculation
  6. Awesome! Thanks So the only complication is that the TC of the media that I am converting to frames, by default starts at 1 hour so 01:00:42:09 equals 87389 frames... however in my editing application 01:00:42:09 when converted into frames on the timeline actually gives the value of 989 frames... so seems to be ignoring the hour or seeing it as 0... As a general rule media and timelines in editing software start at 01 hour in order to give ample space for any credits or such that might need to go before the programme starts and therefore avoiding a negative timecode ie if a program
  7. Hi there, the above calculation has been very useful in adding 8 frames to a timecode. I have another field that when a timecode is entered, a calculation should convert it into a frame count, so for eg if TC: 00:00:42:09 was entered the result in frames would be 1017 (frame rate 24) The above calculation that you gave me converts timecode to frames, adds 8 frames to the value and then converts the frame count back to timecode. I have tried to extract the part of the script that converts timecode to frames but with no luck, can you show me how to convert timecode to frames? Any
  8. This works perfectly thank you. I guess my only other question is that I have been doing a lot of research online and there is a lot of back and forth about why using UUIDs is a better way to link tables than using an ID like this one... so as I'm new to this I am wondering what you think about this and if setting up my database this way cold have any pitfalls along the way. The only potential issue I could foresee is if at some point in the production I am told to change the names of the shot codes (parent) and then nothing from the child records will link thanks
  9. Yes there is a parent record that identifies 0040, so I see what you're saying... the separate field that contains the extracted '0040' should be the foreign key and linked to the parent in the relationship graph...
  10. Hi thanks for this, sorry if my query has come across as confusing, the bare bones of what I am trying to achieve is this: I have a parent table containing ID and some other basic fields. There is a child table feeding into this - with its own set of fields. Parent: __pkParentID Child: __pkChildID, _flParentID,...(other fields) I have many records that I wish to import from an excel doc and a tab delimited file into the child table. I can do this, but can't work out how to auto populate the parent table. I can see what you have written above but I'm not sure how to im
  11. the single scan import will contain multiple records some of which will need to relate to just one shot The scan import will create multiple records in the scans table; each scan record needs to relate to a corresponding shot record in the shots table. There will also be multiple scan records that will relate to just one shot record ie 1 scan record links to shot 0010 but 5 scan records that link to shot 20 The shots and scans are told apart by their names eg shots are labelled '0010' 0020' '0030' etc scans are labelled '0010_scan01' '0020_scan01' '0030_scan01' th
  12. Hi there, There are multiple shots that have already been created and the single scan import will contain multiple records some of which will need to relate to just one shot TabD is tab delimited file Thanks so much for you help!
  13. Hi all, I am creating a database with a simple set up; one table called shots (parent) related to another table called scans (child). I have created a portal in the shots (parent) table with a scripted button called 'create new scan record' that when pressed, creates a new record in the scans table attached to the same UUID from the shots table. This works well and links records from both tables. The problem I have is, I need to import a lot of data via a TabD into the scans table - probably a hundred records at a time that need to share the same UUIDs as the table records so th
  • Create New...

Important Information

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