Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About john9210

  • Rank
  • Birthday 04/03/1935

Profile Information

  • Gender
  • Location
    Audubon PA

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I finally figured it out. the end time field must be formatted as Short System Time in Inspector. I never knew what that was for before.
  2. A simple problem: I want to add a number to a time and get the end time to express AM or PM. For example: Start time = 10:00AM Duration = 3 hours End time = should be 1:00PM I can't figure out how to make this work.
  3. In the script pane I can't drag a folder to a new position. Any suggestion on why this is happening and how to fix it?
  4. I’m trying to get the average value of a field on a found set. But it’s not working. Cost is a number field and I use the following script steps to get the average value. Perform Find $$Avg=Average ( BGL::Cost ) But the resulting value is incorrect. Am I missing something. I assume Average works on the found set.
  5. I'd like to remove unused value lists. If the Database Design Report indicates that a value list does not appear on any layout does that mean it is not used and therefore I can safely delete it?
  6. Even when the field is indexed, the value list does not insert values on new records. Strange! I'm using the "All" option for indexing.
  7. Nope, I forgot it. It now works like a charm. Thanks for all your help. You're working pretty early in the morning aren't you? John
  8. It still doesn't work. Script debugger and DataViewer show that $sp is set correctly in the parent script, however it is blank in the child script so the correct step does not execute. In other words the parameter is not passed to the the other file.
  9. Te attached file shows the scripts I am using.Parent and child file scripts.docx
  10. I want to run a script in the other file, depending on the value of a parameter.
  11. How can I pass a script parameter to a scrip in another file. I want to be able to run a script in asecond file based on the script parameter used in a first file. Or, is there a better way to do this instead of using script parameters?
  12. I’m trying to enter values from a value list based on a calculation field. Specialists::ActiveSpecialists is an unstored text calculation field. The value list ActiveSpecialists reads values from this calculation field. On a new records layout the VL is attached to the Prescriptions::Specialist text field so I can select a name from a drop down list. However, on newly created records, when I select a name, it does not enter into the field. The field remains blank. The source table for the new record layout is Prescriptions. How can I get the VL to work? Upda
  13. How can I print field boundaries? I want to print boundaries on some fields for emphasis.
  14. Why setup a default printer? It seems that every time you print within a script the default changes to the one in the print step.
  • Create New...

Important Information

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