Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About TravisB

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

2,824 profile views
  1. I can in this morning after recovering over night, and am a little surprised to see that it came back with no issues. At this point, should I try saving a compacted file and host that? From my research I've seen mixed reviews - with the majority recommending compacting periodically, and some people saying to never host a compacted clone.
  2. My database is starting to act strange, some users are experiencing random crashes, I’ve had records that seem to just disappear, records make relationships with other records they shouldn’t be and I’m suspecting potential corruption and this is going to be the first time I make use of my backups and try to A) Identify if I have corruption and B)) potentially fix it. I have a few different questions in regards to best practices and next steps. I am running FMS 15. Most users are on FMP 16, a few users are on FMPA 17. About 10 users total. All users are on Windows 10. Server has Windows Se
  3. Fantastic questions. I moved the original field to another location and somehow that "o" character was placed right where it was. This database has been live for somewhere around 2 years and I'm currently doing development work for a new release. No idea how I managed to put that there. I'll blame both the placement and inability to figure it out on exhaustion. Cheers!
  4. I have a layout with a drop down list. The value list it uses is just a simple custom value list with two values.  It shows a "o" in front of the value. I copy/pasted the exact same field on the layout and on the new one it appears normal/doesnt have the anomaly. (it looks like its a o or 0 in a small font, or possibly the degree sign - cant exactly tell which character it is.)  See pic to see the two fields side by side - I have absolutely no clue what is going on here. The simple fix for appearance would be just to delete the original value and use the copy/pasted field - but I'm w
  5. Justin, Thanks for the note. I was doing two back ups daily, one at noon and one at 11pm (we close the doors are 5, but often times employees stay late). The integrity option was checked. Last night I moved Server to a dedicated machine and upgraded to FM Server 13 as well as all the machines to FM 13. We have the current file on the server and are using it remotely while I re-develop its replacement and import the data- everything seems to be working fine and I'm crossing my fingers that it'll hold together today and tomorrow and I can finish up the "new" database by Monday morning. Obvio
  6. Just an update, the file was actually recoverable by using recover in FM 13. The file is still damaged, but the data is at least intact, so thats certainly one big win. I still lost a large amount of development work, but at least I still have the data and a "working" database that I can use to help speed up the re-building processes. Considering where I was 2 days ago, I am very happy with this outcome. I will certainly be advocating as well as exercising best practices from here on out. Big thanks to Wim for helping me behind the scenes, very much appreciated.
  7. I have already emailed Winfried, am awaiting a response. I have not tried FM 13, as I don't have it installed, I also have not tried it on a Mac as I do not have access. As for my comment, and your response, all is fair. If this is a known issue, why FMS wouldn't have a built in feature to check integrity of its backups I do not understand, but I'm also not a programmer or understand the potential complexities so really I suppose one could argue my dissatisfaction with that is unqualified. Your point is well taken, understood and greatly valued. I did not do the proper research on best pra
  8. Today the machine which was running FM Server crashed, and upon reboot our main database would not open. When saving a copy to the desktop and opening directly it says the file is damaged and cannot be opened. When trying the "recover" command, it comes back with "The access privileges in this file have been damaged or possibly tampered with. Please contact FileMaker Technical Support if the problem cannot be resolved." Most troubling is that all of my backups are also opening with the "The access privileges in this file have been damaged...." I literally don't even so much as have an empty sh
  9. All of the portals are populated from relationships via different table occurances and is refreshed with a cartesian join - there is no portal filtering and the cache is never being flushed. Each portal shows a limited amount of records, hence why I have so many portals, each is refined down to very specific situations the job can be in. Would it be much better to have less portals with more information being shown? What about less portals with filtering implemented? I could dwindle the portals down quite a bit with more information show in each portal and possibly having to implement some
  10. Part of the database I am creating includes 19 portals across 3 tabs (10 on first, 5 on second, 4 on third) - with the likelyhood that more will be added. These portals are designed to help employees track status' that jobs are at. I wanted to create a way to minimize/maximize portals as desired by the employee to make it easier to see what you want and only what you want. I have been playing around and pretty sure what I came up with thus far will work, however due to the number of steps I feel there may be a better way performance wise as well as time wise for development. Just as re
  11. Not sure if you still are looking for an answer on this, or perhaps it will help someone else that stumbles upon here in the future, but I too had the issue of it triggering with each keystroke. My issue was what appears to be yours (probably the initial post as well) which is a misplaced ")" You have IF Code (Get ( TriggerKeystroke ) = 13) and it needs to be IF Code (Get ( TriggerKeystroke )) = 13.
  12. This worked exactly as planned, thanks! Thank you for the help. I dont see how invoices have to do with my questions, which my simply be because I haven't actually followed your advice yet, but I will certainly take a look if nothing more than to gain valuable unrelated info. Thanks again to both - its very nice to have a resource as valuable as this forum.
  13. I have a database that consists of purchase orders (one record per PO) that will have a description assigned by a checkbox. I then have an "over view" sheet for each job that will give the end user a quick idea of what type of products are assigned to that job. So, if a job has 5 purchase orders, and the descriptions for the purchase orders are "A, A, B, D, D" I would like the check boxes on the over view sheet to be checked as "A, B, D" with C and E remaining unchecked. Also, a purchase order can be "A, C and D", or any other variation. What I have done so far is assign for each p
  14. Yes, I found I've been trying to use $$ only when absolutely necessary with the preference to use $ whenever possible. $$ seems to inherently pose the possibility for innaccuracy and/or headaches making sure you clear them at the "proper times."
  15. Im pretty new to FileMaker and have a 2 part question. First, I wanted to know if there is somehow a current list of $ and $$ Variables used in scripts? The reason I am asking is to avoid potentially using the same variable name for two different purposes within scripts. I suspect this comes largely down to "proper development principles" to avoid such a conflict, however that sort of "evaluation" feature wouldn't hurt anybody. This is prompted by the fact that I had the same variable name in two seperate scripts; one to filter a portal and the other to set an FK (I caught it before it
  • Create New...

Important Information

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