We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by CKonash

  1. Adjustable Size Layout

    I have a fire department incident report layout which has a portal on it to capture pictures of an incident. After the photo is taken you see a thumbnail of it on the incident report portal. I have a separate layout with mostly the same info which is used to print the incident report if needed. I an wondering how to attach those photos to that "print" layout if there are photos taken at the scene but not have lots of blank pages with empty container fields if there were no photos taken? Thanks Chris Konash
  2. 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.
  3. Adjustable Size Layout

    Thanks everyone! I have never been able to figure out how to do that, I am definitely not an expert. I am going to play around with this and see what I can figure out. Thanks again for your time!. Chris
  4. Script Time Lockout

    Hi. I have a script that runs to add attendance to a fire department incident report. Before the script runs it checks the current time against the dismissed time of the call. If the current time is more than two hours after the dismissed time the script will not allow you to enter the attendance. My question is how would I add a second means of validation to not allow an attendance record to be added unless 15 minutes have elapsed from the start of the call while keeping the two hour time out component? Thanks Chris
  5. Script Time Lockout

    Thanks everyone. I'm going to try this. I didn't know that. Thanks again!. Chris
  6. Hello, I have a few fire departments that use my database, each department connects using filemaker Go. In their database they have a button that runs a script that will collect some fields from an "Incident Report" and save them in a script parameter and then open a mutual aid database that is used by many towns. It opens the mutual aid database using the open URL script step and the username and password are hard coded into the script. The opening of that file triggers a script to run and create a new record in the mutual aid database and pulls in the field info it needs from the script parameter, then the script closes the mutual aid database. What I am looking to do is not change the way an incident is "created" with the scripts i mentioned but rather figure out how to give the Chief of a local fire station the ability to one click open and "monitor/edit" the mutual aid database where he can see the apparatus that are being assigned to his emergency. Since he would have edit abilities I wanted there to be some security on that account. Since each town manages their own user accounts within their databases, using a table, a layout and some scripts to create and delete their own user accounts in their database I don't think there is a good way to also create that user account in the mutual aid database at the same time. Here is what I was thinking. Run a script in the hosted FD database that captures the user account name as a variable and then opens the mutual aid database using OPEN URL. Then creating a user account with the same user name as the hosted fire department chief that wants access to see the mutual aid database, I could use any random password i guess so they will not need to know it. This would give me the ability to log any changes they make based on the account user name. I think that's something I can do but my question is I want that person to have continued access to the database and if they click the button in their database to access the mutual aid database they would get an error saying that this user account already exists no? What's the best way to deal with that? Thanks for your time! Chris Konash
  7. Hi, I have searched everywhere and could not find something I could apply to do what I am looking for. I have a Fire Dept database that I manage, they have a table of "Event Reports" for each call. Within our Fire Departments we have 14 towns that are part of a Mutual Aid Group which has a radio desk that manages large, multi resource incidents. I would like to develop a database to help them manage the resources at the incidents since a handful of departments are already using the database solution I host for them on a server. I would like to create a script that copies the values in about 6 fields on an Event Report from a townships database and have a new record created in the Mutual Aid database and have those 6 values set into their respective fields? I understand the set variable and set field steps but spanning those from one file to another is not something I have done before. Any help would be really appreciated. Town Database the data is coming from. Event Report:Time Event Report:Type of Event Event Report:Full Address Event Report:Township Evnet Report:I.C.S. Officer Mutual Aid Database the data is going to. Incidents:Township Incidents:Address Incidents:TimeStart Incidents:EventType Incidents:CommandOfficer
  8. Just want to say thank you so very much to the three of you that helped me. I was able to decipher what you shared with me and implement it into our fire departments database and now we can create a record and use the scrip parameter to dump in the vital info into a different database that our county will use to monitor incoming fire apparatus. I definitely could not have done that without you. Thanks so much!
  9. I have tried a few different variations of what you described and none of them return we I would have hoped. All of the data is entered into the first script paramenter field and it is still the name of the Table:Field from File 1. See attached. Any ideas? Thanks Chris
  10. Hello, I am definitely not an expert on the filemaker scripting of open file vs open URL but your direction in assisting me to find the needed reading material was awesome, thank you so much. I have never done the XML data exchange so I wouldn't know how to even start that process... Using the Open URL script step, I messed around with it this morning and am able to get the File 1 to open File 2 with the embedded user and password and also get the intended script to run. Adding in the script parameter into the URL is where I get hung up. I added the info as it appears below in the picture but it does not return the data from File 1, it simply returns the literal text that is in the script parameter of the open URL script parameter. Instead of pulling the address from File 1 into File 2 using the script parameter within the url it is only pulling the table::field. Am i doing something totally wrong? Thanks Chris
  11. Hi Wim, I have tried so many different combinations to Open the second file with the open url script step. I still get a popup dialog window to enter credentials for the file that the script is opening. It sees the file on the server and is attempting to open it but the hard coded username and password don't seem to be working. Am I doing it incorrectly? fmnet:/Username:Password@HostURL.com/NORCON
  12. Thank you very much. This would be a handoff of information between a police server and a fire server which happen to be separate. The user account for the handoff would only be able to access the given fields and nothing else so I guess it's ok to hard-code the credentials. I'll research how to open a fmp file using the url script step and put the credentials in the url and see how that works. If I get into trouble I'll maybe reach out to see what I am doing wrong. Thanks, Chris
  13. Hello, I have been successful in getting the script to open the other file and create a record. What I didn't think of is is it possible to specify an account username and password for it to login to the other file under? It was working great for me because I have the same user account and password for both the databases I was working with. I would prefer not to Login as a Guest since that would kill my security privileges I believe. Anyone know if it is possible to specify a user account and password when using an open file script step? Thanks very much!. Chris
  14. Hello, I just yesterday started with a host company for a dedicated server for a few databases I host for some fire departments. I got a downgrade to Server so the departments with FMP12 can still connect. I moved over one database onto the new server that was previously on a shared server host and successfully was using the 360 Works email plugin to retrieve fire call data from an email account. Forgive me but I have not setup a server from scratch before but I have put the 360 works email plugin in the extensions folder on the server and also downloaded and installed Java. In the admin console I see the server sees the plugin but it says Not Loaded under Plug-In Name (not sure if that is normal). With the database open on my FMP client machine I try to run the script which checks for emails and I don't see it working. I believe the registration details for my plugin license are at the beginning of the script that I tried to run. Also when I try to setup a schedule to run this script every 2 Minutes it won't let me create the schedule saying there are no available scrips for the given user account that I am trying to assign within the schedule. After it gives me the message that no scripts are available the FMSE fails and quits. Does any of this ring any bells as to what the issue is? Thank you for your time.
  15. Thank you both for all your help. It was the Java issue. I followed the link you sent, thank you, and restarted the server and everything is working great. Thank you Chris
  16. Thank you Agnes and Ryan!. I don't think I downloaded java 6, i think it was a different version. I will work on that now. The email plugin has been working great both locally in the file and also on the shared server that I was on. The people over at Point In Space were awesome in getting things up and running on the shared server. Now that I am on a dedicated server I am trying to do it myself. I think the register script step is definitely in the several scripts that run on the schedule so I don't think that is an issue here. I'll get back to everyone shortly. Thanks Chris
  17. Hello. I have a few databases for fire departments and in a Personnel Table I have a "Date of Hire" field. I then uses a calculation to get their Years of service and display it as Years, Months, Days. My question is: some members take a leave of absence or go inactive. I'm not sure how to approach subtracting a leave of absence start and end date or set a field with a date they they went inactive and then their Years of service would calculate up until that date and not the current date. Thank you for your time. Chris. Sent from my iPad using Tapatalk
  18. Thank you very much for your input. I'll try that new calculation for when a member goes 'inactive'. As for the leave of absence. Maybe I should just build into the Personnel Records table maybe 5 Start and 5 End dates for a person to take a leave of absence. I know it isn't very clean and neat but I could add up the days of leave and then subtract them from the date of hire calculation. Here is the calculation field I have been using so far and how it is displayed based on the Get Current Date calculation. Thanks, Chris
  19. Cancel That. I had a dumb moment and forgot the ( & ) symbols in the calculation for the script parameter. Thank you. Chris
  20. Hi, I tried a few things and I almost got it working, minus the container thing. The township script is triggering the new record script in the Mutual Aid database. The Mutual Aid Database is seeing the scrip parameter that I set but it isn't setting the fields with the values from the Township Database, it is setting the filed with what is actually typed in the scrip parameter calculation. How do I get the value in the fields to become the values in the scrip parameter? Thank You!. Chris
  21. Thank you very much. I'm going to try that now. One thing I forgot, and was hoping I would have the ability to pass a pdf in a container field in the Township DB into a container field in the Mutual Aid DB. Can I do that via a scrip parameter? Thanks, Chris
  22. Hello, I started a database for a volunteer fire department back in 2012 and they have been storing preplan data for individual addresses since they started using a field "Address/Location". They are now going to align themselves with the format that the Police department is currently using which has separates fields for the address number and the address street. I have created two fields "AddressNumber" and "AddressStreet" and thing a replace field contents step is what I want with a calculation to pull the relevant data into the new field. I'm having trouble with the calculations to pull just the address number into the first field and just the address street into the second field. There is no common separator like a ( - ) or anything that separates the address number and the street name. The only thing is a "Space" Anyone have a solution to do this. They have almost 10,000 address records to doing it manually isn't my favorite option. Thank you in advance for your time. Chris
  23. Comment, Thank you so much, that worked perfectly!! I really appreciate it. Chris.
  24. Hello, Thank you very much for the fast reply. I was very new to Filemaker when I made the original field names. I have since renamed the address field to "AddressOld" The table is "PrePlan" 1000 Wyckoff Avenue 130 Storms Drive 131 Fardale Avenue 15 Whitney Road 274 Campgaw Road 6000 Rio Vista Drive 1 GREAT HALL ROAD We have 5 records that have a ( - ) in the address, like this. I can do these manually if needed. 1-21 FRANKLIN TURNPIKE Thank you!. Chris
  25. Hello, 2nd post here on the forum, thanks to everyone for their help! I have a few databases for local fire departments and they all reference their incident reports with an incident number. They like to have this number start at 1 on January 1st and restart at 1 each year. I have a field (incidentYear) that auto enters the year of the incident. I also have a field (IncidentNumber) which the departments enter manually. The number starts at 001 and they manually increment up 1 number for each call. The IncidentYear field and IncidentNumber field are then combined in a calculation (IncidentNumberDisplay) field so we can sort, reference, and search for them later. My question is how do a write a script that will look for the count of calls already created that year and generate a new record with the next number? This is all being used on ipads so a processing heavy script that will be slow to calculate is something I am trying to avoid. I tried using the auto enter serial number feature but that doesn't reset in January and it doesn't take into account people that create a call in error and then delete it. Any help you can offer would be amazing. Thanks Chris