--- title: "Clarity PPM | Quick Tips: How to Update a Field through a Gel Script" description: In this Clarity PPM quick tips video from Rego Consulting, expert guide James Gille shows how to update a field through a gel script. image: https://blog.regoconsulting.com/hubfs/Quick_tips_gel.jpg --- [![Rego-Logo_Notag-Color-350](https://blog.regoconsulting.com/hs-fs/hubfs/Rego%20Guide%20Images/Rego-Logo_Notag-Color-350.png?width=224&name=Rego-Logo_Notag-Color-350.png)](http://regoconsulting.com) - [Home](http://regoconsulting.com) [![Quick_tips_gel.jpg](https://blog.regoconsulting.com/hubfs/Quick_tips_gel.jpg)](https://blog.regoconsulting.com/hubfs/Quick_tips_gel.jpg) # Clarity PPM | Quick Tips: How to Update a Field through a Gel Script  James Gille, Clarity PPM Solutions Consultant   Today James Gille, Clarity PPM Solutions Consultant at Rego Consulting, shows us how to update a field through a gel script. Read his instructions beneath the video player. ## Training Video  #### [How to Update a Field through a Gel Script](https://youtu.be/Kp34t70Qves)   ### Clarity PPM |Update Field Status For this exercise, we have created a custom object off of the project object called "Project Actuals." We access it via Home > Portfolio Management > Projects > Akhila Sample > Properties > Project Actuals List > PA000044. That object will have field called "Status." It currently reads "New." We're going to update that field to a different status: "Processing." To do so, we'll use a gel script. ### Create a Gel Script To update the status of our object to process, we'll create a gel script in the text editor of our choice. This is Notepad++. You'll include the name spaces that you need to update a field, which requires including the gel name space for the GEL Tag Library and the SQL name space to update SQL. xlmns:gel="jelly:com.niku.union.gel.GELTagLibrary" xmlns:sql="jelly:sql" You'll first want to define your database connection to the Niku schema. And then you'll create an update statement using the update tag, to update that specific "rego\_status" field. In doing so, we're going to be passing in a parameter from our process, using the gel\_objectInstanceId. And we will now put this into a process, by copying the data in our text editor. To see the entire Gel Script we use in this demo, visit [How to Update a Field Through a Gel Script.](https://youtu.be/Kp34t70Qves) ### Create a New Process Take your copied text back into Clarity PPM, and create a new process via Administration Menu > Data Administration > Processes > New. Create a "Process Name" and "Process ID," like "Update Field" and "update\_field." Select "Save." ### Tie a Process to an Object After you've created your new process, tie it to an object via Objects > Add Primary Object > Object Type. Here we select our "Project Actuals" Object. Save and Return. ### Add an Action to a Step Then we want to add an action to a step, to implement that Gel Script. So we go to the "Start Step" tab and select New > Custom Script > Next. Define an "Action Name" for your script. James writes "Execute Script" and his "Action ID" is "execute\_script." We'll copy that script code into the "Custom Script" field and select "Save and Return." Back on the previous page, we need to finish our process by choosing a post condition via Select Step > Finish > Add > Return. ### Validation to Activate the Process Go to the "Validation" tab for the process. Select "Validate All and Activate." This will activate the process, so that we can now go run it. ### Project Actuals Record We'll now go back to our project, "Project Akhila\_Sample..." On that project actuals record, we'll select the "Processes" tab and its "Available" sub-tab, check mark our process box, select "Update Field," and click "Start." ### Finish the Process Now we'll go in and finish the process. Note that the "Status" has changed to green, which means our process has finished. If we go back to the "Properties" tab, we'll see the "Status" has updated to "Processing." Nice work. That's updating a field through a gel script. --- Have an idea for a Clarity PPM Quick Tip? Tell us about it in the comments. If you want to learn more from Clarity PPM Quick Tips, check out our demo on [How to Set Stage Attribute Values.](http://regoconsulting.com/ca-ppm-quick-tips-how-to-set-stage-attribute-values/) For free Clarity PPM educational resources, follow us on [LinkedIn](https://www.linkedin.com/company/rego-consulting/), browse our [nonprofit library, the regoXchange,](http://regoxchange.com/) and join our mailing list below. ### **Let Rego Be Your Guide** Rego offers [free health assessments](https://regoconsulting.com/ca-ppm-health-assessment/), [webinars,](https://regoconsulting.com/events-ca-ppm/) and [half-day training classes for Clarity PPM](https://regoconsulting.com/free-pm-and-jaspersoft-training/) on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft.  For a full list of Clarity Services, visit [regoconsulting.com](http://regoconsulting.com/).  By [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting)|July 29, 2015 #### Share on Social Media - [Tweet](https://twitter.com/share) ### About the Author: [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting) ![Rego Consulting](https://blog.regoconsulting.com/hubfs/Blog%20Images/Rego%20Consulting.jpg) As the leading PPM, ITBM, and Work Management services provider, Rego Consulting has helped hundreds of organizations achieve a higher return on their software investment, including 50% of Fortune 100 and 70% of Fortune 20 companies. ### Related Posts ![blog_4_necessities_for_a_pmo_charter_gartner](https://blog.regoconsulting.com/hubfs/Blog%20Images/2018/February/4%20necessities/blog_4_necessities_for_a_pmo_charter_gartner.png) [Permalink](https://blog.regoconsulting.com/4-necessities-pmo-charter) #### [Clarity PPM | Four Necessities for a PMO Charter](https://blog.regoconsulting.com/4-necessities-pmo-charter) February 28, 2019 | [1 Comment](https://blog.regoconsulting.com/4-necessities-pmo-charter#comments-listing) ![upgrading_Blog](https://blog.regoconsulting.com/hubfs/upgrading_Blog.jpg) [Permalink](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) #### [Clarity PPM | Should We Upgrade to 15.5? - Modern UX Features](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) November 05, 2018 | [1 Comment](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features#comments-listing) ![regoU-Blog-changes_Linkedin_523x273](https://blog.regoconsulting.com/hubfs/regoU-Blog-changes_Linkedin_523x273.jpg) [Permalink](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) #### [Clarity PPM | Early Bird Special at RegoUniversity](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300) January 24, 2018 | [1 Comment](https://blog.regoconsulting.com/clarity-early-bird-special-register-by-january-31st-to-save-300#comments-listing) ![](https://blog.regoconsulting.com/hubfs/Podcast-episode6-01.jpg) [Permalink](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) #### [Clarity PPM | The PPM Podcast: Davey Zywiec on Reporting Strategies](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec) December 20, 2017 | [1 Comment](https://blog.regoconsulting.com/the-ppm-podcast-episode-6-davey-zywiec#comments-listing) ![](https://blog.regoconsulting.com/hubfs/regU-5-star-01.jpg) [Permalink](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) #### [Clarity PPM | 5 Reasons You Can't Miss This PPM Conference](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) November 21, 2017 | [1 Comment](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience#comments-listing) ![](https://blog.regoconsulting.com/hubfs/15_3_blog_header-01.jpg) [Permalink](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) #### [Clarity PPM | Six Things You Need to Know about 15.3](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3) October 24, 2017 | [1 Comment](https://blog.regoconsulting.com/6-things-you-need-to-know-about-ca-ppm-15.3#comments-listing) [![Rego Home](https://no-cache.hubspot.com/cta/default/2652075/655865ab-5c17-4a7d-8626-9917913749d3.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3) [![Contact Us](https://no-cache.hubspot.com/cta/default/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4) ### Subscribe to Email Updates [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Fca-ppm-quick-tips-how-to-update-a-field-through-a-gel-script%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Fca-ppm-quick-tips-how-to-update-a-field-through-a-gel-script%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Fca-ppm-quick-tips-how-to-update-a-field-through-a-gel-script%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fca-ppm-quick-tips-how-to-update-a-field-through-a-gel-script%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0Quick%20Tips%3A%20How%20to%20Update%20a%20Field%20through%20a%20Gel%20Script) ### Recent Rego Articles ### Register for updates! ![rego-logo-white](https://blog.regoconsulting.com/hs-fs/hubfs/rego-logo-white.png?width=205&name=rego-logo-white.png) As the leading PPM, Work Management, and Agile services provider, we have helped hundreds of organizations achieve a higher return on their software investment. ### CONTACT US Questions? We can help. [info@regoconsulting.com](mailto:info@regoconsulting.com) 888.813.0444 ### Stay up-to-date Get the latest news in industry best practices, thought leadership, and software updates. ### Solution Capabilities [Clarity PPM](https://regoconsulting.com/clarity-ppm/) [Rally](https://regoconsulting.com/rally/) [Apptio](https://regoconsulting.com/apptio/) [Sciforma](https://regoconsulting.com/sciforma/) [Jira](https://regoconsulting.com/jira/) [Microsoft | SharePoint](https://regoconsulting.com/microsoft/) [Smartsheet](https://regoconsulting.com/smartsheet/) [Meisterplan](https://regoconsulting.com/meisterplan-itdesign/) ### Quick Links [Our Company](https://regoconsulting.com/our-company/) [RegoUniversity](https://www.regouniversity.com/) [RegoXchange](http://regoxchange.com/) [Careers](https://regoconsulting.com/careers/)   Copyright 2022 Rego Consulting Corporation [Linkedin](https://www.linkedin.com/company/rego-consulting?trk=biz-companies-cym)[Facebook](https://www.facebook.com/RegoConsulting/)[Youtube](https://www.youtube.com/channel/UCdA5xEiDrX--y2nVX2wC1UA?view_as=public)[Twitter](https://twitter.com/regoconsulting) [Privacy Policy](https://regoconsulting.com/privacy-policy/) ![](https://dc.ads.linkedin.com/collect/?pid=14053&fmt=gif)