Jump to content

doughemi

Members
  • Content count

    1,026
  • Joined

  • Last visited

  • Days Won

    36

doughemi last won the day on February 4

doughemi had the most liked content!

Community Reputation

90 Excellent

About doughemi

  • Rank
    lifetime learner

Profile Information

  • Gender
    Male

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    OS X 10.12.6 Sierra

FileMaker Partner

  • Membership
    FileMaker TechNet

Recent Profile Visitors

9,646 profile views
  1. doughemi

    getting started FM on the web

    You have to access the database twice: once to download the list of available colors (before displaying it in html or a php echo statement) and again after the form is submitted (so that $_POST['search'] is populated. Check your PM.
  2. doughemi

    getting started FM on the web

    PHP files need to be in that directory if FMS and web server are on the same box. In your case, that does not apply. Can you post your PHP connect to FM file so we can see if there are any errors there?
  3. You have no mechanism to add a new director to the Directors table. One way is to add a relationship from Movies to Directors ( Movies::Director = Directors::DirectorName ). I changed your field name from DirectorList to be more descriptive --you are obviously going to add more information about each director in the table. Create a script AddDirector: If [Count ( Directors::DirectorName ) = 0 and not IsEmpty(Movies::Director ) ] Freeze Window Set Variable [$addDir; Value:Movies::Director] Go to Layout ["Directors"] New Record/Request Set Field [Directors::DirectorName; $addDir] Go to Layout [original layout] End If Attach an OnObjectExit script trigger to the Director field in Movies, and point it to AddDirector. When you exit the field after adding a director, the script checks to see if the director name is already in the Directors table, and if not, add it. This is a very rough solution as there is no way to prevent multiple entries for misspelled names, but the basic principle will get you started.
  4. doughemi

    Genealogy: Relational database(s)

    Second Steve's recommendation. FM11 will generate problems on High Sierra. FMI only certifies FM16 on that OS.
  5. @wickerman: Try using your checkbox as the primary key in a relationship to the difficulty field in a TO of your Questions table. A Go To Related Records script step should give you all the records which match the checked boxes.
  6. doughemi

    Number format for summary field

    With the reasonable assumption that the Summary field is a number field (with the comma inserted by the Inspector for display), you could use Int(YourSummaryField/1000) Lee's answers are all based on the field being a text field with the comma being actually part of the data, which I would not expect in a Summary field.
  7. doughemi

    Rounding up

    Siroos12's calculation works, but keep in mind that decimal numbers in FileMaker never have trailing zeros. You can format the display of numbers to 2 decimal places in the Inspector, but the actual data will still be only 1 decimal place if it ends with 0 (or none if the result of the calculation should be 6.00).
  8. doughemi

    getting started FM on the web

    I was able to make your php script work with the following changes: The file was riddled with curly single quotes. I changed the login to one I was most familiar with (without the setProperty() syntax) Made the find request layout name match the layout name in the FM file. Changed the include command to show the correct pathname and filename for FileMaker.php (on my system; YMMV) Changed some capitalization. PHP is case-sensitive. I added the sequence using $accessed. I find it a very useful troubleshooting tool, as well as a visual cue for a user when the server is down. HTH EDIT: Even though the attached file is pointed to the copy of your database on my server, I also connected successfully to your server fms.arina.biz aussiejohnTest.php
  9. doughemi

    Reporting records between a date range

    Create two new global fields UserStartDate and UserEndDate and place them on a layout. Create a script If[not isEmpty(YourTable::UserStartDate) and not IsEmpty(YourTable::UserEndDate)] Set Field[YourTable::EndDate; YourTable::UserEndDate] Set Field[YourTable::StartDate; YourTable::UserStartDate] Set Field[YourTable::UserStartDate; ""] Set Field[YourTable::UserEndDate; ""] Go To Layout["YourSummaryReportLayout"] End if Attach a script trigger OnObjectExit which calls this script to both the UserStartDate and UserEndDate fields on the layout.
  10. The line allows the adjustment of the angle and the gradient of the gradient fill which is probably inserted by your current theme.
  11. If your workflow requires it, you may also wish to limit access to users based on creator or job function (only access own records, only access dept. records, etc).
  12. doughemi

    Searching a value entered by a user

    I'm afraid I don't understand how one invoices a product one doesn't have. This has gone well beyond a standard invoice solution. It would require a much fuller understanding of the actual workflow than I have.
  13. doughemi

    Searching a value entered by a user

    I think that a new product code and name typed in to the invoice is added to the Prodkt table. It is in the sample I sent you.
  14. doughemi

    Searching a value entered by a user

    Yes, that would require additional steps in the script. Actually, I would consider creation of new products to be a separate operation, instead of being part of the invoice process. But I have no knowledge of your work flow.
  15. doughemi

    Find multiple words in Value List

    Thanks, Bruce, for the correction. The square brackets are stuck in there somehow by Clip Manager, and I forgot to edit them out.
×

Important Information

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