Problems / Struggles with new Formula Editor
Is anybody else having troubles with the new formula editors? When they announced the update I was excited, but after fighting the editor for the last 2 weeks I thought I'd ask if was just me or if...
Forum Discussion
Have a look at the screenshot of the formula editor I created for another thread:
Are There Any New Pre-Service Worker Disruptive Techniques?
https://community.quickbase.com/quickbase/topics/are-there-any-new-pre-service-worker-disruptive-tec...
The code to mockup this interface and make it operational is minimal. Although I mentioned that you could do this with a Service Worker one thing I did not discuss is where the information defining the JavaScript function is stored once the user saved the formula. All you have to do is store a blob of text in a new table named say "Page Enhancements" using fields that referenced the (1) table dbid and (2) field ID. So the Service Worker when opening QuickBase's Field Editor page would just grab the JavaSrcipt and other info saved in the Page Enhancements table through an AJAX call and slop the retrieved info into the modified page. In this fashion, it would be simple to modify or enhance any aspect of the page. If you want to auto-generate your formulas from some more convenient description you can do as I did in converting the JavaScript function on formulas function. If you don't like the ACE editor - just substitute your own favorite editor.
You may be thinking have all the enhancements such as IOL played themselves out? Hardly - there are going to be an ever increasing cornucopia of enhancements that are possible. The one I am outlining here might be called a "QuickBase Page Plugin" architecture where you could come up with your own mini forms and widgets to supercharge the interace.
Why not? We have reached singularity and fully converged now and everything is now possible.
Are There Any New Pre-Service Worker Disruptive Techniques?
https://community.quickbase.com/quickbase/topics/are-there-any-new-pre-service-worker-disruptive-tec...
The code to mockup this interface and make it operational is minimal. Although I mentioned that you could do this with a Service Worker one thing I did not discuss is where the information defining the JavaScript function is stored once the user saved the formula. All you have to do is store a blob of text in a new table named say "Page Enhancements" using fields that referenced the (1) table dbid and (2) field ID. So the Service Worker when opening QuickBase's Field Editor page would just grab the JavaSrcipt and other info saved in the Page Enhancements table through an AJAX call and slop the retrieved info into the modified page. In this fashion, it would be simple to modify or enhance any aspect of the page. If you want to auto-generate your formulas from some more convenient description you can do as I did in converting the JavaScript function on formulas function. If you don't like the ACE editor - just substitute your own favorite editor.
You may be thinking have all the enhancements such as IOL played themselves out? Hardly - there are going to be an ever increasing cornucopia of enhancements that are possible. The one I am outlining here might be called a "QuickBase Page Plugin" architecture where you could come up with your own mini forms and widgets to supercharge the interace.
Why not? We have reached singularity and fully converged now and everything is now possible.