postUrl returns 201 and never reach the target URL
I am working to get an app hitting webmerge url with postUrl. But from Webmerge's logs and reports, it seems like my request never made its way to their endpoint. So I decide to debug the postUrl response and what I got is this: {"responseText":{"success":1,"queued":1},"responseHeader":{"date":"Thu,
Searching by Lookup Field Stopped Working
Hello, I have code that has been working for years suddenly stop working a few days ago, around 2020-Dec-03. The lookup field used to have Field Name "HH ID", Deluge Name "HH_ID" and Field ID of "HH_ID_ID". Despite the awkwardness it worked for years.
Zoho Creator to Zoho CRM - Create new record with attachments
I am trying to create a new record in our CRM when a new record is created in Zoho Creator. This works well with simple fields, but I am having trouble figuring out how to pass out an attachment. link1 = "https://creatorexport.zoho.com/paulina108/dev-app/View_All_Visits/"; recordid = input.ID; link2 = "/patientAttachments&privatelink=9C2k9U29NCUwF7XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; attachmentURL = link1 + recordid + link2; I would then use this URL with zoho.crm.attachfiles as the file object along
Can I POST file content with invokeURL to a webhook?
Hi, As in the docs is not very specific of posting file upload to external webhook with invokeURL. Am I able to send the file content of a file attachment from a Creator form to an external webhook with POST request? Thanks
Pass value back from stateless popup to calling form
If #Script:page.close is used to close a stateless popup window, are there any methods for passing values back to the "calling" form without reloading the calling form and losing any entered info? I'm trying to zero out the calling radio button's value if my popup's Cancel button is clicked. @damien?
Collapsing Group items in a report view
I have a report grouped by purchase order number and beneath each PO I have the line entries for each order. I would like to have these collapsed so that they all fit on one screen and the operator can expand them if needed. Is that possible? I would
Cannot get authorization code for API purpose
When my external server get response from ZOHO the browser doesn't allow to show the link screen to connect with my ZOHO account. I enabled cookies for third party on chrome and also removed any extension from the browser.
Upcoming updates - October-November, 2020
Hello App Creators, We'll be rolling out the following updates in the next 4-5 weeks: Support for encrypting IP addresses Applying permissions while printing and exporting Using pixels to specify font size in pages Connections for panels and Deluge integration
Close Tab With Submit Button
Hello, I have a link in Zoho CRM that opens up a Zoho Creator form in another tab. I would like the "Submit" button in the Zoho Creator form to then close out that tab. Thanks,
How to display zoho.loginuser and zoho.loginuserid on Page
Hi, I would like to make a page with user name and user's e-mail address. It might be very simple thing, but I could not find a documentation about how to display zoho.loginuser and zoho.loginuserid on page by using script. As I am not a programmer, I tried print(zoho.loginuser); write(zoho.loginuserid); by putting after <%{%> or <%{ but nothing worked. Can anybody help me to make my page work correctly? Thank you very much.
Where is the 'public link' for reports in Creator 5
Hi there, I am upgraded now to Creator 5, but my public reports are no longer working. Answers to either of these questions would be helpful: 1. Where do I find the public link for a report in C5? 2. Where do you now publish a page in C5
Zoho CRM Integrating Google AdWords with zoho creator forms
Hi I would add to my forms created with Zoho Creator the Google Adwords tracking for Zoho CRM. I followed this guide https://www.zoho.com/crm/help/google-adwords/configure.html It's not clear where I can put the follow code in Zoho Creator forms: <input type = 'hidden' id = "zc_gad" name = "zc_gad" value = "" /> In the guide I have to put it in <form>...</form>, but I have not the entire code of form from Zoho Creator. Please could you help me? Thank you
Zoho runs so slowly!
Hi The speed on Zoho Creator is almost unusable sometimes, such as at the moment. We have a fair bit of information on there as we use it as our database for an office, with 25 users. However it is becoming more and more difficult to use and everyone
PDF and Print buttons not appearing on Zoho page
Just upgraded to C5 and found one of my pages does not offer the PDF or Print buttons....despite being enabled. Anyone had this problem?
Como hacer que diversos elementos de las paginas carguen los datos de un intervalo de tiempo
Hola, tengo una aplicación de visitas comerciales y técnicas y en algunos de sus elementos me gustaría que se cargaran los registros del ultimo mes, por ejemplo. Mi problema es sobre todo en un grafico circular, en el que se divide el numero de visita
deluge script on subform fields
Maybe it's just me, but I'm not really liking the new format for workflows. I find it cumbersome to have to create a new workflow for just about everything when before we could put several different types of workflow into one. In any case, with the
Size of Widgets in Creator - How to resize to just single line or double line?
... Happy Morning! We have custom widgets created for display of timer, messages and metrics... how do we resize these widgets to single line or double line of font size 12. the current size of widgets is too big for what we need on a page Thanks K
Community Webinar: Working with Zoho Creator’s v2 API: Examples and Best Practices
Dear developers, Our next webinar is a much awaited session on Zoho Creator's v2 API. Developer APIs are a core pillar of Creator’s extendability. They allow third-party applications to exchange data with Creator enabling a holistic and unified approach
Backups failing due to broken Schedule workflows
I am having endless issues in 2 versions of my app. In an app that Zoho took 3 weeks to recover by repairing a broken backup, I decided to use the Sandbox so I could roll back changes if it broke anything further. Big mistake. Creator could not publish
Can a customer portal user change his email?
Hi, I would like to know if a customer portal user can change his email? Because sometimes we want to create the account for the user (a customer portal user) and fill it with data and give it to him for testing instead of just inviting and then asking
Email Notification Dashboard/Report
Hi, A report containing the Email Notifications sent by Zoho Creator, whether it has been delivered/bounced/opened/clicked etc. is a much needed feature. Ability to export these reports is also needed. Some times, customers complain that they haven't
Pass information from popup subform back to main form
I am developing a form that has multiple subforms on it. The subforms work great on a normal computer however the Zoho Creator mobile interface has a defect as it cuts off the subform fields, doesn't resize when I turn my phone and to scroll over you
Use values from one workflow in another workflow
Hi, i created a "Load of the form" workflow for when starting the form to create 5 lines of the subform. Now want when I fill in the fields of the generated lines and press the SEND button, run a script that takes the data inserted in this subform and
Deluge Scripts when editing from a report
I have a deluge script that works great when I'm adding a new form entry, but doesn't seem to fire when I'm editing a form entry. The script hides a field based on the input value of another field on the form. When I'm adding a new entry, the field
How to get old value and new value of a field of a row in sub-form
Hi, How can I store values of any field before it is modified as I need both old value and new value in my application. Also it is not one field but I want this for a field in each row of a sub-form. Is there any way to do this? If I write a code on User Input then only new value is available old value is gone. Similarly it is difficult to store these values on On-Load trigger as there any many values. Please help. Thanks, Milind Manohar
On form submission check if similar record exists
I want to run a check on each form submission. It should check all existing records on any matching records based on two fields, DOB and Last name. If a match is found it should send an email. I think I am close but not exactly the right code. Can anyone help? Tried this as a workflow on created on success: pnRecord = Register[ID != 0]; for each pn in pnRecord { //fetch matching person records by DOB and last name pm = input.Date_of_Birth == pn.Date_of_Birth && input.Name.last_name == pn.Name.last_name;
Update parent form with data from subform
Hello, I am trying to set up a workflow that will allow me to pass some data from a subform back into fields in a parent form. The Subform does have a lookup field that refers back to the parent form. How can I reference this in the deluge script in
Auto Update a Date field
I have an employee form where the "Years of Service" date is calculated based on his/her hire date. yos=dateofhire.days360(zoho.currentdate)/365; When I view the record, the Years of Service is incorrect. If I go in and create a new or edit the date of
Auto-fill name field
I have created an app with the following forms Registration form -User enters their Name in a name field Scheduling form -There is a name field that should auto fill with the user's name based on what they filled in the Registration form. How can I do
Calculate ages
Hi I'm not technically minded and need to be able to show peoples ages in the Contacts app based on the Date field. Is this easily done? I've had a look at the formula field and got a bit lost! Thanks. Richard
Validate of Form Submission Workflow not Running on Create
I have one workflow for validating a form that runs when editing or creating and works properly. However, for all new forms I cannot get the validation to run when creating. I created a new app with a simple User form and the attached workflow. It runs when editing but not creating a user. Similarly, if I create a workflow that should run only on creation it does not run either. Any idea why this would happen?
Fetch a range a records based on criteria and insert each record as a string into multiple form fields
See the most recent attempt below. Basically I've found lots of info on fetching data but not too clear on how to then put it into form fields when you're fetching a range. I would like my users to be able to see the three previous entries into this form (Daily_Nursery_Log), when they are adding a record in this stateless form(Nursery_Action_Log). I thought it would be easier to input the key fields as one single line field combined, as you can see below. But that is not a requirment. I've tried
is there any way to set height for html snippet?
i use the snippets for embedding reports inside a Page
Number formatting in reports
On screen, when large numbers are un-formatted they are quite difficult to read: What would be really useful and user friendly would be the option to apply number formats for numeric fields in reports. In particular, thousand separators is what I need. For example, I would like to format the numbers 1200000 874000 2000000 like this: 1,200,000 874,000 2,000,000 It seems to me that a reasonable place to put this is under Report Settings -> Column Properties. There is a work-around which involves converting
download attachment API
Hello, I tried download attachment API of zoho, which returns above data how will I convert this above data to proper image type.
How to perform field on user input action in subform
I have a form, Data, that has a subform, Calculation. In the Calculation subform, there are 4 fields, Component (lookup), Concentration (decimal), Unit (dropdown), and Concentration in Percent (percent). The goal is to convert the concentration in the unit selected to % using the Unit as the On User Input trigger. For example, the user selects the component, type 1000 in Concentration, then selects "ppm" from the Unit (dropdown) field, the script should run and output "0.1000%". I can make this
Creating a in Creator using Data from Zoho CRM
Hi, I'm looking to create a customer viewable portal using the Creator app. We would like to be able to create a "Payment Profile" table from data in zoho CRM to be displayed in the customers page. For example in CRM we would have fields such as Payment
Adding Subform data to Books Purchase Order Subform using API
Hello, I am trying to add creator forms subforms data to Books purchase Orders Subform but i am not getting any exact format as of how to map the subform data. This is the code i tried mapp = Map(); mapp.put("vendor_id","177093000000077066"); mapp.put("purchaseorder_number",input.PO_No);
Zoho Creator Third party Access
Dear All, I hope you are well and healthy. I want to ask a brief question regarding Zoho Creator. Is it possible to have third parties accessing the Zoho creator through a web interface and without providing them the right to edit or modify the data?
Is it possible to change relation Call_X>Contact_1 to Call_X>Contact_2
I've got a bunch of data in Zoho CRM. By some reason I'd like to make some historic Calls be related to another Contacts. I.e. Call with ID=zcrm_0...x relates to Contact_1 with ID zrcm_0...1 (or even has no related Contact at all) should be changed to
Next Page