Custom functions?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Hi, I'm new to Quickbase but my background is database programming, mostly in SQL. Does Quickbase allow for custom/user functions? i.e. something I can pass variables into and receive an object/string/number back from?
Photo of TedLogan

TedLogan

  • 80 Points 75 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
The QuickBase formula language does not support user created functions.

However, if you use JavaScript with QuickBase you have functions and all the other JavaScript features and API available to you.

Also, if you use a Service Worker (which is a JavaScript API) you can create you own custom API methods such as ?API_BumpField&rid=1&fid=6&bump=1.

What are you trying to accomplish?
(Edited)
Photo of TedLogan

TedLogan

  • 80 Points 75 badge 2x thumb
Thanks, I'll read up on Service Workers.

I saw your Regex function thread and the only limitation is that I have email fields scattered around the application so I'd have to create script files for each one because the field IDs are different. Multiple files doing the same thing is total anathema to me. But maybe SW's can work. I'm assuming as that thread is two years old, service workers are fully compatible across all browsers and devices now?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,572 Points 20k badge 2x thumb
Service Workers are supported on all major browsers:


https://jakearchibald.github.io/isserviceworkerready/