Jump to content

jl2017

Members
  • Content count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jl2017

  • Rank
    newbie

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
    Beginner
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.12

Recent Profile Visitors

1,122 profile views
  1. So I am very close to getting my modal custom dialog windows to work with the new window card feature that was introduced in FileMaker 16. I have a script in my database that allows users to type in a list and the script parses out the information and finds the appropriate records in my database. When a record isn't present, a custom dialog pops up and notifies the user that the record is not present in the database. The script works flawlessly with the old show custom dialog and will cycle through every record that is not present...popping up a custom dialog for each one. However, using the new window card feature...it is only popping up the first record that is not present and stops there. If I have multiple records that do not exist, the new window card feature fails to cycle through them. Trying to figure out if I am missing a step between how the custom dialog window and the new window card feature commit data? Here is the script using the show custom dialog method: Close Window [ Name: "Multiple Shot Find" ] Set Error Capture [ On ] Set Variable [ $Selects; Value:VFX Counts::VFXCounts_ShotFind ] Go to Layout [ original layout ] Adjust Window [ Hide ] Go to Record/Request/Page [ First ] Set Variable [ $R; Value:Get ( FoundCount ) ] Omit Multiple Records [ $R ] [ No dialog ] Set Variable [ $i ; Value: 1 ] Loop Set Variable [ $Select; Value:GetValue ( $Selects ; $i ) ] Exit Loop If [ $Select = "" ] Enter Find Mode [ ] Set Field [ VFX Counts::VFXCounts_ShotNumber; VFX Counts::VFXCounts_ShotFindRange & $Select ] Extend Found Set [ ] If [ Get ( LastError ) ≠ 0 ] Show Custom Dialog [ Title: "Warning"; Message: $Select & ¶ & "This is currently not a shot, please check the spelling."; Default Button: “OK”, Commit: “Yes” ] End If Set Variable [ $i ; Value: $i+1 ] End Loop Perform Script [ "Go to VFX Counts" ] Adjust Window [ Restore ] And here is the new window card method: Close Window [ Name: "Multiple Shot Find" ] Set Error Capture [ On ] Set Variable [ $Selects; Value:VFX Counts::VFXCounts_ShotFind ] Go to Layout [ original layout ] Go to Record/Request/Page [ First ] Set Variable [ $R; Value:Get ( FoundCount ) ] Omit Multiple Records [ $R ] [ No dialog ] Set Variable [ $i; Value:1 ] Loop Set Variable [ $Select; Value:GetValue ( $Selects ; $i ) ] Exit Loop If [ $Select = "" ] Enter Find Mode [ ] Set Field [ VFX Counts::VFXCounts_ShotNumber; VFX Counts::VFXCounts_ShotFindRange & $Select ] Extend Found Set [ ] If [ Get ( LastError ) ≠ 0 ] Go to Layout [ “VFX Counts” (VFX Counts) ] Perform Script [ “Dialogue Script”; Parameter: "WARNING|" & TextSize( TextFont( TextColor ( $Select; RGB( 51 ; 153 ; 204 ) ); "Arial" ) ; 24) & ¶ & ¶ & "This is currently not a shot, please check the spelling.|OK" ] If [ $$ButtonResult = 1 ] Commit Records/Requests [ With Dialog: Off ] End If End If Set Variable [ $i ; Value: $i+1 ] End Loop Go to layout [ "VFX Counts" (VFX Counts) ; Animation: None ] Anyone have any thoughts as to what I am doing wrong?
  2. I am really struggling with coming up with a solution for this one...so hopefully someone can help me out. This is for a visual effects database on a film that is tracking statuses of multiple VFX shots. I was asked to come up with a way to compare anticipated dates from each vendor based on when the vendor plans to final a shot, the previous date that the shot was anticipated to be final and the actual date that the shot was final or PTF (Potential To Final)...all based on the week ending date. I have successfully created a separate layout for each scenario where I have a summary field for each vendor calculating the amount of shots per the week ending date. I am wondering how to combine all these summary fields into one layout so they can be compared to one another in one spot? The problem I am having is that each layout uses a different sort to properly display the summary fields. Am I going about this wrong or is there a way to display all this information in one spot without having to jump between layouts? Not sure if this is helpful or not but here are the fields I have setup to accomplish my successful summaries for each scenario: Post: Final Delivery - This is the date that the vendor has anticipated the shot to be final Date_Serial - This is a calculation field I have created to create a unique serial for the date. The calculation is: WeekOfYearFiscal ( POST: Final Delivery ; 2 ) & "_" & Year ( POST: Final Delivery ) Date_Serial_Text_Vendor1 - This is a calculation field to sort out the weekending dates based on vendor1. The calculation is: If ( Facility = "Facility1" ; Date_Serial ; "" ) Date_Serial_Text_Vendor2 - This is a calculation field to sort out the weekending dates based on vendor2. The calculation is: If ( Facility = "Facility2" ; Date_Serial ; "" ) Date_Serial_Vendor1_Summary - This is the summary field calculation = Count of Date_Serial_Text_Vendor1 Date_Serial_Vendor2_Summary - This is the summary field calculation = Count of Date_Serial_Text_Vendor2 Date_Weekending - This is the calculation field to generate the weekending date. It is also the field I sort by: POST: Final Delivery + 7 - DayOfWeek ( POST: Final Delivery ) For all the other scenarios I have similar fields (i.e. Date_PTF_Serial, Date_Previous_Serial...) just named differently for the most part, but they do the same calculations. I have attached images of what the layouts look like and how they successfully summarize the count of all the shots based off of the weekending date. Combing Anticipated, Previous Week and Finals/PTF's into one layout is where I am really struggling. Any help at all would be greatly appreciated.
  3. I have a database that tracks all of the VFX shots we have in the current film I am working on. I am looking to get some help on creating a snapshot layout to report how many shots per vendor are estimated to be finaled for the week and how many shots actually are final. I have a table labeled "Status Report" that has a list of all of the shots we have in the movie based on vendor, with the field for vendor being "Facility". The table also has fields for the shot "FX SHOT #" and the date the shot is supposed to be final "POST: Final Delivery". In another related table, "Filmout Takes" we bring in all of the submissions we get from our vendors and that matches up to the "FX SHOT #" through a relationship. In this table, we mark what versions are final in a field called "Final Approved Version". There is also a date based on when the submission was received which goes into the submission "Date" field. I am looking to create a layout that would list the "week ending date", a column for each vendor that gives the sum of shots that are due for that week and a column for each vendor that gives a sum of shots that were actually finaled for that week. The actual finaled shots would come from the "Final Approved Version" field. I thought of creating a separate table so I could create records that contained each week ending date, but I am struggling to come up with a way to find the sum of all of the shots that were supposed to be due during that particular week. Is this a script trigger on layout enter or should I focus on a calculation field? Any direction would be greatly appreciated. Fairly new at complex scripting...so this is a bit of a head scratcher for me. Thanks in advance.
  4. Amazing! Thanks so much. Worked perfectly. Really confused about the positions but glad this worked.
  5. Okay...so I ran into another problem. This works for one field but I need to extract the date from the filename...basically the 150731 or 150721 from the different file formats as well. Is this possible using a similar token calculation? If so that would be awesome.
  6. Actually the token calculation worked perfectly! Thanks so much for your help! Worked like a charm!
  7. I am trying to figure out how to extract a portion of a filename from a field, when the filenames differ. It is for a file database. This would be easy if all the files are named the same, but we have multiple different filenames based on the type of file it is. So the idea is I have a "shot_name" field that pulls in the name from the file I am importing into FileMaker. For instance, here are two of the filenames...one is for a traditional shot and one is for a development shot. Traditional Shot: BOG8515_150731_Line-Up Development Shot: BDC_dev9150_150721_Line-Up Essentially the only portion of the shot I want is the following for each: Traditional Shot: BOG8515 Development Shot: BDC_dev9150 I believe there would only be these two variables I would encounter, however the end of the filename may change from _Line-Up to _Change from time to time. Is there a way to strip out only the shot name? Can't quite wrap my head around how I would do that in a calculation field. Any tips or advice would be greatly appreciated!
  8. Okay...so I added the $searchTerms custom dialogue and have to admit, it is extremely helpful. I have a simple okay button to move onto the next submission so entering multiple submissions is a breeze by hitting the enter key. I wanted to search this way to make it a cleaner experience for the user. I realize I could do all this within a layout, using list view and doing multiple finds. But I like the finder like interaction the custom dialogues give. I'm happy with how this came out...way better than I was expecting. Thanks for all the support everyone! Greatly appreciate it.
  9. So I was able to get this to work with the loop that was provided. It may not seem graceful to the outside world, but I think it will work just fine for my needs. Far better than what I had before. Thanks for all the input and advice. Greatly appreciate it!
  10. Not ideal...as you have suggested but let's say I go about this and add a third button. Say we turn 1 into Find, 2 into Cancel and 3 into Add Vendor...so I would add a loop to the If equation for 3, but how would I maintain the data entered in order to search it once 1 or Find is pressed? Is there a way to generate a list of all of the vendor submissions that the user could highlight and then perform the find? Basically a way to generate a custom dialogue where one could select the appropriate submissions and execute said selects from the custom dialogue? Just curious if there was a way to do that and if it was more effective.
  11. I have a database that tracks submissions we get from our VFX Vendors. I have a field in this database that I import all of the vendor submissions into. I would like to know if there is a way to search for multiple submissions through a custom dialogue. I have successfully created a script for searching for one submission. Is there a way to expand upon what I already have? Here is what I have so far: Go to Layout [ "VFX Notes Original" (VFX Notes) ] Enter Find Mode [ ] Show Custom Dialog [ "Vendor Submission Notes" ; "Enter the vendors submission name down below." ; VFX Notes::VFX Notes_CompDateRecieved ] If [ Get ( LastMessageChoice ) = 1 ] Perform Find [ ] Go to Layout [ "Vendor Issue Notes" (VFX Notes) ] Enter Browse Mode [ ] End If If [ Get ( LastMessageChoice ) = 2 ] Enter Browse Mode [ ] Go to Layout [ "VFX Counts" (VFX Counts) ] End If Any guidance would be greatly appreciated. Thanks in advance!
  12. Jayivan, Thanks for replying. - Which version of FileMaker are using, and are you using it with a server (and which version)? I am using Filemaker 13 Advanced to design my database and I am hosting it on Filemaker Server 13. - How are you looking to speed up your database? Is something performing slowly now, or are you looking to add information more rapidly? I have previously just used a seperate photo database to link to container fields in my main database. I try to use small images but with thousands of records and intermitent internet speeds depending on where I am working, the main database gets bogged down by trying to access these pictures. I can continue to use this method, but read about supercontainer and thought it would be a better option for accessing this data over the internet. - How many clip records currently exist that you need to add images to? I am well into the thousands which is why drag and drop really isn't an option. The records I have in my database are imported from a tab delimited file and I can reimport if need be. I am recreating a database from the ground up so this is not an issue where I am concerned about migrating my infromation. The thing that confuses me is the file structure SuperContainer creates. If I could somehow make the Web Viewer address access the original file name, I could create a link between the filename (which is basically the clip name) and file itself. That is what I am struggling with. Hopefully that gives you more information into what I am looking to do. Thanks in advance.
  13. So I am somewhat new to SuperContainer and to designing layouts in FileMaker. I have a database for a film I am working on and in the database is a record for every clip we have in the movie. We also have an image that matches the data for every clip that is in the movie. What I would like to do is be able to batch import all of the photos (using the batch import option in the Super Container Sample) and link all of the files from that batch import to the web viewers I have setup in my film database. I have toyed around with the address in web viewer, however since every record is a different filename I am getting confused how to link it to the batched photos I brought in with SuperContainer. Is there an easy way to do this, so if I create new records in my film database and then subsequently batch import their matching photos, things will automatically link up? I want to be able to use SuperContainer to speed up my database. I am excited at the prospect of this product, just don't really understand how it works yet. Any help would be greatly appreciated.
×

Important Information

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