Jump to content

Greg Hains

  • Content Count

  • Joined

  • Last visited

  • Days Won


Greg Hains last won the day on June 21

Greg Hains had the most liked content!

Community Reputation

3 Neutral

About Greg Hains

  • Rank
  • Birthday 12/26/1967

Profile Information

  • Gender
  • Location
    Brisbane, Australia

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

  1. Greg Hains

    Counting Distinct Values for a Chart

    Hi Comment, Thank you once again for coming to my rescue. Yes, my description could have been better, but you knew what I meant. I did have all the settings correct as you described, but I did not sort the records again. Once they were sorted, everything came good. Cheers, Greg
  2. Greg Hains

    Counting Distinct Values for a Chart

    Good morning. I am having trouble displaying data in a chart - this may be as much about schema and relationships as it is about charts, but here goes... I have a table called "SOAP Notes". This table has about 12,000 records. In this table, two of the fields are Date (a date field - surprise!) and Date_Count field - a calculation field that reads this: ExecuteSQL ("SELECT Count ( \"Date\" ) FROM \"SOAP Notes\" WHERE \"Date\" >= ? AND \"Date\" <= ?" ; ""; ""; Date; Date) This calculation field gives me a count of any given day - works fine. I then narrow down the data to be displayed with a FIND (for example "9/2018" in the Date field), I still get repeats of the same date, so there might be 10 items in the chart that are for 1/9/2018 when I really only want to show 1 entry per day - a total of 30 for the month of September. I cannot work out how to apply the DISTINCT option to the above statement. It may be "lazy" but I feel I can achieve this result without creating a plethora of relationships to other tables and only modifying this statement a little. Could somebody please throw me a clue? Thank you in advance. Greg
  3. Greg Hains

    Creating a FIND from a portal check list

    Hi Steve, I thought my sample file covered my request fairly well. If not, then all I want to do is select items from a list and run a Find against those items - whatever the schema method employed may be. Thanks for your response, but that was a little over my head. I'll close this ticket before embarrassing myself any further. Greg
  4. Greg Hains

    Creating a FIND from a portal check list

    Good morning, and thank you all for your responses. You're absolutely right - without an example I'm probably only making it harder to understand what I'm trying to achieve. Attached is a rough sample file. Within are some random names of a staff register, and a table of sales made by that staff. I have loosely constructed a relationship for the portal (which may very well be the reason I am not resolving this - I'm doing it the wrong way), from which I can select names. In my case, I have a dedicated table for the staff, hence the portal. Whether I use a check box or not is purely up for discussion. Anyway, you are all more accomplished than me so you will see what I've done and what I'm trying to achieve. Many thanks in advance. Sample.fmp12
  5. Greg Hains

    Creating a FIND from a portal check list

    Hi Steve, Thanks for responding. The portal is actually a different table containing staff names, and hen we use that list to search through another table of client data for which clients that staff member assisted - if that makes sense. It is a multi-user solution, however as this is a rarely used report, it wont have users crawling all over it all the time so that shouldn't be an issue. Thank you for your help and I'll keep my ear to the ground if you find anything. I'll also keep looking. Cheers, Greg
  6. Good morning. I have a portal which has two fields displayed: a check box (a field with 0 or 1 in it), and a name. What I am trying to achieve is generate a FIND based on the names that are ticked in that portal but am not sure how. The portal may have - for example - 30 names in it, but I select 10 names from it (by ticking box against each name). I then want to extract(?) the names from that list to then do a FIND with as many New Request; Set Field [for_each_user_selected] commands as necessary. I'm not sure how to achieve this. Anybody have an idea please? Cheers, Greg
  7. Greg Hains

    Mac OS Mojave and FMPA 17

    Hi Josh, - rolling back is a big job - Recovery Mode etc. Was a brave move I admit - albeit a silly one. Thats OK - it only seems to be FM17 affected by the change. FM16 is working well. Thanks for posting.
  8. Good evening. I apologise in advance if this is not the most appropriate room for this discussion but I thought that somebody can move it if need be. I have had FMPA 17 on my Mac (High Sierra) since it was released - both worked fine for me - currently running 17.01.143. Perhaps over-ambitiously, I decided to load up the Beta of Mojave on my production machine. (did you just hear the fail tone?). When I start to work in layouts or scripts, the application crashes abruptly. The Mojave SP2 was released today and the Mac runs even better overall, but FM still dies a sudden death. Has anybody else experienced this? If so, is there a work around (and please don't preach to me about Beta OS on a production machine - it was a mistake yes, ), or if you've not installed Mojave yet, please wait until it's out of Beta. Just saying... Cheers, Greg
  9. Greg Hains

    Elapsed period query

    Thank you Olger - that worked a treat.
  10. Greg Hains

    Elapsed period query

    Hi Steve, Thanks for getting back to me. Unfortunately I couldn't get that to work - same result. I tried adding in null text at the end of the with the Case to see if it would make a difference. Nope. yr=Case(not IsEmpty(y); y & "y, "; ""); mt=Case(not IsEmpty(m); m & "m, "; "") 😕
  11. Good morning. I have the following custom function in my solution, but would like it modified. It will calculate the elapsed time in years, months and days between two dates. It works fine, however, i want it to not display any zero units for years and months. For example. It will calculate two dates and produce "0y, 0m, 15d" when I would like only "15d". Also, the likes of a two dates where the result would be "2y, 0m, 3d" to just be "2y, 3d". I do want to keep the days, even when they are zero. eg. "1y, 0d". (Even if the two compared dates are the same, "0d" is required.) I am not sure how to add further logic into the last few lines to not insert text if those year and month values are zero. Could somebody point me i the right direction please? Thanks in advance. Greg Elapsed.txt
  12. Good morning. My apologies for a very late reply. Thank you for this idea BCooney - exporting to a temporary folder, then importing it back again. (I didn't look that far - I was thinking it could be imported directly from the field.) Cheers. Greg
  13. Greg Hains

    Counting fields in related table

    Perfect! Thank you very much Olger - that's what I was looking to achieve. Cheers, Greg
  14. Greg Hains

    Counting fields in related table

    Good evening Olger Thank you for your help on this - much appreciated. I was trying to get it one step further though by counting the instances of fields in Activity with contents of the Programme field - so the result on the Client page would be: Client ID 2 OR Records found 1 CC Records found 0 C2 Records found 4 That's what I couldn't get working correctly. Any ideas how I can narrow it down in the Activity table please? Greg
  15. Greg Hains

    Counting fields in related table

    Good evening. Could somebody please help me with this? Attached is a sample solution whereby I have two tables (Client and Activity) which are linked by a single field (Client_ID). I am trying to count the records in the second table (Activity) whose Programme (field) is "OR", "CC" or "C2" - as per the layout in the Client table. The solution attached is not complete, but I am unsure how to setup the relationship so that I can count these records. Currently I am only showing the total record count in Activity. Any suggestions would be appreciated. Thanks, Greg Sample.fmp12

Important Information

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