Offline forms platform development

It would apply to any form that does not need to communicate with the QuickBase server while offline. For example a form that included a field that must be unique would require communication with the Quickbase server to insure the value entered did not already exist in another record. Simple forms that just had basic fields such as contact information would be ideal for offline usage as they don't need to communicate with the QuickBase server and can just be queued for submission and eventually submitted when network access is regained.

So there could actually be a use case for something that can solve the problem of having complex forms work offline?

You can do complex offline forms in terms of hide/show fields or sections and other manipulation of the form inputs. But when you need network access to do queries and lookups you would have to cache that data offline (the primary use of Service Workers is caching) and the task becomes much more difficult. Bottom line is that you can get QuickBase to work offline when the data collect in forms is "intake data" and not deeply related to other records.