Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


madman411 last won the day on September 16 2015

madman411 had the most liked content!

Community Reputation

2 Neutral

About madman411

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location
    Los Angeles, CA

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I've never attempted to filter a portal based on checkbox selections. Is there a particular function that would achieve this? Never mind PatternCount() did the trick
  2. @mr_vodka I figured this was it! Thank you. Can you suggest a work around for this?
  3. Hi guys! I'm about to embark on a project where I'm solely responsible for tracking a lot of different items distributed amongst 20 people. Barcodes were my solution and and the app I've put together works a treat. However, I'm trying to use checkboxes to filter out related records in a portal. When I try to implement this the portal goes blank, which isn't the result I expected. The two tables I'm having an issue with are "Projects" and "Assignments". The "Assignments" portal is on the "Projects" layout. The relationship is: Assignments::ProjectID = Projects::ProjectsID This accurately displays all the related records in the portal. However, when I add a global field to the Projects table ("filter_assignment_status") and link the status value list to the "Status" field in the Assignments table, connect the with the added relationship the table goes blank: Assignments::ProjectID = Projects::ProjectsID AND Assignments::Status = Projects::filter_assignment_status The value list matches any of the values that would appear in the Assignments::Status field. It's worth noting that the Status field is a calculation that uses the Case() function. I'm wondering if the unstored calculation field is the issue? Case ( WrappedFlag = 1 ; "Wrapped" ; IsEmpty ( ItemCount ) or ItemCount = 0 ; "No assets!" ; not IsEmpty ( ItemCount) ; "Active" ; "OK" )
  4. Hey guys I have a NAS which I administer by issuing commands via SSH inside of terminal. All that typing has become a little monotonous so I created a small FM solution to do it for me. This is one of my [native] Apple Scripts that are issued via a button click from inside of FM: on RunTerminal() set ScriptCommand to "docker restart 70763e5576a3 85201fbfccc4 935a69d98be1 afb9e027526d" tell application "Terminal" activate do script with command ScriptCommand in window 1 end tell end RunTerminal on run RunTerminal() end run It works great, but I want to customize it a little more. The alphanumerical numbers (70763e5576a3, etc.) are individual containers which I've had to hard code into my Apple Script. I would like to have all my containers listed in a portal so it's easy to add or delete what containers I want the script to reference (or even further, have check boxes next to the records/containers I want included in the script). I'm not familiar with how to turn apple scripts into customized FM calculations to achieve this. Can anyone help point me in the right direction?
  5. Evening guys. I'm trying to invoke an error message of sorts (and/or even just a conditional format) if a value in a field is shared across multiple records. In my situation each record is assigned a color from a value list. The user can use the same color on as many records as they want, but I want to at least provide some sort of indication that it's already been assigned. I'm sure this is more simple than I'm making it to be. Help appreciated!
  6. Thanks @OlgerDiekstra. I had to trigger a pause script for .01 seconds to allow the field to play. I'll give your method a shot!
  7. Hi all I have a looping script that allows the user to scan barcodes in batches. Based on certain criteria it's either successful or returns an error. It works great. I've now incorporated a "beep" upon an error return - works great. I've added a global container field off the layout and inserted an audio clip of a chime which I want to play when the result is successful. IT WILL NOT WORK. The container is a global, data formatting is set to "interactive content" and "start playback automatically". Field entry set to "Browse Mode". Does not play. Script Debugger returns error 102 (field not found) so I moved the container onto the layout and the audio file plays upon entering browse mode and when I enter the layout, but the script does not trigger the clip to play. Even creating a stand alone script with one script function set to "Go to field - Select/Perform" doesn't trigger the clip to play. The global field is located in the table the layout is set to. I can manually trigger the file by clicking the Play icon within the container. I have achieved this before in another file and I have ripped that file apart from the inside out trying to figure out what I have done differently. The ******* audio clip refuses to play! Using FMP Advanced 13 on Mac OSX El Capitan.
  8. Trying to trim characters from both the left and right of a value in one field. There are no breaks or symbols within the value. For example, the following value is in my "full_ticket_number" field: 2900686073681910 In a separate calc field I need to have the "29" from the left and the "0" from the right removed to provide the value: 0068607368191 In this example, the "29" and the "0" seem to be some sort of control character placed there by the issuer, which have no use for me in my solution. Of course the value is unique for each record so I can't just have the calculation look for certain characters to apply the function to. I've tried to combine both the Left and Right functions, but FM is providing errors I can't seem to solve. Advice much appreciated!
  9. Hello All I have been playing with the free Airline seating demo file from SeedCode. I think this is great and I'm looking to modify it in a way that allows for multiple aircraft configurations, but I'm hitting major snags. For the record, this is just a personal project and in no way is being distributed or sold. If you look at the attached file, they've used repeating fields to create the seat map. The repetition is captured and turned into a seat assignment. Thing is, the seat map used in their file in no way mimics a real-world commercial aircraft and there doesn't seem to be a universal way to map seats among multiple variations of aircraft configurations without extensive calculations. As an aviation enthusiast, I modified the seat map in the FRONT file to replicate a common Boeing 777 configuration with three classes, but as of now this only works properly when there's only one specific seat map. Rows 1-12 are First Class, with a 1-2-1 seat configuration. 17 rows are "skipped" and Economy Comfort are rows 29-32 in a 3-3-3 seat config. Rows 33-57 are standard Coach in a 3-3-3 seat config. Using their existing calculation set up, repetitions 1-48 accurately calculate to the correct seats in First Class. To then map Economy Comfort correctly you then have to skip to repetition 253. That's 205 repetitions completely ignored. The part where I'm hitting a brick wall is integrating additional aircraft seat maps for other "flights", such as an A320, which has a completely different seat map configuration. I don't see how this existing table/relationship/script structure would allow for the database to track more than one map. I've separated the aircraft map into a separate window and considered different layouts for different aircraft seat maps linked to different tables. Each aircraft seating map using a different script, however, the passenger information part of the database would need to be consistent, no? Also, with their current script, dragging a First Class passenger to an Economy Comfort seat yields a seat number which is completely off. With their current config and a larger aircraft I'm struggling to get FM to calculate remaining/unassigned seats in each cabin leading me to believe this might be easier using records rather than repeating fields. Any input appreciated AirplaneSeatingDemo.fmp12.zip FRONT.fmp12.zip
  10. Hi All I'm running into a bit of a calculation dead end. I have an "order" table displayed in a portal where my users can create orders. The user can add a group of records (a kit) from the inventory table. The first related record is a "master" record which shows a description title and a subtotal (see attached image) and where I would like the user to be able to adjust the quantity for the overall group of records. When initiated the script assigns these related records a GroupID which is currently set as a self join (OrderLine::GroupID = OrderLineKit::GroupID). The system calculates accurately if the master record quantity is set to 1, but if the user increases this quantity to two or higher I'm getting the numbers overlapping (stacked fields) and then the user can't manually adjust any of the other quantities without some strange results due to my current calculation. Some grouped records are added with pre-existing quantity amounts which need to be doubled/tripled, etc, if the user increases the master quantity, however the user should still be able to manually change any quantities. The quantity field is where it's driving me crazy. I have the following fields that are stacked: Qty (calc field, hidden on master record row) KitQty (hidden on all portal rows except for the master record row) QtyOR (quantity override, hidden on master record row) When the group of records is added it populates the quantities in the QtyOR field. Currently my Qty field has the following calculation: If ( isEmpty ( OrderLineKit::KitQty ) ; QtyOR ; QtyOR * OrderLineKit::KitQty ) I know my script is missing criteria which is giving me these issues. I hope I explained myself well enough for people to understand. The below image shows an example group of records with the master quantity set to two. The prices and such update properly, but there's an overwrite issue (Qty and QtyOR data displayed on far right for example purposes). Aside from this problem my system works just as expected. I'm so close to wrapping up this part of my database!
  11. The system is connected to QuickBooks. The system subtotals on certain rows so when my boss pushes his orders to QB to create an invoice he only wants the information on these rows passed through.
  12. Hi all I'm trying to create a calculation (order::list) to list related records that have the value of "1" in a field in the related table. My tables are "order" and "order lines". I use a portal for "order lines" on my Order layout. Right now they're connected by Order::OrderID and OrderLines::OrderID. Two fields in order lines table are OrderLines::Description and OrderLines::Flag. If the flag field is "1" I need the list field to list what's in the description field with a carriage return for all related records where the flag field is 1. If it's 0 or empty then that record needs to be ignored. The List function works fine to return the contents of the Description field of all related records, but I'm struggling to make the calculation only look for certain values. I'm sure this is pretty simple but help would be much appreciated. Thanks!
  13. Alright. I think I have it, but I've become a little dazed while trying to debug my calculation while thinking in standard time. As usual I overcomplicated things in my head... Comment, please grade: Let ( [ period1dur = Min ( Meal1Start ; Meal2Start ; WorkEnd ) - WorkStart ; penalty1dur = Max ( 0 ; period1dur - 6 ) ; period2dur = Min ( WorkEnd ; Meal2Start) - Meal1End ; penalty2dur = Max ( 0 ; period2dur - 6 ) ] ; 4 * penalty1dur + 4 * penalty2dur )
  • Create New...

Important Information

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