Jump to content

metamict

Members
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About metamict

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  • Location
    Illinois
  1. metamict

    Detect "File cannot be found" container

    I am not looking to make this determination through a script, but rather through a field calculation. I'd like a calculation field to show whether or not a file is present. I can't find a function that can discriminate between a container field with a reference where a file is present and a reference to a file that is not present. The odd thing is that the container field itself shows a difference (one shows an icon of the file, the other says "The file cannot be found."). So filemaker can see a difference, but there seems to be no way to capture the difference in a calculation. Thank you-
  2. metamict

    Detect "File cannot be found" container

    Oddly enough, I just tried this. Unfortunately, getastext supplies only the file path. I can't seem to find any way to distinguish between a container that shows an icon (the referenced file is present) and a container that displays "The file cannot be found...." Thank you for the thought, all ideas are appreciated.
  3. I calculate a path (through a calculation field) that is displayed in a container. If the referenced file is not present, the container field displays the text "The file cannot be found." Is there anyway to create a calculation field to note if that file is present. In other words, is there anyway to have another calculation field read the container field to note that the file isn't present? I have tried "isempty", but the record with an invalid reference is not considered empty. I have tried "patterncount" for the word "cannot", but it seems that Filemaker doesn't consider the error message "The file cannot be found" as text in the container field. I can't find anyway to capture that the reference is invalid. It seems like it should be possible, since the container field already contains the information I'm looking for, but I can't see how to capture it. Any help would be appreciated.
  4. metamict

    Dollar sign in page number field

    Perfect. Worked like a charm. Thank you.
  5. metamict

    Dollar sign in page number field

    I have page numbers inserted into several layouts in a text box in the form "Page {{PageNumber}}" Since installing FMP13, all of my page numbers have started printing out in the form "Page $1.00" I've never had this problem and I'm sure it is something very simple, but I just don't see how to return it to a simple page number (e.g., "Page 1"). Any assistance would be greatly appreciated.
  6. metamict

    Complex Value List

    Perfect. I had been trying to use the list function but hadn't been using it in in the same table as the Active Employee List. Your explanation was very clear and worked just as expected. Thank you!
  7. metamict

    Dropdown menu without Keyboard

    I've figured this one out myself. This may be obvious to everyone else, but just in case: The dropdown list brings up a keyboard. The popup menu brings up the value list without keyboard. I hope this helps someone else out in the future. I'm not sure how to mark this solved.
  8. metamict

    Complex Value List

    So I'm hoping it's not actually so complicated, but here goes: I have a value list called "Active Employees" that uses only related values from a field. This works perfectly. I'd like to create a new value list that includes all of the active employees as well as two other random values. These two separate values are not employee names and therefore I don't want them to show up in other places where I use the Active Employee value list. The goal here is to effectively combine two value lists. I'd be most grateful if someone can provide me with a workaround whereby I might incorporate these two additional values? Thank you in advance,
  9. I have a layout for the Ipad that uses several dropdown lists. Since the user won't have the option to key-in free text, I'd like to prevent the keyboard from appearing and taking up screen space. Is there any way to prevent the keyboard from popping up when a dropdown list becomes active? Thank you
  10. Was wondering if there is a way to convert a Word document in a container field (either stored or referenced) into a PDF directly through Filemaker? I'm guessing this is not possible, but curious to know if anyone has a solution. Thanks in advance.
  11. I'm using Filemaker 13 Advanced to turn a small project into a runtime solution. I have some videos that are referenced. When I create the runtime solution, everything works fine, except there is an error that the solution can't find the videos. How should I reference videos in a file that will become a runtime solution (or where should I put them once I've made the solution). Thanks for your help.
×

Important Information

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