# mattdunn

Members

17

0 Neutral

• Rank
novice
1. ## Escalating Discounts Calculation

I will take a look at that. Thanks for the feedback.
2. ## Escalating Discounts Calculation

Cool, it's always more simple than I think. If I could ask for one more bit of advice. What if those quantities (100 and 500) and those discounts (10, 15, 20) differ from product to product? "Widget C" could have a 30% discount only take effect at 10000+ units. I was thinking that the discounts and associated quantities could live in a different related table, that way each item could have any number of discounts. Any way to make that Case statement more portable/reusable?
3. ## Escalating Discounts Calculation

Hi, I have been struggling with this. I have a database of items for sale. Each item can have a constant discount, so "Widget A" always gets a discount of 10%, this of course is easy to calculate: Price * Discount (.1) But what if I wanted "Widget B" to have a 10% discount from 0-100 units, 15% from 101-500 units, 20% from 500+ units? Discount becomes a dynamic variable based on Quantity. Does anyone have any tips for this kind of calculation?
4. ## Schema Question

Thanks! That does help.
5. ## Schema Question

Hi Everyone, I would like to get some idea of what developers do in regards to tracking Contacts in a database that uses Contacts in many different ways. For example, say a company has records for Customers, Suppliers, Employees, Advertisers and Contractors. There could be a table for each type because a Customer is different from a Supplier which is different from an Advertiser and so on. If a Supplier decides to buy something from the company then they get entered into the Customer table, thus duplicating data. Alternatively, there could be one Contacts table, but that would need f
6. ## Script to Check Permission

I think I am on to something by using a few "Go to related record" script steps to traverse down to the proper table/record.
7. ## Script to Check Permission

Hi, I am making a Loans Database for our helpdesk. The loan transaction is set up in a typical fashion in that there is a Transaction table, an Asset table and a join table for Transaction Line Items. All of this works. Some of our Assets can only be loaned to students in certain classes. For instance a particular camera is allowed for Art Students and Math Students. Being an Art Student or Math student means that you are a member of certain classes. So I was thinking I needed a couple more tables, Permissions table with a name (Art) and a list of classes (ART101, ART201). Then,

Thanks!
9. ## Static Elements in Portals

Hi, I asked a similar question to this before but now I have an example. I have two portals, one is behaving the way I want and one isn't. When a portal row has no data, I don't want the static elements (in this case some boxes, slashes and the word Staff) to appear in the first empty row. What controls this? I have attached a picture of the two portals. Thanks, Matt
10. ## Validating Portal Data

Thanks for all the help Soren. If I could ask one more question, once the record is complete, is it best to have a script that makes sure the record does not get committed with reddened entries?
11. ## Validating Portal Data

Thanks I will take a look at that. The one thing I should have mentioned is that there are hundreds of items and the entry into the portal records would be done by barcode scanner. So the best case scenario would be: Scan an item...Filemaker says its not available OR Filemaker puts it in the portal.
12. ## Validating Portal Data

Hi, Quick description first. I have a Loans database. There are three tables: Loans, Loan Line Items and Items. Loans has a portal to Loan Line Items which does a lookup to Items. Each Item has a status: Available, Not Available, Reserved. Here is the question...as I enter an item in the Loan Line Items portal, is there a way to get immediate feedback as to the status of the item (beyond just having the field there). For instance, a dialog that says "This item is reserved you can't loan it" and then have the item removed from the portal? What would be the best way to accomplish
13. ## Related record is not the right record

I figured it out. One of the related fields was calculating as text and the other was calculating as a number.
14. ## Related record is not the right record

Hi All, Gonna do my best to explain this because I am confused. We have a slightly modified version of the template Lending Library that comes with Filemaker. Some of our items refuse to check in. I noticed that there is a script step in the script "Process Check In", that step is Go To Related Record. When I try to check one of our broken items in, for instance, 0000042, the related record that appears is 0000421. When I step through the script with the debug mode turned on, it kicks back "This operation could not be completed because the target is not part of a related table". So t
15. ## Buttons in portals

Hi, I have read through a bunch of articles on this site about hiding buttons in portals and I still don't quite get it. I want something very similar to what is present in a lot of the built in templates that come with Filemaker 8 (ie Lending Library). I need a button to delete records in a portal, I only want the button to be present if there are portal records. I have gone through some of the templates to see if I can discover how it is done and still no luck. Any help would be appreciated. Thanks, Matt
×
×
• Create New...