Lost Data- Creating Stateless Form
Ok so I'm a newbie. I was creating a stateless form for one of my apps. I deleted a couple of items on my app and lost my data. Can I turn back the clock and set my apps to a day earlier? Also what is the best way to backup you apps/data? I see there is a backup function is the main menu. Thanks,
Does zoho support SHA1 encryption
Hi, Is there a way to convert a string into SHA1 in zoho ??? If yes then provide me with the information regarding the same... Thanks
Invalid email address when loading from variable
Hello all, When I am loading the variable "mailtolist" into the carbon copy field of the sendmail function it appears to work fine as long as there was only ONE email address in the Contact_E_Mail field. However if I have multiple email addresses in the Contact_E_Mail field then I receive an an error when I try to submit my form. mailtolist = Districts[District_Name == input.District].Contact_E_Mail; sendmail ( To : input.Operators_Email_Address From : zoho.adminuserid CC
Mixing up Forms and Applications
Hi, I just started using ZOHO today and missed the concept of the "Application" - that this was the "Main Database". I created a couple of forms under separate (individual) applications that should have been forms under one application. Is there a way to copy these forms to the one application? Thanks
How do you integrate Zoho Creator and Zoho CRM? What does it look like?
Hello, I am the administrator for our company and we currently use Zoho CRM to collect and manage our data. We need to create different custom account types for parent accounts, manufactures and etc that can be looked up with in our standard customer ACCOUNT or by the "TABS" in Zoho CRM. I was told you can create custom "TABS" in Zoho creator and have the TAB be shown in CRM. I need to know what this look likes and how it really connects so I can present it in order to get the OK to purchase this
commented out code being deleted
As of today, lines of code in user defined functions that have been commented out using "/*" and "*/" are being DELETED when the script is saved and then reopened for editing (or window refreshed). Anton
HELP... form lost all color and notes fields
Hello, Just launched this to 100 of volunteers and the form lost all formatting with color and notes (headings) It is just a plain form with 80 fields now. We need the form to be colored with heading in order for our volunteers to be able to use. Can anyone tell me what I must have shut off or how to get around this? If I edit the form, everything is there. It is also there if I add a record. Only when I click edit on a record from the data sheet do I not see anything but a plain form. Anything
Changing the "from" field in the email response
Hello, My company is using ZoHo Creator as an intake form for potential clients, in a sense. I have it set up so when they submit the form, they get a thank-you/confirmation email. However, the from field in the email comes through as "info." The admin email address we signed up with is info@[companyname.com], so I understand where the "info" comes from, but I'd like to be slightly more professional in the confirmation email to our clients. Ideally, it would be "Company Name" and not "info."
Populating fileds
My question is how do you fetch the data from the CRM by calling the recorded Then populating the a field Eg test = Test [CRM_Lookup == "8000210000000000 "]; // do i call name or the id input.my_input_box = test.field_name_from_crm ; but get the error test.field_name_from_crm dose not exist How do I know if the lookup has made a matched ? is there a simple example to get started using the scripting as i have not found anything Thanks
How to get the Record ID of Zoho CRM object from one stateless form to the other, in order to update the same record in CRM from the other form in Zoho Creator?
I am having 9 stateless forms in zoho creator. In the first form, I am creating a Lead record in Zoho CRM. From the 2nd form and so on, I want to update the same Lead record with the input values. How can I do that? Is it possible to get the Lead ID in all the forms from the 1st form?
Sub Forms
Hi, I created a form to be used as a subform. In that form I have scripts to hide/show certain fields depending on selection criteria. They work fine when I test the application. However once I use the form as a subform those scripts no longer work. Is that normal? Is there anyway around this? For example I need to create a Survey for visiting bakeries. A lot of the input is about the store itself but then we need to start recording the product range and costs etc. I had hoped to create the main
PDF export does not respect landscape mode using 'New PDF generation'?
Hi, I have an issue with PDF export of HTML views. As you can see from the below screenshots, the PDF output looks good with the "New PDF generation" disabled, but an extra page is added at the start of the document. With the new PDF generation enabled, the extra page is gone but the table looks cramped and unattractive. Is there a way to have the best of both worlds - no extra page, plus report looks nice? It looks like the new PDF generation does not respect landscape mode or otherwise it is not
Adding Users
I'm still having problems adding other users. I've added the email address of the user I want to invite, but he doesn't get an invitation. Please confirm the process required to add new users. Thanks, martynhale
long forms
Hello I need help with a very long form, that i would like to split in several small forms, but still using the same recond on the table. Thanks!!
Displaying previously defined relationships in forms / tables
Hi, Hoping someone can help me with my problem. In my database, I have Form A & Form B. In form A, I have linked a "Name" with a "Region" that person lives in. In form B, when I use the lookup function to select the person's "Name" from form A, I want it to automatically display (on form B) the "Region" the person lives in (as previously linked in form A). Can somebody help me? Thanks, Andrew
URGENT :: PostUrl has been broken by a platform change as of today
In our app we rely heavily on the PostUrl function to call various third party APIs to generate emails and SMSes to clients, among other things. As of today this function has suddenly broken which is having a serious impact on our small business. This must be a platform issue as I have not changed the relevant script in our app. The format I use is as follows: the_response = postUrl(url, json, headers,false); The error generated (as of today) is: Execution Failed Error details: Error in executing
Trying to populate e-mail address from another a form and send e-mail notification to that e-mail
Hi, I have two forms. 1. "Staple Goods Project Purchase 5" 2. "SG5 Registration Form" In my "Staple Goods Project Purchase 5" form, I added a "City, State" lookup field which is attached to the respective contact e-mail address entererd in my "SG5 Registration Form". I want the "coordinator contact" field in the "Staple Goods Project Purchase 5" form to populate the respective e-mail address so the form can be submitted to that particular person's email in the notifications settings. How can I achieve this?
Is there a problem with Zoho servers?
Hi, we've been having intermittent problems with Creator all morning across a couple of applications. The applications are either slow to load, don't load at all or the html views are incomplete (ie only some of the forms and views in the html view will load). We are using Firefox, Opera and Chrome. We have tried logging out and logging back in again. The problem is occurring across multiple sites as well so we have established that it is not a problem with our ISP. Please can someone have a
Help with updating record in a different form.
Good Morning All, I am having a little difficulty getting something to work. I am trying to update a length across two forms. One is an inventory master and one a usage pane. After it is used I need deduct it out of the inventory master. I have tried the example of the Library which lead me to. Overall 2 Forms Tally and Material_usage. Length_field is Length of product in Tally Remainder is Material Left over and to be re-written over original length field after Material_Usage is submitted.
Data not being updated
Hi. I have a strange problem when I'm running my app where the updates I make to a record are lost after the 'Update' button is pressed, even though I get the "Data updated successfully!" message. Here's what happens: 1. If I edit the record by choosing "Edit" from a view which shows the list of records for that form, everything works just as it should: I update some fields, click 'Update' and get the "Data updated successfully!" message. The changes I made are permanent. Excellent. 2. If I edit
Scripting Question
Hopefully this is a simple solution, but I'm attempting to take the information from a drop-down field to calculate the field of a single-line to help automate the entries for our techs. Basically if a tech selects Drop-down1, 1st result, I want Field2 to populate with 100. If the tech selects Drop-down1, 2nd result then Field2 should be populated with 350, etc. Thanks in advance,
Special Character (German)
When importing an .xls file zohocreator doesn't recognize special characters - I mean be special characters those that are not part of the English alphabet like German alphabet (ö,ü,ä,ß) or accents. Instead of the symbol � should appear the following letters. Is there a way to solve this problem without editing them one by one?
HIPAA Compliance - update?
Previous posts indicate Zoho was developing a HIPAA compliant service. Any news on that front?
Nonprofit newbie needs creation help
Need to quickly computerize call records/resources for our new, very low-budget crisis helpline. Am trying to do it in the free version of Zoho. No problem creating the call intake form for our volunteers, but can't figure out how to create/link our resource sheets -- similar to how the appear in the Emergency Resources links at: ChristChurchLink.com (I can simplify the tables to only 5 columns) Would love to have a form for each resource page - ideally so that the volunteers can check off
Rich Text Data by Email
Sending a rich text email from GMail to a Creator form results in plain text data being transferred. However, if you send the email from a Creator form using the rich text editor field to another Creator form, the rich text data is transferred! I have identified that this discrepancy is due to how Creator sends an email. In most "normal" emails, there are two MIME blocks, one for plain text and one for rich text. For example, the parts will be separated and designed by this: Content-Type: text/plain;
Print customised view or form
Dear Sir I am using Zoho to keep data of enquiry, quotation, purchase order etc but I wonder how can I make up my own layout and can pull whatever data I want on a single A4? For example, how can I print the data with my own template where I can choose to pull which data I want to print out with my own letter head?? So I can print Quotation Form to my customer or Purchase Order to my supplier?? Please kindly advice Boyd
reports not updating
It seems like, more often than not, my reports are not being generated correctly. I have to always go back and regenerate the report. Is there a way to do the regeneration via a deluge scripting preferrably in in the schedule environment. IE. when a schedule is invoked it will do a "regenerate" then it will send email.
Not able to set criteria
When I try to set the criteria I receive the following message: "Exception ocurred while publishing message to the topic :: [DataModelTopic]" it was working ok and suddenly it didn't let me do it.
Adding numerical values to drop down options in conditional statements
I am making a custom form through the dynamic content that deals with buying items through paypal etc. I'm trying to make it so that I can add in financial aid meaning a discount is given and the amount of discount depends on the option they select from the drop down. Currently, when I submit the formula, it does not give me an error message, but instead, erases my IF ELSE statements with no notification. I have net amount on the bottom as an amount the form calculates based on the price of the item
Upload image from my own website and own form
How can I use my own and external form in order to upload an image to my Creator database? At this moment I'm able to upload text fields, for example the image name, but I can not find the way to upload the image file itself. Can you help me with this issue? I hope you can understand me because my English is not so good as I would like. Thank you very much in advance.
Script
Ok, I give up. Hours and hours wasted trying to get this simple script working. I have hidden a number of fields upon form load (no problem). I am trying to get some of these fields to display upon selection of a Multi Select Field. e.g Multi Select Field (called Cakes) Contains Whole Cake Sliced Cake Specialty Cake So when I select say Whole Cake then I would like 2 hidden fields called Whole Cake Description and Whole Cake Cost should appear. The script Im trying to use is as follows - Cakes -
Using getUrl in Creator to get data from Recruit
My URL shows XML data from Build XPath as well as in a browser. However, in deluge script, there is no responseText data being returned. My code is: url = (((((("https://recruit.zoho.com/ats/private/xml/ClientContacts/getRecords?apikey=") + api_key) + "&ticket=") + ticket) + "&searchCondition=(Email|=|") + input.email) + ")"; mapvar = getUrl(url,false); stringdata = mapvar.get("responseText"); The url resolves to: "https://recruit.zoho.com/ats/private/xml/ClientContacts/getRecords?apikey=40820606c514b452c1ba83c8386c2ddb&ticket=f440b1de14a0a74cd4320d7ec2f2d81c&searchCondition=(Email|=|fn@ln.co.za)"
Fetch date of last donation
Hi all, I've got a question that I've been trying to figure out for a while now without success. Here is the scenario. I work for an organization that provides foster care to blind orphans. (queue violin music in the background). I've made a Zoho database to track sponsors and their donations. I can register new sponsors, link them to a child, and record their donation. When an existing sponsor makes a donation all I have to do is select his/her name from a drop down list and the form will auto-fill
Electronically sign form.
Hi guys I have a few forms that need to be signed by clients at the moment we are printing and then signing. Is it possible for the client once he/she has filled the form on one of our tablets they can digitally sign it? With their finger?? Or can I embed this to the form and get it to attach the file to the record ? http://www.realsignature.com/ Any help would be great :)
wrong error message when adding duplicate values
If I try to add duplicate values in a field which has "Do not allow duplicate value" option checked, the error message which appear is the following one: Error occured while on Success script. Unable to update variable Error occured. This is displayed even if there is no script at On Add - On Success. Regards, George Baltatescu Zoho Creator Developer
Options button on shared view
Hi, I have created a Zoho app and am sharing the view with my collegues. However, when I load it as a tab in our 'normal' Zoho CRM, I don't have the options or print button at the top of the view, to make exports for example. In the actual application I do have them, but I don't want to send them to the custom app (and lose all the 'regular' navigation in CRM). How do I make a tab in Zoho CRM that does display the Options button? (just like all the other tabs) Thanks! Pieter
How can users log in and directly go to the shared up, without having the shared link.
I use a Creator database for a small startup. The other employees are set up as shared users, but unless they sign in directly from the bookmark, they can't find the database. In other words, if a user goes directly to Zoho Creator and signs in, there seems to be no place for them to find and access any apps that have been shared with them. Is a shared app only accessible via the link URL?
excel formula to deluge ...number^power
Dear all I am converting an excel formula to deluge i.e. =10^((0.0031-1.4/($C4+273))*($B4/100))...(works fine in excel) $C4 = Operating_Temp_C $B4 = Operating_Pressure_kPa =10^((0.0031-1.4/( Operating_Temp_C +273))*( Operating_Pressure_kPa /100)) but get this when I enter it? Lexical error at line 1, column 3. Encountered: "^" (94), after : "" From the web page https://sheet.zoho.com/functions I found the following? POWER Returns a number raised to a power. POWER(number; power) Returns number power,
Urgent Help - How do i update my data from an xls sheet
I keep my data in an excel sheet and have uploaded the data to create the form and database. However, I cant work out how to update the data in zoho creator. Some data in each form will change offline and i need to be able to upload the new data overiding the fields in certain records. Please help
simple report to show data entered
Hi all, I am looking for a report that lets me simply report back the data i have entered. I have 20 items to enter and then i just want a report that shows 20 column headers for each row. All i seem to be able to do is pivot tables which wont allow the large number of columns. Any help with reporting many thanks
Next Page