Jump to content

Gogargirl

Members
  • Content Count

    146
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Gogargirl

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. OK - thanks Comment. I like your suggestion in the last paragraph and will give it a go.
  2. Thanks for your help Comment! I think I've misled you, as I don’t need this task to conform to good accounting practice; it is for a history research project and I was trying to simplify my query to understand the basic calculations I would need. In fact the ‘stock items’ are historical commodities and items bought at various prices, currencies and tax rates in the 18th and 19th centuries. I therefore do not want to have variables auto-entered as the records are created – because the records already exist. I want the tax rate - or maybe the currency exchange rate, or anything else I may think of - to change depending on the date in the date field. Can this be done please?
  3. This must be so simple, but I cannot work it out or find the answer! Using Filemaker 14. I have an old db in which my records are stock items. I currently have a number field showing the price net of tax (PRICE_NET) and a calculation field (PRICE_INC) which shows the price including tax at 10%, using the calculation PRICE_NET * 1.10. I also have a date field (DATE) showing when the item was acquired. Let’s say the tax increased to 15% at the beginning of this year. I therefore want to change the calculation in PRICE_INC so that it displays the net price + 10% if the date in the DATE field falls before 01/01/2016, and the net price + 15% if the date in the DATE field falls after 01/01/2016. Assuming there may be another tax rise in the future, I would want to modify the calculation to include the date range when the tax stood at 15%. How do I do this please? I want the prices to be always visible – so no scripts please – and I do not want to do this with look-ups.
  4. Gogargirl

    Pause/Resume won't continue

    By 'just press enter' I mean return - and this always worked on earlier versions, though I'm not sure on FM11, as the solution was mothballed at that time. IdeaData - you're right, it does work with Ctrl+return (or non numeric enter as above) - I just find that clunky.... Thanks for your help!
  5. Gogargirl

    Pause/Resume won't continue

    Thanks Vaughan - The script prints a layout which is a map of a dining room with up to 100 tables. The pause allows the user to select which table to 'mark' in the print-out and also shows who is sitting at that table. A typical work environment for the user is a garret not far from the dining room. They need to e.g. print a new place card for a diner and a runner then takes the print-out and seamlessly puts the new place card in the right place on the right table. There is usually huge time pressure - literally it needs to be done in minutes - and usually they are using a laptop without a numeric keypad. The big button will definitely work, but it's a shame the answer is another step removed from the old 'just press enter'. It always worked before with 'return' rather than numeric keypad enter. Still, it just shows how amazingly varied the uses for FM are.
  6. Hi friends - Back here again after many years to ask some of your first-class advice please.... I have a very old solution which I recently converted from fp7 (can't even remember which version I originally created it on) to FM12 and am checking performance. Windows Vista on a trusty old Dell laptop. There is a script triggered by a button, which pauses indefinitely for user input. Many moons ago, the script would resume when the user pressed Enter on the keyboard. Now, it will only resume if the user either 1) clicks on 'continue' in the status toolbar, or 2) presses Ctrl + Enter 3) clicks out of the field, then presses Enter So if I have the button on a layout which does not show the status toolbar, the only option I can see to get the script to continue is to train the user in method (2) or (3), both of which are clunky and not really what you would expect to have to do. I can see users clicking anything and everything in frustration.... What happened to plain old 'Enter'? This is from the FM help file: "Select 'Indefinitely' to pause the script until the user clicks Continue (a button created by FileMaker Pro in the status toolbar) or presses Enter" Hmm......sorry, but just 'Enter' doesn't work. I'm guessing that this is because the data the user inputs needs to be committed before the script will continue. So the user has to click out of the field to commit the data and then Enter to continue the script. Is there any way to neaten this up please?
  7. Gogargirl

    Disappearing Data

    Thanks everyone for sticking with this! 1. The user's hard drive search showed the 3 related files in the solution I sent him and the 58 sample files that come with the FM6 app. None of the solution files happened to have the same name as any of the sample files. 2. I got the user's files back, but I can't get them to misbehave. 3. Likewise I don't have any problems with the files on FM 6 so far, but I'm still testing. 4. The user is reporting no font problems in any app. 5. All 3 files recovered with no problems. Just found out that Win XP SP2 contains a fix for "Programs That Run Correctly with Windows 2000 Do Not Run Correctly with Window XP" so will investigate this route. I hope it's not this as the user's corporate policy is not to install SP2 (speaks volumes, no?!)
  8. Gogargirl

    Disappearing Data

    Thanks everyone for sticking with this! 1. The user's hard drive search showed the 3 related files in the solution I sent him and the 58 sample files that come with the FM6 app. None of the solution files happened to have the same name as any of the sample files. 2. I got the user's files back, but I can't get them to misbehave. 3. Likewise I don't have any problems with the files on FM 6 so far, but I'm still testing. 4. The user is reporting no font problems in any app. 5. All 3 files recovered with no problems. Just found out that Win XP SP2 contains a fix for "Programs That Run Correctly with Windows 2000 Do Not Run Correctly with Window XP" so will investigate this route. I hope it's not this as the user's corporate policy is not to install SP2 (speaks volumes, no?!)
  9. Gogargirl

    Disappearing Data

    Thanks everyone for sticking with this! 1. The user's hard drive search showed the 3 related files in the solution I sent him and the 58 sample files that come with the FM6 app. None of the solution files happened to have the same name as any of the sample files. 2. I got the user's files back, but I can't get them to misbehave. 3. Likewise I don't have any problems with the files on FM 6 so far, but I'm still testing. 4. The user is reporting no font problems in any app. 5. All 3 files recovered with no problems. Just found out that Win XP SP2 contains a fix for "Programs That Run Correctly with Windows 2000 Do Not Run Correctly with Window XP" so will investigate this route. I hope it's not this as the user's corporate policy is not to install SP2 (speaks volumes, no?!)
  10. Gogargirl

    Disappearing Data

    Thanks Vaughan, but they insist that they don't. Even if they did, data has disappeared from a field that was already populated when they initially received the file. So the user cannot be looking at a copy file without data. Guess I'm looking at file corruption or maybe the user on Win XP SP1 has a font corruption?
  11. Gogargirl

    Disappearing Data

    Thanks Vaughan, but they insist that they don't. Even if they did, data has disappeared from a field that was already populated when they initially received the file. So the user cannot be looking at a copy file without data. Guess I'm looking at file corruption or maybe the user on Win XP SP1 has a font corruption?
  12. Gogargirl

    Disappearing Data

    Thanks Vaughan, but they insist that they don't. Even if they did, data has disappeared from a field that was already populated when they initially received the file. So the user cannot be looking at a copy file without data. Guess I'm looking at file corruption or maybe the user on Win XP SP1 has a font corruption?
  13. Gogargirl

    Disappearing Data

    Sorry Vaughan, but I don't get your point. Client = business client. I email him zipped files that he upzips to his hard-drive. Most of the time he's working on a laptop which is not attached to a network. How can that be a problem?
  14. Gogargirl

    Disappearing Data

    Sorry Vaughan, but I don't get your point. Client = business client. I email him zipped files that he upzips to his hard-drive. Most of the time he's working on a laptop which is not attached to a network. How can that be a problem?
  15. Gogargirl

    Disappearing Data

    Sorry Vaughan, but I don't get your point. Client = business client. I email him zipped files that he upzips to his hard-drive. Most of the time he's working on a laptop which is not attached to a network. How can that be a problem?
×

Important Information

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