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:
- if(${Contacts.Secondary First Name}==null,${Contacts.First Name},concat(${Contacts.First Name},' and ',${Contacts.Secondary First Name}))
Any help or ideas greatly appreciated!!
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
809973758@zohoclosedAccount.com
Bhoomi Joshi
Sunderjan Siddharth
Amanda M.
Sticky Posts
Effortlessly advance through your CRM blueprints by including optional fields in transitions
Editions: Professional edition and above DCs: All Release plan: This enhancement is being released in a phased manner to customers. It will soon be available to all users. Hello everyone, Blueprints streamline processes and ensure users adhere to requiredEnhancement in Field update and date/time based triggers in Workflow
Hello everyone, Workflows allow to automatically execute a set of actions whenever the defined criteria is met. For example, whenever a new lead is created an introductory email is sent. So this action will keep occurring automatically as long as theNotes and Attachments visibility can now be restricted based on profiles
Dear All, We hope you're well! We are here with a quick update about Notes and Attachments profile permissions. In the past, a record's Notes and Attachments were visible by default to all users with record access. However, as notes and attachments canFAQs on Assignment rules - Post your questions
Dear All, Greetings! Assignment rules benefit organizations with effortless queue management capabilities. To bring more clarity on assignment rules, we are constantly publishing FAQs in our knowledge base. To ease the navigation across these FAQs further,Assign records based on user roles in an organization
Dear Customers, We hope you're well. We are excited to share a new addition to the assignment rules in Zoho CRM. When setting assignment rules, administrators can choose to automate all records or only records which match specific criteria. The criteria
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー