Jump to content

TravisB

Members
  • Content Count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About TravisB

  • Rank
    member

Profile Information

  • Gender
    Male
  1. TravisB

    Weird drop down list anomaly value/appearance

    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!
  2. 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 worried that there may be something other than just an appearance thing going on.  "
  3. 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. Obviously this is not ideal to be using the damaged file and relying on it, but I'm putting in 14+ hr days until the "new" database is ready so the only other choice I see that we have is to shut the doors while its down or use a method to deal with the day to day operations with zero chance of being able to import the data easily once I fix my file. I am saving back ups hourly with integrity check on each one and I am also manually checking the back ups every couple hours just make sure they are opening correctly. I am also saving a clone at each hour - which I wasn't doing before.
  4. 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.
  5. 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 practices as far as backups go and I knowingly exercised practices, which were to be temporary, but regardless against best practices while others I had no idea about (checking backups for integrity is something I've never even thought of before). I'm not blaming FM, its my fault plain and simple. Either way, lesson learned, I need to figure out exactly what happened, change my methods, ensure this doesn't happen again and simply move on. In the mean time, I need my data back. Any other tips or things to try before I fully give up on recovery is appreciated.
  6. 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 shell of this database, as I did all development as of late remotely (I do have a 1-2 month old version, but a lot of progress has been made on the development since then.) So not only did I lose all the information which was stored in the database, I also lost the design. I did not realize the built in back up service from FMS was inadequate. From what I have found so far, it looks like im pretty well f-ed. Looking for anymore ideas to try and I guess confirmation that I'm screwed. I still need to call FileMaker and see what they say, but I don't really have that high of hopes, but I guess we'll see. Some things that I was doing that probably contributed to this: A) I did do some development while the hosted file was in use by other users - but nothing too extreme or huge sweeping changes, mainly just fine tuning and tweaks FMS was temporarily on a local computer that was being used for normal day to day stuff as well as running the the database from FMS C) I have changed privileges while users were using the file (which, I just found out from my 20min of research this probably what caused this issue and is a huge no-no. Why do they even allow it if its such an issue?) Really hoping this is fixable.
  7. 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 filtering (just guessing on the filtering, havent actually looked at it and thought about what to do yet).
  8. 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 reference, to minimize/maximize three portals there are a total of 14 tabs, 4 portals would be 30 tabs (I think), 5 would be 62 (I think). Everytime you "minimize" or "maximize" a portal, the script evaluates which portals should be shown and then uses script step Go To Object to "activate" that tab (each time min or max is pressed, it will go to exactly 1/2 of the tabs created to ensure the proper "configuration" of tab layout). Attached is the file I created, any advice or tips towards efficiency, or pointing me towards an already built solution is appreciated. I can also explain further if needed. Thanks MinMax Portals.zip
  9. TravisB

    run script on enter

    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.
  10. 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.
  11. 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 purchase order a calculation to determine whether or not a value is checked (If (Scope = "A" and From Bid = Bidding::Bid ID ; 1 ; 0)), then another summary field to check if any of the purchase orders for that job are assigned as "A", "B" etc, and then another calculation for the checkbox on the overview sheet: If (Purchase Order::sA ≤ 0 ; "" ; "A") & ¶ & If (Purchase Order::sB ≤ 0 ; "" ; "B") & ¶ & If (Purchase Order::sC ≤ 0 ; "" ; "C") & ¶ & If (Purchase Order::sD ≤ 0 ; "" ; "D") & ¶ & If (Purchase Order::sE ≤ 0 ; "" ; "E") Which this works great if there is only one criteria checked per PO, but if there is one PO with more than one description it stops working, have "A" on one PO and "B" on another PO does seem to work just find though. I know that its the "If (Scope = "A" and From Bid = Bidding::Bid ID ; 1 ; 0)" part of it, but without filling out every possibility, which is a lot, I feel like I need a "wild card" option. This, however, also makes me wonder how the summary portion of my solution would work, or better yet if it would even work. Any help with fixing what I have, or giving me a better way of doing it, is appreciated. Also I should note that I know I could get this to work if I made a seperate check box for each description rather than a set, however that then creates 15 extra calculation fields in my database and 5 extra value lists and I feel like there should be a better way, not to mention I will have to deal with this exact situation on more than just this occasion for this database.
  12. 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."
  13. 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 went into action, and upon further inspection one was global and the other was local, so it would've been fine - but this is obviously an isolated event and I can't help but feel I'm doing something quite poorly). Second, is there a "go to" guide for a sort of "Industry Standard?" I've noticed a lot of people use the same/similar formats such as (for fields) cValue, gLength, etc to help identify. Any other advice related to this situation, no matter how loosely, is greatly appreciated.
  14. TravisB

    Runtime - Newbie Question

    Thanks for the clarifications, it all pretty much confirms what I thought but I wanted to make sure. Am still curious to see how these work once I get my version of Advanced.
  15. Hey guys, I've started developing my first FM database and have a very amateur question re: runtime. What is it exactly? I've been trying to research for about the last hour about it, and understand its a "Stand alone application and does not require FileMaker, with certain abilities removed" but what does that mean exactly? I'm pretty sure that it will not work to utilize in my application, which is a CRM/bidding platform for the construction industry. 10-15 (probably more in the future) users will all have to have access and ability to add/edit/delete records. From what I've read, runtime will not work for this - right? I would just create one myself based off what I already currently have and play around with it, but I'm utilizing the 30 day demo for development before buying the licenses using the annual volume licensing or whatever for all the computers in the office. I will be getting Advanced to continue development, am excited to see how well the extra features work. My background stems from overly complicated Excel files heavily utilizing VBA, so I'm sure that, along with exhaustion, plays a part in my inability to grasp this.
×

Important Information

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