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. Night, I think i figured out the issue i was having, the reason is my button was not a button but a Button Bar. I recreated it to a button and its working fine. Thanks for the help
  2. Your test file works perfect, my cant get it to work
  3. Thanks for the reply, User Click on the icon next to "Vendor" Once presses a script is executed Windows will appear on the same location every time
  4. Good day, I am trying to center a "Floating Window" using the new windows command, i want to accomplish one of two objectives. 1- Open the new windows to the right of the "button" that triggers the script To do this i am using the "GetLayoutObjectAttribute( "VendorWindows" ; "Top" ), and "GetLayoutObjectAttribute( "VendorWindows" ; "Left" ) 2- Open the new window in the center of the screen To do this i am using "Get ( ScreenWidth ) /2" and "Get ( ScreenHigh) / 2" But i cant get either way to work. Both option i am entering it in the "New windows" function
  5. Good day, I am having an issue that i never seen before. I have a very basic layout, 5 fields, and a global field for searching with a button to execute the search, all is working perfect, except that when i press the search button the result shift to the right, once i clear to show all the list shift back to the left. Any idea what i could be doing wrong. Thanks Jay Mart
  6. Hopefully not often, Whenever canon publishes their Dealer parts list, once or twice a year. thanks
  7. 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
  8. 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
  9. 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.
  10. 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
  11. 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.
  12. 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
  13. 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
  14. 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
  15. 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..
  • Create New...

Important Information

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