# OneStop

Members

100

## Community Reputation

0 Neutral

• Rank
novice
• Birthday 07/27/1975

## FileMaker Experience

• Skill Level
Novice
• FM Application

• OS Platform
Windows
• OS Version
Windows 10

## Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

1. ## Calculate Shipping Costs - Updated

I never really expected FMPro to handle if/then logic via SQL syntax. The more you know I suppose. Thanks for all your help.
2. ## Calculate Shipping Costs - Updated

Huzzah! This is the part that I was missing. I mistakenly thought that when the BillableWeight was say "4" in your example....That both statements of ≤ 5 and ≤ 10 would both return true. So is that in this calculation FMPro will just evaluate to the first true statement and then stop?
3. ## Calculate Shipping Costs - Updated

Explain Like I'm 5? Here's the new formula for the shipping rates... 0.01 - 0.69 lbs = \$4.99 0.70 - 0.99 lbs = \$5.79 1.00 - 8.00 lbs = \$5.99 + .80 per lb I understand evaluating something like ≤ .70 ; \$4.99 But I'm not understanding how I would get to >.70 ≤ .99 ; 5.79 ; In order to evaluate the new pricing structure I have to be able to define a cost as being between two sets of weights instead of just being less than X.
4. ## Calculate Shipping Costs - Updated

I got a very helpful reply here once regarding calculating shipping costs using this formula: Case ( BillableWeight ≤ 1 ; 8.99 ; BillableWeight ≤ 10 ; 8.99 + 0.5 * BillableWeight ; 9.99 + 0.4 * BillableWeight ) Not however, the terms have changed and I need to evaluate charges that are BETWEEN certain values.... For instance: ≤ 1 ; 8,99 ; is no longer true... Now it's .01 - .69 = 4.99 etc... How would I go about modifying the calculation to evaluate between two values instead of less than a value?
5. ## Showing list of available dates

Well both statements are true. In the first example I stated that in my hypothetical solution the first 4 days of May (let's say) already have appointments assigned to them and therefore would be removed from the list. The list would show the 5th through the 31st as being available still. In my second statement I made mention of the fact that my appointment system handles dates that are often outside of the current month. For example in June.... So what I'm trying to do is basically show a list of dates still available for appointment after doing a find for a given date range... Example: I do a find for the 10th of May through the 8th of June....the list would only show me dates within that range that do not currently have any appointments...
6. ## Showing list of available dates

I watched the video and read through the thread but it doesn't seem applicable to my situation. I need to be able to create appointments sometimes 30-60 days out. So if I were to do a find for all appointments in say June....the list would only show the remaining available dates in June, etc..
7. ## Showing list of available dates

Well for instance let's say I have appointments scheduled for the 1st, 2nd, 3rd and 4th of May. May 5th through the 31st would show in a list like 5th 6th 7th 8th 9th 10th etc..etc... and each time a new appointment was added that date would disappear from the list as it's "taken" What I'm trying to do is create a "quick view" as it were of open available dates...
8. ## Showing list of available dates

I'm working on a small job scheduling system for myself. When a work order comes in I assign a date to it manually. What's I'm trying to do is show a list somewhere on my layout of remaining available dates in that month. I'm not sure where to start with calculating that or displaying it.
9. ## Show Top 10 by DropDown Selection

One last thing...I would like to understand why your solution worked. Did I approach the problem from the wrong end? It appears you decided to subsummary by Salesperson first then by Company Name....?
10. ## Show Top 10 by DropDown Selection

NVM, I found my stupidity...I added the Saleperson field to the layout instead of the SalesPerson Name field... Awesome...thank you so much...you solved a huge problem for me. Thanks for all the help guys. Truly great forums and super helpful.
11. ## Show Top 10 by DropDown Selection

That's great...and I've recreated it with the buttons and the sort order like in your example except all I get is a list of customer names with their Invoice Totals...no salesperson names....am I supposed to sort this a certain way first or do a find for the salesperson then use the sort button etc? I only ask because I noticed you added another subsummary part that's ordered by salesperson name when sorted by salesperson name..which I have also done...yet the salesperson name doesn't appear in mine?
12. ## Show Top 10 by DropDown Selection

"reorder by summary field option" What does that do and how would I use it? I've attached the file if anyone wants a look at it..it's got demo data in it BARE.fmp12
13. ## Show Top 10 by DropDown Selection

I haven't had very good luck with SQL in Filemaker for some reason...so I thought I'd stick to FM's native functions... This seems like this should be a very simple thing...and I'm finding all kinds of neat tricks like trailing grand summaries in list mode and all that, but I literally have 5 fields. Customer Name, Date, ProductSKU, Qty Sold, Invoice Total and SalesPerson Name... Obviously each customer can and does have multiple invoices....So all I'm trying to is add up all the invoice totals for each customer, do a find by the SalesPerson name and then sort the list by the Invoice Total so that I can print off a list of the top 10-20 customers by dollar amount for each salesperson.... Customer A invoice Total = 100.00 Salesperson Joe Customer A Invoice Total=25.00 Salesperson Joe Customer B Invoice Total = 10.00 Salesperson Joe Customer A Invoice Total = 10.00 Salesperson Mary Customer A Invoice Total = 20.00 Salesperson Mary Customer B Invoice Total = 20.00 Salesperson Mary Customer C Invoice Total = 30.00 Salesperson Mary Customer C Invoice Total = 50.00 Salesperson Mary This is how the current table view appears (mostly) What I want to see when I do a find/report by Salesperson Name for Salesperson Joe is this: Customer A Invoice Totals = 125.00 Salesperson Joe Customer B Invoice Totals = 10.00 Salesperson Joe Then if I do a find for Mary I get: Customer A Invoice Totals = 30.00 Salesperson Mary Customer B Invoice Totals = 20.00 Salesperson Mary Customer C Invoice Totals = 80.00 Salesperson Mary Then I need to be able to do the sort on the Invoice Totals to show for example that Mary's top customers in order are Customer C Customer A Customer B
14. ## Show Top 10 by DropDown Selection

For various reasons that would lead down a rabbit hole I can't do any of those things mentioned but i do appreciate the sentiment. I'm merely a consultant trying to make do with a pile of junk left behind by another employee. I could dump all the data into a MySQL db and create anything I wanted but again without going down a rabbit hole...I'm stuck with access to this thing. So that being said...I did watch the video recommended earlier and have begun creating a report. I've created a sub summary part that is set as "Sub-summary when sorted by "Customer Name" and it does indeed show me the data I wanted but when I try to sort those totals after doing a find on the saleperson....the summary info of course goes away... What am I missing? What I'm trying to do is come up with a total dollar amount by customer and then do a find for the salesperson and then sort by that dollar amount, I'm obviously failing to understand Filemaker's basic functions as this seems like a rather simple thing to accomplish without having to do a bunch of find/sort voodoo
15. ## Show Top 10 by DropDown Selection

Well that's kind of the problem...this massive pile of excrement I was handed has everything in one table...no relationships, no keys...nothing...it's just a glorified Excel spreadsheet sitting in Filemaker. So now I'm trying to figure out how to get some actionable data out of it. I have to present a PP presentation using the information that's stored in this thing and I'm just trying to format some displays of that data in order to use them in that presentation. Specifically, I need to show the top tep customers by sales for each salesperson, the top ten product by sales for each salesperson and charts of the year over year sales by month.. I know FMPro can do all those things...I just don't know the series of steps to make that happen other than doing a convoluted series of finds, contrains and omits..
×
×
• Create New...