Jump to content

Ocean West

Administrator
  • Content count

    3,308
  • Joined

  • Last visited

  • Days Won

    35

Ocean West last won the day on July 13

Ocean West had the most liked content!

Community Reputation

103 Excellent

6 Followers

About Ocean West

  • Rank
    I have an idea!
  • Birthday 11/26/1971

Profile Information

  • Title
    Consultant
  • Gender
    Male
  • Location
    San Diego

Contact Methods

  • Website URL
    http://www.fmforums.com
  • Skype
    oceanwest

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

FileMaker Partner

  • Certification
    7
    8
    9
    10
    11
    12
    13
    14
    15
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance

Recent Profile Visitors

33,472 profile views
  1. Expenses (with attachments)

    Are there any examples of this tables & scripts functioning in the wild? Would like to push pull this data.
  2. How to properly shutdown my server?

    the os issues a shutdown command, this will terminate the server processes
  3. Let's all get along? It's been rare for our forums, but on occasions I have had to step in to keep the peace and harmony of the site. At times personalities clash - and the typed repsonses are often done in haste - and the sort of thing that wouldn't be said if we were all in same room together. I am encouraging everyone to re-read https://fmforums.com/guidelines/ our guidelines. Let's please keep threads on topic. - and not abuse the "reporting" system. Please be courteous of others and if you have offended someone please extend a sincere apology. The least thing I enjoy doing is to put people in 'timeout' or ban them from the site. Thank you.
  4. Deleted thread

    threads may be hidden from time to time while we have a chance to review and moderate individual posts to keep the thread on topic.
  5. The site is now running on https, please let me know if you experience any issues. You may need to re-log in for things to work correctly.
  6. Log In Working Not Working ?

    There is an issue on the beta of the site please keep the remember me checked as a temporary fix.
  7. Table with many fields or table with generic field?

    This was a solution I worked on years ago in FM 11 I have not upgraded yet for 16, there are a lot of better ways to make it more efficient. setting up a survey you setup all your questions and answers and you can decide the type of information you require as an answer text number currency date duration single choice multiple choice likert scale branching logic can be made so that if you choose a particular question you could go down a chain of new questions. The end result is a table of records for each participant that will have a record for each question on the survey. Various means of formatting this for a printed report obtainable. however because data is not normalized out additional logic and thought would have to be considered if you are wanting all respondents answers be aggregated. https://cl.ly/0p310i1K3S1P
  8. Export to CSV column order

    I haven't tried on FMGo but on the desktop you can save as a merge file format and just use CSV as the extension that will include header columns.
  9. Loss of Layout Functions in FM16 User

    you need to direct select the object from the object layers window and then you can edit them in the inspector.
  10. Removing Spaces while printing

    vertical lines and boxes won't shrink to fit.
  11. Removing Spaces while printing

    Sliding will not work if any fields are set to align middle (vertically) and borders on lines can sometimes be a factor, also check on the layout setup and un check the boxes.
  12. FileMaker 12 to 16

    SuperContainer data is stored in a directory on the server - you can make sure you backup your HD so you have copies of all the original files. The default locations for the file storage is http://docs.360works.com/index.php/SuperContainer#File_Storage you can get the version number of SC by going to: http://domain_or_ip.com/SuperContainer Upgrading to a new version will update the server tomcat files and resources needed to serve images it will not delete folders where files are stored.
  13. Summarize 3 time fields?

    caffeine running out - fair warning - how about.... create a field that is Sum ( time1 ; time2 ; time3 ) this will sum up the rows, then a new summary field to get the total hours of that field.
  14. I am trying to decide on a schema approach to a small add-on to a vendor/supplier evaluation process, we will have this 'survey' done at intervals, and I am deciding to either put data as a fields or as a table with a key value pair which would require a scripted creation of the data set. Or storing the data as a JSON array and pivot it out to a virtual list. The jury is still out if we need to have aggregate data across all vendors to get a tally if say one of these items is a no. If data is stored in an array computing the aggregate across dozens of records can present its own challenge. Curious to entertain some concepts and suggestions.. During the evaluation period: These questions have Y / N / NA Quality 1. Were the correct materials shipped? 2. Did received materials arrive in good condition? 3. Did all purchased materials met specifications and requirements? 4. Did all purchased materials maintain the quality standards for products? 5. Did we receive prior notification of any changes to purchased materials? Service 1. Were orders processing correctly and efficiently? 2. Were orders received on time and undamaged? 3. Were payment requests handled correctly, efficiently and courteously? 4. Was customer service courteous and helpful? Value 1. Have product prices remained unchanged? 2. Have shipping and handling costs remained unchanged? 3. Was prior notification received for any pricing changes? (no answers above require a text explanations field) Resulting actions (can be more than one): 1. No action required 2. Inform supplier of concerns 3. Submit a formal complaint to supplier 4. Request CAPA from supplier 5. Move to APPROVED | PROVISIONAL | NOT APPROVED list
×

Important Information

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