Beuwolf

Members
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Beuwolf

  • Rank
    newbie

Profile Information

  • Gender

FIleMaker Profile

  • FM Application
    14 Advanced
  • Platform
    Windows 10
  • Skill Level
    Novice
  1. Comment you are a legend
  2. If i do less than the customers min hours i need to change that in the file before i print the report.
  3. This report is the only one i use, i want to end up with a hosted database so i can use phone, ipad or computer to input data. I only work for one client on any given day due to the laws regarding driving. I think probably the easiest rout would be to use the repeating fields and manually change the hours as and when required
  4. This is the format that i have to post it to them in, on this week only one client but usually two or three each on different days
  5. I have to format the days worked into their accepted format, I am trying to get them to accept a table format with a ll the data in but at the moment they want it in mondays work in mondays slot etc etc. I think I have been to tied up in the formatting of the file rather than the mechanics behind the file which is why i have been running around in circles. Ive added a copy of the current file i use so you can see what i'm trying to do Thanks for all your help on this its appreciated 27-7 v4 Clone.fmp12
  6. Hi Comment, Ive checked it out I think the problem lies in that i do work for different clients but only create one final invoice for the week that goes to my agent, what i need to do is be able to use different clients on a daily basis in the same record. each client has differing hourly minimums so if client A has a 8 hour min then Client B has a 10 hour min etc. I'm beginning to understand why no one has done this before it seems to be a pain. Cheers Marc
  7. Thanks Comment I'll have a look Thanks again for your help on this Marc
  8. Hi Comment, Thanks for that I have tried both options and find that all unused repeats are auto filling withe the first value. I'm guessing I am doing something wrong here but have no clue as to what. I have also tried bringing the data into a lookup field with similar results. Dunno what is happening and going slightly cross eyed. Thanks
  9. Thanks for that and I'm getting closer to a solution it seems, I'm trying the extend option but to not real sucess, I have amended the calculation thus (Also changed the Min Hours to MinTIme) If (Hours Worked<customer::MinTime; (Extend (customer::MinTime)); Hours Worked) But even though the First argument and the last argument work the extend doesn't... Am i being completely primary school here and doing something so obvious I cant see it? Thanks for the help its been driving me nuts :-)
  10. Hi Guys, I have been searching for a solution to this for awhile now and would appreciate any insights you can offer up, here goes I have database to track and invoice my hours as a truck driver, I have two tables set up, 1. Work (Pic 1) 2. Customers (Pic 2) In the work table i have a calculation field called 'Hours Paid' with this calculation If (Hours Worked<10; "10.0"; Hours Worked) straight forward enough so far... I have recently added a new customer who pays a different min hours to my others so what i need to be able to do is check Hours worked against a field called 'customer::Min Hours' and if less than the 'customer::Min Hours' it will use the number in 'customer::Min Hours' but if more than the 'customer::Min Hours' field it will use the value in field 'Hours worked'. to make it more interesting the field 'Hours Worked' is a repeating field and when i have tried just linking in the forumla it gives me the correct data in the first repeat but text in the others..... Any Help would be greatly received
  11. Hi all I have a database prob that i cant get my head around it goes a bit like this...... I want to be able to add differing ammounts to a worksheet (and invoice) dependat on the day that the work is carried out..... if day one is a Fri then X ammount is displayed if day one is a SAt the a differnt x ammount etc etc Any ideas? Marc