DylanMoring
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Custom GPT: Quickbase Formula Builder - Version of ChatGPT Optimized for Writing QuickBase Formulas
I didn't do any training, per se, since that's only possible through the API at the moment, but I did develop an instruction prompt with rules and guidelines for the model to follow, as well as a list of all of the functions available for it to use. GPT-4 is very good at performing these kinds of tasks without specific training, as long as it is instructed properly. ------------------------------ Dylan Moring ------------------------------96Views0likes1CommentCustom GPT: Quickbase Formula Builder - Version of ChatGPT Optimized for Writing QuickBase Formulas
[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 ------------------------------227Views3likes4CommentsRe: HTTP error 400 from Quickbase REST api
For me it turned out to be that my client was sending properties with null values. Previously the API just ignored those, but now it's causing an issue. Updating my client code for that seemed to get rid of the error as far as I can tell. ------------------------------ Dylan Moring ------------------------------137Views0likes1CommentRe: HTTP error 400 from Quickbase REST api
I'm experiencing the same thing. I just opened a support case asking about it. My issue is occurring when updating records. The error message with the 400 error is: Request failed [400]: Bad Request: 'Value' property missing for field id 7 row #1 The payload sent by my script uses 'value' properties (with a lowercase v). The error message seems to suggest that should be 'Value', but this doesn't agree with the documentation for the endpoint: https://developer.quickbase.com/operation/upsert ------------------------------ Dylan Moring ------------------------------194Views1like3Comments