JS code in the URL formula field

Question

Hey,There are several URL formula fields in my application. They were created a couple of weeks ago and work great.Today I was surprised that QuickBase no longer allows me to edit them.How to solve this problem?------------------------------Andrew S------------------------------

austink · Answer

By replacing the JavaScript with something else or leaving it be and letting it work. They no longer support JavaScript unless it is in a code page. You can explore code pages or service workers for an alternative. Service workers would be the more powerful one that would be able to make some of the same changes as you do now.

For your exact formula here you are just making it reload the page which there is already a replacement for.

https://community.quickbase.com/blogs/evan-martinez1/2021/07/09/alternatives-to-common-javascript-insertion-techni?CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=recentcommunityblogsdashboard

https://community.quickbase.com/blogs/evan-martinez1/2021/07/15/javascript-upcoming-formula-rich-text-field-change?CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=recentcommunityblogsdashboard

markshnier__you · Answer

There is simple native replacement for what that URL formula is doing. Please post the code by copy paste and we can help you.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

andrews · Answer

var Number XXX = If([Active], 0,1);var text URL = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;rid=" &amp; [Record ID#]&amp; "&amp;apptoken=d7f7g4xdisdv7fdgjvh95d4d3xzc"&amp; "&amp;_fid_99=" &amp; $XXX;"javascript:" &amp;"$.get('" &amp;$URL &amp;"',function(){" &amp;"location.reload(true);" &amp;"});" &amp; "void(0);"------------------------------Andrew S------------------------------

markshnier__you · Answer

this should workvar text URL = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?act=API_EditRecord&amp;rid=" &amp; [Record ID#]&amp; "&amp;apptoken=d7f7g4xdisdv7fdgjvh95d4d3xzc"&amp; "&amp;_fid_99=" &amp; $XXX;var text RefreshPage = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl();$URL&amp; "&amp;rdr=" &amp; URLEncode($RefreshPage)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

andrews · Answer

Thanks Mark, it works fine. Is it any way to redirect and scroll down to the record that was modified?------------------------------Andrew S------------------------------

Forum Discussion

JS code in the URL formula field

6 Replies

Related Content

Replacing Hard-Coded Parameters

Formula for Header field

Formula Field Update

List function in Rich Text Formula field

Formula field error

Recent Discussions

Are all QB notifications "No-Reply" emails

Bulk create child records from selection list

Selecting which fields to display from Formula URL searches

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting

Save & Redirect in a Formula URL Using API_GenAddRecordForm