Forum Discussion

WoolworthsSupp1's avatar
WoolworthsSupp1
Qrew Member
5 years ago

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

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
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------