Blog Post

The Qrew Blog
3 MIN READ

AI & I

wmcada's avatar
wmcada
Qrew Champion
7 days ago

The Qrew is excited to bring voices from our Community into our blog. As both a current customer and former Quickbase staff member, Wes McAda is a long-time member of The Quickbase Qrew. If you have an interesting take or perspective on what's taking place in Tech today, and you are interested in writing a blog like the one below, please email Ben Simon at bsimon@quickbase.com.

There are many AI tools and uses to consider nowadays. There is talk about it making many jobs, from artists to software developers, redundant. As a professional developer and an occasional artist, I have used AI for both.

For example, my goofy, dad-joke loving side gets a kick out of this image:

 

As a Florida State alum and football fan, and lover of both artiodactyls and beer, just “Yay!”. It is an FSU Efes Ewe, but I capriciously digress. I guess I could have paid an artist to render this, but I probably would not have spent the money on it. AI made this silliness accessible. 

AI also makes higher value work easier.

When it comes to software development, I use AI to accelerate front end development work. With proper prompting, I can get code using HTML, CSS, and JavaScript that helps me go much quicker. I do not do a ton of front end work, but when I do, I rarely start from scratch anymore. The same goes for my Python scripts, which I sometimes use to get more out of the Quickbase API. More often than not, I use AI to get started. AI can also help provide alternative approaches for jinja templates that one may use in Quickbase Pipelines or formulas for Excel, SQL queries, or Quickbase formula fields. There are issues with the outputs, so users beware that you still need to know a thing or two about the subject matter and your context. One also needs to be careful providing inputs that may compromise confidentiality, security, or privacy. The point is that AI enables productivity so that I can focus on impact.

AI also helps me in ways that other services like Mockaroo or Canva might; I can get downloadable mock data per my specifications or color palettes in hex codes for my colorblind development work. AI helps avoid a tedious task or facilitates my handicap in this case.

One area in which there is professional/personal crossover with AI is writing. Anyone who has coded or developed a Quickbase app is familiar with the struggle of figuring out what to name variables or attributes. However, when writing emails or even something creative like one of my recent haikus, AI helps me with words. AI does not write for me; it helps me write better.

The AI tools that I generally use are Copilot and ChatGPT. I have also created agents in Boomi, but I am in early stages on how to incorporate a trained agent in a workflow yet. I am looking forward to Quickbase’s forthcoming MCP server offering with great anticipation! My expectation is that enterprises will profit greatly from AI agents when we gain greater confidence in AI’s security and can leverage its processing power on premises.

But what interests me most about AI today is how other devs like me are using it. What are some ways others in The Qrew are using AI? Share below!

Updated 7 days ago
Version 1.0

4 Comments

  • Great insights Wes! 

    AI has for sure become a big partner in my Quickbase work. A few ways I use AI right now are: 

    Creating formulas - I use ChatGPT to create quick formulas speeding up the initial create time. I always have to be careful with this, though, because it gets the syntax wrong a significant amount of times (~50% if I had to guess). 

    Code pages - I'm newer to code pages so ChatGPT has been a huge help when deciphering existing pages that I didn't make, helping me make updates to them, and a few times I've used it to streamline lengthy ones...which would have been a huge challenge for me on my own at my current skill level.

    Formula Rich Text Fields - probably one of the most used ways I leverage AI. ChatGPT excels at generating the HTML for buttons and user messages. It even does a decent job incorporating the logic rules I have in those fields (again staying cautious because of the syntax errors).

    Jinja in Pipelines - Unless it's a simple Jinja statement, I almost always use ChatGPT to help write them. This use has been cool because it introduced ways of using Jinja that I hadn't thought of before. Like most other areas I have to be vigilant because it likes to use Jinja features that aren't available in Quickbase Pipelines so I have to go back and forth sometimes to get it right.

    Even though it costs me time with syntax corrections I think it's been a positive net gain in productivity overall 

    • wmcada's avatar
      wmcada
      Qrew Champion

      I agree! these are great examples too. I should keep Rich Text Formulas in mind myself. Creating tables for them is tedious, and AI is pretty good at HTML that meets my needs.

  • Very nice - you use AI much like I do, and like you, I always have the final say. It is an odd transition to make - after spending years thinking that computer algorithms, calculators, etc were the most reliable when it comes to certain kinds of things - the most useful tool yet (LLMs) - are highly fallible. I too use GPT and Copilot, and I've seen them make some really dumb mistakes. For example, I once gave it a long list of field names and asked it to follow a pattern I had begun, wrapping them in html tags - and while the html output was ok, it actually changed some of the field names - and hallucinated some more fields that didn't even exist. It's like I have a brilliant apprentice who can do amazing things - but he's a little bit schizophrenic, and I can't ever take my eyes off of him or turn him lose on my project without tight supervision. Still - he's so damned useful that I invite him to work every single day.

    • wmcada's avatar
      wmcada
      Qrew Champion

      I absolutely agree. The quirkiness and reliability of AI make me hesitate to use it sometimes and in particular ways. Care and caution are vital!