Allow users to display columns dynamically

Allow users to display columns dynamically

I have a table with 50 users in Column A and the dates 1 Jan to 31 Dec along Row 1.

I want users to be able to add data to the cells but would like to make it easier by allowing users to select a date and display that.

So if the user wants to add data into the cells for the 5th May how can I get it so they can only display Column A and the column for 5th May?

Thanks! 
    • Sticky Posts

    • Create and save user-specific filter views with Zoho Sheet

      The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
    • Revamped Print in Zoho Sheet—customized for paper

      The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
    • Slicers are now available in Zoho Sheet—filter your data interactively

      At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
    • Check out the new Checkbox in Zoho Sheet

      Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
    • Format and analyze spreadsheet data with Zoho Sheet's Table

      While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
    • Recent Topics

    • Use of External Email Services

      Would like the ability to use an external SMTP service to send emails campaigns in Marketing Automation.  Services like SendGrid, Maligun Amazon SES, etc
    • The difference between Zoho Marketing Automation and Zoho Campaigns

      Greetings Marketers! This post aims to differentiate between Zoho Marketing Automation and Zoho Campaigns. By the time you get to the end of the post, you will be able to choose a product that objectively suits you.What is Zoho Marketing Automation? A
    • New Customization options in the module builder: Quick Create and Detail view

      Hello everyone, We have introduced two new components to the module builder: Quick create and Detail view. The Quick Create Component It is a mini form used to create a record and associate it to the parent record from a lookup field. For example, if you have a Deals lookup in the Contacts module, then you can associate existing deals or create a deal and associate it with the contact. You can customize this Quick Create form by adding standard as well as custom fields. There is no limit to the number
    • Next Level - Turn this product into an Adobe Experience Manager Competitor

      I think Zoho Marketing Automation can best differentiate itself from the Zoho Campaigns and other Marketing related products better by tying the entire suite of marketing tools together not only in a viewable instance but in terms of developing internal
    • Leistungsdatum in Rechnungen (Zoho Books)

      Hallo, ist es irgendwie möglich den Leistungszeitraum in der Rechnung aufzuführen? Beste Grüße Aleks
    • Quickly review loan applications for maximum efficiency | Kiosk Studio Session #5

      Hello everyone, Let's take a lending institution as the context for this session. A lot of people apply for loans, and the process of reviewing these applications can be labor-intensive and time-consuming. This process is handled by loan officers and
    • How do you do ticket add ons in Backstage?

      Hi Everyone, If you wanted to have general admin tickets and allow for add ons, like camping, or car or Carbon offset. What would you do? Peace Robin
    • can change deal colors in bigin?

      can be super useful if we can change colors deals process  any way to do it?
    • Enrich your CRM data and keep them updated

      You spend a lot of your time and efforts in generating quality leads for your business. While generating leads is a challenge in itself, the real deal begins when sales reps try to nurture these leads and convert them as customers. So how equipped is your sales team with information about your leads matters a lot.  For example, you might be using webforms to generate leads and collect customer information from your website. The lesser your webform fields are, the more your sign-ups right? From optimizing
    • Zoho Finance Workshop 2025 is Happening Now!

      Hello everyone! 👋 We’re thrilled to announce that the Zoho Finance Workshop 2025 has officially started, and we've already wrapped up the event in Chennai, our home ground! After an amazing session, we're geared up to visit more cities in India and take
    • Canvas rules

      I see that we can create canvas rules. However, all I see is a way to define criteria that will control when a Canvas Rule is applied. However, I can't find a ways to define the settings that would be applied when the criteria are met for the Canvas Rule.
    • ZDC Hackathon 2024 Category-wise Winners – Zoho Creator

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho Creator – Product Category award for their outstanding innovations! Team 1: Wonderboy Thandanani MthiyaneTeam
    • Zoho marketing hub integration with WordPress WooCommerce

      Hello All,  I am a Zoho One User and we are using Zoho Marketing Hub we also have a website on Wordpress and we use Woo Commerce as our store.  im looking to find out if Zoho Marketing Hub Integrates with WooCommerce   ideally we would like to create Journeys or campaigns series based on customer behavior such as buying or already have purchased specific products. or if they go to the store but don't buy (abandon cart follow)  i saw that there is a wordpress plugin for Zoho Campaigns https://wordpress.org/plugins/zoho-campaigns/ but
    • Zoho Finance Workshop 2025 is Happening Now!

      Hello everyone! 👋 We’re thrilled to announce that the Zoho Finance Workshop 2025 has officially started, and we've already wrapped up the event in Chennai, our home ground! After an amazing session, we're geared up to visit more cities in India and take
    • Styling for Subform Fields using client script

      Currently we can add styles to list and detail page for fields using .addstyle in the Client Script But that is missing for fields of Subform We would really like the feature to addstyle for subforms in the detail page Can you please consider adding it,
    • In what case it's better to use Developer Console? Only for marketplace?

      As I can see from the documentation, the limitations are challenging. No Custom API No Page Variables No Custom Connections.
    • Client Script | Update - Introducing Subform Events and Actions

      Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce
    • Resubmit for Approval for Zoho Books Module in CRM

      The integration between CRM and Books is great, but it is incomplete in many areas. One of them is if an estimate/invoice/sales order is rejected, the users in CRM cannot resubmit it for approval. Let's face it, sales people will mostly be in CRM and
    • Zoho Finance Workshop 2025 is Happening Now!

      Hello everyone! 👋 We’re thrilled to announce that the Zoho Finance Workshop 2025 has officially started, and we've already wrapped up the event in Chennai, our home ground! After an amazing session, we're geared up to visit more cities in India and take
    • Restrict Zoho One Account Notifications to Admins

      Hi Zoho One Team, I hope you're doing well. We recently noticed that end users are receiving administrative pop-ups in Zoho One, such as the DKIM configuration notice (screenshot attached). This type of notification is only relevant to administrators
    • Create Quote does not show the "Product Description" entered as part of the Product setup.

      The product description created as part of the product setup page, does not show in the Create Quote module; The module allows for an additional description to be added but without access to the original stored description. By selecting the product from the "Product Name Lookup" pop-up, the "Product Description" part should be populated from the product record where the user is allowed to further modify it.
    • Agents can manage the Tasks on the go, now with Zoho Desk mobile app

       Hello, Everyone!    We are elated to announce one of our most asked for features 'Tasks' in the Zoho Desk app.  Agents can now create and associate tasks with a ticket and the tasks will be listed within the corresponding tickets.   Steps to access the tasks from the app:    1. Go to a particular ticket in the app. 2. Click the Tasks icon in the 'Related Information' section.  3. List of all the tasks will be displayed.    Refer to the screenshots (Android & iOS) attached below for your better understanding:
    • Accountant

      Hi if I have a commercial company with multiple sales outlets, sales representatives and multi currency, what is the best subscription you offer? thanks.
    • Sign

      My name is Dolores Houghton. I signed up for sign package by mistake. I can’t use the program and I want my money back. I have been sent various instructions on how to delete and ask for a refund. Nothing works. I am not able to get into settings for
    • Sync CRM inventory data with Zoho Books

      I just switched everything over to ZoHo books, but I am trying to find out why the CRM Estimates, Invoices, and Sales Orders created in ZoHo CRM are not then duplicated in ZoHo Books? I had Quickbooks before, and had to do everything twice, I thought
    • Zoho CRM and Books integration (related list) column customization

      I was wondering if it's possible to add more cloumns (more informations) inside the related list that we get when we enable the integration. As you see we would like to be able to add more information on the invoice (or the same for PO in vendor).
    • Adding Client VAT and BRN in our Invoice

      Hi, Following request from our clients, we need to add their respective VAT and BRN in the invoice that we issue. Could you please let us know if this is something that we can do?
    • Zoho Analytics - Level on level queries

      I am facing a limitation of having too many level on level queries however some of my queries are complex and rely on multiple joins to get my desired output. How can I bypass this limitation as this is hindering my report creation.
    • Manipulate the Date Time field using deluge

      To update the DateTime field using deluge. CurrentVar = zoho.currenttime; TimeVar = zoho.currentdate + " 10:00:00"; if(CurrentVar > TimeVar.todatetime()) { CurrentNew = zoho.currenttime.toTime("yyyy-MM-dd'T'HH:mm:ss").toString("yyyy-MM-dd'T'HH:mm:ss+04:00");
    • Support streaming display of long texts in zobot chats (usefull for chatgpt / openAI and any other AI )

      Hello, I was able to test the new features you offer to connect chatgpt or openAI assistant with built-in feature or custom code. This is great but the chat seems very slow and laggy because you don't use streaming api from openAI, so the chat has to
    • Configure Notes Title for Blueprint Transition

      It'd be very helpful to be able to configure note titles on blueprint transitions when requiring notes. This would help tie back the history of notes to the blueprint actions. We have some approval processes in our blueprint and require notes for the
    • Website not publishing

      My website with Zoho (domain purchased on Zoho) - GilmoreGirlsGetaway.com - has been active for a few months now with no problems. I went to change the template and make modifications today, but as soon as I click "Publish" it says "Error occurred while publishing - contact support". The website preview looks fine, it just won't update. Thanks, Laura
    • ZDC Hackathon 2024 Category-wise Winners – Zoho CRM Client Script

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho CRM Client Script – Product Category award for their outstanding innovations! Team 1: Marcin Duchnowski Team
    • ZDC Hackathon 2024 Category-wise Winners – Zoho CRM Custom Function

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho CRM Custom Function – Product Category award for their outstanding innovations! Team 1: Onur Gulay Team 2: Yonathan
    • ZDC Hackathon 2024 Category-wise Winners – Catalyst

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Catalyst – Product Category award for their outstanding innovations! Team 1: Raghavan P, Santhosh Kumar K, and Jayabalan
    • ZDC Hackathon 2024 Category-wise Winners – Extensions

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Extensions – Product Category award for their outstanding innovations! Team 1: Puneet Chandhok, Parv Kumra and Akriti
    • ZDC Hackathon 2024 Category-wise Winners – Zoho SalesIQ Zobot

      Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho SalesIQ Zobot – Product Category award for their outstanding innovations! Team 1: Naveenkumar M, Tulasidhasan
    • Announcing the Zohotshots of the ZDC Hackathon 2024

      Hey everyone! After 46 days of innovation, collaboration, and intense competition, the first-ever Zoho Developer Community (ZDC) Hackathon has officially concluded! 🎉 With 1079 participants, 797 teams, and representation from 45 countries across 6 continents,
    • Retrieve separate records from multiselect lookup field

      Hi, I know there are many post on this one, but I just don't get it. I have a multiselect look-up field named Delivery containing 3 different informations like this : Montreal - Tuesday - 3 to 4 pm I need to do an IF script based on the first item in
    • Cannot set Subform Multiline field to read-only using Client Script

      I am using client script to set different subform fields as read-only It works for Single Line Fields, but when I try to set a Multiline field as Read-only it doesn't work var subform = ZDK.Page.getSubform("Subform_1"); var item_Code_old = subform.getField('Item_Code_Old').setReadOnly(true);
    • Next Page