76.4 F
Tuesday, September 26, 2023

Using ChatGTP with FileMaker | DB Services


If you keep track of the latest trends in technology or are obsessed with the Terminator franchise, then you’ve probably asked yourself, “Where will AI be in the next five years?” We’ve seen Artificial Intelligence used to generate artwork, improve patient treatment, detect insurance fraud, and much, much more. The latest entry into this trove of excitement is OpenAI’s ChatGPT. Released in November 2022, ChatGPT (Generative Pre-trained Transformer 3) is a language model designed to produce conversation-style results for its users. Because of its conversational nature, a ChatGPT integration with your FileMaker solution has the potential to increase your automation and efficiency without sacrificing the human-like feel. 

ChatGPT can be accessed for free by visiting chat.openai.com/chat. You may need to create an OpenAI account, and during high volume times, there may be some wait time before being permitted to use the site. The layout is a simple interface akin to a large text message. The AI is activated by typing and sending a message, after which the user can halt a response in progress or regenerate a completed response. 

Use Cases

The AI can handle a range of prompts from simple questions like “What is an elephant’s lifespan?” to even more subjective things such as “What is Klayton Kershaw’s best pitch?” You can even challenge it to a game of tic-tac-toe!

Chatgpt tic tac toe

Of course, for developers, a more exciting feature may be its ability to generate code or think through data models. We asked chatGPT to create a FileMaker script that will loop through a portal. Check out the results:

Filemaker chatgpt create script prompt

We also asked it for help by seeking alternatives to using an unstored calc in a FileMaker relationship:

Alternatives to unstore calculation filemaker chatgpt


The official ChatGPT API is available for $0.002 for every 1,000 tokens. In this demo, we’ll utilize OpenAI’s free GPT3 API in conjunction with Postman to generate directions on how to bake a cake. There are three parameters that help determine the AI’s response:

  1. Model/Engine– Choose between Davinci, Ada, Curie, or Babbage. Each have their own capabilities and speed of parsing text.
  2. Tokens– Required to produce text. For example, if your response requires 600 tokens, you must use 600 tokens to see the entire response. If your max is set to 300, you will only see part of the response.
  3. Temperature– Determines the overall creativity and detail of the response on a scale from 0 to 1.0.

Below are two responses in Postman from the exact same prompt (“How do I bake a cake?”) and model (Davinci), but the temperature has been increased from 0.2 to 0.9. You’ll notice the second image has more detailed steps in the instructions. 

1. Temperature = 0.2

Filemaker chatgpt postman response 1
Filemaker chatgpt postman response 2

Now, let’s see this same thing in action in our FileMaker demo. First, you’ll need to set up a JSON that contains your model, user prompt, temperature, and the max number of tokens you’d like to use. 

Filemaker chatgpt json

Then, you’ll create your cURL options and attach the previously created JSON using the line “-d @<yourJSONName>.”

Filemaker chatgpt json curl options

Lastly, make a call to “https://api.openai.com/v1/completions” using the ‘Insert from URL’ Script step.

Filemaker chatgpt api call insert from url

Using the interface on the demo file is even easier. When you open the file, simply enter your number of max tokens (we’ve chosen 400) and temperature, type in whatever prompt you’d like, and then hit the send button. Here, we’ve added the AI’s response to “How do I bake a cake?” using a temperature of 0.5.

Filemaker chatgpt integration demo file example. 5 temperature

Again, we’ve used the same prompt, but with a higher temperature to showcase the difference in detail.

Filemaker chatgpt integration demo file example 1. 0 temperature


Where will AI be in five years? No one really knows, but the emergence of technology like ChatGPT could mean reliable alternatives to search engines, wikis, and code templates. To discuss integrating your FileMaker application with ChatGPT, please contact DB Services for more information.

Did you know we are an authorized reseller for Claris FileMaker Licensing?
Contact us to discuss upgrading your Claris FileMaker software.

Download the Filemaker ChatGPT Integration File

Please complete the form below to download your FREE FileMaker file.

DB Services
DB Serviceshttps://dbservices.com
FMT's PREFERRED DBServices expert developers are able to tackle any project, whether you need guidance on a small project or want to outsource a large initiative to us. You will work with a reliable team that has the talent and experience to solve any challenge, and a culture designed around excellent customer service and building lasting relationships. Our mission is to make organizations more efficient and effective through digital transformations while offering superior service and exceptional expertise.

Share post:

crm erp


More like this

Dreamforce 2023 Developer Keynote: The Future of Development

Join President and Chief Engineering Officer, Srini Tallapragada, and...

codeLive: Einstein Studio

Join Danielle and Data Cloud product experts to view...

Pause 2023 Takes Place Next Week!

Today, as ever, two factors are essential to Pause...

Tracking Lead Status History & Conversion Rates in Salesforce

Why is a Holistic View of Your Lead Funnel...