Steve Martino

  • Content count

  • Joined

  • Last visited

  • Days Won


Steve Martino last won the day on July 22 2016

Steve Martino had the most liked content!

Community Reputation

10 Good

About Steve Martino

  • Rank
  • Birthday

Profile Information

  • Gender
  • Location
    Broomall, PA

Contact Methods

  • Yahoo

FIleMaker Profile

  • FM Application
    12 Advanced
  • Platform
    Windows 7
  • Skill Level

Recent Profile Visitors

3,388 profile views
  1. Whether the option is Preview or Publish, build the report and go to preview mode, pause the script. After the user clicks continue pop up a custom dialog with the choices. Whatever the user clicks will be the branch the script takes
  2. You can do it a few ways. One way is to do it in Word, copy/paste into a Filemaker field, and/or save the doc as a container (pdf). The other is to make a few layouts that are templates. Using the 'slide up' feature you can make them as long or as short as you want. I do this with customers where I made a table to send letters/emails/texts. After I build the body of the text, select the appropriate template, print/email letter, save a copy of the letter as PDF in a container. Mine is kinda clunky, as I am rebuilding in 15 (from 12) and plan to polish this part of the db with popovers and sliders. But their is an example of this floating around. If I find it I'll edit my post. Edit: This may help:
  3. You can simply put a button on the portal row, set the button to go to related record.
  4. Case( isempty (Table::Map); Table::Price;Table::Map-Table::Price )
  5. It would be easier for me to fix the script with a sample file, but I see a few problems. First may be structure. I wonder about Progress notes and Add on Progress notes being in separate tables. But that aside a few questions. If a Client has Progress notes, can I assume AON (add on notes) is set to 1 when there are add on notes in a related table? If so, how is it set, and do you even need to set this flag field. Also what happens after you print all of these records. Are you omitting them or marking them in a way that prevents them from reprinting when the client has more Progress Notes? I see you flipping back and forth between layouts when it may not be necessary. Are you only printing one client at a time? A simpler way may be to forget the flag field and check for related records in the Add on notes table. From the start I would first check for related records in an If statement, then set the client ID, then go to related records. This way if there are no related records, you don't enter the loop. Sort records instead of Sort Records by Field Then I would enter the loop and Print (save to PDF) the first Note. Then I would check for related records with an IF statement for Add on Progress Notes. If Add on Notes, you enter the inner loop and you go to related records, new window, to the proper layout, and print (append) each on of those, then close window. If No add on notes, you continue on outer loop, to next Notes related record.
  6. I think you want your layout based on weeks, sorted by week name. Then add fields for projects and customer. Much like an Invoice solutions where you base your reports on line items, and have fields usually merge fields for customer. Your boiler plate contract could be in a table or global table of contracts that you could lookup (or by calculation), much like when you look up and add a line item to the invoice. Then you can take the boilerplate, modify it, and save it into a container in your projects table, where you would keep contracts-change orders, additional work, etc. It's quite an involved database.
  7. Is this what you are looking for? Little confused about your description. If it's not, maybe mock up one on Excel. PrototypeModSM.fmp12
  8. I don't fully understand what you are doing, but it seems you are set up incorrectly. I think you should be more set up like an invoicing solutions where Receipt table equals a join table between Inventory and Student. Receipt represents 'line items', and adding inventory is like adding line items, by lookup or calculation. This could simply be a portal on the Students table. Then reporting would be easier.
  9. That's the usual reason. It helps me sometimes in layout mode to zoom in and select all to find those little outlined cast away parts.
  10. When you say it's not working, are you sorting on whatever field the second sub summary part is based on? So with 2 sub summary parts, your report would need to be sorted by both. The other thing to try, is instead of the second sub summary part, did you try a trailing grand summary part and put the field into that part?
  11. Are you printing the receipt from the student record? I would think you would use a script on the student layout that goes to the related records and constrains the found set to only show the 'Not Received' inventory items. You could probably follow the Invoices starter solution to see how they print a list of 'Unpaid' items.
  12. Is one sorted by unicode?
  13. Why would you need to export this to a new table? Seems incorrect to duplicate the data. I would think you could just create a report and a report layout. Find the records by date range, go to report layout and sort. The added advantage is if you ever have to correct some data, you don't have to find the report in the report table and delete, then create new report and save. If you had to do more analysis outside of FM (Excel for example), you could then script an export to Excel. You could also take the report, print to PDF and save it in a folder or save it in a container
  14. Break field is the field you are sorting on in your subsummary part