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. Wow. That is amazing that you were able to whip that up for me. I think I can follow about 80% of what you are doing. I think I can make those items you send above into a script, however forgive me for asking, but where would i get the values of the members ID's that were present for the calls (it's not every member). Would I need to pull them from maybe the first event report / attendance portal, I could create the first attendance report manually and then fill the rest of the found set with the members from the first related event report. Thanks Chris Konash
  2. Hello, I manage a bunch of files for Fire Departments. After the winter we have had I need to come up with an automated way to create attendance records after a weather event like a blizzard. Normally each firefighter either scans a barcode or selects their name from a dropdown to create an ATTENDANCE record for them which is related to the EVENT (Attendance Table for attendance and Events table for Events). Typically to create the attendance record I grab the key field "ID" from the event and the Personnel Record "ID" from a value list dropdown on the incident report and then create an attendance record in a portal on the Event Layout. One of the departments responded to 120 calls just yesterday and none of the members had time to sign in for each event. I'm having trouble thinking of a good way to create a list of the members that were present for the calls (it's the same for each call) and then create a loop script to create a new attendance record for each event for each firefighter. I can easily get a found set of ID's for the events that need attendance records created but i'm not sure if I should do this attendance process by creating another layout or table to store the personnel record "ID's" and store the event ID as a variable and then make script to loop to create the attendance records in the attendance table. I hope I explained that well enough for everyone to understand. Thank you in advance for your time. Chris Koansh
  3. Thank you very much Doughemi!. I think with that detailed description it is within my ability to make that happen. I can work on these changes and try things out. Just one questions. How would I deal with the members current stint of membership since there would be no END DATE for that time period? Thanks Chris.
  4. Hello, My fire dept asked to make changes to our years of service calculation that I don't know how to complete. We have a field with DATE OF HIRE (Date field) and we have a DATE OF INACTIVITY (Date field). The current calculation returns a result in a YEARS OF SERVICE field ie. 7 Years, 2 Months, 15 Days. The interesting part is now they want to add in a members past service in another department and also their service in the military. What would be a good way to approach this. Should I add a start and end date field for each (second department service and military dates)? Or would it be easier to just have them enter an active amount of days or years? I assume a start and an end date for both military service and previous fire department service is the best way to go but I am going to need some guidance on adding those to the current calculation? YearsOfService.fmp12
  5. Thank you very much. I added these elements and things are working great. Thanks for the ideas! Chris
  6. Hello again, I have another question for my fire dept database. We have an EVENT REPORT layout and table that stores all the data from our fire calls. Linked to our ATTENDANCE table via a "kp" are attendance records for each firefighter. The chief of the department wants a time delay on their ability to sign in. Sign in was usually allowed as soon as the call was created and until the chief clicks the CLOSE REPORT button on the EVENT REPORT layout which changes a REPORTSTATUS field to "0". Then the attendance add button doesn't work for some users anymore. My question is how to I add in some script elements that would also not allow the members to sing in to a fire call for the first 15 mins after the report was created. I do have a field with the creation time already, i just get hung up with the double validation on the closed report status and then also the time delay. here is what I use now... Any ideas or guidance would be great. Thanks Chris
  7. Thank you very much RWoods. I will be putting a server script on trial today. Really appreciate the guidance. Chris
  8. RWoods. Thanks so much for the detail and really explaining the pros and cons so well. I have been struggling with this for a while and i never thought about a server script and changing the field type to help my problem. I made the changes to the field type and it's displaying correctly (THANK YOU!) However I am new to the use of a LOOP script step. When I made the script i think i put everything in that I need but if it's not too much trouble could you let me know if I have anything that is incorrect or any steps missing? Right now I have the Date of Hire filed setting itself, is that the correct way to have the calculation reevaluate through a script? Thanks again for all the info and taking the time to help!
  9. Hello, I have a fire dept database that has a field for "Date Of Hire", a field for "DateInactive" and then a calculation field to give the Years, Months, and Days of active service. The calculation seems to only run when one of those two fields are modified which doesn't update the other members years of service. Is there another way to have the Years Of Service calculated that wouldn't allow that field to become out of sync or what looks to be stuck because the calculation wont reevaluate until one of it's formula fields is modified. Below is the calculation for Years of Service that I have been using. Thanks in advance for your help. Chris Konash GetAsText( Year( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) - Year( Date of Hire ) - If( If( DateInactive; DateInactive; Get( CurrentDate ) ) < Date( Month( Date of Hire ); Day( Date of Hire ); Year( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) ); 1; 0 ) ) & " Years, " & GetAsText( Mod( Month( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) - Month( Date of Hire ) + 12 - If( Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) < Day( Date of Hire ); 1; 0 ); 12 ) ) & " Months, " & GetAsText( Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) - Day( Date of Hire ) + If( Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) ≥ Day( Date of Hire ); 0; If( Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) - Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) ) < Day( Date of Hire ); Day( Date of Hire ); Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) - Day( If( DateInactive; DateInactive; Get( CurrentDate ) ) ) ) ) ) ) & " Days "
  10. CKonash

    Finding Records between 2 dates

    Hi Doughemi, Thank you so much. I can't believe I just had the symbols backwards. I could have sworn that I tried that. Also thank you very much on letting me know about the extra script steps that I didn't need. I learned filemaker by watching other and just doing so things like that I never learned before. Thanks again! Chris
  11. Hello, I am a firefighter and have made a few files for local fire departments around me. We regularly respond to incidents on the highway and collecting data from motor vehicle accidents can be hectic. We normally manually type all the data from a drivers license and registration but there has to be a better way. I have found a bunch of online blog posts for scanning Drivers License data(PDF417) and vehicle information (VIN) using the URL to open an external app and call the data back but I'm not to sure how to implement any external apps or internal filemaker calculations that would be something I would be able to figure out. Plus it would be another challenging step to get all the ipads out in the field on the fire trucks to download another app. If we have to I can make it happen but it would be a headache. I'm wondering if there is any available information or code for performing a Drivers License Scan using the ios camera and parsing out the data into the proper fields? Also is there any standards for vehicle registrations across the US states? Would that same scan be something that could collect all the vehicle info via a registration or Inspection barcode and parse it out into the necessary fields? Any help that anyone can offer would be amazing. Thanks Chris Konash
  12. Hello, I could use some help with a find function. I have a table with fields for DateStart and DateEnd for each record. I have been unsuccessful in getting a Find to work when I have a single global date field and then a Find script. I when I enter a date into the global field and then use the find methods below I am not returning the records that fall in between those dates, it looks like I am returning the records that start and end on the date of the global date field? This seems like a simple idea but I can't figure out how to find records between dates based on a single field find script.
  13. Hi. I have a ton of calculations in my Fire Dept database yet I can't seem to get this simple one to return what i expect. I have a "Date of Hire" field with a year in it. I am trying to have a calculation field return a simple year. ie. 12 years. I had found the calculation here in the forum for the calculation result of XX Years, XX Months, XX Days but that doesn't work when the fire dept only enters a year of hire instead of a full date. Here is what I was trying to use. Thanks in advance for all your time! Chris
  14. Hello, I am interested in creating a custom App to use as an "Opener" file on an iOS device that I can deploy to some fire departments. They are using filemaker Go already but I would love to replace the filemaker icon and have it automatically find their host file on the server and log them in, vs opening the "recent" files in Filemaker Go and having them click on that. I downloaded X-Code and applied for the developer subscription and also signed up for the filemaker developer annual subscription and attempted to play around with it enough to get things to compile correctly but I think it maybe outside of my expertise range. Is there anyone that is familiar with this process and can guide me into the do's/don'ts of doing it? Also once I have the final version how do I go about deploying it to just a few users? Is there anyone here that does this as a service? Thanks Chris Konash
  15. CKonash

    Adjustable Size Layout

    Ok. Thanks Lee. The file I'm working to implement this in is a hosted file and i think is around 3Gb in size right now. I'll definitely remember that though.

Important Information

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