Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About JMart

  • Rank

Profile Information

  • Industry

FileMaker Experience

  • Skill Level
  • FM Application
    15 Client

Platform Environment

  • OS Platform
  • OS Version
    Windows 7 Pro

Recent Profile Visitors

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

  1. Hopefully not often, Whenever canon publishes their Dealer parts list, once or twice a year. thanks
  2. Thanks works like a charm, now i have to deal with a speed issue, since i end up having over 3 Million records on this table alone. Thank Jay
  3. Good day all, I need some clarification on how i can possibly accomplish a task. No matter how much i think of a way cant figure out how to do it. i need to import data from an excel file where column "A" contains a unique value, but column "B" and "C" can respectively contain anywhere from 1 value to 50 values separated by a comma each. I need to create one record per value on column "B" but keep column "A" as the key field for each record. Thanks JMart
  4. thanks for the script, i tried the above, but for some reason when i create a layout and place the sList field to show the list of missing invoices it shows the first number only repeated. Thanks for the advice, in this instance all we need to do is collect a all invoices generated by the ERP and enter the number to keep track if the sales person turned the invoice into the accounts department, they were using excel but it got to be too many invoices.
  5. thanks for the quick reply, The database is very simple; there are 5 fields the two key fields are "invoice No" and "Invoice Date", a users populates these two fields, i basically need a script that will find the missing invoice numbers between the lowest and highest numbers. Thanks
  6. hi all, need desperate help in putting together a script to find missing numbers between the lowest and highest. e.g. 1, 2.4,6,10 need a report to show the missing numbers 3,5,7,8,9 help is greatly appreciated Thanks.
  7. Thanks, The only steps I have on my script are; new Record/Request Commit Records/Requests [with dialog:off] Go to Field [inventory Collection::ItemCode] For trigger I have tried; OnObjectSave and OnObjectExit All i get is a loop creating a record. Thanks for you help
  8. Thanks, I don't really need any controls, all i need is the ability to scan a barcode and once the field exits a new record is created and wait for the next scan. The issue i am having is once i execute the script either using trigger on exit or enter it goes into an endless loop cretating indefinite records. Thanks
  9. Hi guys, I am trying to create a very basic script that would allow for continues scanning, but don’t seem to be able to figure out how to get the script to work. i set a script trigger to execute on exit with the following script. new record go to filed [item_code] the idea is so when I scan an item the scanner will add a return at the end exiting the field, and so triggering to run the script over. all I get is an endless loop. thanks
  10. JMart

    Missing Data

    Thanks guys for your input, i figured it was not doable, but it was worth the try. yes the 40 fields are user data entry, the table had a total of 98 field. This is a some what flat database to collect time the document advances in the warehouse. the 40 fields are mostly the are start-and-end time. the rest are calculations to determine time between process. @comment that is how i have a layout with all the required fields and they change color conditional i was just thinking of something more fancy..
  11. JMart

    Missing Data

    Good day all, My apologies if i am posting in the wrong group. I am looking for some advice to accomplish the following task. I have a database with 40 fields, i would like to create a dynamic layout that would show the fields with missing data. is something like this doable. I currently have a portal that show the users the records with missing data in the portal i want to add a button that will opens a window and displays the missing data fields. Thanks JMart
  12. I have another question along the same validation lines. i have a field: kDocumentNumber - "Unique value" is checked and i have the field on the layout is set to trigger on exit i cant get the window to show with either script. I cant get it to show the new window with either script. The idea is if there value exist it will show a custom window Thanks for your rudy
  13. Good day, Thanks, works like a charme. JMart
  14. hi guys, Please please please, What in the world am i doing wrong in the below script, it only works if the user has [Full Access] . Thanks for any guidance Jmart
  15. Sorry pasted the wrong snap. this is the portal filter, and it works as expected, the only issue i am having is to have a button that would clear the filter. Thanks
  • Create New...

Important Information

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