Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About CKonash

  • Rank

Profile Information

  • Industry
  • Gender
  • Location
    Mahwah, NJ

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

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

  1. 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 a separate field (ListOfMoblePhones) that lists all the numbers in the found set of the personnel records. I was trying to find a relationship between the Personnel records and MessagesSMS table that would connect the results of the check box results and then it would lookup the correct ListOfMobilePhone to be sent out. I'm wondering if I'm going in the right direction? What would be the best way to identify a persons personnel record as part of one or many of the check box groups and then in the MessagesSMS table be able to get the list mobile numbers from the personnel record field that contains the result of that checkbox set. Thank you! Chris
  2. 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.
  3. 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
  4. 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
  5. 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 personnel records table (or loop through the records) and then create new attendance records with all of those firefighters ID's? Should I create two open windows, one in personnel records and one in attendance, capture the firefighter ID's one by one after I perform a find of all firefighters in that fire company and then go to the attendance window and create a new record with the captured variables for that event and the firefighter ID, then go back to the personnel window and get a new personnel ID. Just wondering if there is a logical way to approach this. Thank you in advance for even looking at this. Chris
  6. 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
  7. 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
  8. 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
  9. Hello, Not sure if this is the correct area to ask but I've been racking my brain and am not getting anywhere. I have an Event table (Fire Incidents) and related to the ID of the event you can create attendance records in the attendance table for the members responding to the fire emergency. I do the attendance adding using a portal on the event record and add the members by capturing their Personnel record ID and then setting the last row of the attendance portal using their personnel record ID and the event ID. That has been working great and there is no issues there. I wanted to add a new validation that looks to see if that Personnel record ID AND Event Record ID do not exist as an attendance record, before it allows the user to add the attendance. I'm not sure what I should show here, relationship graph, or something else to help understand what my file looks like. Let me know if I should send any additional info. Thanks for everyones time, this forum has been amazing and it's not possible without everyone. Thank you. Chris
  10. I'm not sure if I should be happy about the you "coming out of retirement" or if I should feel bad for blowing the cover off of your summer vacation of hiding... Thanks again Comment! You're making the world a better place by helping people. Everyone should follow in your footsteps and we would have a better place to live. Chris
  11. I'm really sorry. I didn't see that the window of your reply was able to scroll to the right and show the rest of the calculation. Sometimes I'm not the most with it somedays... I really thank you for the help. I'm going to try and implement that and see how it goes.
  12. Thank you for the reply. I have never used the SerialIncrement calculation. Would you mind sharing the rest of your calculation values. I'll play around with that command in the meantime. Thanks again! Chris
  13. Yes. 090520181039 would be exactly what my end goal would be. Thanks Chris
  14. Yes. that's exactly what it looks like. Sorry for not including that before. Thanks Chris
  • Create New...

Important Information

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