Jump to content

1FilemakerMan

Members
  • Content Count

    31
  • Joined

  • Last visited

Community Reputation

0 Neutral

About 1FilemakerMan

  • Rank
    member

Recent Profile Visitors

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

  1. The table has no child/grandchild records. The operating system is Mojave, the version on the Macs is Filemaker 15, on the server it is FM 13. I copied the database to my Mac and tried to delete these files also, and that took the same amount of time.
  2. We are only wanting to delete certain records. Mainly ones that are older than two years.
  3. Hello again everyone! I have a hopefully quick and easy question. Our database has a lot of older records that need to be deleted. When we did a search for these records, and told the system to delete all of them, it seems to take FOREVER!!!!!!!!!!!!!! These 25,281 records would take well over two, or three hours at that rate it is going, and that is only one month of records 😞 . We are simply searching for them, and then selecting, "delete found records". I have tried creating a query to delete all shown records, and had the same results. Is there any quick way to delete a lot of records? THey are NOT associated with any other table in the database either. And here is the script I wrote for this. THANKS!!
  4. Yes, I am programming it on my Mac, and then have this layout setup for Ipad. So I am scanning the barcodes with the Ipad using Filemaker Go, which I LOVE!
  5. This is what I have in the script right now. It is pulling up the camera for the barcode, and it is searching and pulling up inventory, but it is not the correct inventory area.
  6. That is a good video and instructions he gives on that site, but I do not need to create bar codes from google. I simply need to scan the barcodes on the devices, store it and then do a search with the barcode I scanned. I can't seem to figure that out. Thanks.
  7. I have a database that stores compuerts, printers, etc... Each device has two different barcodes on them, our companies, and the serialnumber that it came from. I have been successful in using our Ipads to scan the barcodes and put them into the system as numbers and letters, no problem. Now I would like to have a search button that scans a barcode and then takes that barcode number and searches for it in the database. I am confused on how to do this. I know how to scan the barcode and get the number, but I don't know how to do a search for it?? I created a global field in the database to store the scanned code. But I don't know how to save that and do a search throughout the database for it? Thanks!
  8. I have two versions of FMP open at the same time to test doing updates, and make instructions on how to do the updates at the same time. On a MAC you simply open up the terminal and type this, open -n "/applications/filemaker pro 16/filemaker pro.app" That will open up another version of FMP. Enjoy!
  9. I have been assigned a job to update/fix some problems with a FM Database that was created years ago by someone else. I have it all setup, except for one, simple problem. In the layout, it is set to show a person's name, address, zip, state city and phone number. The problem is that not everyone has a phone number listed. So if they don't have a phone number, the sentence will end like this "Stephens, ." If they do have a phone number it is, "Stephens, 544-545-5444". Is there a way to remove the comma if they do not have a phone number listed??? Below is an exact copy of that data they have typed in. They pull that data out of the database and then the piece of paper gets printed off. The "," after the <<i_name>> is what is causing the problem (yes I enlarged it). <<i_name>>, <<i_pobox>> <<i_city>>, <<i_state>> <<i_zip>> OR DELIVER IN PERSON TO <<i_name>>, <<i_phone>>.
  10. Comment man I love you!!!! AWESOME Job helping me. IT WORKS! At least I think so. It is going in to test mode. So people will be logging into it and trying it out. Thank you so much!!!!!!!!!!!!!!!!!!!!
  11. I have been on vacation and now I am back with a fresh start on it. I am going to look carefully at your program and see if I can get it to work. Thanks!
  12. How do I tell FM to COPY the data instead of linking it directly to the data? Do I need to create a script to copy the selected object? How/where does the Target::Copy go????
  13. yes it does, and thanks for sending it. I am going to look it over tomorrow and see if I can figure out how to do that. I don't have a global field, and things like . yours does. I have only been using filemaker pro for a few months, and there is a lot to learn! Thanks for you help. I will try some more tomorrow at work. This is something I need to learn!
×
×
  • Create New...

Important Information

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