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

    Plugins on AWS/FmCloud for FmGo.

    Hi Olger, and thank you for responding. I ran those two commands PSOS on the iPad and nothing at all is returned. From this, I am guessing that no plugins are on the host. I also checked for Get(LastError) on both commands - I didn't even get a 0. (Given that it's PSOS, would any device running those scripts return the same result? I tried from the workstation as well as a test - same result) I'm not sure what is going on - or how to further diagnose it. Normally on FMS we can browse through the plugin folders, but am unable to do this on AWS. How else can I see what is happening please? Greg
  2. Greg Hains

    Plugins on AWS/FmCloud for FmGo.

    Hi IdealData, Thank you very much - this installation appeared to work perfectly. The Install script returned a 0. How can I tell if the plugin Installed correctly in Filemaker Cloud? (The enable install plugins is switched on.) The result from Get(InstalledFMPlugins) - I am assuming - reads from the local device - an iPad in this case so is not reporting that of Filemaker Cloud. Greg
  3. Good afternoon, I am trying to understand a problem I am experiencing with an FmGo solution. The solution is hosted on FM Cloud (AWS) and runs well on my Mac workstation, but experiences a few issues when running on the iPad. I'm also experiencing the same problem when I host it from a local Windows Server 2012 box. Using RESTful APIs (with BaseElements plugin) on my Mac workstation and I am downloading product data from a host, manipulating the data, then uploading it back to the host. I am assuming that I need to have the BE plugin running on the AWS host before FmGo can use the functions within. As no FM solution runs on the host itself (to Install Plugin), how do I install this plugin to the FMS there? (Assuming that this problem is related to plugins on FmGo). Also, without ScriptDebugging on the iPad, I have a ton of Show Custom Dialogs all over the shop trying to see where it goes wrong on the iPad. Some of the REST calls fail with authentication errors on the iPad but work fine on the desktop. Same script. Got me beat! I'm thinking it may be one and the same problem. Any help is appreciated. Thanks, Greg
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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.
  11. 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
  12. Greg Hains

    Elapsed period query

    Thank you Olger - that worked a treat.
  13. 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, "; "") 😕
  14. 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
  15. 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

Important Information

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