Insert field data to email issue
Hi! I want to get email notification whenever a new record added to the DB, and I insert a "lookup"field into the mail template, but when I get email, the value of that field seems not correct, it shows something like: "1929807000000018033" , what should I check to make sure it insert the correct value into that email template ? Regards, James
Problem with 2 Subforms View in HTML
Hi, I have an HTML view called "Product Offer Sheet" based on my form Create_Products. I fetch and display data from the form = no problem (using: rec = Create_Product [ID == input.id.toLong()]) Then I fetch data of on linked form = Problem (using: for each z in rec.Product_Quotes_ID) And then I fetch data of a subform = no problem (using: for each i in rec.Composition) When I try to save my free-flow script, it cannot and the error is mentionning that my used data (for example: z.Payment_Quotes_Customs_Fee)
Invoice ID Field
Hi Team I have created an invoice within Zoho Invoice from Creator. I want to extract the Invoice ID from the mapped invoice. However the following code to populate Invoice_ID does not work. As a matter of fact Invoice_ID, Invoice_Status and Invoice_Sent_Date do not populate at all (these 3 fields need to be populated right after the invoice gets created). gateWays={ "PayPal" : 1, "Authorise.Net" : "", "GoogleCheckout" : "" }; invCustResponse = zoho.invoice.createcustomer({ "CustomerName" : input.Customer_Name,
Add Number / Decimal Field without using a formula Field? Possible?
Add Number / Decimal Field without using a formula Field? Possible? Let me know if it is possible? thank you
How to create a login form to my zoho creater signup form on my website!!!
Hello any body please help me!!!! I created a registration form using zoho creator,and now i need a login form for my website connecting to my registration form data and allow my users to access my site . So please help me regarding the above problem and please explain me in detail about it!!! Its urgent !!!
Get text from a Zoho CRM field in Zoho Creator
As we know Lookup field in deluge script (input.lookup) gets record ID from lookup table(form) regardless our display settings. To access fields in lookup forms we have to use val = formname[ID == input.lookup].field; My question is, if I use a Zoho CRM field in my form with a field ID like Details_ID how can I get the text (and not the ID) of the selected field? For example this one returns the ID Name = input.Details_ID;
Dead-end ZOHO support on dynamic pick list
list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall()) ZOHO acknowledges that the code above at https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html doesn’t work. I’ve waited weeks in vain for support to get back to me with a solution. Any ideas? Thanks.
In reports, what does the "Like" search function actually do?
The only time "Like" seems to work is when an exact match is found. Therefore it seems indistinguishable from "Is" I would have assumed "Like" should function as a fuzzy string match, like php's levenshtein function. Cheers, John Whitney
Populating information from CRM Modules
So I am trying to use code that I have used previously with no luck. In the past I have used the CRM Lookup to populate fields in a creator form from the Leads Module. It works perfect every time. Now I am trying to do the same but pull the information to/from the Accounts module and get a generic error every time I try it. Code that works: crmResp = zoho.crm.getRecordById(("Leads"), input.Zoho_CRM_ID); input.Company = (crmResp.get("Company")).toString(); input.First_Name = (crmResp.get("First
Using a record as a template for a new record
I'm wondering if this is possible and if my idea of how to do it might work. Maybe someone has an example of this they could share? I want to be able to create a new record that pulls all the value from another record (the template record). The simplest way to think of this would be a drop down that when a value is selected will fill in the entire form. I don't want to code this long hand and instead I want the values to be fetched from another record that is a template already filled out appropriately.
is below stuff possible with Zoho Creator--imp
hi, our Organization basic requirements needs enlisted below 1) Authorization:- Admin assign roles to user then same roles will be approve or reject by Manager , according to that user can access forms. In case if Manager reject role same will be informed to Admin. 2) Sending Mail:- In case there are errors while importing data ,send respected errors as attachment to Manager and user. Then Manager will check data and approve or reject data. 3)Data Import:- When user import data ,same
Embeding Image In Creator from URL of Image Using Deluge Script
I would like to be able to pull an image into my forms image field using it's URL by Deluge Scripting. Here is the URL of the image I want to pull in: http://s3.amazonaws.com/gimages/san432/4169643/21826/Image_1_ae045da0-acb2-0131-847c-22000a1fb1c7.jpg Is this possible? In other words; I want this image to reside within Zoho Creator, not on another server. Thanks for any help.
Confirmation email sending ID instead of contents of Lookup field
I have talked to ZOHO many times but can not get an answer on a very serous problem for me. So serious that I might have to drop my account with them. My confirmation emails do not show the actual data in a lookup field. Instead they show the ID number which is of no use to me. Zoho simply says that is the way their new editor works which is simply insane. I am not sure if maybe Zoho support does not have a good command of English and they are misunderstanding me or they really have designed
Subform field actions not working in parent form
I am creating a sales order form that will have a subform, called products, that has a lookup field that searches ZOHO CRM-Products. The products form also has a quantity field and a price field. I added a field action to the lookup field that populates the price field with the price of the product selected using this: crmResp = zoho.crm.getRecordById("Products", input.Product_ID); x = crmResp.get("Unit Price"); input.Price = x; This works fine. However, when I access the the subform through the
SendMail Not Working
I have a public sendmail form but require users to zoho-login before they can see it. Here's the error Here's the form Cheers, John Whitney
fetch email from zoho crm to zoho creator
having a hard time doing this because i'm a nood :( Hope you can help me guys. Here is the code i use but it did not work :( if (input.Contact_Name != "") { vSearch = "(Contact_Name|=|" + input.Contact_Name + ")"; crmRes = zoho.crm.searchRecords("Contacts", vSearch, 1, 1); if (crmRes.size() > 0) { fa = crmRes.get(0); input.Email = fa.get("Email"); } } Here is the pictures
How to upgrade my zoho account to have new features?
We have been waiting for user permissions and some other features that i just found out are already integrated but only in new zoho accounts! How can I upgrade my zoho account to have these features? Do i need to cancel my entire account and attempt a migration? How can I get these needed features? I wanted to use customer portal but its mostly useless to us if we do not have access to user permissions. Please help me here. Thanks
How do I make a result report for just the last entry added?
Basically I have a report that displays deals that users have submitted. I would like to have a second report that will display the last deal entered. How do I do this? In the creator it seems to have minimum of 10 results. And what option/filter would I use to select last entry for display? 2nd I would like to know if there is a way to have the users select an entry and report it as expired. It is a public report so I don't allow user edits to avoid accidental or intentional deletion of the whole
Unable to set correct variable
I am stuck, and in need of some assistance please. Line 5 (VAR_Tool_State) if I understand correctly should return the newest entry that meets the two criteria stated. However it is returning the FIRST entry made for the tool and serial number combination. Any ideas? Support has access. //ASSETS Current Location Lookup VAR_Location = Assets[(Part_Number == input.Part_Number && Serial_Number == input.Serial_Number)].Move_Asset_To; VAR_Assigned_To = Assets[(Part_Number == input.Part_Number && Serial_Number
Company Info on Form
Hello, I created a form in Zoho creator for Invoices. I have added all of the fields necessary. All is good but at the top of the form I would like to include my company name in case I need to print the Invoice. How can I add/embed the following to the top of the form? Invoice My Company Name Address City and State Zip Phone Thanks. Iram
Find and set null values to 0 in curancy field.
I have a currency field in which I did not set an initial value so it shows up as blank in my view. I now would like to find all null or blank values in my view/report and set them to 0.00 with out impacting the existing values. Please would be very much appreciated. Thank you very much
Export report to email?? Possible or not?
Can i ask if this is possible??
Formula data type doesn't show up as Currency
I have a formula field (Revenue) that is calculated from multiplying a Number field times a Currency field. The result is not showing as a Currency field. Details: Qty is a user-input field, data type is Number Price is a user-input field, data type is Currency (USD) Revenue is a formula field, (Qty * Price) -- it should be shown as a Currency type, but it's showing up as a decimal field. How can I make Revenue show up as a currency data type in my views and reports??? Thanks.
Cannot iterate all values of a subform in HTML view. Only the first one appear
Dear Zoho team, I am working on an HTML view (page) add it to a custom function in a report and it works fine. It is a "Product_Offer_Sheet" HTML. It will fetch data from my Form "Create_Product" No problem about that but in this HTML view, there is one table where I must display the composition of the product which is in a Subform "Composition" of the Form "Create_Product" I did the following code but I can only see the first record of the subform htmlpage Product_Offer_Sheet(id, hidePrint) displayname
Newbie needs expert advice PLEASE!!! :)
Hi All, I have two forms, Job Enquiry and Customer List. In the Job Enquiry I have a dropdown box field that selects if the client is new or existing. If new is selected I want to be able to automatically open the customer list form and complete the add new customer data entry. If possible I would like to be able to select a client company name from a drop-down list in the job enquiry form and the other associated fields from the customer list (I.E. Contact name, telephone number, email, address,
How I get the content of lookup field rather than record ID in NEM?
Hi, I need to make tips according to the lookup field contents, such as : if ( lookup = "male" ) { alert "You're a man"; } else if ( lookup= "female" ) { alert "You're a woman"; } But now I get ID from lookup field, should I need to search data using ID from another form like this ? var = form[ID=lookup]; if ( var.sex = "male" ) { alert "You're a man"; } else if ( var.sex = "female" ) { alert "You're a woman"; } Is there any way to get it convenient? Looking forward to your reply.
Zoho Creator Mobile Version
Hi guys, Still quite new to Zoho and how it all works. We have previously used Zoho Creator as an entry form - as it's a great way to get a database of people that Opt in. This is the old site we did and integrated Zoho Creator: http://www.adlab.com.au/promo/ The only report back we had it the site didn't work well on Mobile Devices. We now have a new promo starting and they want it mobile savvy. Just wondering can you use Zoho creator generated code to work properly within a mobile site? Please
openUrl vs record-edit
I use my ZC app in a Google App window (i.e. thin border, no back forward button etc.) When I use: openUrl("#Form:... , "Popup window"); to open a form and populate it with data ready for any additional editing then when I use 'Popup window', the form opens in a true popup in the original app window and when I click Submit, the popup closes leaving the original window as was. When I use: openUrl("https://creator.zoho.com/.../record-edit/.../", "Popup window"); to open a form for editing
Adding Data From Email (Disclaimer, Signature, Images)
Hi has anyone found a way to get Zoho Creator to ignore footers at the bottom of an email when adding data to a form through email? I have setup an excel file that uploads to our database however I have found many of my clients have a Disclaimer, Signature, Images etc at the bottom of the email. I am getting excel to generate the email as n HTML file however any text after the form information causes Zoho to generate an error. I contacted support and was told the is no work around. This is a huge
please help for this
hi, our Organization basic requirements needs enlisted below 1) Authorization:- Admin assign roles to user then same roles will be approve or reject by Manager , according to that user can access forms. In case if Manager reject role same will be informed to Admin. 2) Sending Mail:- In case there are errors while importing data ,send respected errors as attachment to Manager and user. Then Manager will check data and approve or reject data. 3)Data Import:- When user import data ,same
Can we upload images from zoho creator to zoho Crm
we have a feature to add image in Creator and can we get the same image into the zoho CRM invoice ,like i want to create a customer Catalog and when a purchase is happened i need that image to be on the invoice.invoice contains ,Cus name,phone,collection name (image),model no and price.....
Making report based on existing report instead of table/form??
Hi All, I have two forms. Form 1 contains Product related details and form 2 contains stock related details. I linked both the forms to get product-wise stock related details. Now, if I want to link another new form to this report. How can I link it in Zoho creator? Please help!! Thanks! in Advance.
Adjust column widths in record view
Hello All, I am attempting to create a record view containing a table where the column widths vary. I inserted a table into the view with 5 columns, which creates equally spaced columns spread across the width of the view. I then edited the code for the column %'s. The column widths adjust as expected in edit mode. However, when you go to the record view in the application, the columns are still equally spaced. I am experiencing the same issue width the border weights for the same table. Any
Cancel Delete if there are records in another form that are related to the form I am trying to delete
I think this is simple. Basically if someone tries to delete a PO that has a single or multiple time records associated with it I want it to cancel the delete. I am not sure if I need to count and then create a condition off of that count for it to work? For example, rec = Employee_Time [ID == PS_Work_Order_Purchase_Order]; if (rec != null) { alert "There are Labor / Equipment / Material records in the database you cannot delete this PO / WO!!"; cancel delete; }
business rule.
Hi, I am trying to add following business rule. Please let me know how can I do this. Check box1 Check box2 If the check box2 is checked we have to make check box1 as mandatory. Can this be done by creating creator rule or do I need to do this by java script. Thanks in advance.
How to Make HTML Content Editable without JavaScript / jQuery?
Dear Colleagues, My question is general and I do not know if it is possible to do that in Creator. Let's say that I have an html page with a simple table like <table> <tr> <td contenteditable="true">Hello!!</td> </tr> </table> As we know, HTML has an attibute called contenteditable, in which we can edit the data in our page. The problem is that if I change the text and then click the Print button, it returns 'Hello!!' and not the text which I last inserted. I think that this is because
You have reached maximum number of rows. You can not add further.
Using an funcion, and adding a attachment in subform, Zoho is telling me that I have exceeded my maximum number of rows (110,000). Does anyone have any idea why that might be the case? Thanks Mike
Publish app to client and relinquish ownership
I want to publish source and data to a client and then allow that client to publish the app as if he were the creator. [What I am really trying to do is "give" the app to this person to develop and use as they see fit.] I can publish the app and the client can use, edit, and share the app with his users, but when he goes to Developer Zone, it shows he has 0 apps developed and there are no apps that can be published. The only things there are the apps I shared with him, which are under "My Installed
Problems in sharing my applications
I have tried to share my application as public. It didn't get shared, neither did it show any messages to me about why it did not get shared. But making a form as private from public is happening successfully.
Issue Uploading Logo
I'm sure a ton of you will pass this post right up, but that is alright by me. I've been winging it through trial and error and answering most of my own questions. The embarrassing thing is that I cannot seem to upload my logo. The diminsions are exactly 90 wide X 55 long, and the file type is a .png. When I go to upload, the upload status bar just keeps going and going. Am I missing something?
Next Page