Input list of records in Lookup
Salut,
I have 2 scripts that input list of records in a lookup. The first on works fine, the second one doesn't and I do not know why.
The only differences, is that the first one input in a lookup a list of records from an actual lookup field, and with the second one I try to input a list of records from a numerical field in a lookup field. In both cases, I get all the good ID number I need in the variables (checked with INFO command).
First script:
enable Produits_LIGNE;
clear Produits_LIGNE;
RefCat = input.Categorie_LIGNE.Categorie_OFFRE;
ListeDispo = Offre_de_produits[Quantite_offerte > 0 && Categorie_OFFRE == RefCat];
input.Produits_LIGNE:ui.add(ListeDispo.Produit_OFFRE.getall());
clear Produits_LIGNE;
RefCat = input.Categorie_LIGNE.Categorie_OFFRE;
ListeDispo = Offre_de_produits[Quantite_offerte > 0 && Categorie_OFFRE == RefCat];
input.Produits_LIGNE:ui.add(ListeDispo.Produit_OFFRE.getall());
Second script:
enable Offre_produits_LIGNE;
clear Offre_produits_LIGNE;
RefCat = input.Categorie_LIGNE.Categorie_OFFRE;
RefProduit = input.Produits_LIGNE;
RefUnite = input.Prix_Unite_LIGNE;
RefOffre = Offre_de_produits[Categorie_OFFRE = RefCat && Produit_OFFRE == RefProduit && Unite_OFFRE == RefUnite];
input.Offre_produits_LIGNE:ui.add(RefOffre.Quantite_offerte.getall());
clear Offre_produits_LIGNE;
RefCat = input.Categorie_LIGNE.Categorie_OFFRE;
RefProduit = input.Produits_LIGNE;
RefUnite = input.Prix_Unite_LIGNE;
RefOffre = Offre_de_produits[Categorie_OFFRE = RefCat && Produit_OFFRE == RefProduit && Unite_OFFRE == RefUnite];
input.Offre_produits_LIGNE:ui.add(RefOffre.Quantite_offerte.getall());
Anybody can tell me what is wrong with the second one ?
Sylvain
Topic Participants
Coordination
Karunakaran G
Recent Topics
Quotes
Has anyone figured out how to automatically upload a quote that was signed via Zoho Sign and insert it directly to that leads file and push it through the pipeline to proposal signed status?Suggestion: Smart Purchasing Module for Zoho Inventory and Zoho Books
Suggestion: Smart Purchasing Module for Zoho Inventory and Zoho Books As an active user of Zoho Inventory and Zoho Books, I’ve noticed that the suite already provides valuable tools for managing inventory, analyzing trends, and processing purchase orders.TDS Filing
Is there any option for automatic 26Q and 24Q filing in Zoho books. Even Tally has this option. Why don't Zoho has this ? Is there any customisation available for this ?Adding bank details to the contact through API
How to add bank-related information to the contact while creating it using API? The account number needs to be encrypted before sending it through API but not sure how to encrypt and get those values. Please guide me in this.average cost display
Hello there, I'm using the average cost valuation method, and the cost price shown in the Items menu should reflect the latest WAC (Weighted Average Cost). However, it doesn't update automatically. Is there a way to display the current average cost withoutApple Mail issues
Dear Sir or Madam, I am trying to configure my Zoho mail account to Apple Mail. It is not working. It seems to need more information (perhaps a path prefix?) than is shown in your tutorial (<www.zoho.com/mail/help/apple-mac-imap.html>). After pluggingAssistance Required for Migrating Data from Odoo Inventory to Zoho Inventory
Hi Team, I previously used Odoo Inventory to manage my stock and transactions, and I’ve now moved to Zoho Inventory. I’d like to migrate my data from Odoo—including product details, stock, purchase, and vendor information- into Zoho Inventory for continuityClient 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 introduceI need my entire Zoho Account (mail/organization) deleted!
Hey! I used zoho for my email aaron@aaronglass.me with domain forwarding/mx all that. I got rid of the mx info on my godaddy account and still Google won't let me sign up with my aaron@aaronglass.me email. (I'm moving to Google for business) SO! I wasError: "Invalid Element warehouse_id" when sending order to Zoho
i'm getting the error "Invalid Element warehouse_id" when trying to send an order to Zoho via API. Has anyone faced this issue before? How can I fix it?No way to sell individual and case units smoothly in Zoho
Currently, Zoho Inventory handles inventory primarily at the case level, which can be challenging for businesses that frequently need to break down cases into individual units for retail sales or smaller shipments. Although Zoho Inventory currently supportsHow to handle multiple languages (Resume parser, Job opening, job board, career site) ?
We are looking to bring Zoho Recruit to a market that needs to support 2 languages. The first thing we need to make sure is that the Candidate be flag with the language they speak. This is easy enough make a custom field that as the desire languages.Multi-Card Selection and Cross-Zobot Copy-Paste Functionality
Dear Zoho SalesIQ Team, We’d like to suggest a productivity-enhancing feature for the Zobot builder in Zoho SalesIQ: the ability to select multiple cards (modules) at once using a selection area, and then copy-paste them either within the same canvasShipping Labels
Hi, Can we generate Packing Labels for manual shipping same as the format as Airway Bill in zoho books or inventory?Add a Way to Duplicate Cards in the Same Canvas (Retain All Settings)
Dear Zoho SalesIQ Team, We would like to request a new feature in Zoho SalesIQ: the ability to duplicate an existing card within the same canvas while retaining all of its information and settings, including conditions, configurations, and display preferences.Session "Ask Me Anything" Zoho France - Le 26 Juin 2025 14h à 17h (en Français
Chers Utilisateurs, Vous cherchez à mieux comprendre Zoho CRM ou Zoho Desk ? Nos experts seront disponibles pour répondre à toutes vos questions lors de notre session Ask Me Anything. Rejoignez-nous ici pour en discuter en ligne. Pendant trois heures,How to work with getFieldNames formdata functions ,Any Examples
I don't find any example showing usage of getFieldNames. Where do i find .is there any Help documents availableEmpowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM
Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individualsManaging two books in Zoho Books
is it possible to effectively manage two separate books within Zoho Books? My organization is considering handling accounting for two distinct subsidiaries, and we would like to understand the best way to achieve this within the Zoho Books.Unit Measurement Sign,
Dear Zoho Support Team, I hope you are doing well. We recently purchased Zoho Inventory based on recommendations of your team that “it would be a great fit for our Shopify operations”. However, we are currently facing several urgent issues that requireLeadchain into a custom module
Hello ZOHO Community ! is it possible to put the leads collected by leadchain into a custom module instaed of leads module ? Best wishes NielsDeluge script issue : Mismatch of data type expression. Expected BIGINT but found STRING
I'm building a Zoho Creator form to take inputs for Email, Bootcamp Name, and Tag. If a record with the same Email + Bootcamp exists in a custom module (bootcampattendence), I want to update it by adding a new tag. If it doesn’t exist, I want to createUrgent: How to Bulk Upload Images in Zoho Inventory? Any Workarounds?
We are currently onboarding 5,000+ items from Shopify into Zoho Inventory, but we’re struggling with the lack of a bulk image upload feature. Right now, we have to manually upload and assign images one by one, which is extremely time-consuming and inefficient.Can I automatically update COGS and Inventory account when creating an item?
I have been trying to get Zoho to update the other two fields when I update one (Sales Account, COGS account, and Inventory Account). I know this seems like not a huge time saver, but I am all about efficiency and being an independent taproom, I createI'm looking for a Microsoft List alternative in Zoho One to manage large lists of repetitive tasks
I've used Microsoft Lists to manage lots of tasks that need to be completed several times for different users. We started with a large spreadsheet and then discovered lists, which worked pretty well. I was wondering if there is a similar products in Zoho,Importing a contact with a linked product
Hi, I'm trying to import my contacts from an excel spreadsheet and each of those contacts have fields that relate to products. Is there a way that I can import the contact with their linked product? Some of the contacts in my spreadsheet have multipleNew features and improvements in Desk's integration with Zia powered by GPT
Hi everyone, We’re pleased to announce several new enhancements in Zia Powered by GPT integration. These updates bring more customization options, improved response generation, and additional language support. Below is an overview of the enhancementsZoholics Europe and UK Awards 2025: Honouring our loyal customers!
We're excited to announce that at this year's Zoholics events across Europe, we're holding customer awards for the first time ever! This is your chance to shout about the amazing things you've created, connected, or achieved with Bigin! And if you win,Zoho Landing Page "Something went wrong" Error
Hello, Every time I try to create a new landing page, I receive a "Something went wrong" error with no explanation. I cannot create any new pages, which means we cannot use this application. I did create one landing page successfully over a month ago,In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote
In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote Pls help how i fix thisCRM - Workflow Rules to be applied and work across modules
Hello, It seems that you can't use workflow rules in CRM to work across modules, is this correct? I need a customer account status to be changed IF there have been no new deals or new quotes in the last 6 months. I can't see this is possible? I can createI wan to schedule a meeting report From previous Thursday to this thursday of this week on Every 6 pm want to recive this report in zoho CRM
I wan to schedule a meeting report From previous Thursday to this thursday of this week on Every 6 pm want to recive this report in zoho CRM. How I Can achive this in Zoho CRM.Fillable template with dynamic tables?
Is there a way to build a fillable template so that users can add rows to a table? To describe what I'm trying to accomplish the table has 3 sections; a header row, some number of rows with custom information, and a summary row with totals. I can't figureSurvey end date extension
Hi, Is there any way to extend the end date of my survey? I needed more time in finding respondents that is why I need to extend the end date of my survey. Help. ThanksHow to store API keys in zoho?
Hi everyone, I'm currently building an integration using Zoho Flow and I need to securely store several API keys that will be used to make external service calls from my flows. I would not like to hardcode the values in the code of custom function. What'sZoho RPA is now available in your Zoho One bundle!
Hello All! Of late, it's been quite a stint of new app integrations in Zoho One. This announcement pertains to the addition of another Zoho application, the most sought-after Zoho RPA - Robotic Process Automation, to the bundle. What is Zoho RPA? ZohoEarly Payment Discount customize Text
Hi, I’m currently using Zoho Books and am trying to customize the standard “Early Payment Discount” message that appears in the PDF invoice template. I’ve reviewed the documentation here: https://www.zoho.com/books/help/invoice/early-payment-discount.htmlMulti-currency in Zoho CRM Forecast and Reports
As a company we have branches in 4 different countries with as many different currencies. Our Sales Teams would like to work with their local currency as much as possible. The Forecast module using only 1 currency is practically usable only by the salesis there an easy way to embed a zoho analytics report into a widget (or inside the "account" page) of Zoho CRM
Hi, I have built a report that is specific to an account in Zoho CRM but I would like this to be built into the Zoho CRM front-end. I have looked at the widget concept but it seems quite complicated (see attached screenshot but I need to filter this viewZoho Notifications - Received two notifications for one message and none for the other
We had a client reply to a ticket twice in one minute. The ticket owner received two emails for the second message but none for the first (which was crucial content and unfortunately was therefore missed). I'm assuming this created a race condition -Next Page