Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Industry
    Softeare Development
  • Gender
  • Location
    Cornwall, UK

Contact Methods

  • Website URL
  • Skype

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

MartinL's Achievements


Rookie (2/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges



  1. Hi I am trying to create functionality in my FileMaker 19 solution to connect to Dropbox using oAuth2 using the Webviewer. However when I use the URL 'www.dropbox.com' for Dropbox with or without the necessary URL parameters all I get is a page saying 'Upgrade your browser to use Dropbox' with error code 409! My machine is Windows 10 with the latest version of Internet Explorer (20H2), I also have the latest versions of Firefox, Edge and Chrome and have installed the latest FileMaker V19 update as well. Also I have checked my machine for any outstanding updates and there are none. Even my previous functionality for Xero and Quickbookswhich I successfully tested some months ago is no longer working and gives the same error message. Please can someone tell me how I am supposed to upgrade Internet Explorer and to what or how to change the default browser used by the Webviewer, I have search the internet for answers but as yet I have had no luck. Thanks in advance
  2. Thank you for your reply. I will just have to download the files to my pc and then login to the local version using the FileMaker accounts and then upload again once I have finished. Martin
  3. I have just started to use FileMaker Cloud and have watched the video suggested in the email from Claris but I do not seem to be able to login to hosted database file using the [Full Access] account previously setup. I have created the Groups in the FileMaker Cloud instance which match the same one orininally created in my file, ie. Administrators and General Users and have set the accounts within the file to use the matching cloud Group. However I still cannot workout how to open the hosted file using the Admin account originally setup in the file. I have tried creating a privelege set with all of the same option ticked as the Full Access version but still no luck. Please can someone let me know if this is actually possible and if so how to se this up. Many Thanks Martin
  4. Hi JMW Yes, you would need to have an instance of the related table in the schema so you could use the table instance name in the query but it does not necessarily need to actually have a relationship to the other table. I am assuming that you have already included the Equipment file as an External Data Source. If you do not want to add the Equipment file to the Exam file at all I would consider creating a Web Service somewhere that you could call from a script in the Exam file which would then retrieve the data from the Equipment file using FileMaker xDBC or the FileMaker Dat API and then return the result back to the Exam file. I have just watched a really good presentation by Wim Decorte about Web Hooks and although it may not be exactly what you need it gives a good understanding of Web Hooks (Web Services). https://www.youtube.com/watch?v=N9GJ4sz1hSE
  5. The client needed to run the search so that they could export the found records and use them for a mail campaign. They then run the code again to find the next batch and so on until there were none left. Although the Company Name value might be duplicated the rest of the info such as the email address is not. They were trying to not bombard their clients with numerous emails at once.
  6. Hi, Thank you for all of the replies. I used Comment's option which worked realy well even with a dataset of over 50,000 records.
  7. Thank you for the reply. it is up to the first 6 duplicates of each name and the order is just in the order of creation.
  8. I have a table of data where there may be many duplicate records based on the 'Name' field, however the other fields data are different. I need to find the first 6 duplicated records based on the 'Name' field and then set a number value (incremented starting from 1 ) against them in a field used as a flag. The table may contain as many as 20,000 records with each unique 'Name' value having 0 to 50 duplicates. Does enyone have any idea how I might achieve this using a script or a custom function?
  9. If you do not want to have a relationship between the 2 table then you might want to try using the ExecuteSQL command with a SELECT statement such as SELECT Field1, Field2,Field3 FROM Equipment WHERE EquipmentID = EXAM.EquipmentUsedID Jusr replace the fields with yours then you can parse th result to get the individual field data.
  • Create New...

Important Information

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