Configuring Conditional Dropdown
Can I create a conditional dropdown based on a radio button or check box selection? ie Radio button for "documents" selected dropdown would contain those items or "improvement plans" selected dropdown contains plan types
Filtering a table on an html page
Hello Zoho's, I have an html page with a table in it. The table takes its data from one form in my application (lets call the form "FNA form"). I'd like to have the option to filter the data in the table, with 4 possible fields to filter by. I figured my solution is to embed a stateless form to my page, next to the table, and to have its field passing parameters to the html page, filtering the data I fetch from the FNA form. - note - I do not want to embed a report to the html page, for many reasons
Import data into a lookup field with multiple values
I've searched through all documentation/forums and nowhere is this simple use case adequately explained or documented I want to import data into a form that contains a lookup with multiple values with a form linked by lookup relationship. The classic example is I want to import data of students who have multiple courses. - I have a form for students. - I have a form for courses. - In the student form, the courses field is a multi-select lookup from the courses form. I have a .csv file that
Allow deep relationships in reports, lookup-display fields
Consider the following: I have four tables, A, B, C, D A has two columns: A.ID (primary key), A.BID (foreign key from B) B has two columns: B.ID (primary key), B.CID (foreign key from C) C has two columns: C.ID (primary key), C.DID (foreign key from D) D has one column: D.ID (primary key) I wish to create a report that displays all columns of the records where the relationship A->B->C->D exists (assume, for the purposes of this discussion, that B, C, and D also have columns that contain useful data
Cannot create a zoho account via China mobile number to activate the account
I tried to create a new zoho email account, but when I activate the zoho account to let the system send a verification code to my Chines mobile number, I will never receive any code. Is this a known issue?
Viewing more than 10 records by default
On my page I have posted the html code from my different views for my application. The problem is the default view is 10 records. I need to change it to be the maximum by default. Is that possible?
Internal Server Error Sorry! Due to an unknown error occurred in our server, the page cannot be opened now. Please try again later.
Hello, could you please fix the bug in my profile? micheledacosta at iCloud dot com Thanks! Michele
Restrict Search to initial filtered view?
hi - I have a view that is accessed via an OpenURL statement and has filter criteria applied on the openURL statement so the user only has access to view a subset of records. However, when they do a search from the view , then all records are searched and what gets returned are records they should not see - ie. the initial filter criteria is now ignored. How do i restrict this so the only records that get searched or returned are records that also have the initial filter criteria applied? thanks
Lookup multiselect - counting the number of selections
In my application I have a form for recording the published books/papers written by my colleagues. The form has also a lookup multiselect field for selecting the name of the authors from another form that contains the names of all my colleagues. For each published work there is allocated a number of points. For example, 5 points. If the published work has only one author he will get the 5 points. If there are two authors each will get 2.5 points, etc. I have to calculate for each author the number
Limit Image Size
Is there a way to limit the size of images uploaded, or better yet, automatically resize to a certain dimension?
I can't open my new domain name purchased at ZOHO for the web site I created
I created a web site on ZOHO , then purchased a domain name through them. Then clicked the link to verify it. Now when I try to go to the web page all I get is a error code "404- file not found. There is no web page matching your request" I emailed zoho 3 times and only wasted more time. First they said the site was linked to my email and sent me a email. Ok the email works, but no one can go to the web site? Some one else gave me a link to a page saying to register the name in searches such as
not null date field
Is there a way to create a "not null" condition to indicate that an email has to be send when the date field is not empty? Something that replaces null on the code below if (input.Date_Time1 != null) I have also tried if (input.Date_Time1 != null) { //do nothing } else { //send email } but it is not working.
is it possible to integrate zoho creator and zoho reports?
i have created form with one file upload control and one button control in zoho creator. first i can upload excel using file upload control , secondly when i click button i want show the sprint number analysis(from zoho reports) on the form for uploaded excel file . is this possible with zoho creator???
How to use PHP fonction like md5 in HTML view ?
Hi, I'd like to use md5 (http://ca3.php.net/md5) in my application for authentification purpose with another application. Can we use PHP in HTML Views ? I'd like to push a string and get back the result to make a if in my HTML view. The sample code is like this : <?php $str = 'apple'; if (md5($str) === '1f3870be274f6c49b3e31a0c6728957f') { echo "Voulez-vous une golden ou une spartan?"; exit; } ?> Is it possible ? Thanks, Pascal | nsisolution
Stop Click on URL From Opening Record Options
My form has a URL field that populates the column titled "Invoice URL" on my reports. Every time I click on any link under the "Invoice URL" column, the link opens to a new window AND also opens this additional box on the right-hand side of the page that shows options available for that particular record. I'd like for the links to ONLY open to the new window and NOT show this additional box on the right-hand side. How can I achieve this?
Need to insert a "." between numbers in a string field
I am trying to take a string field in which a number like 1415 is entered and have the field insert a "." so that the result will be 14.15 What is happening with either of the examples below is resulting in 14.5 with the Creator Cursor spinning forever and locking the record/field up. Can someone tell me how to "end" or "return" the processing so it will stop continuously looking at the field named Start_Time and move on the next field or process. I'm sure there is a qualifier that has to be put
Mobile App IOS Ipad
Two problems using file uploads in the mobile app. 1 The indicator within the Report of the existence of an uploaded file is an icon of 4 tiny dots that can hardly be seen. 2. The file, for example a PDF, will open ok but clicking the Action icon will crash the app.
Multiple selected records on 1 page table in Record Summary
Is it possible to create a Record Summary which displays certain form entries in a table...all on 1 page, instead of each record having a separate page. A similar command, would be the >>Next Record command in a Word Mail Merge. Record Column 1 Column 2 Column 3 Column 4 Record 1 >>Next Record >>Next Record >>Next Record
Updates
How can updates recods comimg from api?
How to Create a pop-up message?
I would like to create a pop-up message after a user submits his information. I see that you have a function called Alert() but this function is not listed under the More Task options nor under the Built-in functions to select from.
Display bold font based on conditional statement
I want to make font bold or different color based on conditional statement...any ideas? if(input.Door_Physician_Mins > 10) {display font.bold }
Customer Portal Issue
Good day, I have my apps working thru the customer portal in the company own domain, today when we open the apps only appears the header and the tabs menu. If I work thru https://creator.zoho.com/ its normal. I try with Chrome, Internet Explorer and Firefox in 3 different computers. What could be happen? Best Regards,
Variable is already defined of data type
Greetings, The first four items, have been working fine in getting "currency" field from the CRM. When I added the fifth, BMD, I get variable error. Can you point me to the error of my ways? "Variable 'BMD' is already defined of data type 'DECIMAL' but trying to update 'STRING' data type //Dealer Opportunity gdr = crmResp.get("Dealer Gross Revenue"); lsv = crmResp.get("Less Service Revenue"); lsfas = crmResp.get("Less Sales from AS"); INDopp = crmResp.get("INDEAL Opportunity"); BMD = crmResp.get("Base
how to fetch records whose list field contains a certain value?
I have a form which contains a multiselect field. Now I want to get all records searching for a value inside that list on form. I tried something like this: records = Form [multiselectlist.contains(input.value)]; But Deluge tells me there's a syntax error. How is right way to do that?
Import Data
Is there any way for a non admin user to import a mass amount of data into a table in creator? The import data that the admins can access works perfectly. However we'd like this function to be usable by a non admin user. The Zoho Migration tool seems like it could be an option, but I get an error when trying to install that on our machines saying that the software is incompatible with the operating system. E-mailing doesn't seem like an option, from what I can tell that only works on I row of data
Missing Grouping & Sorting Link in report settings
All but one of my report settings has a grouping & sorting option. Anyone know why this option would be missing in one report? I need to sort it by date Gill
Time (Duration) Question (Data Entry)
I am contemplating adding a feature to my app that will take from 2-8 time entries and add them up. It is important to note that the times entered are not calendar-related but rather, units of duration in the format "h:nn" What I'm looking at is either a form to store the data entries or perhaps I'll just use an unbound form to perform ad-hoc calculations (addition) of multiple time durations. But what I'm ultimately after is this Does Zoho offer a quick and easy way to enter a time as some spreadsheets
Cannot display a form image in a Page
Hi I have a page wants to display a company details. Name and Logo. so in the form Company Name (Single Line) Company Logo (Image) then in my page I fetch the record MyCompany = Company [ID == "333344343"]; then I look to display the name and the image <p>My Company name: <%=MyCompany.Company_Name%> this works great.. but HOW do I display the logo? Is it something like this? any ideas? I cannot find it in the doco. <p>My Company Logo: <img src="<%=MyCompany.Company_Logo%>" alt="" height="42"
Unsubscribe link to pull in email address
I am creating a form for unsubscribing from daily emails. Is it possible to set the Email field to pull in the email address of the person that clicked the link in the email they received with workflow code?
Search Page
I am trying to add a search function based on the instructions at https://www.zoho.com/creator/help/tutorials/advanced-app-building.html I believe the first part is working as it opens the html page with the word that is typed in the search box e.g. #View:Search?searchword=skills However, I cant get any results to be listed. I have copied the sample code as below; //pass the parameter (searchword) from stateless form (Aistear_Links) //fetch the record from "Aistear" form (Aistear), fields = Category,
Native Mobile App
Hi Can customer portal users access applications published to it through native mobile app? Regards, Rakesh
how to set filters dynamically to pivot chart
Hi, I've to generate pivot chart based on the value selected on the form. For example, After completing survey, I''ve to show survey report for that particular survey. For this I need to set filter value based on selected survey Id. Can I do it. Thanks for the help, Regards, AppAdmin
ZoHo Creator Database newby Question
Hello ZoHo Community, Can someone help me out with my first ZoHo Creator Database? I created a database with a form to submit data on a date base. The data entry consists of 4 columns. For example: Date Value1 Value2 Value3 Value4 01-01-2016 10 15 20 10 11-01-2016 20 20 30 50 I would like to calculate the difference in values on a daily base, based on the datevalues in the Date column. Based on the example above the avarage daily
Populating a fillable PDF with zoho data
I see that there was a question like this about 5 years ago. Is there such a function already
does not save changes in sheet published in the embed code
mode in view of the report does not save button saves modifiche.Il is present but does nothing . This happens in the embed code help
How to update the status of an item in a report
Hi everyone, I'm new to Creator and struggling to figure out the following: I have an order form that my sales person uses to enter orders taken over the phone. Typically an order has several items which he can add to the order by selecting from a dropdown that uses a lookup to pull from a master list. I have created a report that shows my procurement person each of the items in the order so that he can pull them from the shelf. At the item level there are details about where it can found in our
Replicate Xero
I am looking for someone to help me with the design a system within Zoho Support via Zoho creator to replicate the below modules: Book Keeping: https://www.xero.com/uk/ Property management: http://www.arthuronline.co.uk Anyone looking for work and can deivery this please let me know.
Adobe Echosign Links not saving in Rich Text Fields?
Normally the URL that is inserted as a link in a rich text field works fine; i.e. they can be inserted, they save during update and are available in the rich text. However, Adobe echosign links sometimes fail. They get inserted fine, but on updating the field the link gets converted to straight text and only the description text remains.I tried converting the dash and underscore characters per other threads but did not work. Is there a known issue with echosign links in Creator? Link Example working:
Print From Creator App or Mobile Website Version
Any idea how to print from a cell phone or tablet? I was think using a custom action but the buttons don't show on my device. I don't see print to HTML working in the app.
Using parent form as a subform in another form but not create a record in back-end
Hi I have a form A which is a subform of Form B. I am using Form A only to fetch records into form B and hence i dont want a record to be created in Form A table when i create a record in Form B. Is there a way around it? As i understand a sub-form will create a record in the back-end and we cant change it. But can we find a way around it so that i can still fetch records from Form A to Form B and not create a record in Form A. I cant use the normal Fetch records because Form A is fetching data from
Next Page