Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Answers last won the day on October 6 2015

Answers had the most liked content!

Community Reputation

1 Neutral

About Answers

  • Rank
  • Birthday 07/26/1965

Profile Information

  • Gender

Recent Profile Visitors

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

  1. I did look at the VL and download some sample files. And yes a lot to digest and I totally get the head banging, trying to decide the best solution to the problem and for me at times hesitant because it is a lot to digest! I think you are right, the VL is the right way to go and I like the web viewer idea with a popover button. I will make the time, this customer I've been working with really loves their database (they did everything manually 18 months ago) and so it has been a real time saver. So the extra effort is well worth it... In the mean time I made tab panels on the property layout with each tab being an appliance 1, 2,3 etc.. filtered an inspections portal and the estimates portal on each per appliance number pertaining to that tab. This buys me time. Next I'm going to tackle the VL so they can have their information compiled. Thank you so much for pointing me in the right direction.
  2. Hey Steve, I was wondering if you would have some insight. How are you? I'll explain better ('splain it to me Lucy, LOL) So the customer id is actually a property location (there could be more than one owner of a property over time, that is taken care of). So one property location can have many inspections and estimates. And one property could have more than one appliance (we are talking fireplaces and chimneys, the great northeast, you hear me). Previously everything was "driven" by customer id but easy enough to turn it into a property id. And to answer a question you had, the estimate turns into an invoice but not in Filemaker by sending the total amount to quickbooks, basically posting totals. Filemaker creates a work order, contract and the details. The hierarchy is, Property address- appliance- estimates and inspections.1- many-many. Fireplace 1 could have an inspection and estimate every year. Fireplace 2 as well. Hence, I could search by the property address and appliance (i.e. living room fireplace) and see the history of the inspections and estimates. And right now I could search by property and appliance, but they would like a neat orderly format that doesn't require a search. Perhaps I need to create a table with appliance & property, (I had some ideas)...... no still the same problem listing all estimates & inspections (since they are in 2 tables, am I wrong?) Okay enough babbling and thinking out loud. I will check out the link you sent. And you are correct, there will be no flattening this file, there are much more pieces to this puzzle.
  3. I have a database that has the tables customers, estimates and inspections. (there are other tables as well) Anyway i currently have a layout per customer which has two portals, one that displays the estimates per customer, one that displays the inspections.When you click on one it takes you to the details of that "form". It works nicely but now they want to see one portal with the estimates & inspections listed in one portal. I thought what I would need is a join table but somehow I have become baffled. All three tables have the customer id. Inspections & Estimates have appliance ids as well. The end result is to view by customer all of the estimates and inspections per appliance id. I can make a sub summary report but they would like: Customer Appliance 123 Inspection Estimate Any suggestions would be greatly appreciated. I might need to be more descriptive. Caroline
  4. Thank you for replying to my topic. I got sidetracked with other issues. So whats getting slow is Picasa and the NAS. So we are looking for a central location for the photos, and that it's easy enough to edit (annotations, light edits) And correct they are basically taking the edited photos to upload some into FileMaker. As simple a a drag and drop. The customer does fireplaces and chimneys so the images are used to guide the technicians and also for before and after history.
  5. I have a customer that has 3TB of photos in the program Picasa. They use it to edit images and then put some in Filemaker. Currently the images are on a NAS. The problem is it seems to be getting slower and slower. Picasa is discounted so I'm looking for a replacement that can handle the large amount of images they take on the job site and interact with Filemaker, seamlessly. they run on a windows platform but would like to perhaps introduce iPads to the mix in the future. Not sure if this is the right place to post this question but I thought I'd give it a go. Any guidance on the matter would be greatly appreciated.
  6. Solution at last! Anyway this is what I put in my web viewer object, "https://safer.fmcsa.dot.gov/query.asp?searchtype=ANY&query_type=queryCarrierSnapshot&query_param=MC_MX&query_string="&CARRIERS::MC#
  7. Hi Steve, Yes you were correct, pass a value from our database to the web form. Thank you so much for your reply. I'm going to try it right now! Caroline
  8. This seems like a fairly simple problem,. perhaps I am missing something. I previously had a web object on a layout that would grab information from 2 fields, so the result of the search would be displayed for that record. The web address I used before in my web viewer: Case( CARRIERS::MC# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=MC&n_docketno="&CARRIERS::MC# &"&s_legalname=&s_dbaname=&s_state=~~&pv_vpath=LIVIEW "; CARRIERS::FF# > ""; "http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist?n_dotno=&s_prefix=FF&n_docketno="&CARRIERS::FF# &"&s_legalname=&s_dbaname=&s_state=~~&pv_vpath=LIVIEW ") Now the website has changed and I can't seem to have it grab the information to display in the record..The website is: "https://safer.fmcsa.dot.gov/CompanySnapshot.aspx" and basically I want it to fill in the MC#, I've tried using the method I used before. I viewed the source of the website but cannot seem to figure out the correct syntax. Any help would be greatly appreciated.
  9. We have had Filemaker 15 Server up and running of while but when we originally installed it was installed on port 444 (because of our router configuration). We wanted to reinstall using port 443. So I uninstalled per instructions, uninstalling, bonjour, microsoft items, java etc... Rebooted our Windows Server 2012. Ran installer and got the error message the port 443 was not open. Rand netstat -a -o from command prompt, it said Filemaker 14/ on port 443 was listening (PID 768 and 4), So used skill to kill the PID. Rebooted, still unable to install Filemaker 15, port not open. Then went into diagnostic mode, started the installer service. Installed successfully but then could not launch Filemaker server, could not even change firewall settings. So now we are restoring the server to the image backup. Would like to uninstall and reinstall again tomorrow using port 443, any hints or tips on what to check before an uninstall and reinstall. Any help would be greatly appreciated. I would call FM tech support but they are not available on the weekends.
  10. In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens). The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.
  11. An update. The only problem with my PDF solution is it makes for very large PDFs and that would present a problem with email. After a month of tweaking, now I realize the size problem. Any ideas or suggestions? Thank you!
  12. I could have sworn I replied to this.... so that was the idea I needed to finish my script for pdfs in a runtime. I put the landscape and portrait container fields on top of each other on one layout. And I put Hide when Page field ="Landscape" on the Portrait container, and Hide when Page field ="Portrait" on the Landscape container. So it grabs (copies and pastes) the different layouts from different tables (of course there are some loops to grab the multiple pages etc...) The end result is one complete report that can be sent to a pdf driver in runtime. Works quite nicely. Then it deletes all the records in the container table. So thank you everyone for your ideas and help. It's a work around but it gets the job down. Wahoo! Caroline
  13. So I wrote a script to go to each print layout, preview, copy and paste in the related containers, then print records being browsed where the enduser would need to choose a pdf printer driver. It's working quite nicely but.... I'd like the portrait and landscape layouts to be combined, is there any way a layout in filemaker can contain two different orientations I have specified a portrait layout and landscape, with a field that contains which type of layout it should print on. Any ideas? I attached my script. PDF Bundle script.pdf
  14. I am familiar with the virtual list technique, I hadn't thought of that option, perhaps that is an option, I'm sure though the PDFs are needed for email etc... If I'm missing something please advise.
  15. I suppose one way is a subscription to Filemaker (I saw it online before, that way the annual cost isn't too great). I did try to be creative, I created a table with fields for Job No and a container field. I created a relationships from the multiple tables using X operator (cartesian sp?). I wrote a script to go to each print layout, preview, copy and paste in the related containers, then print records being browsed where the enduser would need to choose a pdf printer driver to then save. Seems a tad convoluted but it would create a full report. I have not finished the script because it was tedious and I felt fried (know that feeling everyone?) :-) I really appreciate the feedback, any other ideas?
  • Create New...

Important Information

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