Forum Discussion
BrianCafferelli
5 years agoQuickbase Staff
Hi Ivan,
Inserting Javscript into Quick Base formulas is an unsupported technique, and later this year we will begin blocking any new Javascript code from being added in this way. This is an important change to the platform as Quick Base was never designed for arbitrary code to be used in formulas, and it causes a lot of issues being able to support such apps and to pass them on to other admins in your company.
We're looking into improving our formula language to allow for reloading the page, but in the meantime we recommend copying your formula for each report/dashboard it appears on.
Thanks,
Brian
------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------
Inserting Javscript into Quick Base formulas is an unsupported technique, and later this year we will begin blocking any new Javascript code from being added in this way. This is an important change to the platform as Quick Base was never designed for arbitrary code to be used in formulas, and it causes a lot of issues being able to support such apps and to pass them on to other admins in your company.
We're looking into improving our formula language to allow for reloading the page, but in the meantime we recommend copying your formula for each report/dashboard it appears on.
Thanks,
Brian
------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------
- AustinK5 years agoQrew CommanderShould this be considered the announcement for Quick Base not supporting any type of JavaScript in formulas then? What happens to old formulas that are there already that have the same functionality? When will we expect to see this go live? Will there be a point where you do this to current formulas as well which will break them or will that not happen?
Maybe I missed a previous announcement but this is the very first time I am seeing this being said.- BrianCafferelli5 years agoQuickbase StaffHi Austin,
While I didn't specifically intend to break news with my above post, yes this may be the first time this change has been mentioned on this forum.
To clarify, inserting javascript code into formulas, branding, etc has never been supported but the change we're planning to make is to prevent javascript from being inserted in places where it was not already there, and to prevent changes to formulas that have previously had javascript added. javascript has always been intended to be used in code pages and that will continue.
This change will not impact existing formulas that use javascript, in that they will be continue to work as-is after the change. We currently have no plans to stop supporting that. However, this seems like a good opportunity to remind folks that it is never a good idea to use javascript that way as those formulas could stop working at any time without warning. That continues to be the case, and those formulas will become more likely to break as we work to update the Quick Base UI over the next few years (for those who leverage DOM objects in their javascript-powered qb formulas).
We'll have more details to share about these plans in the coming months.
------------------------------
Brian Cafferelli
Product Marketing Manager | Quick Base
------------------------------- AustinK5 years agoQrew CommanderThanks for the information. We for the most part avoid any of the BOL or tricks like that for this reason. We do rather prolifically use a formula similar to the above one for reloading the page as that is not something Quick Base currently offers. I think if you added the ability to reload the page in a formula like you mentioned a few posts up that would be a huge help in transitioning away from using JavaScript.