Jump to content

CKonash

Members
  • Content Count

    73
  • Joined

  • Last visited

Community Reputation

0 Neutral

About CKonash

  • Rank
    member

Profile Information

  • Industry
    Firefighter
  • Gender
    Male
  • Location
    Mahwah, NJ

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.12.6

Recent Profile Visitors

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

  1. Thanks Steve. The Narrative records are related to the Event records using the Primary Key of the Event. Here are some screen shots of what the users see. The report in RED is the event report. The ones in WHITE are the print layout of that same report. My issue is that if a narrative is very short the print layout has a lot of empty space in that portal field until it gets to the next page which is actually another portal that starts are related record #2 and goes to related record #5.
  2. Long story short is I'm having a printing layout issue that I'm not sure how to solve. I have a fire dept file that has an EventReport table and each event gets one record. Related to the EventReport records is a Narrative table. Officers from an incident can enter multiple timestamped narrative dialogs for a given event. I have a layout on the EventReport table for printing an event report and I had listed the Narrative dialog records within a portal. However i'm just having layout issues between windows and mac when printing and the portal records wouldn't line up with the page breaks a
  3. Hello Comment, I finally had a chance to implement and test your suggestions and boom. they worked first shot. Not that I had any doubts in your instructions, only my ability to follow along and do things correctly. One question. The Go to Related Records / Find Request is searching through about 1000 fire truck records, I noticed it's a bit slow, maybe 15-20 seconds to complete. I'm guessing that is because of the related record part since a normal find request (the old way, wrong way) was relatively quick. Any semi easy ways to speed up the search / related record proces
  4. That's a great question. Sorry I didn't think to describe that a little more in the original question. When checking a global field checkbox and then searching the apparatus for matching records I am interested in matching the individual boxes and Not all of the boxes between the global and apparatus field. The issue I was having is that the find request if I were to check the "Ladder" global field, after the find request, would return all the apparatus records that were checked off as a "Ladder" and "Tower Ladder" . Is there a way to only return the "Ladder" trucks and not have it find t
  5. Hello, I have an interesting problem that I can't seem to figure out. I have a database of fire trucks, each truck gets its own record in the Apparatus table. within the apparatus table there is a field for what "Group" that fire truck falls into. The field is a checkbox set because an apparatus can be in multiple groups. In this instanced a fire truck can be a LADDER or it can be a TOWER LADDER. They are very different types of apparatus so searching for them would be important. Right now the way I built the script if I search for LADDER I get a return of LADDER and TOWER L
  6. Hello, I have been trying to figure this out for weeks and have gotten nowhere. I have a script that ran perfectly fine on server 17 and it also works when run locally on Pro 17 or 18, but it won't complete a perform find function when run on server 18. I was wondering if anyone has experienced this and might be able to take a look at my script steps to see if I am causing something that isn't viable in server 18 scripting. The Pro or Go client calls a local script called "Send SMS to Server", then the server runs a script called "Send SMS on Server" . Here are screensho
  7. Hello, In my fire department I have a table PERSONNEL RECORDS, I put a field on there LIST SELECT TO SMS. In that field I have a check box value list assigned like "Co. 1, Co. 2, All FD Officers, etc" each record in the personnel record table will get a variety of these check boxes checked of to match which group they are currently in. I have a separate layout and table (MESSAGESSMS) that a chief officer will go to and write a message to be sent out using the AWS SMS service, which I have working. In the personnel record table I have the members mobile phone numbers filtered and
  8. Hello, I am not sure what I am doing wrong but I am trying to take a layout and save it as a PDF to a container field on the same layout. I keep getting this error that the "file cannot be found". If you wouldn't mind taking a look at the structure of the script and letting me know if you see anything wrong? Thank you in advance. Chris.
  9. Wow. that was so perfect. I'm not sure what the $i of the script does but I followed along and everything works perfectly. I tried to get my own iterations of a script to work for months now and you just solved it in one day. I can't thank you enough! Thank you!! Have a great weekend! Chris
  10. Thank you very much Comment. The first method seems the best for me and I think I can figure out the steps to do that. One question, how do I then use that returned data in the List() function to create individual records in the attendance table? My apologies for not fully understanding your initial directions. Thanks, Chris
  11. Hello, I have a dozen fire departments that manage attendance records (related to an event) and they enter them by barcode scanning or manually selecting their name (ID) from a dropdown and clicking an Add button. I have been asked a few times for them to be able to add all members to the event attendance portal. I'm not too sure how to approach this. The members and their ID's live in the Personnel Record Table, The attendance records are created in the Attendance Table when someone is checked in. What is a good way for me to capture all the firefighters ID's in the personne
  12. That's a great idea. I created that field and tried it out. What would be a good way to deal with all of the error messages that come up when a duplicate record is created. I have a dialog box pop up when the validation fails but then a few more Revert or Cancel dialog boxes come up and then it still allows a user to ultimately create a duplicate record. Thanks, Chris
  13. Thanks Steve. I thought about how to implement a dwindling list and even started doing the work to put that in but then I realized that firefighters can also scan in by barcode which means they aren't selecting from a dropdown list. This brought me back to the "checking to see if a record exist before proceeding" idea. Thanks Chris
  14. Hi Tom. I do have a script that creates the new records in the related Attendance table while the user is on the Event Report layout. It was the script step or calculation that I am unsure how to implement? I didn't want to do a full perform find to see if there was a record already created for that firefighter at that event. I though it cold be done more simply buy adding a simple script step in the current script. Thanks Chris
×
×
  • Create New...

Important Information

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