Implementing global variables...sort of

Implementing global variables...sort of

One of the big gaps in Creator is the lack of support for global variables, i.e. variables with a scope extending outside a given bit of script. The usual workaround suggested by Zoho - creating hidden fields on forms just to store temporary data - is really ugly. Three reasons it's a bad idea: a) Even if you hide the fields from all but admins, admins do have to see them (it's a pain to issue hide statements in script all the time, too); b) they aren't truly global, but are scoped to that instance of a form; c) there is no support for multiuser contention, in that the "temporary" variable values in a hidden field are actually stored in the database, so one user can stomp on another's values.

In an effort to create a simple solution to this, I created a form and two functions (a "set" and a "get") that can be cleanly and easily called whenever you need to work on a global variable. The "variables" are not stored in memory, but in a simple persistent table that can be accessed throughout the application. This approach has been suggested before, but I tried to make it cleaner by wrapping some set/get functions around it to reduce redundant coding.

This is not a perfect solution by any means, but it gets me most of the way there. Just sharing it in case useful to others. I am attaching all the code in a file.

High-level, these are the steps to implement it:

1. Create a form called globalvar per the attached source code.

2. Hide the form in your app by moving it to a "dummy" section and hiding that section.

3. In a namespace of your choosing, create a user function called setvar, copying the attached source code. This function will be globally available to your Zoho apps, so you only have to create it once. 

What this function does is c reate or update an entry in the globalvar table that associates a user-supplied variable value with a user-supplied key and the user's login identity. It is up to the developer to ensure a unique key; I usually use a prefix indicating the relevant context (e.g. a form name), with a variable name and the relevant record ID appended. You could add a timestamp if you want to be REALLY sure it's unique, but then you'd have to remember that timestamp when you go to retrieve the value again. The way I do it seems to suffice. There is an example in the attached source file.

4. Create a corresponding getvar function per the source code attached. It includes a boolean parameter that allows you to decide whether to "free" the global variable after reading its value. If you don't free it, it will persist beyond your session, which could actually be useful and in any case doesn't harm much.

5. When you need to store a global variable value in a script, simply call setvar(), When you need to get that value back, use getvar(). These can be used to hit the same variables throughout your application—i.e., they have truly global scope. So you could set a value inside the OnUpdate handler of one form and retrieve it in the OnLoad of a different form. Handy.

LIMITATIONS:

Just some I can think of....

- My sample code handles only string variables. You could create similar functions for other data types, but for my purposes this is fine; I can convert the type after retrieving the value if I need to.

- There is no automatic garbage collection upon application termination, as you might expect in a real programming language. The getvar function allows you to free a variable (= delete the record from the globalvar table), but if you forget to do it you will slowly accumulate outdated records. If Zoho exposed a session_id we'd be easily able to control this, but they don't. Overall, the effect of leaving stray records behind you is pretty benign IMHO. Note that depending on your key-naming conventions, a dangling record will simply be reused the next time the same user wants to operate on that form.

- It's up to you to make sure the lookup key you feed to setvar() is unique enough to avoid accidental overwrites by other processes, since you're storing your stuff in the database rather than in memory. This is a double-edged sword, though. By being clever in your key-naming you could decide which variables to persist session to session, across users, and there might sometimes be a good reason to do that architecturally.

So - not perfect, but anything to get rid of the clunky "hidden field" hack! I hope this is useful to someone out there until Zoho gets their act together and implements true variable scoping. (Hey, it's Christmas time, Zoho - what a nice gift that would be!)





    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.






                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts





                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner









                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ



                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方




                                                                                                                • Recent Topics

                                                                                                                • Showing the map along with mileage expense

                                                                                                                  When you use the GPS to track mileage, it shows you the map of the actual path travelled. It would be very useful and practical to save that map with the mileage expense, so that when the report is created, it provides a map of each mileage expense associated
                                                                                                                • ID:2406331

                                                                                                                  Hello, I have sent the form (ID:2406331) but no answer after two days. This is a paid subscription, I am not allowed to use the eighth paid slot of 50GB email space anymore, only 7 are being used. Is anyone going to help me please so I can use the eighth
                                                                                                                • E-Invoicing Automation

                                                                                                                  Do you have an API endpoint for pushing the invoice through the e-tims for Kenya
                                                                                                                • Transaction Rule Matching

                                                                                                                  Q1. Is there a method to have the Transaction Rules applied across multiple Bank Accounts? Q2. To match "contains" text in Transaction Rules, is a wildcard or regular expression required? Is it case sensitive? Would searching for "issue" in the following
                                                                                                                • Notebook on Mac: Fuzzy fonts in list view

                                                                                                                  Hi, I am running Notebook on Mac OS 26. Generally it works fine, and the font display in the notes themselves is crisp. However, in the notes list (left of the open note) the font of the note titles as well as first lines is noticeable fuzzy. Attached
                                                                                                                • Zoho CRM Email Templates 100% Width No Background How?

                                                                                                                  Hi, On the Zoho CRM Email Templates in setup > customization > templates > new templates > I choose blank template, but still it puts in a gray background and a max width for the email. I just want to make an email that looks like an email I would send from gmail that has no background or max width. How do you do this? 
                                                                                                                • ZOHO CRM Quote Export / Quote Report

                                                                                                                  How can I either Export my quote list, or create a Report that shows all quotes AND includes the NOTES field in a column. I attempted to Run a Report which includes ALL FIELDS, however it does not include the Notes Field (but oddly does include the fields
                                                                                                                • Introducing Radio Buttons and Numeric Range Sliders in Zoho CRM

                                                                                                                  Release update: 1. 2 March 2026: Currently out for CN, JP, AU and CA DCs (Free and standard editions). For other DCs, this will be released by mid-March. 2. 26 March 2026: CA, SA, AU, JP, CN DCs - Free, Standard, Professional, Enterprise, Ultimate, CRM
                                                                                                                • Adding a Mark Up

                                                                                                                  Can you use the discount column to be a mar up column on estimates and invoices?
                                                                                                                • Subscription Statuses - Dunning

                                                                                                                  How are other companies handling the scenario when customers don't pay and dunning takes over? Our issue is that in my situations, we want our customers to be able to catch up their late payments and continue their subscription after the dunning process
                                                                                                                • Logo Doesnt appear on email

                                                                                                                  Hi, 1. PROBLEM: mails sent to customer from zoho invoice ( Estimates and incoices etc.) Logo doesnt appaer on email. 2. SUGGESTION: there must be an option to select from google fonts if we want specific font to the pdf templates. thanks
                                                                                                                • How to see Statement Details Shown in Unclassified Transactions in All Transactions?

                                                                                                                  All, The list of Unclassified Transactions show the Statement Details and Descriptions. What is the method to see that column in the All Transactions list? -Thanks!
                                                                                                                • Non-Avalara Tax Automation wtih Zoho Books

                                                                                                                  We are paying a ridiculous amount for Avalara. Our team wants to make a change, but they're the only software fully integrated with Zoho. We also don't have the bandwidth to do this manually, so we do need some sort of automated software solution. We
                                                                                                                • Migrating to the new outgoing webhook model in Zoho Connect

                                                                                                                  Dear User, Outgoing webhooks configured in the Zoho Connect Integrations page, and used as triggers in Zoho Flow and Zapier will stop working after May 31, 2026. This is due to an upcoming upgrade to our outgoing webhook flow. This update is intended
                                                                                                                • Create formula calculations in Assemblies for scaling quantities

                                                                                                                  Something we have been encountering with our composite items is dealing with scaling of quantity of one or more items within the composite assembly relative to the number of complete units being sold. I.e. running the equation 2(n-1) on one of the assembly
                                                                                                                • Lastest update

                                                                                                                  The latest update to notepad has completely trashed all my notes. If I go to view it it just opens up a screen with a box with dotted lines around it for me to add something I can import saved nodes but you can't view them at all. Anybody else having
                                                                                                                • Tip #67- Exploring technician console: Disable Input Devices- 'Insider Insights'

                                                                                                                  Hello Zoho Assist Community! Picture this: you are in the middle of a critical remote session, carefully configuring a system or running an important update, and the customer accidentally clicks somewhere or types something that undoes your progress.
                                                                                                                • What matters more in Zoho implementations: tools or system architecture?

                                                                                                                  I recently worked on a full-stack migration for a catering equipment business using Zoho One with Shopify, and it raised a few interesting observations. The setup included migrating a large product catalog (around 9,700+ SKUs), integrating multiple supplier
                                                                                                                • [Webinar] Solving business challenges: One tool for documents, forms, PDFs, e-signatures, and more

                                                                                                                  Hi Zoho Writer users, Most businesses rely on multiple tools, such as a word processor, form builder, e-signature provider, and PDF editor, for their document workflows. Managing multiple subscriptions, switching between tools, and moving data across
                                                                                                                • Deposit on invoice

                                                                                                                  I'm trying to figure out how to customize an Estimate to include a Deposit/Retainer Invoice line within the Estimate. I tried creating my own custom field called "Deposit" where I manually inputted the deposit amount, which was nice. However, my employer
                                                                                                                • Zoho NOTEBOOK: What are file size restrictions?

                                                                                                                  I understand that Zoho NOTEBOOK is a free product, and what it offers is great. But I'm wondering what the file size restrictions are. When I record an audio note in Zoho Notebook, what is the maximum length of recording time/audio file size? When I wish to upload MP4 video, what is the maximum video size I can upload per Zoho Notebook restriction? Moreover, does Zoho Notebook use its own storage structure, or can I upgrade my storage for Zoho Notebook to add larger file attachments, videos and audio
                                                                                                                • Concern Regarding Stock Validation in Inventory Management

                                                                                                                  Hi Zoho Team, We would like to highlight a concern regarding stock validation in the inventory system. As per standard inventory management practices, if the stock level is zero, the system should not allow users to create a shipment, packing slip, or
                                                                                                                • Automation Series #2: SLA vs Supervisor Rule in Zoho Desk

                                                                                                                  SLA vs Supervisor Rule: Keeping tickets on track in Zoho Desk This post is part of the "Desk Automation Series," Chapter 1. Through this series, we will help you choose the right automation type in Zoho Desk by comparing commonly confused automations
                                                                                                                • Zoho Recruit - Email Relay

                                                                                                                  Good day, Has anyone succeeded in setting up an email relay for Office 365? If I add the details from https://support.microsoft.com/en-us/office/pop-imap-and-smtp-settings-8361e398-8af4-4e97-b147-6c6c4ac95353, I get the connection error. Regards, Eka
                                                                                                                • Better use of contacts

                                                                                                                  Zoho inventory has the ability to add multiple contacts to customers. However Zoho inventory doesn't currently provide a way to link a contact to objects like sales orders. This means that while you can tell what company has placed a sales order you can't
                                                                                                                • Notebook AI limits

                                                                                                                  Hi folks, Working with the AI transcription tools in Notebook, on the Mac App, which I find quite handy, but the one thing I am struggling with is the inability to either edit or copy the results of the transcript: I can't click in any of the boxes, and
                                                                                                                • Disappointment with Zoho Payments

                                                                                                                  Dear Gowdhaman, I am writing to inform you that I am removing Zoho Payments from my website. I cannot continue to disappoint my customers due to the lack of UPI support, as has been the case with my experience so far. Please note that the 0.5% transaction
                                                                                                                • Zoho Commerce B2B

                                                                                                                  Hello, I have signed up for a Zoho Commerce B2B product demo but it's not clear to me how the B2B experience would look for my customers, in a couple of ways. 1) Some of my customers are on terms and some pay upfront with credit card. How do I hide/show
                                                                                                                • Rename system-defined labels in Zoho CRM

                                                                                                                  Renaming system-defined labels is now available across all DCs. Hello everyone, Zoho CRM includes predefined system fields across modules to support essential CRM operations. Until now, the labels of these fields were fixed and could not be edited from
                                                                                                                • Introducing parent-child ticketing in Zoho Desk [Early access]

                                                                                                                  Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child
                                                                                                                • Separate Items & Services

                                                                                                                  Hi, please separate items and services into different categories. Thank you
                                                                                                                • Log a call: Call Duration for Inbound is mandatory but inbound is optional

                                                                                                                  Hi Team Can you advise on why the call duration for the inbound call type is a mandatory field? We have a use case where we are manually logging a call but do not use the call duration field. The field does not have the option to make it non mandatory
                                                                                                                • Zoho Sign 2025–2026: What's new and what's next

                                                                                                                  Hello! Every year at Zoho Sign, we work hard to make document signing and agreement execution easy for all users. This year we sat down with our head of product, Mr. Subramanian Thayumanasamy, to discuss what we delivered in 2025 and our goals for 2026.
                                                                                                                • 【開催報告】東京 Zoho ユーザー交流会 NEXUS vol.1 ~ データドリブン経営・少人数組織のCRM活用・AIエージェントの最前線 ~

                                                                                                                  ユーザーの皆さん、こんにちは。 コミュニティグループの中野です。 2026年3月27日(金)、東京・新橋にて「東京 Zoho ユーザー交流会 NEXUS vol.1」が開催されました。 今回は「マーケティング領域のZoho 活用法 × AI」をテーマに、ユーザーさん2名による事例セッション、Zoho 社員によるAIセッションなどを実施しました。 ご参加くださったユーザーの皆さま、ありがとうございました! この投稿では、当日のセッションの様子や使用した資料を紹介しています。残念ながら当日お越しいただけなかった方も、ぜひチェックしてみてください。
                                                                                                                • Monthly Webinar : Getting Started with Zoho LandingPage

                                                                                                                  Our monthly Getting Started with Zoho LandingPage webinar is back! If you're building your first page and want a little guidance, this is where to start. Learn how landing pages fit into your strategy, generate leads, and improve conversions. Here’s what
                                                                                                                • Mass emails - Allow preview of which emails will receive the email based on the criteria

                                                                                                                  Feature request. Please allow us to view and confirm the exact recipients of the mass emails based on the criteria we've chosen before sending. It can be quite sensitive if you send the mass email to some wrong accounts accidently, so it would be great
                                                                                                                • Limitation in Dynamic Constant Sum Based on Previous Question Selections in Zoho Survey

                                                                                                                  Zoho Survey supports the Constant Sum question type, allowing respondents to distribute a fixed total (such as 100) across a set of options. However, it does not support dynamically populating these options based on selections made in a previous question.
                                                                                                                • SAP Business One(B1) integration is now live in Zoho Flow

                                                                                                                  We’re excited to share that SAP Business One (B1) is now available in Zoho Flow! This means you can now build workflows that connect SAP B1 with other apps and automate routine processes without relying on custom code. Note: SAP Business One integration
                                                                                                                • sync two zoho crm

                                                                                                                  Hello everyone. Is it possible to sync 2 zoho crm? what would be the easiest way? I am thinking of Flow. I have a Custom Module that I would like to share with my client. We both use zoho crm. Regards.
                                                                                                                • CRM Client Script Buttons

                                                                                                                  Hello, Client Script ZDK list button functions, but I am not sure how to interact with them. I tried a few methods of getting the API name for a custom button, but no luck. Any ideas where the button API names are stored? Also, custom buttons must be
                                                                                                                • Next Page