sirsancho09

I have a database setup wherein I take post-production notes on an animated series. I have a slew of retake scenes in any given database (a new one is used for each episode, a protocol issue with the studio) which some of them have categories for the type of note. Not all scenes have this category (they indicate reasons for these particular notes). When we have completed the review of any given episode, we need to reconcile those categories. Generally this comes down to matching that categories frame count (say 12) versus the scene's entire frame count (say that is 20). If the counts don't match we generally need to add another iteration of the scene with a category that is 8 frames long to reconcile the scene. I hope that makes sense, the nuts and bolts of it is convoluted in a way that animation is just not ready to face.:) So here is where I'm at. I have created a layout where all the scenes can be displayed with the scene number field (SCENENUMBER), frame count of scene (frame_count_scene), and frame count of category (frame_count_category). As often there is multiple iterations of the same scene I have created a Subsummary part that sorts on scene number and a summary field that gives a total of the category frames (frame_count_category_sum). That is then weighed against the scene frame count (frame_count_scene) and a field (frame_check) displays a "OK" if they don't have a category, "COMPLETE" if they match, and a "RECONCILE" if they don't match. Is there a way to filter it so it only shows the scenes that result in a "RECONCILE" return in frame_check and does not display the other two returns? Any help would be useful. I am not married to this method, so if something has changed in the last few versions (on 17 now) I am happy to switch. I unfortunately cannot provide the file due to an NDA, but I could provide further details if needed. Any help would be useful. Cheers!

Perfection! Thank you for the elegant solution to my brute force methodology.

Sorry hopefully it will show now. I'm on 15 Pro Advanced. If there is a direction or the concept of the direction it would be ideal if it worked there. However it could also me the means to get my company to update us (not likely in this current world).

That is a good solution, but I failed to mention that I am pasting lists from excel in the "listfind" field to get multiple results in the portal. So something like that will turn a list like: 5 9 10 12 To 591012. Sorry I failed to mention that.

I have a database setup wherein I take post-production notes on an animated series. I have created a relationship where a table occurrence of my main table (retakes) named (retakes_listfind) is present. This is a relationship where a text field named "listfind" in retakes_listfind is set to equal a text field named "scenenumber" in retakes. I can paste a list of incoming scenes (1, 2, 3, 4, 5, etc.) in a retakes_listfind layout with a portal to retakes. Here is the issue. It works fine, but only if the numbers match. Due to an accounting requirement we need to enter all scene numbers with a leading zero, and it isn't a pure number because often scenes have text additions for inserts (e.g 004A between 004 and 005). However when i receive my lists from excel they do not have that leading zero. I can manually create a formula that formats out right, but I would rather make it so if I paste 4 in the "listfind" scene, "004" will show up. I was able to create a separate field name "listfind_scenenumber" where the scenes are dialed down to numbers without zeros with an Int calc, but this ignores the letter and anything with leading zeros (so 4A above would show 004A and 004-not that big a deal I can work with that but putting it there for context). I would like to be able to enter either 4 or 004 and have the record show up. If I match it to both fields in the relationship it only seems to show exact matches again (essentially ignoring the match on "listfind_scenenumber") It's such an oddly specific thing, and I coded the original use of this in another database an age ago that I am hazy on the nuances. Any help would be useful. I am not married to this method, so if something has changed in the last few versions (on 15 now) I am happy to switch. Cheers!

I have a database where I have created a global field where when I paste in a list of values it shows me the matching fields via a portal. The global field (listfind) matches a name field (design) via a relationship with an additional occurrence (designdata_match) of the main table (designdata). That is working fine, however what I want to add in is a way to indicate if one of the values I paste into the global field is not matching in the other table. It could be as simple as highlighting the value in question in a different color. I am unsure how to achieve that. Any help would be amazing.

I don't have one, I could place the values on a Value List.

I am wondering how one would go about listing missing values in a group. I have a group of records that are assigned a value in a field called Incidental, for ease of use, 1-20. I may have 12 records with the value of 1, and 3 with a value of 2, none with a value of 3 or 4, 2 with a value of 5 and so on. Some records won't have a value at all in that field. I need to know if there is a way to generate a list of the numbers between 1-20 that do not have a record connected to them. Is there a way to poll the records and get a list of that? I created this script: Perform Find // Shows only records that have a value in the Incidental Field Sort Records // Sorts the Incidental Field in Order Set Field [gincidental; ""] // Clears Data and is used to create list of values Loop If [$PI = Incidental] Set varialble [PI; Incidental] Go to Record/Request/Page [Next; Exit After Last] Else If If [($PI+1)= Incidental=0] Set varialble [PI; Incidental] Go to Record/Request/Page [Next; Exit After Last] Else If If [Incidental - $PI >= 1] Set Field [gincidental; If(gincidental=""; ($PI)+(Incidental-$P1)-1; gincidental & ", " & ($PI)+(Incidental-$PI)-1) End If Set varialble [PI; Incidental] Go to Record/Request/Page [Next; Exit After Last] End Loop I know the calculation is bad because I am not getting all the missing values, because it doesn't account for all missing values, so when it goes from 2 to 5 in the above example it would only show 4. I feel like there is a more elegant solution that would show me 3,4, and and other missing values accounting for duplicates, and if possible, empty records as well. Any help would be grandly appreciated, Shaun