Jump to content

Matthew R White

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Matthew R White

  • Rank
  • Birthday 04/08/1986

Profile Information

  • Gender
  • Location
    Corona, Ca

Recent Profile Visitors

3,174 profile views
  1. I am looking for some help in trying to help calculate the difference. I have 3 time summary fields that summarize hours worked in a sub summary. IE Regular hours worked 36:08:00 and overtime worked 4:00:00 I tried creating a calculation field to add these together but I just get a huge number and no actually an hours breakout. Any thoughts would be greatly appreciated. Thank you!
  2. I'm using the following function to pull text from a text field. The text is about 30-40 lines long. How do I text parse until the end of the text? I tried using "" as the end suffix but I am now returning nothing. Thank you Let ( [ Textfield = BWIA2 FMP11 2::Web Quote Entry Hangar ; prefix = "comments:" ; suffix = "" ; start = Position ( Textfield ; prefix ; 1 ; 1 ) + Length ( prefix ) ; end = Position ( Textfield ; suffix ; start ; 1 ) ] ; Middle ( Textfield ; start ; end - start ) )
  3. Hi All, I have a main table and a secondary table called users. They share a field called Producer number. Within the main table, which contains thousands of customer files, each customer has an assigned producer number. Within the users table, all of our producers (9) have individual records and are numbered 1-9. I'm looking to create a script for our new business website leads that when a new quote request email comes in, filemaker can sequentially assign web quotes based on the day. So, for example, the first quote request would go to producer 1, the script would then check how many quote requests each producer has received for the day and distribute evenly, making sure each producer gets an even number of quote requests each day. The reason for the script to search and make sure the numbers assigned are equal, is because we can have up to 3 users entering web quotes at the same time. So as the quotes are entered, the total assigned needs to be searched and updated/checked and compared in real time. I'm thinking some kind of loop script is the best way to accomplish this, any tips or ideas as to the best way to get this done? I guess I can create a loop that goes to each user in the user layout, checks how many have been assigned to that user, then sorts by least assigned for the day and sets that producer number as who the quote request goes to. Thank you!
  4. I have a table called Premiums and the initial premium is always the first created record in this table. Throughout the year more records are added to this table as premium is subtracted or added. I’m looking to summarize the initial premium in the first row for all my records to show total initial premiums Does this make more sense?
  5. Is there a way to calculate only the first row of a table? thank you in advance
  6. I'm not sure which section this goes under. I need help integrating RC2FM with my filemaker database. I'm looking to hire a developer. Any recommendations? Thank you!
  7. I have a table with over 100,000 records and I'm trying to show the top 5 accounts by premium for each month in a portal. One way of doing this is to create a portal and then filter the portals by premium size (so I get the top 5 at the top of the portal) and then filter or show only the top 5 records I'm just worried that with the amount of data, every time this portal loads it will take significant calculations. Is there a better way to store this or create another table to keep the usability quick for my users? Thank you in advance
  8. I have a table with a field that's called Premium and another field that summarizes the premium field. In the premium field we have premium amounts and negative premium amounts. Is there a way to create a calculation field that only counts the positives?
  9. Hi everyone, thank you in advance for your help and support! I have a field called Total Premium and over 10,000 customer records in my database. I use a card layout as a "Dashboard/Summary" to show sales and other data for the month. Currently my script is as follows, new layout/card, enter find mode, find records with dates for this month. perform find. At this point for about 12-15 seconds filemaker is spinning in the background summarizing the Summary:Total Premium Field and then the data is displayed perfectly. Is there a better/quick way to calculate and store this data on the fly, perhaps on the server or in a table that makes this summary screen faster to load? Also, does anyone know of an article or post that's dedicated to what slows databases down and how to optimize your database? I am opening up a branch office in Alaska next year and if loading this dashboard takes 12-15 seconds while connected on wifi to the server, it will take many minutes logging in remotely from my team in Alaska Thank you!
  10. Hi all, I currently have a database hosted with an iMac/FileMaker server and I have about 11 computers that connect via the network daily and then from home using the IP address. Our database is filled with tons of conditional formatting and thousands of pdf’s. FileMaker at home is usable but a lot slower than using it on the network in our office. I am opening up a brand office in Alaska next year and it will be staffed with 5-10 employees and I need them connected to my database. My current plan is to have them all connect to the IP and use our single server, but I’m afraid it will be very slow and impact productivity. Should I set up a second server in our branch office and sync them or what is the best options for this setup? Thank you
  11. I'm trying to create a calculation field that calculates time and days it took to quote. I have record created date and record created time fields and then record quoted date and record quoted time fields. I'm hoping to have a field that shows average time to quote 3 days, 34 minutes Anyone have experience on something like this? Thank you
  12. I currently have a button that exports the current record in excel format on my Mac desktop. When I use Filemaker go on my iPad this button does nothing. Ideally I would like that button to recognize the iPad as the device being used and create a script to export to iCloud desktop Is this even possible? Thanks
  13. I have a table with the field Producer Number. This table has about 10 records each with a different producer number 1-10 and these numbers change daily. Some days it will have numbers 4, 5, 6, 7. Other days it will have 1, 2, 5, 6. Etc. I'm trying find a way to to set a field when entering a layout to a random number within this field so when 4, 5, 6, 7 numbers are entered in the field a random number from that set will be selected and entered into the field. Further, is there a way to use this field or value set from my table and enter these numbers sequentially? Please let me know if I wasn't specific enough. Thank you!
  14. I have a major table that I'm trying to integrate into a drop down menu option - get values from field but I need some help with this... The table has 3 fields, Year, Make and Model (Aircraft), so the values look like 1990 Cessna 180, 1990 Cessna 190, 1997 cessna 150, etc etc I'm trying to create a drop down wherein the user first selects the year (menu items calculated from the year field) then once a year is selected, only those makes from that year are shown, then model, only those models from that make is shown. Any suggestions greatly appreciated, thanks!
  15. I've deployed filemaker server 15 and when I'm offsite (at home) i can connect to my filemaker database when my iPhone is on wifi only, once I switch to LTE the server disappears or loses connection. Any thoughts or suggestions on this? Thank you!!! Matt
  • Create New...

Important Information

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