IF statement to join 2 first names only

IF statement to join 2 first names only

I have set up on a contact layout to have a partner/spouse with secondary first and last name fields. 
I'm trying to set up a formula field where if the secondary name is empty, the only the first name will appear in the 'letter' formula field, but if there is a secondary name then the formula should conjoin the two names together as "name and name2". 

I've tried to do this as both boolean and string, but each time it gives a bracket error but I cannot find the error to resolve. 

I am unsure if I should be using ==null, or empty, or something else for the IF statement to check if the text field in question is empty or not. If I use just the concat part of the code I receive no errors, it is only when trying to include it as part of an IF statement.

The code I am using: 
  1. if(${Contacts.Secondary First Name}==null,${Contacts.First Name},concat(${Contacts.First Name},' and ',${Contacts.Secondary First Name}))
Any help or ideas greatly appreciated!! 

    Access your files securely from anywhere







                          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 Writer

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ











                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Is it possible to link a CRM field or Zoho User to a ticket auto assign function.

                                                                                                            Dear Support, I have a unique situation at our company. So I know it might be able to link a ticket to the client account owner from the CRM. However, is it also possible to link an email field, username or other field in the CRM to a new ticket created
                                                                                                          • Boost your Zoho Desk's performance by archiving tickets!

                                                                                                            The longer your help desk operations are, the more likely it is to accumulate tickets that are no longer relevant. For example, ticket records from a year ago are typically less relevant than currently open tickets. Such old tickets may eventually lead
                                                                                                          • How to overcome Zoho Deluge's time limit?

                                                                                                            I have built a function according to the following scheme: pages = {1,2,3,4,5,6,7,8,9,10}; for each page in pages { entriesPerPage = zoho.crm.getRecords("Accounts",page,200); for each entry in entriesPerPage { … } } Unfortunately, we have too many entries
                                                                                                          • Drill Down - Pivot Table

                                                                                                            Is there anyway to have drill down options in pivot tables like in the chart function?
                                                                                                          • Allow Zoho form to send to one of our ogranizations groups

                                                                                                            All emails from the form submission are being held for moderation. I have permissions set to organization members, and I think I have the forms setup in our DMARC
                                                                                                          • Kanban view - which modules support this view?

                                                                                                            Recently (a few days ago), we started exploring Zoho Recruit and like to use Kanban view to visualise the data in different modules. I just found out from emailing Zoho Support that they need to enable Kanban view for different modules (why?). Which modules
                                                                                                          • Email notification for followers

                                                                                                            Is there a way to enable email notification for followers of a support ticket? ie: Ticket #123 is owned by Agent#1, Agent#2 adds themselves as a follower. Whenever ticket #123 receives an email from the customer, Agent#1 receives an email. Agent#2 would
                                                                                                          • Prevent duplicate with custom fields?

                                                                                                            I was wondering something about custom field/custom modules in Zoho Desk. For some reason you can make a custom field mandatory but not unique? For example, if I create a custom module to manage equipment and renewal and make a field serial number no
                                                                                                          • Remove the dot menu and + sign on sub form

                                                                                                            If I don't want the user to be able to add more entries on a subform, am I able to remove the dot menu and the + sign?
                                                                                                          • Writing Checks to Employees for Reimbursable Expenses

                                                                                                            I couldn't find a way to write a check through books or expense to an employee for reimbursable expenses. The expense created an entry in the system with a debit (expense) credit (liability). I entered a bill and used the liability account so it would
                                                                                                          • Peppol Malaysia API

                                                                                                            Hi Zoho Books, my country Malaysia will going to implement "Peppol" (E-Invoicing), starting 1 Jul 2025 for all businesses. The government intends to provide API for accounting app. The workflow involves creating an invoice from accounting app, triggers
                                                                                                          • Pipeline in Custom Modules

                                                                                                            I love the way the Sales Pipeline looks and functions with reports. I would like to add the save pipeline features and visualization to a custom module, however, I only see that these pipelines are only available for the Deals module. Is there a way to add pipelines to custom modules?
                                                                                                          • Error "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required"

                                                                                                            Hi, I'm trying to send an email via the SMTP server using C# code but getting the following error: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required" I know the username
                                                                                                          • What's New in Zoho Inventory | January - March 2025

                                                                                                            Hello users, We are back with exciting new enhancements in Zoho Inventory to make managing your inventory smoother than ever! Check out the latest features for the first quarter of 2025. Watch out for this space for even more updates. Email Insights for
                                                                                                          • Latência

                                                                                                            Estou com bastante latência 200ms em São Paulo Brasil para o endereço mail.zoho.com, e email demora para carregar as vezes trava como está por ai ? segue print sabem se é normal ? ping
                                                                                                          • Home and Reports Tabs Not Loading

                                                                                                            Hello, I've been trying to view the home and report tabs since yesterday but the same issue persists. While the Home view appears, the data will not load (see screenshot). The Report view does not load at all. Clicking the tab elicits no response; the
                                                                                                          • Introducing the Zoho CRM Lead Magnet plugin for Wordpress

                                                                                                            In this digital era, websites are the most important source of leads. That means your CRM system should be well integrated with your website to contextually capture each and every visitor to turn them into a lead. Introducing the Zoho CRM Lead Magnet plugin for WordPress.  The plugin lets you to: Create webforms using Zoho CRM forms/ Contact form 7 plugin Embed them in your website hosted using Wordpress Automatically capture leads into Zoho CRM with zero attenuation. Not only is the integration
                                                                                                          • Importing into Multiselect Picklist

                                                                                                            Hi, We just completed a trade show and one of the bits of information we collect is tool style. The application supplied by the show set this up as individual questions. For example, if the customer used Thick Turret and Trumpf style but not Thin Turret,
                                                                                                          • Can't call function with ZML Button

                                                                                                            Hi, I have a page where I have a subform and a button made in ZML. My initial goal is simply that onClick, I call a function that updates multiple entries. Even though the function exist, I am unable to reference it. If I try to reference it manually
                                                                                                          • Team Modules in Zoho CRM: Empower Every Team, Break Silos and Boost Collaboration

                                                                                                            Hello Everyone, The ultimate goal of every business is to achieve customer delight—and achieving customer delight cannot happen with the effort of a single person or team. At Zoho CRM, we believe that it’s a shared mission that spans across your entire
                                                                                                          • Trying to integrate gmail but google keeps blocking Zoho access for integration??

                                                                                                            hi i am trying to integrate a gmail account so can track/access business emails this way. I have followed the instructions but after selecting my email account it gets re-routed to this message (screengrab below) Can anyone advise a way around this or
                                                                                                          • Zoho Projects - Give Project access to developer (external)

                                                                                                            We have a client using Zoho Projects and would like to invite several external users and assign the Projects because the Project tasks are outsourced to other companies. What is the best way to give access to external Users and is there any limitations
                                                                                                          • External calls & email notification limits

                                                                                                            Salut, I was doing some testing of SMS and Email notification yesterday, on the development environment, and got an error due to External calls exceeded. I know that my plan has 100 email & external calls limit, but in my billing page, I do not see those
                                                                                                          • DORA compliance

                                                                                                            For DORA (Digital Operational Resilience Act) compliance, I’ll want to check if Zoho provides specific features or policies aligned with DORA requirements, particularly for managing ICT risk, incident reporting, and ensuring operational resilience in
                                                                                                          • Introducing the Germany Tax Edition !

                                                                                                            Whether you're operating within Germany, trading outside the country, or dealing with customers within or outside the EU, our new Germany Tax Edition makes navigating the complexities of VAT management a cakewalk. Our Germany tax edition allows you to
                                                                                                          • How to get custom estimate field to display on existing or new services?

                                                                                                            I am using FSM. I recently added a new custom field to Service Details to help categorize my services. I can see the newly added field as a column on the service list view. However, when attempting to update an existing or create a new service, I don't
                                                                                                          • Add Support for Google reCAPTCHA v3 in Zoho Forms

                                                                                                            Hello Zoho Forms Team, We appreciate the security measures currently available in Zoho Forms, including Zoho CAPTCHA, Google reCAPTCHA v2 (checkbox), and reCAPTCHA v2 (Invisible). However, we would like to request the addition of support for Google reCAPTCHA
                                                                                                          • Centralized Organization Information Management in Zoho One

                                                                                                            Dear Zoho One Support, I'm writing to propose a feature that would significantly improve the user experience and streamline data management within Zoho One. Current Challenge: Currently, managing organization information across various Zoho One apps requires
                                                                                                          • Please add custom sort in Windows ver. of Notebook!

                                                                                                            Dear Zoho, I love the custom sort (drag and order notes) in the Android version of Notebook, but when I sync onto the Notebook on Windows, the note orders all get messed up because it doesn't support custom sorting yet. This makes it impossible to do
                                                                                                          • Office 365 is marking us as "bulk"

                                                                                                            All of a sudden (like a couple of days ago) all of our customers who are on Office 365 are getting our mails in their junk email. This is not the case with Gmail or other random mail servers, nor between us. We got a 10/10 score on mail-tester.com. Also,
                                                                                                          • error while adding a domain

                                                                                                            I am adding a domain to admin console but they're showing this kind of error! pls help me with this.
                                                                                                          • Unable to add estimate field to estimate template

                                                                                                            I have the field "SKU" as part of my service data. I can also see it as a column when displaying the list of services. However, I have no way to include it on my estimate template because the field is not showing as a column field to include for the service/part
                                                                                                          • Pivot Table - Zoho Analytics

                                                                                                            I'm creating a Profit and Loss chart in Zoho Analytics using the Pivot Chart feature. While Net Profit can be calculated using the total value, I also need to calculate and display the Gross Profit/Loss directly within the chart. To do this, I need to
                                                                                                          • Including attachments with estimates

                                                                                                            How can attachments be included when an estimate is sent/emailed and when downloaded as a .pdf? Generally speaking, attachments should be included as part of an estimate package. Ultimately, this is also true for work orders and invoices.
                                                                                                          • Add Hebrew Support for Calendar Language in Zoho Forms

                                                                                                            Dear Zoho Forms Team, Greetings! We are using Zoho Forms extensively and appreciate its versatility and ease of use. However, we’ve noticed that the Calendar Language settings currently do not include Hebrew as an option. We would like to request the
                                                                                                          • Ask the Experts 20: Level up your Business with Zia

                                                                                                            Hello everyone! We're excited to reconnect with you again. The recent sessions of our Ask the Experts series have contributed to valuable conversations, beginning at the live sessions and evolving into one-on-one conversations and remote-sessions where
                                                                                                          • Ability to Remove/Change Zoho Creator Admins via Zoho One Interface

                                                                                                            Dear Zoho One Team, Greetings, We would like to request a feature enhancement in Zoho One. Currently, it is not possible to remove or downgrade a user with the Admin role in Zoho Creator from the Zoho One admin interface. Unlike other Zoho apps where
                                                                                                          • Company centric layout

                                                                                                            Hey everyone, I want to have an "account-centric" Zoho, where the main part is the "Account" and other parts like "Contacts", "Deals", "Projects" are linked to this "Account". Tricky part is, that I have different layouts for different departments, and
                                                                                                          • CRM HAS BEEN SOOO SLOW For Days 05/15/25

                                                                                                            I have fantastic Wifi speed and have zero issues with other websites, apps, or programs. It takes an excruciatingly amount of time to simply load a record, open an email, compose an email, draft a new template, etc. Am I in a subset/region of subscribers
                                                                                                          • Announcing Zoho Community Developer Bootcamps in India – Catalyst by Zoho

                                                                                                            Hey everyone! Following the success of the first set of bootcamps on SalesIQ Zobot and Extensions last year, we're ready for the next set of bootcamps—this one dedicated to Catalyst by Zoho! These bootcamps are aimed to empower developers to build, scale,
                                                                                                          • Next Page