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?
payment module with quantities for multiple items
How to create a payment module with quantities for multiple items? I'd like to have multi select checkboxes with a field where input quantity insead of the checkboxes. I know this is not possible. somebody found a solution or a workaround?
Form design: segmenting fields into brackets
On my input form there are 40 fields. I need to categorize the fields into 5 to 6 segments.... how do I design this? Tabs? How to put a horizontal dividing bar between segments/sections? thanks gurus.
Importing Data/Zoho Migration Tool
This is what we're trying to achieve, let's say: 1. We had a form with these two columns: ╔════════╦═══════╗ ║ Job No (UID) ║ Cient ║ ╚════════╩═══════╝ We have already +1000 records for these 2 fields. 2. We added these two new columns to our form: ╔════════╦═══════╦════════════╦══════╗ ║ Job No (UID) ║ Cient ║ Department ║ Code ║ ╚════════╩═══════╩════════════╩══════╝ 3. We exported the data
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.
Selective : Form entry
I need to open up 5 out of 20 free-entry fields for users to enter data online. How can I do this?
Can I Order the Menu on the Live Application?
I would like to be able to reorder the menu that is on the left hand side of the LIVE application, when I click "Access the Application". How do I do this?
Conditional mandatory
For some fields I want to make them "mandatory entry" if some other field's value is equal to a certain value. How do I implement this? Thanks.
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
Changing the list order of VIEW items in EDIT APPLICATION
Is it possible to change the LIST order of the ITEMS under the VIEW menu in EDIT APPLICATION? Craig.judd
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)
Built-in Function to get Private URL Link
Related to this post: https://help.zoho.com/portal/en/community/topic/permalink-for-private-app-and-sign-in ZC provides a few built-in functions to get aspects of application urls. It would be vary helpful to also have one to get the url key to share a private view or form rather than having to go to live mode and copy an permalink. One clear advantage for this would be application portability. Cheers, John Whitney ZOHO Creator Developer
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
Plans...
... I have a STANDARD subscription but in my EMAIL OF DAY I have 0 (ZERO) quota from 20th of november. WHY? My next billing day is 2 december. Some scripts are not running. Sendmail are not running. My applications are involving public institutions with very important situations. What are happening? Thanks Misca
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
If / Then formula
I'm trying to write an If/then formula that says if the total number of items is equal to 1, then the shipping cost is 7.00. If the total number of items is more than 1, then the shipping cost is the total number items * .50 + 7.00. This is my attempt at that formula that is not working. If(Total_Number_of_Item)==1,7.00,Total_Number_of_Item)*.50+7.00) Can I get some help with writing the correct formula?
Creating a Link between form and subform.
I am trying to link a form and subform. I followed the instructions and it shows you who to use lookup in the subform. Using look up it asks which field in the form you would like to use to link the two. This is a problem, there are no unique identifier fields in the form. I tried using ID which i understand is a long unique field for each record but all I get is a drop down that asks me to select an ID out of hundred of IDs even if search and autocomplete is ticked. Can someone show me practically
Can I print a blank form?
I`ve created a customer record form and I would like to print a blank copy of it i.e containing no data, just empty fields. Can anyone help? Thank you.
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,
Updating one form with data from another form instead of copy and paste
Hi I have form called Study Details (parent/master) and another form called Risk Log. There is a one-to-one relationship between the two via a field called WY_ID. I have updated the Study Details form with fields from the Risk Log form, as the current arrangement is causing problems (i.e. disappearing fields due to one-to-one relationship). For example, there is a field called Risk Type on form Risk Log, and I have added the field Risk Log to Study Details. So basically transferred all the
Payment Form Confirmations
After processing a form on PayPal, how do I control the confirmation page? It seems to show a fleeting "payment success" message and then redirects to the original form. Also, I have set-up an On Success email, but it's not working. Are these issues due to testing the form in PayPal's sandbox mode? John M. Whitney
Issue after editing one of form
Hi, I have plan to add one more option in my form, for which I have set the variable. FEM = Engineer_Master [Engineer_Name == input.Engineer_Name]; SEMN = FEM.Telephone_No; After saving it, my form start giving different errors. Attached Screenshot. I have given edit access to support, below is my apps url. https://creator.zoho.com/piju2111/form/686/2/scriptbuilder/ Thanks
new calendar view - suggested improvements
Please consider making the following improvements to the new calendar view: Colour code events based on a field value. (In our case we need to colour code appointments based on which practitioner is linked with each appointment record.) Increase the amount of text displayed for the description (display value field). This could be done by a mouseover pop-up and/or text wrapping where there is sufficient vertical space. Restrict the display of time-slots to user-specified business hours in the weekly
input.Email script issue
Hi, I have one form 'Parent Registration' which includes an email field with the field name: Email I have another form 'List a Job,' which has a lookup field correlating to the Parent Registration form. I want to add script from the List a Job form to send an email to the input email. The input email is originally in the Parent Registration form, but I thought this should still work as I have used the Parent Registration Form as a lookup field. However I am getting the issue: Error at line:3 Viariable
Custom action to edit all records at once
Hi everyone, I know how to script a custom action and add it to a view, so I can bulk edit many records at a time. But it seems to me that it is limited to 200 records at a time. I have more than 5000 records and need to do a lot of bulk editing. How can I run a script through all my records, in order to edit some fields, in a one-time operation? Thanks Patrice
Can't use reports!
Yesterday all my reports crushed. I asked support by submiting feedback form, but had no answer. I can't understand what i must to do to fix this problem, and how i can describe a problem:
input.Email script issue
Hi, I have one form 'Parent Registration' which includes an email field with the field name: Email I have another form 'List a Job,' which has a lookup field correlating to the Parent Registration form. I want to add script from the List a Job form to send an email to the input email. The input email is originally in the Parent Registration form, but I thought this should still work as I have used the Parent Registration Form as a lookup field. However I am getting the issue: Error at line:3 Viariable
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.
Duplicate a form
Is there a way to duplicate a form without having to recreate a similar form? I have followed the instructions to do so via script, however, I am unsure where the code snippet is to be copied to.
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.
Next Page