Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About smdig

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Hi, I have quite a few summary fields in portal layouts that I use. I have found that you usually need to refresh the portal for the totals to update. To allow my totals to update automatically, I have attached a script trigger to the fields that users enter the information, in our case qty ordered and buying price. The script trigger runs on object exit and runs a script called refresh portal. All this script has is two lines: enter preview mode enter browse mode. This is enough to refresh the portal and works for us. Regards, Sdig.
  2. Hi Digital Life, Thanks for your reply. However, all the records are marked New before the scanning process starts. Once a record is found and printed, it is marked as such. As i explained in my post, this is not the problem. The problem is, that when you have even two users both with scan guns and they scan the same product barcode, which is then part of a find request for the first outstanding order matching the barcode, Filemaker runs so fast, that it can allow them both to find exactly the same record. This would not be a problem if they were searching for different barcodes, but the
  3. Hi, I am trying to solve a problem in filemaker 11. I have a database that has multiple orders from customers. However, the product ordered can be repeated multiple times across the customer orders. Herein lies my problem. I can have two or three users, each with a pile of product that can have the same title, but is for different customers orders. They run a script which allows them to scan the product barcode and it searches the database for the first outstanding customer order matching the barcode. Problem being, that if two users have the same product and happen to run the sc
  4. Hi, If you want to change the field from no to yes, just include the following in your script Set Field(Invoice::paid;"yes") Note: If you are already in the correct record, you do not need the Go to Field step in your script. Regards, Sdig.
  5. Hi, I have a related table called Po lines. What happens, is that customers place orders for goods not released yet ( we are selling CD's; DVD's-etc). We put all these orders in this table, then when we have enough orders for a particular supplier, we create a purchase order. However, in the PO lines table, you can have 6 different customers ordering the same product, for differing quantities. At present I create a Po and assign the Po number to all the records chosen in the PO lines table. Then in a portal layout i can view by po number, the order and its related lines and produce a summ
  6. Hi, I am running filemaker pro 9 advanced on Mac osx, so do not know if this works in your environment. However, if you are trying to auto calculate the date between any given date, the easiest way in filemaker, is first to create the fields for comparison, so for example you could have a date submitted field and a date reviewed field, both set up as date fields. Then you create a calculation field for days out, using the following formula: GetAsNumber ( date reviewed ) - GetAsNumber ( date submitted ). This will then work out the differnece between the 2 date fields and return a number
  7. Hi, You could achieve this using the set variable step. If you create a new field in filemaker called Path, then in this new field enter the path to the images in the following format user/Desktop/Images/ (obviously, this path is for information only). Then in your script, after you have specified where you want the image pasted, choose the set variable script and in the options set the name as $Path (Note:the name must be spelled the same as the field name, as it is case sensitive)and for the value choose the new field you have created. Then select the insert picture script step and d
  8. Hi, I am using Filemaker pro 9 Advanced, So not sure if procedure is the same in Filemaker 8. However, if you create a script and select import records, then select specify data source and select file type comma-separated text files and then select ok, you get a dialogue box that defaults to field names. If you ok this and then de-select the specify data source and specify import order and save the script, it retains the info for file type. When the script is run the user will need to select the file and once they do, it will import records, but not the first line. I have tested on my sys
  9. Thanks for your response. Had tried assigning to new button, but did not work. Also, did not want to put on custom menu, as we have approximately 40 databases and the users are used to running various scripts off buttons. However, since posting my question, I have found the solution by trial & error. when running the script from the button it was apparent that filemaker was performing an action on each line, which the user could see. This obviously does not happen when you run the script from the menu. Therefore, at the start of the script I put the Freeze window script step and now
  10. I having recently migrated to Filemaker Pro 9 Advanced from Filemaker 7. A script I used in 7, which was assigned to a button and ran very quick, now runs very slow in 9, when run from the same button. However, if I run the same script from the script menu in 9, it runs as quick as it did in 7. If anyone has any ideas as to why this is happening, I would be grateful.
  • Create New...

Important Information

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