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

2,924 profile views
  1. Matthew R White

    Calculation field for first row of table

    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?
  2. Is there a way to calculate only the first row of a table? thank you in advance
  3. Matthew R White

    fmp17 RingCentral RC2FM DEveloper

    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!
  4. 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
  5. 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?
  6. 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!
  7. Matthew R White

    Remote server and sync?

    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
  8. 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
  9. 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
  10. 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!
  11. Matthew R White

    Customer Menu - values from field

    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!
  12. 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
  13. Is there a script step to send a message to another filemaker user thats currently logged in? Thanks! Matt
  14. I'm trying to set up a button bar that displays the current months names based on the following Current month Last month Next Month I can use Month (Get(current date)) - 1 (for example) but I get a number of 2 for february or 1 for january If I use Monthname (Get (Currentdate) - 1 my result is (-1) Thanks in advance, thanks!
  15. Matthew R White

    Hide Tab Control and Hide Fields

    First, I have a tab control with 3 tabs, I would like to use the Hide If feature to hide certain tabs depending on certain conditions. When I try this it hides the whole tab control (with all 3 tabs) and I'm looking to do this individually, is this at all possible? Second, I have quite a few fields that I need to have on my layout for calculations and scripts but I don't want users to see these. What is the best way to keep the fields on a layout but hide them from users? Thanks!

Important Information

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