Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

2 Neutral

About wattmhite

  • Rank
  1. If using the week number function to define a field, is there a way to get the first date of week 25 (for example) and last date of week 26. I'm using this for payroll so I can show on the pay slip for weeks 25 and 26 include dates June 19th - July 2nd.
  2. I have a time table and every time an employee logs into filemaker a record is created, the field Time In is set to get current time, date is set to get current date, account name is set, the record is given a record number and an $$variable record number is created. When the user exits filemaker a script is run: to to time layout, enter find mode, set field $$variable, find record, set Time Out field as Get Current time. This creates the time in and time out record overtime an employee uses our system and I have a time field that calculated time out - time in = time elapsed. Every day an employee will typically have 2 records, morning time in, time out for lunch. A new record when back from lunch and time out for the day. How can I create a calculation that finds both of these records for each account name and adds the time elapsed together so I can create a layout saying Monday Account #1 worked a total of 8 hours, Tuesday 7.5 hours, etc etc.
  3. Thank you!

    I'm not sure which topic this belongs in but... I really just wanted to let everyone on these forums know how thankful I am for your support, advice and guidance. Over the past few years as my small business has grown into a bigger business I've needed filemaker to do more advanced things and as I am not a developer and simply a business owner, I've turned to these forums and to you all and I couldn't have built my database without your help. From the bottom of my heart thank you so much!! Matt
  4. I have 2 fields, time in and time out that are filled in when a user clocks in or clocks out. I'm trying to create a 3rd field that calculates the lapsed time. If there is no end time then the field should (get current time) so these hours are calculated on the fly. Here is my field calculation so far: Case( Time Out; Time Out - Time In; IsEmpty (Time Out); Get( CurrentTime ) - Time In )
  5. There may be a simple solution to this but I can't think of one. I have a field that calculated total hours for the day. How can I have a field show any time over 8 hours for that day? Thanks
  6. I have 3 different time fields and each have a corresponding time summary field which summarize total hours for the week. How do I summarize all 3 fields so it shows the hours correctly?
  7. Cannot Connect to Server

    Hi All, I have filmmaker server 15 deployed at my office with high speed TWC Static IP address. I've opened up all the ports per filmmaker instructions but I cannot connect from my home network and all of my 8 employees on their own home networks cannot connect either. Any thoughts or possible solutions to try? Thank you!
  8. I'm trying to hide a tab from all but the following users, Matt, Haley and Kristen. I'm trying to use the hide object when- (Get ( AccountName ) ≠ "matt") or (Get ( AccountName ) ≠ "haley") or (Get ( AccountName ) ≠ "kristen") but its not showing even to me at the moment. Any idea what I am doing wrong or a better way to go about this? Thanks
  9. I'm looking to create a calculation field that takes the field 6 Total Premium and if that field is between 0 and 2,501 then calculates field Financed Monthly Amount by 1.06032941. If 6 Total Premium = 2,501 to 5,000 then calculate by a different amount, etc etc. What is the best way to accomplish this, I started setting up the calc below but it will not work. Thank you so much! If ((${6 Total Premium} > 0) and (${6 Total Premium} < 2501)) ; Financed Monthly Amount * 1.06032941
  10. I have a main table and a separate table called the checklist which has 7 different people, each with their own checklist. I'm trying to create a little red number (like the red email number on the bottom of the Mac dock) that shows in real time the number of checklist items for each user in the main table. Is this at all possible without slowing down the system?
  11. List by record viewed

    I currently have a few fields that automatically enter the date, time and user when a file is modified. The problem is that when a file is not modified and simply viewed it doesn't show up on the list. Is there a way to auto enter this information when a record is viewed only? Thanks
  12. my table is currently sorted with: year (get(currentdate)) so every section breaks down my accounts by year (2016, then 2015 then 2014) So I'm trying to have 2 sections in my table, the top section is all current year accounts, the next section is all other accounts 2015-2000 all lumped together (not in sections)
  13. I have a date field and I'm currently sorting all of my records by year is 2016 then 2015 then 2014 then etc etc. I would like to sort this by current year i.e. 2016) then all other records 2015, 2014, 2013 together. What is the best way to accomplish this? Thanks
  14. Export XML Formatting

    I'm trying to export my records data in a specific XML format. What is the best way to do this, configure a layout in the way I would like the data exported or? Please see pictures - thanks!
  15. I'm aware of filemaker being able to pull data from a specific website but is there a way for filmmaker to also input into fields on a specific website and interact with buttons within a script? Thank You Matt

Important Information

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