For each row in SubForm create a CRM record - zoho.crm.create
We're trying to create a new 'CRM' PurchaseOrders record for each row in a 'Creator' SubForm. I have written the below code, this currently creates CRM records "On Success" but instead of pushing each rows unique data into a new CRM record, it pushes duplicate data from row 1 into each record e.g. if there are four rows in the sub form, it creates 4 records in the CRM but all have data from row 1. What we would like it to do is create a unique CRM record for each row in the SubForm e.g. row 1
Password Fields in the Forms
Does ZOHO Creator provides facility to have a password field in the forms.... I tried but could not find it.......... Please tell me about it
Cant access edit form
1. I created a form at https://creator.zohopublic.com/registrocivil/registro-de-nacimiento-doble-ciudadania/form-perma/Envio_de_Documentos_inicial/UbUsnYy7X5gyZhpJCjjt9hkAj01Y0AtV1kAM9kGsjJ3hBBQtRgVvsZQQsd2qjFrTZvOeMPNh5kFpNV7BqHbsjpNG29DQAqRehUYY 2. I need customers to be able to modify captured data afterward without a Zoho account.. For that, I’m trying to use the following link: https://app.zohocreator.com/registrocivil/registro-de-nacimiento-doble-ciudadania/Envio_de_Documentos_inicial/record-edit/Envio_de_Documentos_Report/3400680000000013173/
Function to reduce code duplication?
Hi, In my calendar view, I have the event title set as the 'Calendar Name' field. I run the following code when a record is added, but also when it is updated. This creates a useful event title for me in the calendar view. brand_lookup = Brands [ID == input.Brand]; type_lookup = Types [ID == input.Type]; if (type_lookup.Type == "Special Event") { input.Calendar_Name = input.Description + " - Special Event"; } else { input.Calendar_Name = brand_lookup.Brand + " - " + type_lookup.Type;
Label Printing
Hi I would like to print labels whenever I update records among a condition. Is these posible? Looking forward to a soon reply, Greetings!
How to Publish a page in zoho creator and access it without login
Hi team How can i publish page in zoho creator? I know how to publish a form in zoho creator. But how can i publish the page without login access in zoho creator?
How to create a Summary Report from two forms data?
Hi I am trying to build a database wherein I store all inputs of adding a stock and another form to removing the stock, how do I create a page wherein when I putin a Product ID it shows up a complete summary of stock in hand in various locations? And do I create an indirect table to hold these values which are updated whenever there's a stock addition or removal? Totally new to this software so looking fwd to some immediate help! Thanks Amit.
How Do I Add a Filter to a Public (Permalink) Report URL
I have a public URL (permalink) where I am exporting as a xls. How do I add criteria to the export link? http://creatorexport.zoho.com/<username>/<app name>/xls/<report_name>/NSSrKNu5hhjZCQDDmEFmg6DkD4JGSR97HPSEGrgY0pVW<crazy_permalinkCode>/&Neighborhood_Associations.Active='false' But this does not work. I can use that exact critera in a non-permalink and it works fine. Can someone help with the structure? I cannot seem to get it right.
External Database Source
Hi everyone, Is it necessary to store data in Zoho creator database when I input the record through Zoho creator form? As there are some sensitive data, I would like to retrieve and store data on my SQL server or private cloud. Thanks.
Barcode scanner attached to PC
I am exploring the options available to use barcode scanning in a Zoho Creator app. At the moment it is possible to scan barcodes using the creator app (iOS), but this means users always needs to have access to a mobile device (phone/ tablet) Is it possible to use a standard barcode scanner attached to a PC to scan barcodes when the app accessed through desktop browsers ?
What is the right way to implement a new design onto an existing Zoho application
I'm new to Zoho but a long time application developer. I'm about to start making some modifications to an existing live Zoho Creator application. However, clearly I want to create a development version, make the changes there and then somehow update the live application once testing has been com pleted. My problem is that I can't find any documentation anywhere that explains the right way to safely and confidently transfer my updated design to the live database for implementation, and I don't
Zoho creator Sandbox and making updates to a live system.
I'm finding the help file on sandbox too simplistic to help me make some major design changes to an app i have been working on. It states that " Changes in Form Definition and View Definition cannot be made in Sandbox mode." However, there is no explanation as to what is meant by Form definition or View definition. I am still new to Zoho Creator and would like to know exactly what this means before I start using the Sandbox and finding out the hard way that some of my changes have not been implemented.
Sending form field data with mailto:
I have added an "Add Notes" field to a form which will be visible when editing a record. The note contains a link with a mailto and I want to send some of the fields as an e-mail I first tried to access the fields directly, but that didn't work. Example: <a href="mailto:someone@somewhere.com?subject=<%input.Title%>&body=<%input.Content%>">Send this record via e-mail</a> I then tried to generate a populated mailto:-link in the onLoad script. Example: Send_mail_link = "<a href='someone@somewhere.com?subject='
URL link to form not working
I created a webpage with a 3-button menu. Every button links to 3 different forms in my zoho creator app (using the URL pattern for example: "https://preapp.zohocreator.com/<my user name>/<my app name>/#Form:<myform name>" This menu page works perfect in the desktop version, and was working OK within the mobile app (which we use to scan QRCodes), but now when you click any of the menu buttons I got a message "An error occurred"... I emphasize that this happens only with the zoho creator app on my
Multiselect Lookup Count
I have read several threads/forums on this but cannot figure out how to do what we need. We have an Zoho Creator application with a subform for Hotel Reservations for our clients. In the subform there is a Lookup multiselect from another database to list all employees available to be added to a reservation. I have tried various code and nothing is successful. We have a field named "Number" that we want to count the total number of employees selected from ProCon Employees multiselect lookup.
Attach custom actions to security profiles
Does anyone know it you can attach custom actions to security profiles in zoho creator? The requirement I have is to approve purchase invoices. But the approve button should only be visible for the users in the management profile and for the users in the assistent or other profiles.
Setting up multiple alerts/notifications
Hello, I've created two instances: Customer and Order. Now I'd like to set up multiple notifications by mail for every order by a DueDate field (say 7 days prior to DueDate, 3 days prior to DueDate and at the DueDate). Could you guide me how to do that? I'm not a coder, so please be gentle Thank you very much
Migration Tool - "Please specify valid form name" error, even when form name is correct
When using the command line migration tool, we get the message "Please specify valid form name". Nothing has changed from yesterday when this worked. (App name, form name & credentials are correct) I tried with the GUI migration tool but when I try selecting a form name from the Existing Form drop down, it is empty. (Images attached.) Has anyone else experienced this?
HIPPA
Are Zoho products HIPPA secure?
Call Deluge function via rest/xml rpc api?
Hi! I need to invoke deluge custom function via api. I can't find any information about it, except this tread. Is it possible? Thanks, Alex.
form/report to appear in multiple sections
Is there a way to assign a report or a form to appear in multiple sections? I want to create several sections for certain groups of users. (techs, manager, admin, etc)
Email
How can I add many emails adress in the same fealds? or add new feald for a new email adress'
Multiple mandatory fields
Hello, I'm trying to ensure that several fields are filled in based on following statement. if(DeliveryOption == "משלוח") Each field should produce different error message So I've created several "rules", one for each mandatory field like this: if(DeliveryOption == "משלוח" && DeliveryCity == null) { alert "יש להזין עיר למשלוח"; cancel submit; } if (( DeliveryOption == "משלוח" ) && (RecipientStreet == null)) { alert "יש להזין רחוב למשלוח"; cancel submit; } if (( DeliveryOption == "משלוח" ) && (RecipientHouseNum
How to Create a Link to Jump to a Specific Part of a Page
Hi is this possible on zoho creator pages? here is simple html code <a href="#c4">Jump to Chapter 4</a> <h1 id="c1"> Chapter1 </h1> Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Nulla quis lorem ut libero malesuada feugiat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Cras ultricies ligula sed magna dictum porta. <h1 id="c2"> Chapter2 </h1> Curabitur aliquet quam id dui posuere blandit. Donec rutrum congue leo eget malesuada. Curabitur non nulla sit amet nisl
Using Zoho Creator Login for Custom built mobile app and web application
Hi, We are trying to enable logging into our Custom mobile app and web application using Zoho's Creator's credentials. Is it possible to do the same? Do Zoho has a authentication apis/equivalent to do the same? Regards, Jeeva Gautam C K
Creating a CRM Task and assigning it to a CRM Lead
Hi, Hopefully a very simple question. I am trying to create a script in Zoho Creator that does a number of things. After a form is completed and validated do the following: 1. Send an email - Done 2. Create a new lead (or update an existing lead) if it exists - Done 3. Identify the lead ID in point 2 - Done 4. Create a new task for the lead created / updated in step 2 - Problem I am having an issue with how to create a new CRM Task AND assigning it to a lead. I can create a task, but it does not
Blocking fields from a condition
The users in the form have the authorization to update the data previously registered, but what I want is to fill a specific field, can not be updated or modified again, is this possible?
Issue in checbox enabling
Hello , I'm facing some issue in checkbox. On some condition it should be able to check the checbox. It was working fine till now. But dont't know why it is not working! 1st form:Order 2nd Form: Line items. one Order has multiple line item. In the line item one check box is there. If the check box of all its line items is true, then Order form's one checkbox should be enabled. Earlier it was working fine but right now its not working. is it a org problem or what? How to fix this issue please
Zoho Creator University Degree: Learn to create your own applications from experienced developers
Do you dream of developing your own custom applications with Zoho Creator? Hi, I'm Raquel Cantarero, I introduce myself, I work for a company called Zenith. We are a training platform which is 100% dedicated to teach Zoho Products. Zoho Creator is a very powerful tool but there is a lack of training resources available where users are able to train themselves to master it. Learning such a powerful tool without proper training can be a very daunting task that's why we have created the Zoho Creator
Error when trying to import .ds file
Hi I'm trying to import a .ds file from my developer account to the client one and am getting the following: Problem encountered while creating the application Error at line number : 727 Number of arguments mismatches A conversation using the chat feature seemed to time out though there was mention of needed to relink things? Can anyone help? Thanks
Dynamic Lookup field
Hi I have a lookup field (Lookup field 2) to show entries from another form. How do I control it to show variable # of entries per value entered in another field (Lookup field 1)? On the "on user input" action of the other field (Lookup field 1), how do I generate in real time the # of entries for this look up field (Lookup field 2)?
Zoho Creator - Subform not visible in OnEdit of all records.
Hi, I can't see the subforms in my OnEdit view, There are No error messages, and I can access those fields in OnAdd. So that it's proved that I have the access rights for those forms. How can I make the subforms visible? Any suggestions would be helpful, Thanks in Advance.
Custome Theme
How Can I change the theme of my page and create a costume theme with my company colors and logo.
getUrl returns "internal exception"
I want to get a json list of items from a webservice: map Campaign.listSibCampaign() { mapheader = Map(); mapheader.put("api-key","Ab7XXXXXXXXXXXcaJ"); resp1 = getUrl("https://api.sendinblue.com/v2.0/list?page=1&page_limit=2", mapheader, false); return resp1; } This works fine with Postman I get this { "code": "success", "message": "Successfully retrieved list details", "data": { "lists": [ { "id": 689, "name":
Error message advanced email in Zoho Creator
I keep getting this error message. What I am doing wrong? Error at line number : 2 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression 1 sendmail 2 [ 3 from:zoho.adminuserid 4 to:Properties_20170822_200937[ID == input.Property Name].Email 5 subject:"Subject of the email" 8 message:"Your message" 9 content type:HTML ]
Add/Edit/Store multiple forms within a form
I have created a form to keep track of a project. I have fields such as: Address of project, Contact for project, special instructions for project etc. What I need is a way to store multiple purchase orders within a form. A purchase order will contain information such as the product, the number of pieces, the weight etc. I can use a sub-form but in reporting it only shows up as a link. I need a report that shows all the details of each PO not just a link to details. Does anyone know a solution for
Validate multiple rows in subform
I currently have the following script in Form Actions > On Add > on validate: for each row in Order { inventoryamt = Promotional_Item_Input[ID = row.ItEm].Quantity_In_Stock; if(Order.Quantity > inventoryamt.toLong()) { rec = Promotional_Item_Input[ID = input.Order.ItEm]; alert "There are only " + inventoryamt + " left of " + rec.Item + ". Please adjust your order quantity."; cancel submit; } } It works to check the quantity of items ordered against quantity in stock for the first row in the subform,
Zoho creator account issue
Hi, I just upgraded my zoho creator account to professional, but my account type is still on personal free. Can you please advise me on what is wrong. My account email is adrien@nova-ix.com.
Fetch criteria with "if" ?
Hi All, I have a function that gets two variables: Date (date) and SectionName (string), fetch entries from a form by criteria based on those variables, and than makes a change in the entries. The criteria always targets the "Date" field, and if "SectionName" var is not empty, it also targets "Section Name" field. Currently, I have the same syntax run twice - once if SectionName != "" (meaning it's not null, and than the function use it as a filter) and second time for SectionName = "" (meaning it's
Sharing permissions in lookup fields
Hi, I' trying to test sharing settings. I successfully managed to limit a user ability to see form A records not created by him. However, if in form B there is a lookup to form A he will see all records. Is this how it should work? How can I also limit the view permission in lookup fields? Thank you for your help. Bruno
Next Page