displaying a Signature field on another form
Is there a way to display the contents of the new signature field on a different form? With an image field I can display the contents in a note field on the second form. But I have been unable to get the signature to format and show. Thanks for your help. Herb
Cannot adjust width of custom action column in report
I have already managed to adjust the width of columns that aren't custom actions. But when I try to adjust the width of a custom action and then click "save changes" it goes back to how it was. I also tried adjusting the width via report definition but this also does not work. This is what I want This is what I keep getting even after I click "save changes"
crm create quote - why are price not calculated automatic?
The quote and product price are not automaticly calculated when adding a quote and product with deluge scripting. Screenshot in Swedish language: If unit price and quantity is given, it should calculate the product total, right? If I edit the offer, the product total is automaticly calculated and added as soon as I enter edit mode. The total amout isn't either calculated automaticly. If I am in edit mode and edit tax, then the total amount is calculated. If I manually create a quote with the very
Upload to Google Drive
Hi Zoho, I know its been discussed before but I could not find a solution: I have a form that is uploading files to the Zoho system, I need to store that file on the Google Drive as well, automatically. Can I use Google Drive API in a postURL script in order to add the file? or can I send the file as an attachment to email? Thanks a lot Ravid
Linked record does not view in HTML
I have an HTML page that has text and is hyperlinked to a report. When I click on the hyperlink and the report pops up, I try to click on a linked record in the record summary but nothing happens. The report simply closes. What's going on? Below is a picture of the report that pops up. (this happens with any report, by the way). When I click on Event Date, the report closes. Also, it closes if I simply click on the record to view it.
days360 function return incorect result for March month
I try to use the days360 function to get the number of days between the first day and last day of March and it returns incorrect result: 29 instead of 30. For all other months with 31 days the days360 function will return correct result: 30 between the first day and last day of the month, only for March is shows 29. The strange thing is that until year 2007 it will show correct information: 30 days between 1st of March and 31th of March but starting with year 2007 it will show 29 days between the
Triggering a Zoho Creator Function from a Custom Button
Can I create a custom button, placed in another application, such as Zoho Inventory or CRM to trigger the execution of a function defined in Zoho Creator? John Legg Owner: The Debug Store
Zoho Creator Access to other Zoho Applications
Hi I want to be able to use Creator to read and write to data used in other Zoho Applications, such as Zoho Inventory and Zoho Books. Can someone please direct me to information that will assist me do this? I assume that it will be necessary to access each application's API. Many thanks John Legg Owner: The Debug Store
Limit data displayed in field in report
Hi - I have a report with a comments field that sometimes gets quite lengthy. I don't want to limit the input on that field, but when I display it in a report, that field can make the row for the record take up most of the page. Is there anyway to truncate the amount of information displayed for a given field in a report? Basically want to keep my reports crisp looking without limiting the underlying data in the form. Thanks.
Can I use a custom action to open a form and populate a lookup field?
I'm using a report with a custom action, trying to open up a form and populate a lookup field with a project code but having issues. My custom action function is as follows: void display.BookAppt(int id, Add_Project proj) { openUrl("#Form:Book_Appointment?Project=" + proj.Project_Code, "same window"); } On the Book_Appointment form, I have a lookup field called "Project" and I'm trying to pass the "Project Code" value from the Add_Project form, but it isn't working. if I change the function to
Transfer data from dropdown to a new form on submit
Hello, On submit I transfer data to another form which is working. However when I transfer data from a dropdown it reveals the ID of the dropdown and not the text. How do I code to transfer data from a dropdown into a dropdown on another form on submit? insert into Paraplanning [ Added_User = zoho.loginuser Case_Details = input.Brief_Details_of_Advice_Given Case_Status = "New Submission" Client_Full_Name = input.Client_Name_to_be_Used_within_the_report Date_Received = input.Date_Submitted
Basic Subform Behavior
I'm scratching my head trying to figure out the basic subform behavior. What I expecting was the subform (based on a form linked to parent) would act similarly as a list report. Where you could click on the row and the actual form would popup with all the fields available for editing the subform information. However, what it does is all editing of only "shown" fields in the row of the subform, With no way to get to the actual form, that I've found. I building a contact list. Parent form is Customer
Zoho Creator Basic (25000 records) vs Standard (1000 records)
Hi, I have a Standard subscription that offers only 1000 records per user and 10 apps. Is it possible to move to Basic subscription that offers 25000 records and 3 apps? What other differences are between these two plans? Best regards, Juan
Embedding images in record summary
Hi, I am having trouble trying to design the template for record summary. For each event_report record that I have, there is a list of customers for this event, and a list of images that has been uploaded for the event. When I try to design the record summary template, I could find this field for event images (Around 6 to 8) with its related description. After this is added in the template, instead of displaying as [Description1][Image1] [Description2][Image2] [Description3][Image3] [Description4][Image4]
API Response Javascript Function
Hi, the problem is that a creator api call return a variable or javascript function and no valid json response. Can you please add a valid json response. Thank You, Daniel
Fields
Hi all, Can i create a field with block in it? more like separating the filed in lets say 5 blocks for the user to put data in the blocks Thanks.
Paypal issue
I am having an issue with some payments from PayPal, when completed and returning to merchant the screen just say transaction being processed please wait, this just goes and on. The payment is being completed and the confirmation email is sent, but the hang screen is worrying customers. Is this ipn settings in PayPal and if yes what is the return url address I put in, and will this work for forms and creator? Thanks, Simon
How to remove applications in Zoho creator I no longer want?
I do not see these applications in my account through the computer in order to eliminate them. I already deleted them but I know it's still there. I know they exist because I see them through the application of the cell phone and when I try to create another it tells me that I can not add any more. I see the application of the Electronic Teacher's Book as four times and I'm not interested.
get link value of URL field
How do you get the value of the link from a url field? I want to use openurl to open the url from a url field. If I use openurl(url_field, New Window) It uses the Link name not the actual link.
Zoho Creator iOS app 3.7.2
Good day, just updated to latest version 3.7.2. which in the release notes says to feature offline support. Is this to be interpreted as now possible to enter data while no network available?
Embedded Report in HTML page: Header title being cut off
How can I fix the issue below? The Header title is being cut off
Average weekly visitors
Hello, I count daily visitors, have unique names. Users want to have the statistics, where they see average Distinct weekly visitors in a month. Lets say first week I had 11 distinct Visitors . Next week I had 15 distinct visitors. So the proper calculation would be that I had (11+15)/2 = 13 .. on avarage in one week I had 13 distinct visitors. Is it possible to do this in Pivot report? It gets more complicated when I have the whole month andin this month 4.5 weeks, I have then to do the maths as:(11+15+12+17+6)/4.5.
Cash register
Hi all, Is there a possibility to have a cash register with zoho creator? Where simply i can get a record and print out a receipt with a epson printer? Thanks!!
User permission for application?
Hello Zoho Team, is it possible to setup my application for the user's (Login via E-Mail) that he only can create a new record and not delete anything in the database? Regards Carsten
Upload File to Google Drive
Hello, Is there any way to have the "Upload File" button in Zoho Creator push the uploaded file to a Google Drive folder directly? Thanks.
How to find and set a value into a field from another form?
I have 2 forms. On occasional basis, I add new name into the first form and assign particular tax rate and commission to that name. Daily, I need to enter data into the second form. I choose a name from "lookup/drop down" menu connected to the first form and fill out couple numbers. The form calculates the rest. What I need is, depending on the name I select, to automatically look up and fill the tax and commission that were set in the first form. What would be the best way to accomplish this? Thank
How Does one print a Form?
I have created a number of forms which I would like to print out for Government record keeping purposes. The format of the zoho-created reports is unacceptable. Is there perhaps an "OpenUrl " expression that will produce a new window that can be printed? Is there another way to do this, or should I be looking to something entirely different to accomplish this? I see the "Pages" feature, but I cannot find any Zoho documentation that explains in any detail what can be done with a Page . Is there
Convertir Numeros a texto?
Quiero saber si es posible convertir números a texto en Español, Quiero enviar facturas con números y texto: ejemplo: 1000 (Mi ) ó 20000 (Veitemil) Es posible o algúna funcion similar dentro de zoho?
Zoho Api Question
Hey All, Have a quick question regarding parsing json. I believe my code is valid however it doesn't display a response when i search for specific key / value. I can however return the response->uri just fine but can't get anything other than that or the full file. function GetLeads() { $file = fopen("https://crm.zoho.com/crm/private/json/Leads/searchRecords?authtoken=API KEY&scope=crmapi&criteria=(Last%20Name:test)", r) or exit("Unable to Open File!"); while(!feof($file)) { $theData = fgets($file);
Include lookup field in function
Hi I have two forms (A and B) connected with a bidirectional lookup. I want to copy records from one to another including the value from another lookup (from form Country) which they both include. So far the function looks like this: void copyRecord(string First_Name, string Last_Name, string Email, string Profession) { insert into New_Profile [ Added_User = zoho.loginuser First_Name = input.First_Name Surname = input.Last_Name Email = input.Email
Total income calculation form
Hi , I wonder if anyone can help me. I have a job process form where by the user records a job undertaken, which calculates agains a job form. So there is a list of jobs complete in a report. I want to a separate form where the user can select a month of the year, and it will calculate the earnings over that period. I have attached a screenshot below of the "Job Proccess Form" which i would like to build this new form from. Thanks for your help in advance. Danny
Numerical format field report
Good Morning
I could collaborate, to know how to format numerical reports Zoho Creator. For the numerical field shows it without any format and I would like, if possible, to show it with scores of thousands, hundreds, etc.
Example: 1234567 see 1.234.567
Thank you for your cooperation
Add edit button to record summary
Hello, I have taken a look at these 2 posts https://help.zoho.com/portal/en/community/topic/how-do-i-create-a-link-to-a-pop-up-edit-window-in-an-html-view https://help.zoho.com/portal/en/community/topic/tip-using-duluge-create-url-field-with-dynamic-parameters-such-as-record-id But none of these posts solved my problem. When I click on a linked record from a record summary, I want to be able to edit that record in a popup view within the application. I've gotten this far temp_param = input.ID.toString();
How to get value of field in current record
Hi, I have a table called 'Classes' In that table, I have a field called "Class1" - it is a drop down field. On the action "On user action", I want to save the value that is in the field if a user removes that value. So, if the value in Class1 == null, I want to know what it was before it was removed and save that value in a variable. This gets me the value that is in the field before it was deleted. ctemp1 = Classes [ID == input.Class1]; How do I save that value though after the field value
Mobile app Zoho creator
Hi, Can the mobile app be customized like the web app? for example the layout or icons?
"?Terminal.Id="
What does the "?" in front of the "?Terminal.Id=" mean?
Alternate version of same data
Is there a way to display an alternate version of a data in certain layouts ? For example, I have a radio button field with two choices : Yes and No. In a "list" layout, I would like this data to show as Y or N instead of Yes or No (...or show as X or "empty"), but I still want the data to show as Yes or No in other types of layout. Is there a way to create an alternate version of this data and indicate which version to use in which layout type? Thanks for your help!
Pre-tick a check box in a form
Hi, is there a way to "default pre-tick" one or more check boxes in a form the same way you can "default pre-select" a radio button? Thx!
Enable and disable fields in a subform On Edit - On Load according to an other field value.
Hi Zoho, I have a subform and I would like to know if its possible to enalbe or disable a field "Quantity" according to an other field "Status" for different rows when I open the record to edit it. I was trying the following code, but I can't even save it. for each rr in Detalil_RC { if ( rr.Status == "Approved" ) { disable rr.Quantity; } } It says "rr" is not defined. Any help will be appreciated.
Retrieving zoho.loginuser variable using email address
I am trying to retrieve a zoho loginuser variable by using an email address so i can link only relevant information to the specified customer.
Next Page