We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Ocean West

  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by Ocean West

  1. Removing Spaces while printing

    vertical lines and boxes won't shrink to fit.
  2. 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.
  3. 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.
  4. 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
  5. 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.
  6. test

  7. If the output is all in one text Calc then use the char(9) or a tab then use tab stops on the field.
  8. Styles eye dropper problem

    if any one objects is a button it is grouped and the old behavior of being able to style it or use the eye dropper is gone you have to select the object from the object window.
  9. We have updated the site to the latest beta version of the forums software. Please report any issues you discover. Thank You.
  10. Site Update - June

    New feature is "Fluid" found on the forum index. allows you to view all forums then select which forums you wish to filter by.
  11. Adjustable Size Layout

    you can use sliding objects on the layout and things will slide up when blank or you can use the hide object when and hide the field when it is empty so that only content will print.
  12. Update Feedback

    I had to update that part it should be back on.
  13. Taptalk

    Users of Taptalk, please know we are offline for the time being while the site is currently in beta and a new versions is pending.
  14. View File FM16 Card Style Window Preview Mode Action Button Pallet This technique was inspired by @Claus Lavendt in a tweet. Now with offset new card style mode you can now create a tool pallet to interact with a document in preview mode Submitter Ocean West Submitted 05/16/2017 Category Samples FM Version FM Version: 16  
  15. Version 1.0.0


    This technique was inspired by @Claus Lavendt in a tweet. Now with offset new card style mode you can now create a tool pallet to interact with a document in preview mode


  16. Live Development

    plan to later in the week make some alterations to a solution which is the same database that gets cloned and sent out to end users. There will be some new fields added and some fields will be tentatively removed or renamed. Other then rename/removing of fields if I get the bulk of the system updated before I alter the syncLayouts what other things must I be aware of for field workers who may have unsynced records on their iPads thru the week? also, is there a recommended way (other then sending out an email) a way for their database to know once they have synced data on their device to the host that there is a new 'build' available and present them a link to download it?
  17. Where have all the formats gone?

    latest updated turned them off - should be back.
  18. External Container Field Insert Very Slow

    check your server DNS settings if your using a FQDN and uploading to server I had an issue where there was no loopback or something causing very small images and files to take many seconds to upload.
  19. fields on Sync layouts

    What fields should and should NOT be on the sync layouts? In the dialog box it said something about not having Modified By fields on the layout... can you please expand on this? - I did notice that I have on my hosted file a Created by field (account) after the sync all the records are now owned or created on the date of the sync on the mobile device. - discovered a small bug. in this solution the primary fields are named with double underscores __TableName and foreign fields are single, in one table we had __Notes for the primary field and also a field called Notes however in the config of the sync picking the primary key ignores the double underscores.
  20. fields on Sync layouts

    Since development is ongoing, and were massaging data still there are times when we need to make bulk edits to record sets. So in the field that is used for the timestamp on the layout the calculation is: stampModifyHost: Case ( $$isDev = 1 ; stampModifyHost ; Case ( stampModifyLocal ; Get (CurrentHostTimestamp) ) ) StampAccountModify: Case ( $$isDev = 1 ; stampAccountModify ; Case ( stampModifyLocal ; Get (AccountName) ) ) when we know we are going to mass modify a lot of records we set $$isDev to thru a script only available to someone with full access. after a loop or replace all has been done turn off the $$isDev However I have a suspicion that this may be ill-conceived or may not achieve the necessary intensions.
  21. Setup Script...

    I am noticing a dialog box now when logging in to the live databases on mac or iOS, it reads: I've had the script referenced in the on first open trigger but never remember getting this dialog.
  22. Repeating fields are legacy feature in FileMaker however they do have their uses. I was trying to create a report with columns that would slide up to the height of the maximum field the problem with using regular fields and turning on any borders on the fields the sliding up of all above or directly above did not produce the desired result some columns would be shorter then others and the lines would not be consistent from the top of the body to the bottom. In this case the columns are all the same width so I thought the use a calculation will be able do the trick. With the final result sliding up to the height of the largest column, with a little tweaking to the padding and line spacing and since some numbers needed to be formatted as currency a custom function in the calculation made it possible not to have to apply currency formatting to the entire repeating field. Also in order to get the column headers to line up I even created a similar repeating calc for the column labels.
  23. The let function declares the variables a - h in this case and I wrap each field with the Extend( ) function this is solely used for taking non repeating fields and making their value accessible to a calculation's repetition. The calculation at the end is a Choose function that returns the value depending on the function Get (CalculationRepetitionNumber) In essence the first rep gets value in a, second is b, third is c and so forth. This function is zero based meaning its the few functions in FileMaker that start out with zero so that is just blank, with two "". you should be able to click on the image to zoom in on it.
  24. Duplicate Script

    have you considered doing this all server side using Perform Script on Server, thus there is no lag as no data has to be sent remotely.