CSS Style sheet or google web font in embedded view
Hi, We want to embed a Zoho Creator form in our web site. We of course wants to make the embedded form appear with same layout as the rest of our web site. Is it possible to link to our own css stylesheet 'style.css' and/or a google font type like <!-- Google Web Font --> <link href=" http://fonts.googleapis.com/css?family=Raleway:300,500,900|Open+Sans:400,700,400italic " rel="stylesheet" type="text/css" /> Kind regards, Bo Thygesen
Anyone integrate Zoho Creator with EchoSign or DocuSign
Have a business need to prepare documents in Zoho and then integrate with EchoSign, or DocuSign, or any other like service that might work easier/better. Anyone have any experience doing this that would be willing to share info? Thanks.... Steve Henry
Search and Sort by Multiple Lookups
We are a community college. I have one report for instructors and one report for course schedule. I want to create a Course_Schedule_Search form that allows the user to pick an instructor from a lookup field and, in a multi-select lookup field, show only those courses in course schedule that the selected instructor is teaching. However, I'm having trouble with the "on user input" code. I keep getting an error, and I think it relates to the ID. Here is my "on user input" code for Find_Instructor
Difference between sharing to individual/groups and on role level
I am a bit confused as to what the difference is between sharing forms and reports in an application to individual users or groups compared to giving access to users based on the roles set in Users & Profiles. For my specific applications, under the Share menu, I have set the entire application unshared. But under Users & Permissions I have instead given permissions for all users to access which in return allows all my users to access the forms and reports. I tend to believe, that administrating
Edit record using record ID and pass parameter without displaying zoho header and application components?
Alternatively, you can also use the default functionality of Zoho Creator to view and edit individual record using its record ID. The following url will display the form alone without displaying top header and other application components. http://creator.zoho.com/<userName>/<applinkname>/<formlinkname>/record-edit/<viewlinkname>/<recordID> Is it possible to edit a record in the above mentioned way and also pass a parameter to the form?
sign up
Sorry! Free domains with extensions such as .tk, .cf, .ml etc., are not supported I found this error again and again even my domain is .com but still got this error please help .......
Date Validation between two date fields
Do you have an example of date fields validation? I have two date fields (from, to). I would like to check if the date in FROM field is earlier of the To field then it's ok...If the date is after or same to To field then give an error message. I know how to do it in javascript but I do not know if it is possible to do it here.
Sorting custom filters in dropdown?
How is the best way to sort my custom filter options in the "filter" dropdown?
Auto Increment ID
Hello, How is the value of the auto increatment ID field created or calculated? I've created a registration database reserving spots at a conference for the first X people who register. Will the auto increment ID always be greater for the most recent registrant--the most recently created record? In other words, I can rely on this ID to tell me the order in which people registered? Thanks for you help.
Help with script for custom action
Hi, I have a custom action that works fine for the form's report it was created. In this main form (Requisici_n_de_Compra) there is a subform (Detalle_RC). I would like to have the same feature for the subform report. this is the script that currently works for the main form report. void PostInv2(int PurchaseID) { proRowData = Requisici_n_de_Compra [ID == input.PurchaseID]; for each r in proRowData.Detalle_RC { fet = Agregar_Producto_Almac_n [Descripci_n == r.Descripci_n];
Using url scripts to show reports for single record
Hi there, I'm slowly getting my head around everything and have built up my app with a couple of scripted features. It's unfinished as yet and I just wondered if anyone could help with some final feature tweaks. I have used a recLinkID URL to draw up a report of a single record, which is working perfectly: void Results.FullRecord(int recLinkID) { openUrl("https://app.zohocreator.com/nathan429/simcentre-hospital-records#Report:Patient_Demographics?recLinkID=" + input.recLinkID, "Same window");
Is there a right way to edit a record and save as a new record?
I would probably save a new record on on validate section and then cancel submit. Is there a better way to do that without an alert message to user? I want to use some records as templates.
API Call with Authtoken in url not working
Hi, I am try to make the api call to following url - curl --data "notificationCode=766B9C- AD4B044B04DA-77742F5FA653- E1AB24¬ificationType= transaction" https://creator.zoho.com/api/zoho_rahul179/xml/demo/form/TransactionID/record/add/?authtoken=mytoken&scope=creatorapi But I am always getting the 2899 error, I have given the public permission for entering the data to my form. The problem is that I cannot pass authtoken and scope as POST data variable. If I do like this - curl --data "notificationCode=766B9C-
How Can People Submit their Tutorials on my Website
I want to make website in which people can submit their tutorials how can i make this type of website what type of things i should do for this I do not have any knowledge of html, programming and any other language (totally zero programming knowledge)
Payment Gateways
Hi Zoho, Is there any plan on integrating Creator with more payment gateways (aside for Paypal)? Stripe would be a good start. Zoho invoice has these 8 options https://www.zoho.com/invoice/addons/. Please advise, Thanks.
Transfer a file from Creator to Box?
Is it possible to transfer an uploaded file in a form to Box.com (or any other site) using the API or cURL or Post URL or by any means? Thanks!
Stateless Form button error in App View
I have 2 stateless forms which perform search functions. When the page reloads to the left of the search results the buttons do not display correctly. In the app builder they appear normally on reload but in the live app on reload they are repeated numerous times down the page and have the form_field_name on them. The only code in this page is 'on click' to specify the Search Parameter; childname = Child_Registration [ID == input.Search_Child]; searchParam = childname.Child_s_Name; openUrl(((((("https://creator.zoho.com/"
Passing in parameters into a hidden field in a view
I would like to pass parameters into a hidden field. There are some things I pass into a view on load via URL that I would prefer my users didn't see.
creator.zohopublic.com getting a privacy error. My clients are unable to access their forms and data. Huge Issue
Privacy error on Chrome for all embedded forms and reports, this is a huge issue: Your connection is not private Attackers might be trying to steal your information from creator.zohopublic.com (for example, passwords, messages, or credit cards). NET::ERR_CERT_COMMON_NAME_INVALID Need this resolved ASAP my clients are in a 24/7 industry!
Displaying an image in a HTML page
I have a Child_Registration form with an image field and a HTML search page that fetches and displays individual data from this form. I want to include the child's picture (Photo_ID) but it always displays as a broken image. I have looked at all the guides and information on images but can't seem to get the right code so the image displays.
Mobile Form showing hidden fields.
I have a Form that in the browser is behaving correctly. i.e. it hides a field until a rule/task is activated and then shows the form field. However on the mobile device it behaves differently. On initial load the field appears. Other rules within the form behave correctly. I have deleted and re-created the rules as well as the form fields but each time it is the same. Can you please provide any assistance as to the cause? Thanks Kevin
Logo or Image insert in a form or Page in add note
Dear Sir I have created one form having two field "Name" and "Image", and update data with company logo and create a function module for fatching the logo Code as follows string Pipeline_Management.Image(string name) { imagelnk = Image[Name = input.name].Image; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","#View:Image_Report"); imagelnk = imagelnk.replaceAll("fieldName","Image");
why checkbox automatically deselects and how to sovle it?
hi there is list with 2 variants of checkboxes checked variant_1, before script variant_2, after script script is " // search entry by ID record = zayavki_form [ID == input.record_ID]; // check on in a list "email_process" // value of checkbox "subscription_page_visited" // (in input.email_process variable) record.email_process = input.email_process; " why after script execution "SMS_subscription_sent" is unchecked?
How can I make an Autonumber Creator field visibile?
Is it possible to make an autonumber field visible ?
why there is a endless loop for .remove() ?
hi try remove "On User Input" some characters all works well but interface views that there is a endless loop of operations code "On User Input" mob1 = input.mobile3.remove(")"); mob2 = mob1.remove("("); mob3 = mob2.remove(" "); mob4 = mob3.remove("+"); mob5 = mob4.remove("-"); input.mobile3 = mob5;
Submit by Email
To whom it may concern, We would like to make use of the submit by email feature, however our email system auto appends a legal disclaimer to all outgoing emails. This results in an error and the email is rejected by Zoho. The error is as follows: The Following error has occured while adding this record: Failure, Invalid column value "tel +44(0) 20 XXXX XXXX." specified I have changed the XXXXs as these are our telephone number. Furthermore, what we are trying to achieve is an update of just a
Send an email with all data from a subform
Using the following code, I have been able to include information from a subform into an on success email. " + input.SubForm1.Single_Line1 + " However, it is only displaying the first value of the field. I have tried to fetch the data using the following code with different iterations x = form1 [ID == input.Single_Line1] but I am always getting an error. Is there any way I can display on an email all the records stored in the subform for a particular field? Thanks.
Invalid JSON String Format
Hello, We are trying to fill-in the pincode of a customer through an API call. The API returns the values in JSON format such as: {"query":"Delhi","pincode":"110001"} If the pincode cannot be found, the API returns with the values such as: {"query":"Searched Address","pincode":"","error":"Not found"} We get a "Invalid JSON string format" error when address fields are left blank on add customer record form. The code we are using to make the API calls is: if (input.Address_Line1 != null || input.Address_Line2
Posting form data to another url and and opening page in the new url
Hi, I am quite confused with the process of postUrl. On submit I need to post form data to an external url which will auto populate matching form fields and trigger an event (submit Form). All this must happen in the same window. Please inform where I am going wrong. input.adult_no2 = postUrl("http://demo..co.uk/searchhotel",input.adult_no2);
how to set admin permissions to notes?
hi! need document all fields by notes there are more than 50 fields how can i set for notes view permissions "Admin only"?
Add product detail in PurchaseOrders of CRM
Hello, i user ZCREATOR to create PurchaseOrders in ZCRM. I put only Product in a List as itemsList = List:Map(); ..... For each ligne in MyView..... { itemsList.add({ "Product Id" : ligne.ID_produit_ZCRM, "Unit Price" : MonProduit.get("Unit Price"), "Quantity" : newQty, "Total" : newTotal, "List Price" : ligne.Prix_achat, "Net Total" : newTotal }); } My ItemsList is full with product. responseCreate = zoho.crm.create("PurchaseOrders",{ "VENDORID" : idFournisseur, "Subject" : Subject, "PO Number"
can't able to imort app?
When i just trying to import app as a .ds extension it shows me Invalid Request
Lookup Multi-Select
Hi, I am building an attendance app. I created a lookup multi-select field. When I select the attendees, I want to put a 1 to their individual names to indicate their attendance for the event. How can I "remove" the commas in my report and show their names individually?
Dropdown field is showing "Other" option
We have a Creator application where we are tracking Customer's visit activity. Currently the Activity dropdown field has 4 options: Buy - Yes Buy - No Decision Pending Return/Exchange When adding a record, we get the desired 4 options. However, on the edit screen, Creator shows an additional option - "Other" as shown in the image. We suspect it has something to do with the On Load screen of that form but can't really figure out whats the issue. Any help would be appreciated. Thanks!
No CA certificate imports for private HTTPS
No where in the Deluge reference documentation can you find mention of certificates for transport layer security (TLS). Apparently this is because there is no getUrl() support for importing a CA certificate which means that you may only use an https:// scheme with an HTTPS server which has paid a yearly subscription for a certificate from a CA recognized by Zoho.
getUrl() does not support ports other than 80
The Deluge reference page for getUrl() says: "By default, it supports websites running in port 80 and 443." I was dumbfounded when told by Zoho support that it ONLY supports these ports! Apparently the standard URL format of http://host:port/path is not supported at all. It uses port 80 for the http:// scheme and port 443 for the https:// scheme and does NOT do the right thing to allow us to specify the actual port the HTTP server is running on. This obvious shortcoming rules out using Creator
How to "Add Comment" to a Case in zoho CRM
I'm trying to "Add a Comment" to a case in the CRM via a Stateless Form. The code below "should" work but does not. The caseResp says "Successfully Updated Record". Am I missing something? caseMap = map(); caseMap.put("Add Comment", "test"); caseResp = zoho.crm.updateRecord("Cases", "841019000007280001", caseMap); alert (caseResp) ;
How to download record summary pdf when a new entry is added?
Hello, I want to download the pdf of a record summary PDF when I make a new entry in the form I have tried this On Add / On success openUrl("https://creatorexport.zoho.com/danielmndez2/recibos/record-pdf/Recibo_Report/<ID>/<contratista>/(Report Secret KEY)?<ID>=" + ID + "&<contratista>=" + Contratista,"New window"); The problem is that the resultant URL is the next one https://creatorexport.zoho.com/danielmndez2/recibos/record-pdf/Recibo_Report/input.ID/input.Contratista/Report Secret KEY)?input.ID=3112670000000106103&input.Contratista=3112670000000078982
lost field in report!
hi! previously was made a report all works well few days ago lost 1 field "дата доставки" in field it is, but in report there it is not how to solve it?
Help with CRM integration
Hi, i just started using zoho creator because i need to creat a new application for insurance policies. The objective is that using Zoho CRM when i see a contact information to be able to see the insurance policies he has with the pdf and the image of the car or house insured. I created the aplication using Zoho Creator in wich yo can add the following information: 1.- Image (upload image flied) 2.- Document (upload pdf field) 3.- Policy number 4.- Premium 5.- Related to: (contact in Zoho CRM) After
Next Page