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";
Registration system
I have a private form that captures name, address etc. When someone goes to the form the standard Zoho Sign In form is displayed. This is exactly what I want. However if they don't have a Zoho account there is no option to create an account. How do I get a sign up button to show? I expect about 1500 people to register and I want each to have a separate ID. To add a little complexity I want to avoid displaying the Zoho logo. Zoho is a great brand but some people will get confused. Herb Wexler MBA
Security Groups
I'm testing the "Creator" product to see if it will meet my requirements. I want to have different users in different security groups who are able to see forms, views, and reports based on their group. It looks like you can do this! So...I created a simple test. I created three groups with different email addresses in each group. I created three tabs and set "sharing" to be different on each one. I invited the groups. When logging in to the first email address using the link provided in the email,
Need to get a list of all user names
Is there a way to get a list of all the user names for an application. I see the ability to get the current user name but not all users. I want to use it to populate a drop down list.
BOM
How do I create a form where I can accept a Bill of Material type input form?
Help Parsing XML Response
Here's an example of the xml I'm dealing with: Yes, this is a real example. It does not have the same structure between each booking id tag. {"responseCode":"200","responseText":"<?xml version="1.0" encoding="UTF-8"?> <bookings> <booking id="5381694"> <resource_name id="156376">Lower level 30 x 40</resource_name> <start type="datetime">2012-11-19 08:30:00</start> <finish type="datetime">2012-11-19 09:30:00</finish> <created_by>john@xyz.us / administrator</created_by> <updated_by></updated_by>
populate the recently entered data to other form
Hi, How can i populate the recently entered data of 1st form to other form or else how to populate the selected value (not values) of dropdown to other form. Please help me out of this.
Need Script Help to Find and Display Duplicate records
I need a script or View or Report or something that finds and displays all duplicate/multiple records so I can choose which one to delete. ANy help much appreciated.
The Dollar Sign Problem
It is impossible to add a simple Dollar sign to a string. The following expression will result in an unidentifiable error: text = "$" + someOtherText; This is strange because just initialising a string variable with a Dollar sign is no problem. The following statement is just fine: text = "$234.00"; But you can’t write: text = "$" + "234.00"; // error! THE Workaround: instead of “$” use the html escape code “$”. The following expression works fine and produces the same outcome: text = "$"
Not able to create Pie-chart
Hi, Iam not able to create Pie-Chart for a particular form.Getting Error "Sorry.Error occured while creating the report". Please help me out of this.
Deleting from Sub-Form only deletes one side of relationship - Not the record
Hello. Let me explain how I've set up my application and then describe my problem. I've set up my application where I have Contacts and Orders On the Contact form, I've added the Orders as a Sub-Form. So from the Contact edit page, I can add Orders. On the Order form, I've added a look-up field back to the Contact. Essentially, what I've done is created a two-way relationship where I can view the Order Details from the Contact and I can view the Contact information from the Order. The built in
Passing a parameters across a possible 12 forms
The application that we are working on, will be used to track all the variables that go into make a batch of compost (we are a mushroom grower). Click here to view the flow, read below to have a better understanding. Application flow explanation: 3 - Areas of data collection Phase 1 Composting Phase 2 Composting House Information In the "View Complete House Record" (HTML View) All the data needs to be display as it relates to the "house number" that is selected. Example of the most complicated situation:
Trying to get Field IDs to display Labels
This should be a simple thing, but I'm a little dense. I am creating records that use lookups. I can't figure out how to get the selection to show up as the label. Right now all I'm getting is the Unique ID, which isn't helpful to the user. Any ideas where I should be looking?
Formula Field showing form data but at the same time being a URL refference
Hi, it is common to use a formula field to display a link to a detailed view for the record. for example "Contact Detali" My question is how I can use the name of the contact (e.g. input.Name) , instead of a hard coded text (e.g. Contact Detail). Below you can see the code I am talking about. I want to replace the text in red by the actual name of the contact (i.e. input.Name) Is it possible? or is there a work around? I basicallly want to add a hyperlink to data in the view. ((("<a href=\"#View:Contact_Detalil_View?Contact_ID=")
Next Page