• Content count

  • Joined

  • Last visited

Everything posted by CKonash

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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.
  6. 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
  7. 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
  8. 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
  9. Cancel That. I had a dumb moment and forgot the ( & ) symbols in the calculation for the script parameter. Thank you. Chris
  10. 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
  11. 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
  12. Comment, Thank you so much, that worked perfectly!! I really appreciate it. Chris.
  13. 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
  14. 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
  15. 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
  16. Thanks everyone. Ralph, I installed all the items you mentioned and made the relationships. Everything is working well with it auto generating the incremental incident number however, sometime pretty regularly it will skip a number. Any ideas what might case that? Thanks Chris
  17. Hello, I am not a developer so excuse me for asking something that might seem simple. I manage a filemaker database for a fire department. There are many tables but the ones I am referring to are "Incident Reports" and "Pre Plans" Chiefs or firefighters enter the address of an incident into a new record in "Incident Reports". On that layout is a button that will take the address and perform a find for that address in the "Pre Plan" table and tell you if that address has a record. In Pre Plans we store address specific info like electric shutoff and other things. My question is: How do I get the button on the "Incident Report" To change color after someone enters an address? I would like it to be RED if there is no related record and Green if there is a record present for that address. I already have a relationship linking IncidentReport::Address to PrePlan::Address. Thank you for your time!. Chris
  18. Hi All. I did the TrimALL field replacement on the PrePlan Address Records, Incident Report Address Records, and out Street List value list (to fix future problems) and everything is working AWESOME. Thank you so much for your experience and help!. There must have been extra spaces everywhere which was breaking the relationships... I would never have figured that out without your help!. Thanks Again!. Chris
  19. Hi, Thanks everyone for their comments and experience. I would love for every address that will be used on an Incident report to already be in a list somewhere however we have new addresses pop up all the time and our calls for service very often reach outside of our town, county, and state so there is just no way for us to gather all those addresses and maintain a correct database. We have decided to do what we can to make our own townships addresses our priority and having them exported from the Tax dept was the easiest way to get a good capture of each and every address. You both bring up very valid points and I may see if the Police department can give us the same full export from their dispatch system of each address, but that would would carry a unique ID with each address record. That might be a better way to do this. But yes the simple colored button was an easy way for a chief officer on the scene of a call to see if there was a Preplan record that matched that address. the button could still be pushed to trigger the find script but then you would simply get "no records found". One more thing is I have the button do a search for the numeric and street address only. Since some of our commercial businesses all operate under the same address using the "Colored Button" I have a layout "list view" of all the addresses that match that and then it lists the suite or unit number. This way the commanding officer of an incident can search an address and see all the associated business inside that address and then they each have their own PrePlan record under that same address. Not sure if that made sense or not. Sorry. Thanks Chris
  20. Awesome. Thank you very much! Sent from my iPhone using Tapatalk
  21. Thank you. A way we are trying to control data input is to have people filling out incident reports manually to pull all the street names from a value list instead of them typing it in manually. I will play with the formatting with the 'trim' Calc a little later tonight. Hopefully we can figure out a way to get the button that finds the related preplan to change from red to green if there is a related record present for that address. Thanks agin for all the help. Sent from my iPhone using Tapatalk
  22. Thank you LaRetta. I wish I could relate the addresses in the two different tables via a unique ID. Unfortunately here's why not. The Preplans were created with an excel export from our township tax dept, now we have a preplan record for each taxable address in our town, 10,000ish records. The Incident Reports are populated from an email that is pushed out from our police dept computer system with there is a call. The email is parsed out using a script and 360works that I paid a developer to help me with. I have no control over the police computer system and therefore can't get a unique address ID from them for each call to join as a relationship to our preplans. So unless I'm not approaching it in the correct manner I don't really see a way to relate the records except for the address itself. I'll backup the database when I get home and try the replace "trim" Calc and see where that gets me. Thanks everyone for your help! Sent from my iPhone using Tapatalk
  23. Thank you for the replies. I entered that formula into the conditional formatting area of the button that runs the script to perform the find in the PrePlan records. I see the button changing colors as I scroll through the data records in the Incident Report Records, however there is no rhyme or reason to when it changes. Its "Red" on incident reports with addresses that definitely have preplans already and it's green most of the other times. I wonder if it's the type of relationship since it's not a number key field or something. The relationship is a simple relationship of when one address directly matches the same address in the other table. Wouldn't an extra space in the address field in one table break the relationship?
  24. Hello, I am also receiving the following error "An error occurred: [ALERT] Please log in via your web browser: (Failure)" I have confirmed that the 2 step verification is OFF and ALLOW LESS SECURE APPS is ON. I had this working perfectly on two hosted databases on a server-side scheduled script. I had issues with that Host provider and just moved to a new provider and this is where the problem popped up and things do not work as it looks like Goggle is blocking the login attempts. Any ideas what I can do to make this work? Thanks Chris K.
  25. Hi,. First post here so sorry if I don't give enough info. I have a fire dept database I made and manage. In our Event Report table I have a Timestamp field for recording when fire incidents occurred. I also have an Attendance table used to record members attendance for each call, the Event report table and attendance table is replaced to the Event Report table. Normally when the scrip runs to create an attendance record for a member at a call it currently sets a field in the attendance record as "Incident". i need to modify the script set to Determine the time the call came in and set the field in the attendance record as "Incident Day" or "Incident Night" based on the Timestamp from the event report. Night incidents are 00:00-06:00 and 18:00-23:59:59 and Day incidents are 06:00-17:59:59 right now I have the event type field Auto enter as "Incident Day" and members entering attendance for a night event need to change the field to "Incident Night" via a drop down list. My goal is to remove the drop down list and set the event as Day or Night in the background. Is is this easy to do? Thank you you for your time. Chris.