Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About beckham

  • Rank
  • Birthday 12/10/1959

Profile Information

  • Industry
  • Gender
  • Location
  • Interests
    Man Utd
    Everything Mac

FileMaker Experience

  • Skill Level
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
  • OS Version
    El Capitan

Recent Profile Visitors

2,469 profile views
  1. Hi, can anyone help with considerations of my first attempt at charting in filemaker. I hope to show a colum chart (sales v wages) on a weekly basis, with the chart displaying actual data and the percentage wages represent against sales? Thank you for any advise...
  2. beckham

    Can anyone help with conditional Value list?

    Answer to my own question, I found an error in the setup i failed to identify the "include only related values checkbox"
  3. beckham

    Can anyone help with conditional Value list?

    Following Lee's advice i have succesfully managed to create a conditional value list, but i have have a strange problem. The conditional popup menu (or drop down) is very slow at propagation of value i.e.: the list that matches the condition can take minutes to load or change based on the trigger condition... any idea how i can speed this up? Thanks...
  4. beckham

    Can anyone help with conditional Value list?

    Thank you Lee i found the you tube link earlier and another one by Guy Stevens but didn't understand how to relate those examples to my file. Your example file is most useful i will check that out in detail. kindest regards..
  5. Hi can anyone advise how i can make a simple value list conditional? I have a single table on a job bag system and one field specifies the choosen print supplier i.e.: "London Print ""Wards Print" etc. I would like the detail fields such as "Foil Colour" to be conditional because different suppliers have different references to the colour swatches.. e.g. London Print may use "RED032" where Wards Print could use "BlazeRed" I only want to display the user the values specified by the choosen supplier.. i'm not sure where to start? I think i need to create tables and relationships but would appreciate any help thats out there on the forum... many thanks
  6. Hi Lee, Thank you for the sample file i am most grateful .. even lloking at the sample file i dont yet understand this witchcraft used in Calc fields but i am able progress my solution further with your generous help... Thanks again..
  7. Help Please, I am trying to figure out how to extract field contents via a calculation as follows: My lookup field is ABCDEFG-01-12345.jpg I want to automaticaly extract only 12345 to be placed into another field? I tried the Calculation Right ( Sorce field; 5 ) but that returns me 5.jpg any adivise is most welcome. Thank you
  8. beckham

    Please Help match an imported field

    OK I can answer my own question now, i created another field to target the import to and I used replace field contents "Left (Design) (7) ) to look up the target data. This new field then only held the "AB12343" part.. which i could use to update matching records in found set. If any other newbies have a similar puzzle..
  9. Hi Guys can anyone advise me please with my following problem. I have a database (FM15) containing a field populated with the following example "AB12343-02-12345" I want to import a csv using "match existing records" matching only the "AB12343" element of the existing records. Then a new field is used to store the imported "AB12343" because i don't want to overwrite the completed field of "AB12343-02-12345" if no match exists it will create a new record. A big thank you for any Guru help on this!
  10. beckham

    Find expiry date range

    Thank You for the sample file Lee that helps me understand the options i have much better. kind regards
  11. beckham

    Find expiry date range

    Hi can anyone offer advise on the best practice to script a find function please? I have a "expiry date field" e.g.: 12/03/2018 and would like to have a script that could show records that fall within 8 weeks before or after the expiry date. Thank you
  12. Hi, does anyone know how to validate a container field as unique? I am placing a barcode graphic into a container field and want to ensure that barcode can't get assigned to another record. Thanks for any help..
  13. Hi Can anyone advise on how i can script a button that would populate a Table view field with squential numbers. i.e.; i need to generate a batch of 1000 squential numbers starting at 010000000001 into field which could then be exported to third party program. Thank you for any hints on best practice here.
  14. Hi can anyone help advise on a script step to export certain fields to an excel document.. I wish to export content from 20 fields from the current record into a single xls document presented in a single colum view. (not rows) e.g.: abc123 ASD223 etc many thanks

Important Information

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