Bug with embed report in HTML page
I embedded a report in an HTML page and the height sometimes doesn't show all the records. This problem only happens when I open the app for the first time and click on the page link, or if I refresh my window, and click on the page link. The report shows all of the records when I click on the link for the 2nd time. But I wanted to try something. Below is a picture of two reports that contain the same exact script. These 2 reports contain the EXACT same script, but one shows all of the records,
Dyanmic Subform
Hi, I have created travel form for Employee travel management. I want to create conditional form. Condition is here. employee may have either international travel or domestic travel. employee may have international travel as well as domestic travel. First, Employee will fill the international travel form. if he needs domestic ticket he can apply for it. Here i want conditional form. if employee says " YES" he needs domestic ticket then this form will appear down side to the international Form, If
Time Field
Hi, I want to manipulate a time field without displaying the date but there seems to be no time field available, just a time date field. Is there a way to hide the drop down calendar in a date-time field and just make it display time? Why isn't there a time field?
Create a report with calculated column and filter by calculated column.
I have a invoice form with invoice date, duedate. I need to generate a overdue invoices report where duedate is past current date. Also, I need to show the number of days between duedate and current date.
How to call a field name from another form ?
I have two forms in my application . I want to get value/data form one form to another one . How can i can get value/data form one form to another one and How to call a field name from another form ?
Filter a Report based on a date
Hi, I am building a club membership app. Each member has an expiry date. I would like to generate a report that displays a list of anyone expiring within, say, 45 days. On a the report, I am trying to use a Criteria condition. Expiry Date >> Before >> (now + 45 days) How do I code the "now/today + 45 days"? Best regards,
Restricting View For Calendar
Hello, I have created a calendar report that is based upon a CUSTOMER form that contains information such as... Assessment Date Assessment Time Support 1 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Support 2 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Rep 1 (once confirmed, ADMIN then assigns the lead to a representative) Rep 2 (once confirmed, ADMIN then assigns the lead to a second representative
Column Creation
I've searched all over and cannot find where I created a multi column view. I created this view and cannot find where to edit it, it changed the behavior of the fields on entry and I would like to delete it. Sorry for the vague reference, I'm new to the product and not quite familiar. Thanks!
Open url after deleting a record
How to OpenURL after deleting a record? I put the script in On Delete -> On successs and also on Delete -> Validate but its still not working
Search field in the dropdown
Hi, It looks like there is no search field in the new android version of the zoho creator app. How can I fix this? Regards, Gianfranco m
"You are not authorized to view this record"
This has never happened before. I am the one who is creating the application. How can I take this off? Any linked record within this specific record summary gets this error. If i work my way around the application, I can view the linked records, but if I try to view them via record summary from another linked record, I get this.
Auto populate fields in same form
On User Input I would like Curr_Version_Name and Curr_Notes to auto populate into a field (while remaining in their current fields) called Notes_History and to add a date/time stamp + a single line space In that same form I would like any changes On Update of the Curr_Version_Name and Curr_Notes to add an entry below the last one in Notes_History Been stuck on this one for a while. Would appreciate some help. Thanks, guys.
Lookup field question.... using the If statement to refer to the user input
Hi I have a lookup field named 'country' in a form which is looking up country names in another form. I am trying to write the code below to say something like "if the country = Singapore then make the 'project sell cost' field visible, which is currently hidden. My dilemma is how do I refer to the actual country name? Currently I am using the code below which is using the ID of the country. What am I doing wrong? Regards Martin
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
Next Page