[Link to Quickbase Formula Builder Custom GPT]
I've been using ChatGPT a lot this year, and have found it especially useful for writing simple code, typically in Python. I've attempted to use it for writing Quickbase formulas too, but it never got it quite right.
A couple months ago, OpenAI released the "Custom GPT" feature for ChatGPT. This allows people to create custom chatbots designed to perform specific tasks by providing instructions and reference information.
I had some free time at work, so I decided to attempt to make a Custom GPT that actually can write formulas for Quickbase. I provided some basic information on required syntax as well as a list of all of the built-functions.
The result actually seems to work pretty well!
I asked it to write a formula that calculates Sales Tax using a couple different rules, and this is what it wrote:
var number taxRate = Case([State], "State1", 0.07, // Replace "State1", "State2", etc., with actual state names and their respective tax rates "State2", 0.08, // ... add more states and their rates here 0); // Default tax rate if state is not listed
var number tax = If([Customer Type] = "General" or [Customer Type] = "Subsidized", [Subtotal] * $taxRate, 0);
var number adjustedTax = If([Customer Type] = "Subsidized", $tax / Sqrt(ToNumber([Customer Tenure])), $tax);
$adjustedTax;
This is a work-in-progress, but I wanted to share what I made in case it is useful to anyone else.
[Link to Quickbase Formula Builder Custom GPT]
You do need a ChatGPT Plus subscription to use this, unfortunately. If you are already subscribed, I'd love you to give this a try and let me know how it works for you. If you aren't, keep in mind that this is a work-in-progress, so I don't recommend getting a subscription just for this tool.
When writing requests, it's helpful to do the following:
- State the name of the field you are creating
- Describe in plain English what you want the calculation to do
- Mention the exact column names used on your table
------------------------------
Dylan Moring
------------------------------
