--- title: "January Updates: Profound UI Updates" description: Our team has been hard at work! See the Profound UI updates added January 2021, including database-driven widget support and loading animations. --- [![(877) 224-7768 <>](https://no-cache.hubspot.com/cta/default/1708946/5d9809e1-1922-4e3e-b06b-d359616d29bd.png)](https://cta-redirect.hubspot.com/cta/redirect/1708946/5d9809e1-1922-4e3e-b06b-d359616d29bd) [![sales@profoundlogic.com ](https://no-cache.hubspot.com/cta/default/1708946/4fc30eb7-f66d-4552-81e2-49cc209a5ead.png)](https://cta-redirect.hubspot.com/cta/redirect/1708946/4fc30eb7-f66d-4552-81e2-49cc209a5ead) [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.profoundlogic.com%2Fjanuary-updates-profound-ui-updates%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.profoundlogic.com%2Fjanuary-updates-profound-ui-updates%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.profoundlogic.com%2Fjanuary-updates-profound-ui-updates%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Profound Logic](https://blog.profoundlogic.com/hs-fs/hubfs/PLS_Logo.jpg?width=150&height=52&name=PLS_Logo.jpg "Profound Logic")](https://www.profoundlogic.com/) - AI-Enhanced Products - [Profound AI](https://www.profoundlogic.com/ai/) - [Profound UI](https://www.profoundlogic.com/profoundui/) - [Profound.js](https://www.profoundlogic.com/profoundjs/) - [Profound API](https://www.profoundlogic.com/api/) - Services - Futurization and Transformation - [Profound 360 Analysis](https://www.profoundlogic.com/services/profound-360-analysis/) - [Flexible IBM i Code Transformation](https://www.profoundlogic.com/services/flexible-code-transformation/) - [IBM i UX Modernization Service](https://www.profoundlogic.com/services/ibm-i-ux-modernization-service/) - [Database Modernization](https://www.profoundlogic.com/services/database-modernization/) - Integration & API Development - [System Integration](https://www.profoundlogic.com/services/systems-integration/) - [Cloud Migration Services](https://www.profoundlogic.com/services/cloud-migration-services/) - [Rapid Application Development](https://www.profoundlogic.com/services/application-development/) - [Application Development](https://www.profoundlogic.com/services/application-development/) - [Mobile Application Development](https://www.profoundlogic.com/services/mobile-application-development/) - [Company](https://www.profoundlogic.com/about-profound-logic/) - [About Us](https://www.profoundlogic.com/about-profound-logic/) - [Press Releases](https://www.profoundlogic.com/press-releases/) - [Careers](https://www.profoundlogic.com/careers/) - [Contact Us](https://www.profoundlogic.com/contact/) - Resources - [Blog](https://www.profoundlogic.com/blog/) - [Case Studies](https://www.profoundlogic.com/case-studies/) - [On-Demand Webinars](https://www.profoundlogic.com/webinars/) - [White Papers](https://www.profoundlogic.com/white-papers/) - [Product Documentation](https://profoundlogicsupport.atlassian.net/wiki/spaces/PUI/overview) - [User Forum](https://forum.profoundlogic.com/) - [Contact Support](https://profoundlogicsupport.atlassian.net/servicedesk/customer/portal/1) [![Contact Us](https://no-cache.hubspot.com/cta/default/1708946/interactive-172756632938.png)](https://blog.profoundlogic.com/hs/cta/wi/redirect?encryptedPayload=AVxigLIJotEa4UKkk1aCZFkNF%2BYf%2F42lRNnu2g%2BE5AY1p%2FrDve3g2EUZU8SnmQfA%2BkylJjNvSiG288sAf7zbJJOZrvjcOd1DEoiOpRd%2BvqYTlZOUJEHfG9ec%2FtEHz5V58VU5td%2FAYmKnkjOmjC74LfYPNGsvq4mPl94C%2BVw4ErgIIY7YVqXFpsTqJS2Q&webInteractiveContentId=172756632938&portalId=1708946) # iModernize - The Profound Logic Software Blog # January Updates: Profound UI Updates Posted by [Miranda VanHorn](https://blog.profoundlogic.com/author/miranda-vanhorn) on Jan 27, 2021 8:00:00 AM - [Tweet](https://twitter.com/share) ## Version 6 Fix Packs 10.0 – 11.0 Our team has been hard at work updating our products and services. See the latest updates for Profound UI:   ## Control Over Genie Workstation Suffixes Genie has always let you specify a workstation name and a suffix if there are duplicate names. For example, you can use a URL such the following: **http://your-ibmi:port/profoundui/genie?workstnid=DSP&suffixid=1** This uses workstation named DSP. If it is not available, it will use DSP1, then DSP2, and so forth. With Profound UI 6, fix pack 10.0, you have greater control over the suffixes that are assigned. In your httpd.conf you can specify a list of suffixes to try, for example: **SetEnv PUI\_WORKSTN\_SUFFIXES "ABC123"** With this option and the URL above, it will try workstation DSP, then DSPA, DSPB, DSPC, DSP1, DSP2 and DSP3. If none of these are available, it will give up.   In the case where you don’t want it to try without the suffix (i.e., never use just “DSP”) there’s another new option. **SetEnv PUI\_TRY\_WITHOUT\_SUFFIX N** By default, Genie always tries without any suffix first, but if you set the above option, it will always use a suffix. More information can be found here: [https://docs.profoundlogic.com/x/CYA3B](https://docs.profoundlogic.com/x/CYA3B)   ## Database-Driven Widgets Support Joins with Multiple Tables Rich Display File sessions have long supported Database-Driven widgets—grids, drop-downs, charts, and auto-complete for textboxes. These widgets allow developers to display data without programming server-side logic. However, getting data to load from multiple tables was cumbersome. New in Version 6 Fix Pack 10.0 is a tool making it easy to load data from multiple database tables. Loading data from multiple tables is now a matter of making a few clicks and dragging-and-dropping the to define the relationship between the tables. In Visual Designer you can now specify multiple tables for data: ![add another database file](https://blog.profoundlogic.com/hs-fs/hubfs/Picture8.png?width=463&name=Picture8.png) ![grid properties-database join](https://blog.profoundlogic.com/hs-fs/hubfs/Picture9.png?width=216&name=Picture9.png) Also, defining the relationship between the tables (the join) requires no programming knowledge—just drag and drop from a column in one table to one in another: ![defining relationship](https://blog.profoundlogic.com/hs-fs/hubfs/Picture10.png?width=318&name=Picture10.png) As before, you can pick which columns to use from the table. However, now with joins you can see columns from all the selected tables: ![see columns from all selected tables](https://blog.profoundlogic.com/hs-fs/hubfs/Picture11.png?width=478&name=Picture11.png) All the information needed to setup a Database-Driven widget is conveniently there in Visual Designer. Like in the past, Profound UI handles the logic for building the SQL statement on the server-side allowing for useful output: ![Profound UI handing the logic for SQL statements](https://blog.profoundlogic.com/hs-fs/hubfs/Picture12.png?width=317&name=Picture12.png) ## Week Number Property The Date Picker widget can now show a column with the week number. To enable, set the “show week number” property to true. ![column with week number](https://blog.profoundlogic.com/hs-fs/hubfs/Picture13.png?width=509&name=Picture13.png) The default setting calculates the week number within the year:![calendar view](https://blog.profoundlogic.com/hs-fs/hubfs/Picture14.png?width=413&name=Picture14.png) Additionally, different time values for the Week Number can be setup via the new API, pui\["week number calculator"\].   ## Grid Widget Loading Animations Loading grids now have animations. These will be sized according to the grid’s size and can be as small as 35x35 pixels or as large as 100x100 pixels. ![loading animations in table](https://blog.profoundlogic.com/hs-fs/hubfs/Picture15.png?width=624&name=Picture15.png) ![loading animations with smaller table](https://blog.profoundlogic.com/hs-fs/hubfs/Picture16.png?width=624&name=Picture16.png)   ## Improve the Nodes.js Templates So That the Generated Code Can Run In "case-sensitive" Mode   Prior to this version, Profound.js code generated by the Jumpstart templates must run in "compatibility" mode, since the fields defined in the generated Rich Display File are in uppercase, and the fields as referred to by the Profound.js code are in lowercase. Also, the case of some control field names (such as "btnExit") did not match between the Rich Display File and Profound.js code, requiring "compatibility" mode. Starting with Profound UI 6 fix pack 11.0, the database fields in both the Rich Display File and the Profound.js code are generated in lowercase, and the case of all control fields (such as “btnExit”) will match between the Rich Display File and Profound.js code. This lets you run your Profound.js application in the (preferred) "case-sensitive" mode. Below is an example of the new generated Rich Display File and Profound.js code from the "Subfile" template, using Language option of "Node.js". The file CUSTADRP has field CUSTNO. Rich Display File: ![rich display file](https://blog.profoundlogic.com/hs-fs/hubfs/Picture17.png?width=495&name=Picture17.png) Profound.js code: ![profound.js code](https://blog.profoundlogic.com/hs-fs/hubfs/Picture18.png?width=820&name=Picture18.png) ## Support for 5250 Pull-down Menu Bars Genie now supports the green-screen menu bar feature, such as those that would be created with the MNUBAR and PULLDOWN DDS keywords. Here’s an example of how this looks in Genie with the Classic skin: ![pull-down menu bars](https://blog.profoundlogic.com/hs-fs/hubfs/Picture19.png?width=624&name=Picture19.png) Support for 5250 menu bars and drop-down menus is also provided in Genie Macros, allowing you to script actions from both XML-style macros and Atrium. More information can be found here: [https://docs.profoundlogic.com/x/T4AM](https://docs.profoundlogic.com/x/T4AM)   Topics: [New Features](https://blog.profoundlogic.com/topic/new-features), [Profound UI](https://blog.profoundlogic.com/topic/profound-ui) Search Blog ### Subscribe to Blog Updates **....and get our "How to Get Full Business Buy-In for Your Modernization Project" ebook!** ![business buy-in ebook](https://blog.profoundlogic.com/hs-fs/hubfs/mockup.png?width=621&name=mockup.png "business buy-in ebook") ### Recent Posts ### Posts by Topic - [Events & Education (203)](https://blog.profoundlogic.com/topic/events-education) - [Application modernization (173)](https://blog.profoundlogic.com/topic/application-modernization) - [IBM i Modernization (169)](https://blog.profoundlogic.com/topic/ibm-i-modernization) - [IBM i applications (169)](https://blog.profoundlogic.com/topic/ibm-i-applications) - [Profound.js (165)](https://blog.profoundlogic.com/topic/profound-js) - [Node.js (164)](https://blog.profoundlogic.com/topic/node-js) - [Agile modernization (162)](https://blog.profoundlogic.com/topic/agile-modernization) - [IBM i (161)](https://blog.profoundlogic.com/topic/ibm-i) - [RPG (158)](https://blog.profoundlogic.com/topic/rpg) - [AS400 modernization (157)](https://blog.profoundlogic.com/topic/as400-modernization) - [iSeries (149)](https://blog.profoundlogic.com/topic/iseries) - [Legacy Modernization (141)](https://blog.profoundlogic.com/topic/legacy-modernization) - [RPG Development (85)](https://blog.profoundlogic.com/topic/rpg-development) - [AS 400 (58)](https://blog.profoundlogic.com/topic/as-400) - [Profound UI (54)](https://blog.profoundlogic.com/topic/profound-ui) - [Profound Logic (50)](https://blog.profoundlogic.com/topic/profound-logic) - [AS\_400 (49)](https://blog.profoundlogic.com/topic/as_400) - [New Features (28)](https://blog.profoundlogic.com/topic/new-features) - [Tips and Tricks (26)](https://blog.profoundlogic.com/topic/tips-and-tricks) - [Development (20)](https://blog.profoundlogic.com/topic/development) - [green screen modernization (15)](https://blog.profoundlogic.com/topic/green-screen-modernization) - [Mobile Development (14)](https://blog.profoundlogic.com/topic/mobile-development-2) - [5250 (12)](https://blog.profoundlogic.com/topic/5250) - [IBM Watson (10)](https://blog.profoundlogic.com/topic/ibm-watson) - [Press Release (9)](https://blog.profoundlogic.com/topic/press-release) - [Product Announcement (9)](https://blog.profoundlogic.com/topic/product-announcement) - [Scott Klement Health (7)](https://blog.profoundlogic.com/topic/scott-klement-health) - [Partnerships (6)](https://blog.profoundlogic.com/topic/partnerships) - [PLUS 2018 (5)](https://blog.profoundlogic.com/topic/plus-2018) - [Prime UI (5)](https://blog.profoundlogic.com/topic/prime-ui) - [Case Study (4)](https://blog.profoundlogic.com/topic/case-study) - [Enterprise Modernization (3)](https://blog.profoundlogic.com/topic/enterprise-modernization) - [Year in review (3)](https://blog.profoundlogic.com/topic/year-in-review) - [PLUS 2019 (2)](https://blog.profoundlogic.com/topic/plus-2019) - [mobile applications (2)](https://blog.profoundlogic.com/topic/mobile-applications) - [mobile mondernization (2)](https://blog.profoundlogic.com/topic/mobile-mondernization) - [2016 Survey (1)](https://blog.profoundlogic.com/topic/2016-survey) - [2019 Survey (1)](https://blog.profoundlogic.com/topic/2019-survey) - [Conversion Service (1)](https://blog.profoundlogic.com/topic/conversion-service) - [Model 3 (1)](https://blog.profoundlogic.com/topic/model-3) - [Tesla (1)](https://blog.profoundlogic.com/topic/tesla) - [connectria (1)](https://blog.profoundlogic.com/topic/connectria) - [node (1)](https://blog.profoundlogic.com/topic/node) see all ### Archive - [September 2014 (17)](https://blog.profoundlogic.com/archive/2014/09) - [March 2017 (14)](https://blog.profoundlogic.com/archive/2017/03) - [May 2017 (10)](https://blog.profoundlogic.com/archive/2017/05) - [April 2019 (10)](https://blog.profoundlogic.com/archive/2019/04) - [May 2019 (10)](https://blog.profoundlogic.com/archive/2019/05) - [February 2013 (9)](https://blog.profoundlogic.com/archive/2013/02) - [June 2017 (9)](https://blog.profoundlogic.com/archive/2017/06) - [August 2017 (9)](https://blog.profoundlogic.com/archive/2017/08) - [September 2017 (9)](https://blog.profoundlogic.com/archive/2017/09) - [October 2017 (9)](https://blog.profoundlogic.com/archive/2017/10) - [July 2017 (8)](https://blog.profoundlogic.com/archive/2017/07) - [June 2018 (8)](https://blog.profoundlogic.com/archive/2018/06) - [January 2019 (8)](https://blog.profoundlogic.com/archive/2019/01) - [March 2019 (8)](https://blog.profoundlogic.com/archive/2019/03) - [June 2019 (8)](https://blog.profoundlogic.com/archive/2019/06) - [August 2014 (7)](https://blog.profoundlogic.com/archive/2014/08) - [August 2015 (7)](https://blog.profoundlogic.com/archive/2015/08) - [December 2017 (7)](https://blog.profoundlogic.com/archive/2017/12) - [January 2018 (7)](https://blog.profoundlogic.com/archive/2018/01) - [July 2018 (7)](https://blog.profoundlogic.com/archive/2018/07) - [August 2018 (7)](https://blog.profoundlogic.com/archive/2018/08) - [October 2018 (7)](https://blog.profoundlogic.com/archive/2018/10) - [June 2014 (6)](https://blog.profoundlogic.com/archive/2014/06) - [October 2014 (6)](https://blog.profoundlogic.com/archive/2014/10) - [September 2015 (6)](https://blog.profoundlogic.com/archive/2015/09) - [April 2017 (6)](https://blog.profoundlogic.com/archive/2017/04) - [November 2017 (6)](https://blog.profoundlogic.com/archive/2017/11) - [March 2018 (6)](https://blog.profoundlogic.com/archive/2018/03) - [November 2018 (6)](https://blog.profoundlogic.com/archive/2018/11) - [December 2018 (6)](https://blog.profoundlogic.com/archive/2018/12) - [February 2019 (6)](https://blog.profoundlogic.com/archive/2019/02) - [January 2014 (5)](https://blog.profoundlogic.com/archive/2014/01) - [April 2014 (5)](https://blog.profoundlogic.com/archive/2014/04) - [October 2015 (5)](https://blog.profoundlogic.com/archive/2015/10) - [February 2018 (5)](https://blog.profoundlogic.com/archive/2018/02) - [April 2018 (5)](https://blog.profoundlogic.com/archive/2018/04) - [July 2020 (5)](https://blog.profoundlogic.com/archive/2020/07) - [January 2013 (4)](https://blog.profoundlogic.com/archive/2013/01) - [March 2013 (4)](https://blog.profoundlogic.com/archive/2013/03) - [April 2013 (4)](https://blog.profoundlogic.com/archive/2013/04) - [July 2014 (4)](https://blog.profoundlogic.com/archive/2014/07) - [May 2018 (4)](https://blog.profoundlogic.com/archive/2018/05) - [September 2018 (4)](https://blog.profoundlogic.com/archive/2018/09) - [July 2019 (4)](https://blog.profoundlogic.com/archive/2019/07) - [September 2013 (3)](https://blog.profoundlogic.com/archive/2013/09) - [March 2014 (3)](https://blog.profoundlogic.com/archive/2014/03) - [July 2015 (3)](https://blog.profoundlogic.com/archive/2015/07) - [November 2015 (3)](https://blog.profoundlogic.com/archive/2015/11) - [January 2016 (3)](https://blog.profoundlogic.com/archive/2016/01) - [March 2016 (3)](https://blog.profoundlogic.com/archive/2016/03) - [April 2016 (3)](https://blog.profoundlogic.com/archive/2016/04) - [September 2016 (3)](https://blog.profoundlogic.com/archive/2016/09) - [October 2019 (3)](https://blog.profoundlogic.com/archive/2019/10) - [June 2020 (3)](https://blog.profoundlogic.com/archive/2020/06) - [August 2020 (3)](https://blog.profoundlogic.com/archive/2020/08) - [November 2013 (2)](https://blog.profoundlogic.com/archive/2013/11) - [February 2014 (2)](https://blog.profoundlogic.com/archive/2014/02) - [May 2014 (2)](https://blog.profoundlogic.com/archive/2014/05) - [November 2014 (2)](https://blog.profoundlogic.com/archive/2014/11) - [January 2015 (2)](https://blog.profoundlogic.com/archive/2015/01) - [April 2015 (2)](https://blog.profoundlogic.com/archive/2015/04) - [February 2016 (2)](https://blog.profoundlogic.com/archive/2016/02) - [June 2016 (2)](https://blog.profoundlogic.com/archive/2016/06) - [July 2016 (2)](https://blog.profoundlogic.com/archive/2016/07) - [October 2016 (2)](https://blog.profoundlogic.com/archive/2016/10) - [December 2016 (2)](https://blog.profoundlogic.com/archive/2016/12) - [February 2017 (2)](https://blog.profoundlogic.com/archive/2017/02) - [March 2020 (2)](https://blog.profoundlogic.com/archive/2020/03) - [April 2020 (2)](https://blog.profoundlogic.com/archive/2020/04) - [May 2020 (2)](https://blog.profoundlogic.com/archive/2020/05) - [September 2020 (2)](https://blog.profoundlogic.com/archive/2020/09) - [October 2020 (2)](https://blog.profoundlogic.com/archive/2020/10) - [January 2021 (2)](https://blog.profoundlogic.com/archive/2021/01) - [November 2012 (1)](https://blog.profoundlogic.com/archive/2012/11) - [December 2012 (1)](https://blog.profoundlogic.com/archive/2012/12) - [May 2013 (1)](https://blog.profoundlogic.com/archive/2013/05) - [June 2013 (1)](https://blog.profoundlogic.com/archive/2013/06) - [July 2013 (1)](https://blog.profoundlogic.com/archive/2013/07) - [August 2013 (1)](https://blog.profoundlogic.com/archive/2013/08) - [October 2013 (1)](https://blog.profoundlogic.com/archive/2013/10) - [December 2013 (1)](https://blog.profoundlogic.com/archive/2013/12) - [December 2014 (1)](https://blog.profoundlogic.com/archive/2014/12) - [March 2015 (1)](https://blog.profoundlogic.com/archive/2015/03) - [May 2015 (1)](https://blog.profoundlogic.com/archive/2015/05) - [May 2016 (1)](https://blog.profoundlogic.com/archive/2016/05) - [November 2016 (1)](https://blog.profoundlogic.com/archive/2016/11) - [January 2017 (1)](https://blog.profoundlogic.com/archive/2017/01) - [August 2019 (1)](https://blog.profoundlogic.com/archive/2019/08) - [December 2019 (1)](https://blog.profoundlogic.com/archive/2019/12) - [November 2020 (1)](https://blog.profoundlogic.com/archive/2020/11) - [December 2020 (1)](https://blog.profoundlogic.com/archive/2020/12) see all #### Related Resources - [\[fa icon="caret-right"\] Benefits of Modernizing Legacy Systems](https://www.profoundlogic.com/benefits-of-modernizing-legacy-systems/) - [\[fa icon="caret-right"\] Customer Satisfaction and Supply Chains](https://www.profoundlogic.com/customer-satisfaction-and-supply-chains/) - [\[fa icon="caret-right"\] Why Your Business Must Modernize Its Legacy Applications](https://www.profoundlogic.com/why-your-business-must-modernize-its-legacy-applications/) - \[fa icon="caret-right"\] Coding in 2021 and Beyond: Is Node.js Dead? #### Recommended for you - [\[fa icon="caret-right"\] The Importance of API Security to Protect Sensitive Business Data](https://info.profoundlogic.com/the-importance-of-api-security-to-protect-sensitive-business-data) - [\[fa icon="caret-right"\] Why API Matters for Enterprise Development](https://info.profoundlogic.com/why-api-matters-for-business-development-whitepaper) - [\[fa icon="caret-right"\] The Cost of Technical Debt to Business on IBM i](https://info.profoundlogic.com/technical-debt) - [\[fa icon="caret-right"\] Node.js for Enterprise IBM i Modernization](https://info.profoundlogic.com/node) #### Watch now on demand - [\[fa icon="caret-right"\] What is Code Transformation?](https://info.profoundlogic.com/code-transformation-stage-one) - [\[fa icon="caret-right"\] Transform IBM i/AS400 Now](https://www.profoundlogic.com/transform-ibm-i-as400-now/) - [\[fa icon="caret-right"\] Profound API, Low-Code and Product Updates Announced at PLUS 2020](https://info.profoundlogic.com/plus2020) - [\[fa icon="caret-right"\] IBM i Transformation Risks Every Business Leader Should Know](https://info.profoundlogic.com/transformation-risks-wod) #### Company - [\[fa icon="caret-right"\] About Us](https://www.profoundlogic.com/about-profound-logic/) - [\[fa icon="caret-right"\] Press Releases](https://www.profoundlogic.com/press-releases/) - [\[fa icon="caret-right"\] Events and Webinars](https://www.profoundlogic.com/events/) - [\[fa icon="caret-right"\] Careers](https://www.profoundlogic.com/careers/) - [\[fa icon="caret-right"\] Partnerships](https://www.profoundlogic.com/partnerships/) - [\[fa icon="caret-right"\] Contact Us](https://www.profoundlogic.com/contact/) [Sign up for our newsletter](https://www.profoundlogic.com/newsletter-signup-profound-logic/) | [Developers](https://docs.profoundlogic.com/) | [Blog](https://www.profoundlogic.com/blog/) | [Privacy](https://www.profoundlogic.com/privacy-policy) | [Contact](https://www.profoundlogic.com/contact/) | [1-877-224-7768](tel:877-224-7768) Copyright © 2026 Profound Logic Software | [Sitemap](https://www.profoundlogic.com/sitemap.xml) \[fa icon="chevron-up"\] ![](https://www.facebook.com/tr?id=237478240316292&ev=PageView&noscript=1)