Javascript will retire soon on end of march for Rich text fields and formula fields.

Question

Hi All,I have using the below formula for a URL field to provide the approvals in some other text field. var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])& "&_fid_33=Yes";If([CM Recommends]<>"Yes" and ([CM] = User() or [Recorder]=User() or [Current User - Allowed to Approve All DVR Items?]),"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});" & "void(0);")Now quickbase announced from April onwards we cannot use java script in QB apps except in code pages.Kindly help me how to replace the above code without java script.Regards,wowsupport------------------------------Woolworths Support------------------------------

MarkShnierYou · Answer

Your code will work fine. They will be phasing out the ability to create new fields of this type, but existing fields will not be affected. The now delayed March release has a native replacement.
https://help.quickbase.com/release-notes/march-2021-release-notes.html

Enhancements

Formula URL and rich text can now redirect to where a user started

Previously, builders had to pre-define a location for their formula buttons to redirect to, or first redirect to a custom code page. Starting in this release, a new URL pattern is available to redirect an end user to where they started. For example,

URLRoot() & "db/" & [_DBID_SUB_TASKS] & "?a=API_AddRecord"&"&rdr="&URLEncode( URLRoot()

& "db/" & Dbid() & "?a=doredirect&z=" & Rurl())

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Enhancements

Sign up

Login to the community