Jump to content

Ponderosa

Members
  • Content count

    17
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Ponderosa

  • Rank
    member

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra
  1. Is there a way to count the number of records in a portal (got that part figured out in a sum field) AND account for if a record has a specific field entry? I have a portal that displays games and sometimes the games are paired together in one record. I want to be able to count the paired games as 2, not 1. I'm thinking something like If ( Qty = 2 ; ( Get ( TotalRecordCount) * 2 ) ; 1 ), but currently what I get is ALL the records, times 2.
  2. Totally not sure if I've put this thread in the right topic category, as I'm not even sure how to go about this. First, I'd like to be very clear on the fact that, if possible, this will be done without scripting. I'm hoping for some kind of calculation. IDK. Anyway, I'm trying to copy or Calc one field from an older record to its newest match (using BatchNum field to match). The two fields are different fields (FormNum is the ID number field) (RefID is the the reference field for FormNum ). RefID would allow the user to find the last time the same arrangement of data (FormNum being its ID number) was used. It's meant as sort of a skipping stone effect, if that makes sense. My thought was to create a filtered value list of some kind and just set RefID with the highest ID number from FormNum, prior to the newest entry. Or organize by newest Date Created, prior to the newest entry. Again, IDK. I'm quite stumped and hope this rambling makes sense to you very helpful people. Thanking you in advance....
  3. Summary Field

    NM. Got it to work with a solution discovered from this thread. https://community.filemaker.com/thread/65009#comment-84575
  4. Summary Field

    I have a set of order forms, in which each order form has X amounts of orders from X amounts of clients. I can summarize with a Summary field the number of orders each client has ordered on one order form (weekly order form) and now I want to make a report that tells me the breakdown from week to week, and quarter to quarter. I can get the report to break apart the weeks by quarter, and it displays each week's correct total, but it won't do a total sum of each quarter, let alone for the entire database. I've tried summarizing the weekly summary field to get the quarterly amount, either in a new field, or on a trailing sub-summary part. The new field just copies the number from the weekly summary field from the record that is active, and the other way just shows the last above record. Wanna pull my hair out! I have a feeling that the problem is in how I set up the original weekly summary field, but I just can't see how, or how to make it work.
  5. WebDirect doesnt match

    rwoods, I forgot to say thanks for the help, and as an update to this post I organized my styles better and tested, tested, tested as you'd say, on the one layout needed for WebDirect. I'm fairly satisfied in the results, thought the layout looks REALLY weird in Filemaker, LOL. Part of the end-result was directing the person to that layout ONLY if they're using a web browser by the "Get ( ArchitectureMode ) " function and getting the solution to go there if it said "Web Publishing Engine" and the version number. (Middle section is included if needed for anyone else who gets stumped by my conundrum) Oh, and I upgraded my Pro version to 16 yesterday afternoon, and there doesn't appear to be any change (oh, well), positive or negative.
  6. WebDirect doesnt match

    Is it possible that part of the problem is that I'm working from 15 Pro, but "broadcasting" from WebDirect 16?
  7. WebDirect doesnt match

    So I created a solution in Filemaker Pro and its appearance looks great.... until I open it in WebDirect on a web browser. Fields are cut off at the bottom, styles like Condense condense wrong, and rectangle boxes don't show at their full size. Also, the padding spacing on radio buttons is completely ignored. I've tried three different browsers: Safari, Firefox, and Google Chrome, and all show the exact same results. The only way I am even remotely able to change the appearance for the WebDirect browser page is by scrubbing out all the style changes (mostly Condense) and that still only changes about 20% of the inconsistencies. Thank you for any help.
  8. Automating Date Lookups

    Haha! SUCCESS! Thank you, both. Fran_g, that worked perfectly once I turned the "Do not replace existing value of field (if any)" on. Every time I created a record now, the field automatically populates with a day 7 days hence. Woot!
  9. Automating Date Lookups

    Thanks for moving my question! I still haven't quite figured out how to 'label' my questions properly. My problem is that I want the "+7" stuff to calculate from the same field, but in a previous record, so that each record jumps ahead by seven days. I don't know how (or if it's even possible) to give it a start date in that same field in the first record, and then start calculating accordingly. Is this making sense? I really appreciate the help.
  10. So there's probably something simple, but do you guys know of a way to automate dates from one record to the next? Each record date needs to be seven days after the previous one, and I'd like for my client not to have to enter it manually. I tried doing Let ( Today = ( ReleaseDate ) ; Date ( Month ( Today ) ; Day ( Today ) + 7 ; Year ( Today ) ) ) and some others, but none appear to automatically fill in. Help!
  11. Looked Up Info

    I have a set of tables that pull information into a separate table (Table A) , to populate it and prevent user data entry that is incorrect. What I'm trying to do with field A (Table A) is filter records (from Table B ) through field B (also Table A) and then choose from the remaining records by a range of two fields in Table B of a minimum number and a maximum number. If field C (the number field in Table A) is equal to or between the min and max, then a field from the same record in Table B fills in field A, Table A.
  12. Double Filtering a value list

    Greatly! Got me to where I figured it out. I added a third relation between the two tables and added a auto-field which filtered the statuses automatically. Thanks!
  13. Double Filtering a value list

    Hi, so I'm struggling with a solution for work. It requires being able to filter a set of records through two different specifications (the first being department [HR, engineering, shipping, etc] and the second is status [active, inactive, or unknown]). I want it so that WITHIN each department only the records with Active and Unknown are displayed on a value list for populating a related table. I know how to do it for one level, but not two.
×

Important Information

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