Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Slogan

Conartist's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. Thank you so much. This solution worked perfectly. Though, I wish I could wrap my brain around the concept.
  2. One of the above suggestions refers to using an unstored calculation with "getcurrent date" as part of the relationship to create a value list. I thought you weren't able to base a value list on an unstored calculation. :B
  3. Thank you for your help, it made me look at things in a new way. But I'm still stuck after I tried implementing your suggestions. After a few tries I was ending up with an "index missing" error. Which I now realize is based on having an unstored calculation involved in my value list. I'm having a hard time figuring out a way around this. I misspoke in my original post, simply using date to base my relationship on doesn't quiet work because my main database contains shows that are in the future but haven't yet met the requirements to be an "active" show and I don't want them to show up on my "active shows" list. I currently have a checklist of things that make a show considered "active" - I use an unstored case calculation to evaluate what has been checked off the list and then give that show a status category. So unfortunately for me, both of your suggestions were helpful but don't quiet work for my situation.
  4. I run a tradeshow company and have written a couple of separate databases to track our business. Currently I have a main database that tracks all of our events and the exhibitors who will be attending those events. I have a separate freight database that we use in the warehouse to track their inbound shipments to us. To expedite the data entry for the freight database, I use a filtered value list setup so that they can pick the name of the show and then have access to a second drop down that shows the list of exhibitors filtered by the show name. Currently I export the customer list from our upcoming shows and manually add it to the freight database and then delete that show information as the show ends. I would like this to be done automatically by linking the main database to the freight database in some way. I understand how to link the databases together and have been playing with value lists across the files. My problem is that my main database has thousands of shows. The drop down list on the freight desk can't show all of the show names, it needs to just list upcoming shows and not the past events. To accomplish this "filter" in the main database I have a status field that calculates the current date and the show dates to give an "active" or "inactive" status to the event. This has added one more level of filtering, sorting or whatever it is to the situation and now I'm stuck on what to do next. How do I get only the "active" shows to show up on a value list in the freight desk?
  5. Did you figure out how to do this? I'm looking into an automated backup of the database files using SyncBack to backup directly to an ftp site. I'm thinking that to have the backup be as clean and as useful as possible the databases should be closed when the SyncBack backup is scheduled. I saw something related to using windows scheduled tasks to accomplish this but I'm just not entirely sure that the commands "FMServer STOP" and "FMServer START" are going to accomplish what I want. Any help is appreciated.
  6. I wanted to submit a follow up with exactly what I did...for the archives...not sure if this is the most elegant code but it seems to work. I ended up creating two calculation fields to parse out my "booth #" text field. Booth # Text - is a calculation which results in text Filter (Left (Booth#; 1); "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ") This selects the first character in the booth # field and then filters out anything that is a number. I'm left with either a blank field or a letter if present. Booth # Number - calculation is GetAsNumber ( Booth#). This parses out only the number characters. I then sort by Booth # Text and then Booth # Number and the records sort how I want them to. Thanks to everyone who helped out with this.
  7. Yes! Comment you've got it. I think what you are suggesting is exactly what i need. I knew it was simple. Thank You! I think this problem might be a little hard to wrap your mind around unless you've seen it in action..we might be too used to Excel's handing of sorting text and numbers to not quite understand the way Filemaker handles them.
  8. My database tracks orders for items rented to exhibitors at tradeshows. Several of the reports I print need to be sorted by booth #. 99% of the time everything works fine using the booth # as a number field and then sorting by number. However some of my tradeshows will separate areas of booths by including a letter in the booth #. For example booths in room A are labeled A1, A2 and booths in room b are labeled B1, B2. I need to be able to sort by number and letter so that my report would end up listing A1, A2, B1, B2. With the field categorized as a number I get A1, B1, A2, B2. Which is not helpful. Similarly if the field is text it doesn't sort the #s correctly if they don't have a letter in front of them. I'm sure there's a simple solution to this I just can't find anything similar in the forums. I need something that will work with mixed data as well for example the current tradeshow I'm working on has normal numbers 1 - 100 and then T1 - T100. Any help is greatly appreciated. I have to do reports tomorrow, so I guess I will manually sort them for now.
  9. I have a database that tracks exhibitor orders for tradeshows. I need to add a new feature that would allow a user to choose items from the customers orders and create a work ticket. The work ticket would be used for items that "need to be done". Example customer ordered 3 tables and only has 2 in their booth. The work ticket should only show 1 table. As that is all that "needs to be done". Currently the main screen that is used to track customer orders contains a portal showing all related records on a layout that is connected to the customer. I plan to use Genx's "select multiple portal records" (http://fmforums.com/forum/showtopic.php?tid/180278/) solution to get me started. What I'm not sure about is the next step....how do I allow the user to update the quantity of the line item on the work ticket without changing the quantity of the original order. This would be necessary in the above example as the customer would still need to pay for all 3 tables (original record needs to stay for invoicing and inventory checking purposes) but the work ticket should only say deliver 1 table to exhibitor. Do I need to create duplicate temporary records and then delete them after the work ticket is printed? or create some kind of text that is editable on the work ticket? I'm a little unsure of how to implement this next step. Thanks.
  10. I'm using double carriage returns inside of text quotes and it results in the one carriage return that I want in the resulting email. I'm using FM 8.5 and Outlook on a PC.
  11. I have an invoicing database that pulls pricing information from another table. We have multiple prices for the same items depending on different criteria. What I have done is create a table that holds pricing information and this table has multiple entries for each item depending on how many different price options there are. Works fine except for one picky detail....I find that when I'm doing data entry I prefer to use all keyboard shortcuts and not use the mouse....when I tab into the dropdown list and hit the down arrow key to select a price, it selects the second value in the list not the first one. This behavior is not what I would expect and actually causes the user to hit the down arrow and then the up arrow to select the first item in the dropdown list! How annoying. Is there a way around this? I frankly have thought about creating a blank price field that would effectively move the 1st actual price to the second position in the dropdown list making this the first one selected when hitting the down arrow....but this seems clunky. Anyone have any ideas?
  12. You do not need to have separate databases just separate tables. It seems like it will be difficult to help you in this forum when you are at such a beginning level. I was in a similar position about a year ago This forum is more based on helping with the technical sides of developing with filemaker but can't really help explain the fundamentals of database design. I would suggest reading some books on database design - my personal favorite which got me from ground zero to where I am now is a series called "Using Filemaker" by Steve Lane & Co. I have "Using Filemaker 7" but they have also published a new version "Using Filemaker 8". What's great about this book is that it does walk you through the fundamentals of database design and also covers more advanced topics. Its a large book and will help you through all of the stages of development.
  13. I am attempting to do a similar thing in my database. My database tracks events. An event is marked as "current" if it is less than 30 days from the closing date of the event. I want to use a filtered value list for data entry such that the drop down list only lists show names for shows that are marked "current". I tried to follow your instructions but I'm not getting good results. Here are the fields involved: Showfacts:Show Name Showfacts:Active_Status = Calculation(If ( End Date - Get ( CurrentDate ) ≤ -30; "Not Active" ; "Active" ) Showfacts:Show Name_Active = Calcuation Case (ActiveStatus = "Active" ; Show Name ; "Not Active" ) If I'm understanding the logic correctly, the Show Name_Active field will drop in the Show Name when the Active_Status field is set to "Active". When the Active_Status field is set to "Not Active" the Show Name_Active field will drop in "Not Active". Then when I create a value list on the Show Name_Active field it should list all the Show Names for "active" shows and then a "Not Active" entry. This sounds good to me - it is better than the current situation which is a huge drop down list of all show names in database. This isn't working as expected. First I had to change my two calculation fields to be indexed for them to be eligible to be used in the value list. (I'm concerned about this as I'm not really confident on what Indexing really means and I think calculation fields should generally be unstored.) My current result is a list of 2 shows and the Not Active entry. I have 19 currently active shows. No idea why its grabbing only those two shows and not the others. I feel like I'm missing something.
  14. I appreciate your response. Yes they were set to date fields. I have solved my problem by simplifying things. I'm really not very confident that I understand what I did to fix this problem. I vaguely understand that it has to do with the order of the cases (?) in the script (?). Case ( Final Invoices checkbox = "Yes" ; "Final" ; Exhibitor Kit Emailed checkbox = "Yes" and Get (CurrentDate) < start date; "Ordering" ; Get ( CurrentDate ) > end date ; "Closed" ; Get ( CurrentDate ) ≥ start date ; "Open" ; "Planning" )
  15. My database tracks events. There are several different tasks I need to perform based on the current status of the event. I am trying to create a status field to mark records as one of five different categories depending on the records "state". I have been using the calculation below with some success. All of the "states" are working as expected except for the two "open" and "closed" states. I assume that the problem has something to do with how I am working with the dates but I'm kind of lost. This is my current calculation. I've tried to move the order of the cases around and have tried different ways of ordering the "get current date" steps. Nothing seems to work. Any advice would be greatly appreciated. Case ( Final Invoices checkbox = "Yes" ; "Final" ; //Black Get ( CurrentDate ) ≥ Start Date and Get ( CurrentDate ) ≤ End Date ; TextColor ( "Open" ; RGB ( 24 ; 162 ; 75 ) ) ; //Dark Green Get ( CurrentDate ) > End Date and Final Invoices checkbox ≠ "Yes" ; TextColor ( "Closed" ; RGB ( 255 ; 0 ;0 ) ) ; //Red Exhibitor Kit Emailed checkbox = "Yes" and Get ( CurrentDate ) < Start Date; TextColor ( "Ordering" ; RGB ( 0 ; 0 ;255 ) ) ; //Blue TextColor ( "Planning" ; RGB ( 0 ; 255 ;0 ) ) //Light Green )
  • Create New...

Important Information

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