relating date field to a view
i have two forms. one is for adding participants to the database. the other form is for adding "events" that participants have attended, which includes the event name, participant list, and date of event. within "events" there are several types of events to choose from that will be repeated over time, including "tutoring", "lunch meeting", "ski retreat", etc. ideally i would have used a dropdown for this field, however since dropdowns are not available for lookup fields it is simply a single line
Charts issue
Hi, I have an HTML view,where i have created 2 iframes.In the 1st Iframe i have placed one bar chart and in 2nd iframe another bar chart. By using openURL iam trying to access the HTML view in the form.While accessing the application its showing the 2 IFRAMES along with the tabs.But i dont want the tabs.I need only 2 bar charts to display. Please help me out of this.
Bug with subform interaction
Hi, I've found a bug that comes up when I'm pulling data from one subform into another. Please review the two screenshots below. ============================================================================ Case 2: I enter a name in the Child subform It seems like there's an error that occurs in the Event Location On Input function because the row.Debug updates don't work. However, I can't debug the function because Zoho doesn't let me use info commands in OnInput functions. No error messages appear.
calculated field requirement
Hi My database contains amongst other things a table of owners and a table for assets. I would like to be able to create a field in the owners table which adds up the capacity field of those assets and displays that in that owner table. I've looked around but can't see any documentation which explains this. I would also ideally like to be able to pull that information into a third view which is contacts and partially made up from the owner table displaying related fields. Please help Many Thanks
how can I change the "add +" button in a subform ?
Hello, Is there a way (I guess there is !) to customize the "add + / add new" button in a subform. I need it in french for a public access form. Thanks. When you access the application, the Subform will be displayed within the main form, as shown below. Here, the "Order form" displays the "Items" subform to add the items ordered. You can use the "Add +" or the "Add New" button to add entries to the main form from the subform.
Scripting Problem
I'm having trouble getting a simple Hide/Show script to work. I keep getting this error when I try to enter the script to the "On User Action" section: Error in statement at line number 3 The Left expression is of type STRINGLIST and the right expression is of type STRING and the operator == is not valid here Here is the script I'm using: if(input.projectType=="Print") { show Quant_Print; } Please help.
Chinese interface
I need to used a Chinese UI for my users in China. Can Zoho Creator do this?
Send Mail when Dropdown field is changed
How would I create a script that sends an email when a dropdown of an existing record is changed/updated to a specific option. For example: a database record has a dropdown with three options (a,b,c) when it is changed from option A to option C (and submitted) I would like to send a notification email to a user. But specifically from A to C, not A to B. Is this possible?
Formula Field & Aggregate Record (Count)
Are there any plans to allow a formula filed to support the aggregate record function? The use case is a vacation day application. Users can see the number of days they can take and the number of days they have taken (via record aggregation). I'm using an html view to do all this now. Cheers, John Whitney ZOHO Creator Developer
Data not populating fields in form
Hello, I am having an issue where data from my stateless form is not populating the fields in the form it is supposed to be INSERT INTO. Please see code below. What is supposed to happen is this. 1. In the STATELESS FORM The user enters data into "input.Lateral_Vibrations_Bin_One" this value should be multiplied by 0.5 then the sum should be loaded into "input.Lateral_Vibrations_Bin_One_Weight" 2. When the user submits the data the value from "input.Lateral_Vibrations_Bin_One_Weight" should then
Cannot provide admin rights to my developer
I cannot provide admin rights to my developer. Can someone help? When I go into my application settings I don't have any option to add admin rights. See image attached. Please help as I'm wasting time with my developer and they too are getting pretty frustrated with the lack of access to help build my forms and capability.
Links to Zoho CRM
Hi, I am developing a Cretaor App for a client that is to tie into their CRM, I have yet to work on the integration (phase 2) and it may all become cear but my concern is about publishing. The CRM link help implies I need to do the integration work in their own account(s) so it links through to the correct data. Is there no way to link to their data in my dev area and then share to the client via the developer Zone so I can continue the development whilst they use the phase 1 system. Thanks
Set the view group back color?
Would love to be able to change the default back color for group rows from the default yellow (list view with a group set). Looking through https://help.creator.zoho.com/Style-based-URLs-for-Embedded-Forms.html#6._View_Customization there doesn't seem to be a parameter for it?
Sendmail not working with anonymous users
I've setup sendmail to email the person completing the form. The form is for leads so the people submitting the form won't be logged into zoho. Unfortunately, the sendmail function doesn't work and I've tried making the application public with no success. Ironically, other deluge scripts work (e.g., validate fields) but not the sendmail. Any thoughts? Thanks in advance.
Form Schedule Filter not working?
Hi, I'm having trouble setting up my Form Schedule in Zoho Creator. Situation I add assignments to my employees trough the system. The employees have to make an appointment with our customer. The appointment date is then saved in the assignment row (called Afspraak, Dutch for appointment), to keep track of 'open' assignments. Afspraak is a datetime field. The emloyees are expected to to this in 24 hours after the creation date of the assignment, but sometimes it takes up to 48 hours or even more.
Div & Iframe Problem
Hi, Iam not able to increse the width and height of the DIV & IFRAME. If i apply also,Its not reflecting while accessing the application. Please help me out of this.
What's the easiest way to duplicate a form?
I would like to duplicate a form I have created and then make small changes to that form. I see that I can create a new form based off of ZOHO templates but I would really like to base it off of the form I've already created. I would also like to be able to copy forms from one application to another. Please let me know if this is possible. If not, please consider this functionality for future ZOHO development. Thanks!
How to set master transaction relation ship
I created a dept master with only one dept_name field. I want to create a list and it should appear in employee master in a dropdown list box what ever i added in dept master. Please help me in this regard. I am very new to Zoho
No reply to "Hire an Expert"
Hi, I have a project which may interest an expert and so from the Zoho Creator, "Hire an Expert" link, filled out the form and duly sent it off, waiting for my reply within 2 business days, as advertised. 2 business days later, I'm still waiting and although I'll be patient considering the potential time differences involved, I do wonder whether I haven't had a reply because of condition 1 : "Your requirement is not possible". If I don't get a reply because my requirement is not possible, how on
Need to get IFrame in zoho form.
Hi, How to Get IFrame in Zoho Form.(Not in HTML view)
Related Record ID
I have a subform (Fulfillment Activities) which is related to a parent form (Service Orders). I want to create a functional URL that lets me open a subform view and only display the records related to the parent. For further explanation: https://creator.zoho.com/cvanputten.contactpoint/pro-services-ams/#View:Fulfillment_Activities?ID=660708000000316925 will retrieve records for this form based on the record ID of the subform record. However I want to substitute ID for whatever the field name is that
CAPTCHA Error
In the last week, I've see this error a few times. Cheers, John Whitney ZOHO Creator Developer
Scheduling tasks
I organise my work with tasks. Scheduling them is important for me. If I would like to schedule an existing task for tomorrow, I have to work with the calendar function. Wouldn't it be great if there will be a possibility? a) + (schedule the task for the next day) b) ++ (schedule the task in two days) c) w (schedule the task in one week) d) ww (schedule the task in two weeks)
scoring a simple questionnaire
greetings, I am new to zoho creator. I am trying to create a simple questionnaire where I will be able to have a few questions that need to be added up to give a final score. Each question will have a few answers using the radio buttons field and each answer will need to have a numerical value assigned to it. It seems that we cannot assign numerical values to each radio button option. Is there a way to do such a thing? I just want to add up the answers and get a final score. And I want my users
How - Look up and display more than one field from a form
As all things, this sounds simple but I can't figure it out. I have a form for client information with these fields: First Name Last Name Phone Car several other fields I have another form that deals with work done on cars and I want it to pull up some of the fields from the client info form (display only) I have a look up in the work form for last name that looks up the last name from the client info form. I would like for it to pull the telephone number and car off that form and display them in
Can we limit users view ?
Hello, First of all sorry if this question was already answered or if I posted on the wrong forum. I want to create a shared application with 10 users but I don't want them to see each other data. For example user 1 can only see his own details. Do you know it's possible ? Thanks for your help
Bug with "On User Input" for subform fields
Hi, I've found an annoying bug that comes up when trying to edit the On User Input event function for subform fields. It doesn't let me access the function when I'm in Free-flow scripting mode. Please see the screenshot for more details
Passing Multiple parameters to Embedded View
I'm trying to pass multiple parameters to a view embedded in a Html view. It is not filtering as expected. This is the code I'm using: htmlpage Finding_Duplicates(recid) displayname = "Finding Duplicates" content <%{%> <div elName='zc-component' viewLinkName='Copy_of_form2_View' params='zc_Header=true&ID.contains(<%=recid%>)'>Loading ...</div> <%}%> The "recid" is passed from stateless form, it has multiple ID's. App "grocery" is shared to support. Can someone take a look, please? Thanks, Damien.
Creator capability
Before I start on what will probably be a large project, I would like to know if there any show stoppers to using Creator to create CRM, Accounts and Database Based Web Site modules linked to eliminate transcribing data between them?
Pre-select the multiselect field on form load
Hi, How to pre-select some values in the multi select field. For eg: If we take dropdown,i have 5 five items in the dropdown field.And the default selected value will be 1st value in such away how to do in multiselect field. Any help is appreciated.
Something goes wrong with Zoho Creator
Since Morning I am not able to put entry in one of my form. When I select "Type Of Work" or Engineer, it keep on rotating. https://creator.zoho.com/piju2111/penta-crm-11/#Form:To_Do_Form Given edit access to support. Note: I haven't done any changes in script. I tried all the browsers and different computer.
Best Practice for Forms with lots of fields
Hi, I am developing an app that has a lot of fields, and I am wondering what the best practice is in trying to get them on a page without the need to scroll. The forms need to be stateless as I need to do some pre-processing before storing them. I have more fields than will fit on a decent sized screen with the default two columns. These are some of the thoughts I have had but not found a way to do them or do not know if there is a better way. 1. Have more than two columns in a form. 2. Have one
Dynamically generate chart -- Urgent need help
Hi, I need to generate the graph dynamically.For eg:I have 100 employee in one form and based on selection of employeeID need to generate bar graph for the employee in other form. Thanks, Customer
Remove all items from dynamic picklist in subform
Hi, I want to create a dynamic picklist in a subform. The problem is, I cannot clear all items from the picklist. Please see the screenshot below for an explanation of the problem. Can anyone suggestion a way of clearing the "Select A Child" item from the initial dropdown box? (I have to have at least one item in the dropdown box)
Based on first form data,i need to enable/disable the second form fields.
Hi, Please help me out of this. Based on first form data ,i need to enable/disable the second form fields.
Condition in Date field
Hello, how can I develop a code on user input on a date field, that when I insert date the hour is before 4pm then it allows me to choose the day after, but if the hour is pass due 4pm then it only allows me to choose the day after + 1? Is this possible?
Permalink for Private App and Sign-in
When we share a private app's form or view via permalink with the access code like this: form-perma/myform/DN3uYKHrnhjv9gnGmEMYredRrzHr6hbvumH52m4HdfvrUAyQEEKTsYsjpsadM1h5PBpkEUOjRCQ1DvhEaCO3eAWm5En7EvWppQP8/ Is there a way to enforce users to sign-in anyway? The use case would be to capture the user's email and only display records they created. Is this even allowed? Cheers, John Whitney ZOHO Creator Developer
On success of First form data need to post the same values to second form
Hi , On success of First form data need to post the same values to second form. For Ex:In 1st form i have 3 single line ctrls.Once i will enter and save the form,i will get success msg.After that i need to redirect the 3 ctrls values to second form. Please help me out of this.
On updating one record automatically update all records carrying formula fields
I am trying to build a project management application where each task is dependent on its previous task and each task's End Date becomes the Start Date of next dependent task. End Date of each task is calculated by adding a duration into that task's Start Date. What I want to do is when I edit and update a task's Start Date or Duration, it should update all dependent tasks automatically. So far, I have been able to update only one record (either the next dependent task or any one task or record selected
How to seperate the given string based on comma.
Hi, How to seperate the given string based on comma. EX: string str="seperate,the string based, on comma"; Result[0]="seperate"; Result[1]="the string based"; Result[2]="on comma";
Next Page