Discussions

Expand all | Collapse all

Custom functions?

  • 1.  Custom functions?

    Posted 08-03-2018 14:22
    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?


  • 2.  RE: Custom functions?

    Posted 08-03-2018 19:32
    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?


  • 3.  RE: Custom functions?

    Posted 08-07-2018 08:49
    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?


  • 4.  RE: Custom functions?

    Posted 08-07-2018 08:58
    Service Workers are supported on all major browsers:

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1744927/RackMultipart20180807-50363-hj06zn-screenshot_inline.jpg?1533632269">
    https://jakearchibald.github.io/isserviceworkerready/">https://jakearchibald.github.io/isserviceworkerready/">https://jakearchibald.github.io/isserviceworkerready/