Jump to content


  • Posts

  • Joined

  • Last visited

BeckyMN's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I'm having a tough time figuring this one out. I have a table with three fields; two global calculated fields and one regular text. The table has only one record. The calculated fields are simply the literal strings "Yes" and "No". The regular field is only there to give the table one record. I should also mention that the file is hosted by Filemaker Server. When I connect remotely to the open file I expect to see the value that I entered into the regular text field along with the values of "Yes" and "No" in the globals. The value in the regular field is present but the globals don't populate. However if I create a new record the globals populate immediately. If I delete the new record the global values remain. If I close Filemaker on my PC and relaunch the globals are gone. I understand that this is common behaviour for global text fields but I would expect that global calculated fields would calculate no matter what the situation is. In other words, they would always be populated with "Yes" and "No". Is this normal? Can somebody explain what is going on? Thank you, Becky
  2. Thanks for the info Comment! An idea popped into my head this afternoon which may work out better than importing. Basically, I'm going to create an intranet web page using ASP and VB and then use Filemaker's Web Viewer to scrape the HTML from the page. I can tell VB to replace the end-of-line characters (chr(13) & chr(10)) with 's. From there I can have FM replace the 's with native Filemaker carriage returns. There is a positive side effect to this method as well. I will not have to establish ODBC connections on each PC, only the web server. If this method doesn't work out I may be back. Thanks again for your help! Becky
  3. I'm importing data into Filemaker (version 8.5) from an Oracle 8i database. All goes well except for columns that are called "long" by Oracle. These "long" columns can contain lots of text and are (I think) not indexable. The text in these "long" columns imports fine except that there are some extra characters at the end or the beginning of every line. The characters appear to be spaces and rectangles but they are not easily selectable with the mouse or arrow keys. I tried substituting these character with a simple native Filemaker carriage return but no luck. Anybody know how to how to clean them out after the import or better yet prevent them from being imported in the first place? Thanks for your help!
  4. IsEmpty works too, but I had to remove the "not" modifier to make it work properly. I thank all of you for your help. I learned something today. Now if I can just remember it for next time. Becky
  5. That worked. I even looked at IsValid in the help file before posting but didn't realize that it did this from the description. Thank you Jens!
  6. I have a simple two table database. What I would like to do is have a button that will take the user to the related record if there is one but if there is not a related record then I want to pop up the custom dialog box. Can someone explain how is this done? It seems pretty simple but I can't get it to work. Thank you! Becky
  7. Reed, Thank you for you assistance! I hadn't checked back in a while and didn't know that you had provided an answer. That's an idea I hadn't thought of. My plan was to take them to a specific record to approve but providing a list of all records that need approval may actually be better. Just for my own FYI, do you or does anyone else know if going directly to a specific record using CWP is possible?
  8. I have a simple IWP question. I'm a real newbie at IWP, in fact I'm just starting my first project so be gentle. This will just be a simple approval process. I would like to have regular Filemaker Pro (not IWP) create and send an email message to the approver when the record is ready for approval. In the body of the message I would like to have a hyperlink that when clicked would take the approver to the proper database (IWP) and to a specific record. With the little experimenting I have done so far I can make the correct database file open but I don't know how to go directly to the correct record. Is this even possible with IWP? If not can it be done with CWP? Simply stated, I want to go directly to a specific record in a specific database directly from a hyperlink in an email. Thank you.
  9. Mikhael, Thanks for the help but I may have confused the issue by mentioning the the database was designed before version 7. It is now in fact on version 7. It was converted to v7 last year. I only mentioned that to illustrate that the tables are in different files. I guess I confused the problem and I should have been more clear. I did try adding a couple of HALTs but it's not working for me either. Again, I'm thinking it is because they are inside if the "IF" which means that the script has to return to the source file to complete. Becky
  10. I have a couple FM files from pre 7 days. The files are related to each other but there are no portals in either file. What I would like to do is create a script in one file that will take me to the related record in the other file if there *IS* a related record. If there is *NO* related record then I want go just go to the file anyway and browse all records. Here is my script with all of the fluff removed: Set Error Capture On Go To Related Record If Get ( Last Error ) = 101 // no related record Open File ["The Other File"] End If When I run the script, if there is actually a related record it seems to locate it but the window never becomes active. It think this is because the script in the source file is not finished. The same thing happens if there is no related file. It probably goes there but comes back to the original file to finish the "End IF" statement. I've hit this problem in the past and came up with some pretty clunky workarounds which I would like to avoid this time. I'm hoping one of you more experienced developers can show me how you would handle this situation.
  11. Oh good lord the lightbulb just went on! Of course I know that Filemaker has calculated fields but I had no idea that they could global too. This is the perfect answer! It should work everytime. Thank you Comment! How did I miss this obvious feature for all these years? It's pretty embarrasing.
  12. Comment, Forgive me but I don't understand. Could you please elaborate a bit? Thanks, Becky
  13. Good morning! I have a database with 2 layouts. They are similar but differ in a few ways. One is a service call ticket with a portal showing billable activities and the other is a service call ticket showing non-billible activities. The relationship is one TICKET, many ACTIVITIES. The primary key is TICKET_NO in the TICKET table and the foreign key is TICKET_NO in the ACTIVITIES table. Each ACTIVITY record also has a field called TYPE where the valid entries are BILLABLE and NON-BILLABLE. I have built my relationship via TICKET_NO and TYPE. I have a global field in the TICKET table where I can either choose BILLABLE or NON-BILLABLE. The portal dynamically filters the results depending on which choice I have made in the global field. This works just great. Now for the problem, and really it's not so much a problem but more of a question on how other Filemaker developers accomplish this: I would like one layout to always show BILLABLE lines and the other layout to always show NON-BILLABLE lines. No user interaction required at all. I have built this already by creating two more global fields in my TICKETS table and having a startup script that populates both fields; one with BILLABLE and the other with NON-BILLABLE. This works but is this the right way to do it? I don't want to depend on Filemaker's ability to remember a value entered in a global field the last time it was closed in single user mode because it seems like as the developer, I could easily lose that value if I'm not really careful. On the other hand I also don't particularly care for the script that runs on file open because I know that if a file opens via a relationship the script won't run. I'm just looking for some more dependable options. -Becky
  14. Thank you Comment! Your calculation works perfectly and I think I understand how you arrived at the shortened version. Sincerely, Becky
  15. I'm embarrased to ask this because I asked a similar question before but I have such a hard time understanding how validation by calculation works. I have 2 fields. Field A is a number field. Field B is a text field. What I want to do is require the user to add a note--enter some text into Field B--if Field A contains any number. This is so common in other databases that I have encountered yet I just can't seem to figure out how to make this calculation work. I just don't seem to understand how to think about the problem. The note at the bottom of the define calculation says that it must be boolean which I think means 0 or 1 or true or false. But what does that mean to me and how do I think of it in terms of what I am trying to do? Can somebody explain this in plain english for me? I would love to get past this learning hump. I feel like such a dope.
  • Create New...

Important Information

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