Jump to content

Greg Hains

  • Content Count

  • Joined

  • Last visited

  • Days Won


Greg Hains last won the day on June 21 2018

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. Good evening. This is a tricky one and may be a "limitation" (aka feature of IOS), but I am all ears if anybody has any ideas... My solution is for counting products, and it is recommended that user employ a bluetooth scanner (which acts as a keyboard "wedge"). The only way (as far as I can tell) for the scanner to input information to the solution is through a field currently in focus, but the OSK also displays at the same time(wedge), taking up (x) pixels at the bottom of the screen and hiding the lower part of the solution. Turning OSK off (Enable Touch Keyboard [Off]) disables the ability to enter data through a field from the scanner - even if Go To Field is used in a script. I admit to having tried many combinations of the Enable Touch keyboard command and script triggers on that field, but to no avail. Through much fiddling and fluke, I have occasionally come to a point where I only get the Previous, Next, "stack" "O" +/- and Done on the bottom of the screen - taking up minimum screen real estate, and I can access the field, but not been able to do this consistently. I would rather not have this here either but it is a slightly different state than the full OSK so thought it worth mentioning. I'm thinking that rather than fighting with IOS on this that perhaps there is another way to do this. Has anybody got any ideas that would allow me to scan into a field without this OSK giving me grief. All feedback welcome. Thanks. Greg
  2. Good morning. I am getting a status message appear at the bottom of my iPad (that black pop up bar) with my Go solution: "Old location received. New location requested". It's not a problem, doesn't seem to take long to go away, but I've never seen it before - and can't find any reference to it through Google searches. My Internet connection from the iPad is fast - it happens both on 4G and through a wireless connection. I can find no consistency as to the cause. My solution is using CURL functions, so wasn't sure if it was related to that at all - e.g. a message from the host. Can anybody shed some light on this please? Greg
  3. Hi Ocean West. Thank you for this information. I saw these Shortcut URLs before but could not see one for calculator - so thought there was another method I could employ within Filemaker. I'll keep digging in the URL Shortcut area. Cheers! Greg
  4. Good morning. Does anybody know how to launch IOS apps from Go please? I am looking to open the calculator. Greg
  5. Lee helped me on many an occasion - a generous and clever man. He will be missed. My sincere condolences to his family.
  6. Hi, I am looking to move some functionality away from BaseElements (4.0.3) and into Filemaker Pro's native functions. There are three functions that are used that I need to migrate. Could somebody please help me 'translate' the following line away from using BaseElements (BE) and into Filemaker's own functions? 1. BE_HMAC_Deprecated ( $queryString ; $$_API_Key ; BE_MessageDigestAlgorithm_SHA256_Deprecated ; BE_Encoding_Base64_Deprecated ) As I understand it, the new function would be: CryptAuthCode( data; algorithm; key) yet the BE function has four parameters, and Filemaker has only three, and I'm not sure how to "translate" the third and fourth parameters in the above line into the Filemaker equivalent. Details at: https://baseelementsplugin.zendesk.com/hc/en-us/articles/204700668-BE-HMAC-Deprecated 2. I cannot find the "BE_MessageDigestAlgorithm _SHA256_Deprecated" details on the BE web page, yet I find something with a similar name similar at: https://baseelementsplugin.zendesk.com/hc/en-us/articles/204700878-BE-MessageDigest-Deprecated If it is the same as the then what is the Filemaker equivalent? 3. Similar situation with the "BE_Encoding_Base64_Deprecated". The way the function in the command above shows no parameters being used, yet the BE reference guide (https://baseelementsplugin.zendesk.com/hc/en-us/articles/205350447-BE-Base64-Encode-Deprecated) shows a single parameter required. So as my command works with BE loaded as a plugin, I am wondering if it is even using those third and fourth parameters at all. Can anybody give me a hand please? Cheers, Greg
  7. Good evening, Some of you may already be aware, but the latest version of BE plugin for Linux (4.0.3) is causing issues when installed on FM Cloud. Filemaker and Goya (authors of BE) both acknowledge this. Goya have recommended rolling back to 4.0.2 which works fine. My question is (on top of all the other issues with FM Admin Console is giving - grrrr), I need to remove the plugin that is up there. I understand it is done via SSH. Does anybody know how to remove FM Cloud plugins please? Greg
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  • Create New...

Important Information

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