Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ray-El

  • Rank
  1. Thank you for the tip. Very nice sample. I'll have to dissect it and see if I can understand what's driving it.
  2. I'm trying to come up with a way to allow users to create a list of cascading categories, which will eventually be used to help customers narrow down products on a website. The first two categories are entered for them in two fields in the same table. So they would see the following listed: Record 1: Garage Tools Record 2: Kitchen Silverware When they click on the record 1 ( Garage - Tools), a portal shows them all the subcategories for that record and allows them to add more as needed, such as: Hammers Drills Saws Crow Bars I added a second portal so that when
  3. I'm about to perform a major overhaul on an existing database that is used to track customer orders. They want to add a billing feature that automatically calculates sales tax appropriate for each state/zip code on an item-by-item basis, since some of the line items being sold are taxable and some are not. So the person entering the job will have to determine the taxability of the item and then I can set up the database to apply the applicable sales tax. Or maybe I will set up a table of items with predefined tax statuses. Haven't decided yet. But before I go creating this myself, I'
  4. You don't need to buy a full PC version, you just need an .exe installer. I would contact FileMaker and see if they will send you a link to download the PC installer. I needed both the Mac and PC installer to create Runtimes for both. Since I have FileMaker Maintenance, they send me a single e-mail with a link for both installers. Your installation code for the Mac also works for the PC installation.
  5. I'm not sure if this is possible, but I was wondering if I can keep a user from entering ANY data into field1 if the value of field2 = "C". If the value is not "C," then they can enter anything they want into field1. I have a database that customers can use to generate product orders by finding items, entering a quantity and clicking an ADD button to add the item to their order. However, some of the items on the product list (which are pulled into a layout from a portal) can't be ordered by themselves because they are part of a larger kit, even though they have their own unique item
  6. Thanks for all the tips. I went with a modified version of the first option with the layout switching because I just ran out of time to work on that particular issue. But I plan to explore the second option as well. The final result has created quite a stir, so I'm sure I'll have many more chances to play around with it. Also, the list of items had to appear on another layout/table because my order form took up most of the screen space and a different set of items would be available for each new order based on the manufacturer. Customers can create multiple orders, but because of how the
  7. Thanks! That set-up looks like it will work. I'll have to see if I can recreate it in my database without missing anything. I'll also keep my eye out for any other instances where I cheated and used Copy/Paste instead of Set Variable. It seemed like the easiest and quickest way to go, but even as I was setting it up, I had a feeling it wasn't the best way to go.
  8. No. It's version 11 Advanced. I just haven't updated my profile in a really long time.
  9. My database has two tables; one with product information and another that is an order form. I set it up so customers can browse items in one window and click an "ADD TO ORDER" button that copies the item number from the item database, then goes to the order form layout, pastes the item number into an item number field in a portal on the order form, and then returns to the list of items. After the item number is pasted, the order form populates with all the relevant pricing data for that item from the item database. The general idea is to have the order form act as if it were a shopping
  10. Thanks for the suggestions. I think I will work on setting it up so that other tasks can repeat too. That's a good idea. For this immediate need, I noticed my checkbox was already a button that was running a script that would check off the box and get a separate field to indicate whether the job was open or closed based on that checkbox. So I created a new script that first compared the Due Date to the current date, so that if anyone accidentally checked off an old occurrence, it wouldn't duplicate the entry. I also had it check to make sure the Completed Date wasn't blank and the
  11. I have an idea that I could use some input on. I set up a departmental To Do list for a group of users in FileMaker 9. I'm going to have these same users perform a backup of their hard drives every 2 months. So I want to set up a record for that task within the To Do list. In order to mark that the task is complete and have it not show up on their To Do List for the next day, they have to check off a box indicating that the task was completed and enter the date it was completed. What I want to do now is set it up so that when they check off that they completed the desktop backup, Fi
  12. Hi everybody, Does anyone know if there is a version of FileMaker that I can upgrade to that will bypass the limitation that lets you only view 5 records at a time when you are viewing them thru a web browser from a locally web published FileMaker Pro 7 database? That 5 record limitation is killing all my web publishing plans. I'm about to put in a recommendation for some FileMaker Pro upgrades and if either Advanced or Server can do this, then I'll get one of those added on. I tried getting an answer from FileMaker, but they replied and asked me to call their technical support. I j
  13. I'm working on a database that tracks the ads placed in a publication. Some of the advertisers place ads in multiple editions, so I created an "edition" field to track which ones they appear in. But I would like all of the fields for listings that are older than 2 editions to appear in red so that I can easily distinguish at a glance which ones are old and which ones are still pending. This is the script that I wrote using the text color function. Then I created a button for each record and set it to run this script. I know I would have to add the other fields to it, but I can't even get
  14. Thanks for the suggestions. They got me going in the right direction. I had buttons in the database that each user of the todo list would use to view their own projects. Instead of having that button just perform a find, I made it perform a script with the same find criteria and I just stuck in a step where it inserted the current date into the global "Today's Date" field. It doesn't keep the "Today's Date" field updated all the time, but it's a perfect work-around since the first thing anyone does when they go into the database is click on the button with their name on it.
  15. I set up a project todo list with a container field that shows a blinking gif that says "URGENT" anytime I missed a deadline on a project. The container field is set to compare a field with the current date and another field with a project deadline. If the dealine date passes (as compared to the current date) and the project is still listed as incomplete, then the container field will show the blinking "URGENT" gif. I got it all working great, except I can't seem to get the current date to ever stay current on its own. I found a way to refresh it using a script and a button, but I need it to r
  • Create New...

Important Information

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