Rest API Help
Hello I have just started working on a portal to add records to Zoho Creator. I have successfully added records, however the page automatically downloads a json file with the data I posted. How can I stop this from happening?
How to Use a Custom Action to Invoke a Function to Send SMS/Email to Users selected in a report?
Hi Everyone, I would love some help with the logic on how to accomplish sending SMS/Email to many users selected in a report, then using a custom action to invoke a function. Here is what I have: My Report: As you can see I have many "Users" (Email, phone etc.) for each row. When I create the custom action I cannot pass the ID of the user, instead I am limited to only pass the ID of the "Delivery Location". Question #1: How do I create a "for each" loop that gets the ID's of the users after passing
Problem with purchase to Zohocrm from Creator
Hello all, i have a code to create a purchase order in zoho, work in generally fine, create the PO in zoho, but dont add the product detail.. i dont know what is the problem, if i dont send all data requirement or is a wrong format.. respuestaPO = zoho.crm.create("Purchaseorders",{ "Subject" : (("" + infoso.get("Numero de orden de venta")) + " t4 ") + infoso.get("Subject"), "Status" : "Created", "Vendor Name" : "" + infoso.get("VENDORID"), "Orden de Venta_ID" : "" + infoso.get("SALESORDERID"), "line_items"
Copying value of image field to another image field creates a broken link
I have a form that has five visible image fields and three hidden image fields. There are five check boxes that are used to select up to three of the five photos to be displayed in the report. In the OnSuccess action I have the following code: input.Hidden_Report_Image_1 = null; input.Hidden_Report_Image_2 = null; input.Hidden_Report_Image_3 = null; if (input.Include_Image_1_In_Final_Report) { input.Hidden_Report_Image_1 = input.Image_1; } if (input.Include_Image_2_In_Final_Report) { if (input.Hidden_Report_Image_1
Sync Google Contacts with Contacts in Creator
Is there a way to sync my contacts from in my creator app with my google contacts? Is coding with APIs the only way? I know some deluge but don't understand how to use the APIs.
Zoho Creator Portal App
Has anyone been able to use the Zoho Creator Portal mobile app? I had come to two types of error. Invalid_Request and Network Error. I had tried with different active customer portal users and different devices but sadly it happens the same. Im really looking forward to use this great functionality. Thanks in advance
Create multiple events concurrently
Hi, Any idea how can I program to create multiple events at one shot at fixed intervals, instead of creating one after another. Such that, the form allows users to select the frequency of the event (E.g. Daily, Weekly) and the number occurrence (E.g. span of 8 weeks). Gerald Lim.
Account moved to trash
Hi In some reports the account name appears duplicated. I have sent to trash one of them ti items and the account has disappeared.(both) How can I recover the account from the trash ?? I cont' see the Trash Thanks JM
Subform too large for main form
My Sub form is very large 30+ fields and my problem is that this is unusable in the horizontal sub form view and would ideally need to be opened in a popup window so that it can be worked on via an ipad etc. Has anyone else had and/or solved this problem?
Need a Zoho integration consultant in Los Angeles.
Anybody know of anyone? There are many on UpWork.com but I would prefer connecting through an introduction. Thanks! David
Request: In the Reports UI for User ad-hoc searches: support boolean logic within a column and between columns (ideally via Criteria builder?)
This is a common wish for us, and I see that this is has been requested multiple times. We see that we could build something of the sort using a stateless form with results shown on an HTML page. Yet... MUCH more powerful would be to support it in the native reports UI . This way, the user may have more flexible ad-hoc options in the search, and most importantly: when results are delivered, the user has all the controls of the standard UI vs. html list. NOTE that the Global search is not sufficient
filtering a subform lookup with a mainform field
Hi! :) I have a Products form with a lookup field on Factory form. I have an Order form with a lookup field on Factory form The Order form has a OrderItems subform with a lookup on Products form. At the subform OrderItems I want the lookup on Products form to show only the records that match the Factory chosen at the Order mainform. Is this possible? Thanks :)
Report based on multiple forms without relationship
Hello, I have two forms and I would like obtain a report of either. I'm interested of two fields (one date and one integer) and I ask how could I join this like sql. This form doesn't have any relationship. Thanks, best regards Maurizio
Subform : Report with subform rows and relationship with main form
I have Form A with a subForm B. 1 record in form A has 3 records in subForm B. I would like to have a report with the 3 subForm B records and with also some fields from Form A. Is this possible ? Many thanks !
Show/hide in mobile
Hi Zoho, It would be great if there was an option to hide/show reports/views/forms in mobile app. Kind of like a publish setting, but strictly for mobile app. There are select forms and report that I only use on the mobile app and some html pages that only work on web version... Please consider for future enhancement. Thanks.
Jump to a specific place in a form
Hi Zoho! I'd like to give the users a link to a form, that directs them to a specific field in it. (So the form will open with the window scrolled down to the field) How can I do this? Thank you Ravid
Diferent layouts for diferent sections of a form
Hi! :) Is it possible to have diferent layouts for diferent sections of a form? I would like to have a form with two columns and a subform that would fill all the form. Thanks! :)
validate UploadField { script manual mandatory }
Hey community im just curious is there a way i can validate an upload field with a manual mandatory script if.UploadField does not contain = ".png, .jpg" { cancel submit; } or if = null / "" / 0 or something along this line ??
[Solved ]sendmail from NON zoho.adminuserid / zoho.loginuserid
Hi, I used to use a simple form from built in features on the Sites app. Not knowing the Creator app can allow me to do much more. So i bought a subscription for a standard plan with Creator, and built an app with forms that i am very happy with, with some help from support already. Thanks for that. But now there's one last thing I wish to do, but it seems like a bit of a road block now. I hoped to do something like this: sendmail [ from: input.Sales_Email to:"helpdesk@company.com" cc:input.Sales_Email
How to hide the field before submitting and updating after successful saving
Hi All, I am trying to develop ticket management application for practise. I have added below fields in form. Status List should not be visible while submitting the form. Once form is submitted Status list should be visible with assigned value. 1. Subject 2. Decription 2.Product 4. Priority 5. File 6.Staus -- 1. UnAssigned 2. Assigned 3. Completed. After submitting the form Status should be UnAssigned. Regards, Nagendra.
Alphabetical order in lookup field not working correctly with spaces
I have a lookup field that has people's names, and the options are sorted alphabetically. They are correctly sorted by first name, but if there is multiple people with the same first name, then the last name isn't being sorted alphabetically (see screenshot). The options for the lookup use a formula field which returns: First_Name + " " + Last_Name
How do I get a custom app in to CRM
So, I created an application in Zoho Creator, and can't get it in to my Zoho CRM. I have only created a form at this point. The goal is to have a related list on my accounts. Support said that it would appear in the list of Extensions for my Zoho CRM's CEO (Setup > Extensions & APIS > Zoho > Build Custom Apps > Manage) But it does not, I shared it with her and it still doesn't appear there. Not a big surprise that support was wrong (I have contacted them 5 times, and they have had a correct answer
BUG
Hi, I am try to create "library management software" by using ZOHO CREATOR.I have a "ADD BOOKS" as a form.In that form,I have a LOOKUP field.Now, I am not able to see that field in form but I am able to see that in WORKFLOW and in LIVE MODE OF APPLICATION. Kindly,help me. Thank you.
Error - There is no such view in Zoho Creator
i used HTTP JSON request to access to my views but i have the response : There is no such view in Zoho Creator i use the url : https://creator.zoho.com/api/json/jb10/view/KC_Masters_ExtraTools can you please help me
uploads sent to Box.com?
I use Box.com to store files. Id like attachments uploaded on Creator apps to get sent to Box.com. I can't use Box.com upload embed script because ZC doesnt support javascript. Box.com also accepts uploads via email attachments. Is there a way to get the notification email on form submission to include the file as an attachment rather than a link to send to Box.com?
clarification in Sandbox
Hai 1.When we create a sand box It duplicates our application but I can't get all the reports that I have in the original app.Is there any way to get it? 2.In sandbox if I publish with new changes it will change in original app after doing it more than 2 time if in case I need the previous edit can I get it?
If statement within Add Record
Does Zoho Creator not let you put an if statement within an Add Record function? I have coded my form so that when you submit it, a record is automatically added to another table using "Add Record". I want to put an if statement within this to specify different values of one of the fields based on another. See code below: insert into Healthlink [ Customer_PO = input.Customer_PO DeliverToCode = input.Healthlink_Customer_Code if(input.Number_of_items == "2") { ItemType2="S"; } else
Schedule Report as Excel
All, I would like to know if it is possible to schedule report and send it as attachment as Excel and not as PDF. I didn't found the option so by default it send PDF. Do you know if it is possible? Thank you Riccardo
"Loading View..." message when viewing page with view components
When i go to any page with a view component (even if the view is the only thing on the page), I just get a "Loading View..." message appear. I have left the page for 15/20 minutes, but it hasn't displayed correctly. Other pages work as expected. Appears to have started earlier this morning. Is anyone else having this issue?
Is there an alternative to customer portal with Creator?
Is there a less expensive alternative to using the $99/month customer portal for allowing customers to update their own information in Creator?
[Solved] sendmail subject line expression as lookup field
Hi, On my form name: Wesmar With zoho support's help, i've finally managed to craft a form that functions the way i want, and seems to display properly when scripted to sendmail (except the template does not display more than about 20% of content) However when i try to use the expression in sendmail subject line "input.Customer_Name" - it outputs a string of numbers like 2511901000000054103.. Note, it does this when Customer_Name is a lookup field. It works fine if it's a normal Single Line field...
Automated delete records
Hi, I would code a custom schedule to delete records after 1 month from creating. Any idea how can I do that? Gerald Lim
Edit Report
I have created a report with criteria to display only certain fields. When I hover over a record, the pencil edit icon appears. When I click the pencil (edit), the form that the report was built upon displays. The display only shows those fields which are in the report. (Which is what it is supposed to do.) Is there a way to display all the fields on the form when I click the edit button instead of just the fields in the report. In my case, I want to have quick access to some information not on the
How do I add an item to a lookup list via a script
Hi I am looking to add a value to a multi-select lookup field. I have a employee record with a list of countries that the employee work in. We have a new country and I am looking to automatically add the new country to every employees record. I am looking to do this via a workflow script excution. It would appear that I need to use the following. "<picklist field>:ui.add(value); " e.g. employee.country:ui.add("UK"); However the interface reports the following error. 'ADDTOPICKLIST' can be used
Fetch data from related form not working in a mainform/subform scenario
I have three forms: Orders (mainform) Order Items (subform) and Products. When i input the product ID at Order Item, a script trigered on user input fetches data from the related form Products to populate all the other fields of the Order Items. It works fine if i enter the Order Item form the Order Item form, but if i enter the Order Item at the mainform Order where there is the subform Order Item, it doesn't work... Please advise. The script: x = Products [ID == input.ProductID]; input.Price =
Formula to count number of connected records
Hi. We have a courier business and use Zoho Creator to record our runs and jobs. We have two forms to record runs and jobs. One run can have many jobs. I need a formula field in the run form to count the number of jobs allocated to it. Any ideas please.
Google Drive with Zoho Creator
I would like a "File" field to store files actually on Google Drive. The pointer to fetch the file should be pointing to a google drive location or index. Can this be done?
For each record - hitting deluge statement execution limit - to only update 730 records across 2 forms???
Hello, I have trying to update 730 records across 2 forms as follows: - Create booking = 365 records - My availability form = 365 records These are daily recurring events for a period of 1 year, which are set up in "My availability form" then inserted in "create booking" form. Both form are linked via lookup field through their ID Create booking has lookup field My availaibility_form_ID My availability form has lookup field create_booking_ID For each series (across both form) there is a unique reference
Help with pivot table!!!
El problema que tengo es que tengo que multiplicar el valor con 2 columnas, que dice SaldoBodega con el costo, para traerme este inventario de almacén, y cada bodega tiene que realizar el mismo procedimiento. Ejemplo: Agradezco cualquier ayuda.
Syncing data from Zoho AppCreator
Hi, Is there any way to programatically access the CSV download from the backend. Right now the link to CSV download is behind a login wall. Is there a way to pass the login details to the download link? Or any other way to sync Zoho AppCreator backend data with our system?
Next Page