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

    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
  2. 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
  3. 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
  4. 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
  5. 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.
  6. 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
  7. Greg Hains

    Elapsed period query

    Thank you Olger - that worked a treat.
  8. 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, "; "") 😕
  9. 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
  10. 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
  11. Greg Hains

    Counting fields in related table

    Perfect! Thank you very much Olger - that's what I was looking to achieve. Cheers, Greg
  12. 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
  13. 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
  14. Hi Docasar, I am trying to do a similar thing... I'd like to drop a CSV file into a (global) container field (for convenience rather than setting a path in concrete), then be able to read the contents of that file into one of the tables. I wasn't sure if I was able to read the contents directly (should be possible right?), but thought I could then export it back (was CSV) out to a known path (get(temporary path) in this case) then Import it back in. Whilst it's not the most elegant solution (double handling the file for sure), I was not sure how to Export it back to this temporary folder because I'm not saving an FM file - its a file within a container. Whatever the method, there must be a tricky way to import entries from a CSV that is already stored in a container field. I'm going to work on this over the next few days - if I find a solution I'll let you know. If one of you gurus out there already know a method I'm keen to learn. Thanks, Greg
  15. Greg Hains

    CURL question - API usage

    Hi Dan, Thankyou for this file. It looks great. I have sent you a private PM through FmForums as well. I have been also working with the provider in regards to the exact syntax they require. I probably wont hear back over the weekend but will get back to you once they do. Thanks for your help and look forward to working further on this question. Greg

Important Information

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