Dynamic Picklist not submitting selected choice on add
I set up a dynamic picklist and the options available in field 2 depend on what I selected in field 1. The problem occurs once I hit submit. In the corresponding report, the option I selected in field 2 is not recorded. The record displays all other entries except the selection from the dynamic picklist (field 2). This problem occurs even if I try to add a new record from the report. The only way I've been able to get the option to stick is if I edit the record once I add it. Any ideas on what the
printing mailing labels work around?
I was reading that you can't print labels form Creator. Is there a way to do this by connecting data to to CRM or Reports and then printing them from there? When do you project to have this work in Creator? Ray
Creator Report by Record Creation Date
I want to make what I think should be a very simple report in zoho creator. The report would show us the number of leads we get per day. Should be easy but i can't see any way to add zoho record creation date to one of the report axis. Why is this field not available to add to an axis? This is a system field and i would rather not create a new field to hold the value as it is already stored. What am i doing wrong? I cant figure out how to use the Add Aggregate Formula section either so if this
Why do hard coded filter criteria succeed and variable ones fail on zc-component?
Hi I'm very confused. Why does #1 below work but #2 does not? <div elName='zc-component' viewLinkName='Properties_Report' params='zc_Header=true&ID=2811360000000011231'>Loading View...</div> <% Property_ID = 2811360000000011231; %> <%= Property_ID %> <div elName='zc-component' viewLinkName='Properties_Report' params='zc_Header=true&ID=<%= Property_ID %>'>Loading View...</div> On the surface, it seems to be a simple case of variable substitution. On the other hand, I have been fighting this
Page Printing - Not printing record detail
I have created a page "test page". In the page I have embedded a stateless form "job detail". The "job detail" form pulls information when the field "Job Number" is selected. The "test page" looks great on screen but when I print the page I get all the fields from the "job detail" stateless form with no data or record information. All the fields are blank. What am I missing?
I create new apps and I want to pay through paypal to Zoho ? but that option not available???
I create new apps and I want to pay through paypal to Zoho ? but that option not available???
Lookup displays as list on mobile
I have created an application. The lookup dropdown is displaying as a list on one form and as a click on the dropdown select from a seperate list page on another form. Does anyone have any ideas about why the same lookup dropdown would display differently? Cheers, Jon
Record summary condtionally
Hello everyone, Is it in any way possible to make a record summary conditionally? For example: When, in a form, question 1 is not answered and question 2 is answered I want only to be shown question 2 and the answer on question 2. So the question 1, which not has been answered, is blank. Or is there an other way to generate such a summary? Maby trough pages? I really hope someone can help me I even want to pay for the solution and maby you can help me build it. Greatings, Erwin
Report
Hello, I have a form with 30 questions. A customer answer these 30 questions with answers. Some questions can't be answered. So a couple of fields will be empty. Now I would like a report or export to excel with only the answers which have an answer. Is this possible? Or how can I fix this problem? Maby I can use the On Edit --> On load functionallity like: if (input.field1 = null) { hide field1; } The problem is I can't export a form in the on edit mode. Or is it possible to generate attachment
Data based upon Form responses?
I'm looking for a way to capture Form answers and turn them into numerical "score" outputs. For instance, if a respondent answers A to Question 1, I want answer A to equal 6 points, and if they answer B, then B might equal 9 points, etc. Instead of me manually tabulating the numerical scores based upon respective answers, is there an "If/Then" feature that would make these calculations for me and then send to me via email?
SQL Server select script upload from local server.
I am new to Zoho and still learning the ropes. We have a project that we think would fit Zoho well. We would like to use Zoho Creator as a look up table. To do this we would like to upload a SQL Select query to the Zoho database that the creator would use for the lookup. This would need to be done several times a day as the data is constantly changing. I have downloaded the uploadtool but as of yet have not gotten it to work. In reading all the info that comes with it I see a lot of references
Criteria to show today
I have a view which I would like to show only entries that were made that day. Added_time = today This results in nothing showing, even though there are entries that I have made. If I put: Added_Time in this week it will show what was entered. But I don't want to see anything other then just what was done today....
Function to import JSON data to Zoho Reports Table
Hi, I am trying to create a function in creator by passing parameters that would retrieve JSON data from external website(GET method) and import that json data to Zoho Reports Table using ZOHO Reports API. I am new in API related issue so I could not figure out how to write the script in creator. Can any help me how to code in deluge script ? Zoho Report API : https://zohoreportsapi.wiki.zoho.com/importing-bulk-data.html Thanks Arfater
View criteria for blank (null) date field?
Is it possible to set criteria and/or filter a view to show only rows where a particular date field is blank (null)? If so how? Thanks.
Create a Task list based on dates from different forms
Hi all, I would like to create a task list based on information captured for different forms ex: I have a Client's Birthday fields - on Client information Form Broker Birthday Field on - Broker Form Follow up Date - on Referral Form So I would like to create a to-do-list / Task list if any of the above happens it should be added to the list ex: Client's Birthday - Mr Koos is having his Birthday Today with his Cell number ex Broker Birthday - Koos Marias is having his Birthday Today with
Customer Portal to view their own account ONLY
I am looking at the Customer Portal for my application. I want to be able to allow users to view their record and be able to update it, view their invoice, pay their invoice, upload a file, etc. My understanding is that the Portal just gives access to areas in your application to those that you invite. How are others tackling this issue? Or is this an issue at all, am I just mistaken?
Calculate Duration with Time in text-fields
Trying to subtract to decimals and get a time in minuets and seconds. When trying to add the formula Duration_in_Decimal - Duration_in_Decimal.toLong() * 60 to a text field I am getting error : Error at line number : 4 Variable 'Single_Line' is already defined of data type 'STRING' but trying to update 'DECIMAL' data type
Zoho Creator Chrome App?
Is there a Chrome App for Creator? Seems to be an app for every other application but I can't seem to find one for Creator?
Criteria for Chart on Load
I have a database which contains records for 30 companies. I want to show a chart showing information for each company. A User Filter is not a good solution since each company should not see other companies data. Since I can't specify criteria when opening a report can I access global information such as the current login ID or IP address? Is there any way to display charts specific to each company without creating 30 separate charts?
Integration between zoho calendar and zoho creator
I am loving being able to send calendar events in Zoho Calendar, but wish all the possible fields in zoho calendar could be defined in the script. I would have thought that functionality of zoho calendar internally should be at least as good or better then the google integration. I'd prefer to keep all my eggs in one basket, ie, in zoho rather then bring another program into the mix. At the moment according to: https://www.zoho.com/creator/help/script/create-an-event-in-zoho-calendar.html you can:
Relate forms rows rows (pivot table)
Hi, I´m looking for your advice about a problem. I have two forms Team and Player. In team form I declare the name of the team and in a subform I have some more information which come from a other form (Season & Competicion) In the player form I declare the name of the player and I need to get in a subform where he has participate each season (the information I have input in the team subform) Any advice? Thanks.
Trying my hand at creating a Page
First of all, let me say that I am using ZOHO Creator for a number of things. I have been developing apps creator for around a 1 and a half. I use some pretty complex deluge scripting to achieve my desired results. I have to thank all of tech support for all of their support and help over the past year. Now for the question. Is there an easy way or can someone give me a piece of code to create a page. I am seriously just now getting to the point where I am looking at creating some pages. I
HTML page - iterate rows - first row repeats
Hello all, I've taken a Zoho example (https://www.zoho.com/creator/help/views/create-html-page.html) to try to create a dashboard of my own. Starting simple so I understand the syntax (since I don't know HTML very well), I took a sample page (which works) and replaced hard-coded values with a "for each" loop. However, when I run it, the first row repeats for as many values in the table. My pertinent code: for each SP_row in SP {%> <tr class="zc-viewrow zc-row-2">
problem with subform
Good afternoon. I am trying unsuccessfully to help support you in four days and no response . I'm having the following problem: I created a form and subform it loses the rules made in the original form. Form is : https://creator.zohopublic.com/zoho_bruno123/requisicao/form-perma/Correspondente/D6fpDwguR9WbGNZpv4HaNd2W5kytgBsUtB4TUXQSNCFnM2fOw7YyHuF177meO0h3tUyuFQFkbQNPXbXF9HNpW1qxt7XnHejTMus1.
When I put " city " the county should open only selected and is not opening at all. What can it be?
Formula to Calculate Total of Multiple Rows in Sub-form And Return the Grand Total to The Main Form
Hello there, I am working on a main form, a kind of invoice divided into 2 sub-forms. First sub-form is Customer Info. Second sub-form is Items list. I can calculate something like Quantity*Unit Price in one raw. But I don't know to to run formula for one column (Total Amount). So As you can see, I can work horizontally, but not vertically. This is at least the most problem I have. Hopefully, someone could fix this as I think this would be common but no clear answer I found for. Another thing is
Create a lookup relation
Hi there! I try to create the lookup relation. Unfortunately, only one field for the selected form is shown for selection. The rest is the Added Time, Added User IP Address, ID, Last Modified Time and Modified User IP Address. Please advice me on this matter. Tq!
one lookup to fill multiple fields
Hello all I have two forms CLIENTS and CLIENTHISTORY In CLIENTHISTORY I need to fill the client ID, full name and office name I want to select the client ID and once selected the fields of full name and office name to be filled automaticaly from the data already stored in CLIENTS form How can I do it??? Thanks
We are unable to fetch this data, sorry! Please note that your data is SAFE.
I am getting this message on views every once in a while and I can't figure out why it appears or why it goes away. Strangely, I have it right now for one particular user on one particular view and only in Chrome, Safari with the same user and same view loads up just fine. Any suggestions?
Dropdown list contents listed out in customized order
Hi, I'm trying to setup a dropdown list with lookup relationship, and I'd like to list out the looked-up contents in a specific order rather than the default alphabetical way. Please kindly assist. Thanks.
How do I automate this process?
I am building an automated form that upon opening does the 1. Goes to the suppliers website, as a sample we pretend it is: https://www.url.url 2. Enters my username in the username field. The XPath for the Username field is as follows (I used a fake url for to protect our supplier, but the XPath is real): https://www.url.url/html/body/center/form/p[1]/text()[1] 3. Enters my password in the Password filed. The XPath for the Password field is as follows: https://www.url.url/html/body/center/form/p[2]/input[1]
Zoho Creator lookup field, getting contact ID
In my application I have a form Courses and subform Students. In my students subform I have a zoho crm lookup field (looks up contacts) labeled Student Name. How would I get the zoho contact ID of the record that I'm working with. All that I see in the field is what appears to be a concatenated first name and last name of the contact i.e. Bryan Annas. I need to update the record with application values and can't figure out a good way to do so. Thanks, Bryan
Export images from records
Hello, I have an application that uploads .jpg files. I would like to be able to export/download all the .jpg files for a specific record onto a local hard drive. How do I accomplish this other than saving the .jpgs one at a time? Thanks in advance!
Group items in subform
hello, in my form i have a subform with fields Product Code || Description || Quantity. How can i make to group items by Product Code and sum Quantity ? Thanks you
Birthday's in Calendar
I haven't been able to find an answer to this as it pertains to Zoho Creator. I have a birthday field for employees children and am trying to get them to display on a report (Calendar View). They only show up for the year they are born, not yearly. Has there been a solution for this? Thanks, Brian
Information from South African ID
Hi there I am referring to the post made 3 years ago. I need to calculate the Date of birth and Sex form a South African ID Number https://help.zoho.com/portal/en/community/topic/extracting-usefull-data-from-south-african-id-number I am not sure where I need to insert the required information, also I need to adjust the code to suite my field names: I have an ID Number Field (ID_Number) and then a Date of Birth Field (Date_of_Birth) as well as a Male / Female option box (Sex1) Hope someone will be
Get 5000 Records For Free! Referral Program Is Now Tell-A-Friend
In response to a survey, 95% of respondents said they would readily recommend Zoho Creator to their friends. We've always known that to be true. These customers who refer, don't expect anything in return. They just do it because they want to share their find with friends. But we thought it would only be appropriate for us to return the favor. That is why we came up with the referral program. But free users felt left out of all the action. Keeping them in mind, we have redesigned it, so that everyone
Ampersand in field being converted to "& amp;" in lookup field
Hi, When using an ampersand in single line field and then using that field in a lookup it is displaying as "&". See http://prntscr.com/8haopw Thanks, Damien Cregan Hire an Expert
Mobile application database "n00b' needing direction re: app in progress.
Good Afternoon, I am really new to building database's for mobile applications. I am experience in building the front-end app though. I am needing help with putting together a database. I do prefer to do the work myself so I can learn. Okay, the problem; I am building an app in app-press (client's choice) & I have done all the psd/ai files and all the boring hard work to put the app into a functional state, now I need to assemble the database. It's an app for farmers/miners re: tyre psi etc... Screen
Development workflow - is it possible?
I have an application that is currently in production. I need to understand how I can accomplish a development cycle/process for this. There will be changes made to the app regularly (multiple times a month possible). Many of the forms require lookups, etc, so in order to do work on a development copy, I need to have the data as well as the forms. I'm told that the only way to duplicate the application with data is to have Zoho do it for me. I am a paid (Professional subscription) user. So now I
Webform with unique link
Hi, I'm trying to implement a webform for a registration to an event. I have various events in my database and I don't want to let users see all the event and pick the event they want to subscribe, rather I want that through a unique link (or any other way) they go to the registration form of a specific event. I wonder if this is possible in either CRM of Creator as I could not find a way to do it. Has someone else had the same issue? Thanks, Andrea
Next Page