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.
PHP JSON Data Request using Zoho Creator API
Using PHP Is it possible to request data from a table or view without using a post form method. For example, can I get the data similarly to this process https://api.creator.zoho.com/REST-API-View-Records-in-View.html But then store the data into a variable and then loop through the data in php. The only example given in the above URL is a Form Post. I want to execute the url and store the json data into a variable so I can then loop through the data to extract what I need and then display it.
Send a conformation email to non zoho user when form is submitted
Hi How do I send a copy of the form completed to the email address of the non zoho user when they have completed or submitted the form? cheers
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 = "$"
platform update
I saw here that there are 2 updates made today: File upload field supported in update and insert record task Limit exceed message for integration task is fixedI need some explanations regarding the new updates. I saw that there is still not a file upload field in stateless forms, so there is still no way to insert a new record with an uploaded file using stateless forms. Maybe I am missing some cases when this feature would be useful, I think that it would be useful to have this documented. Limit
Import to Excel through html/permalink- ewb query not working anymore in the new Creator interface. I need help.
I hired someone 8 month ago and I spent a lot of money to create a very big Creator application that serves data to Excel via old Export/HTML functionality (using Excel's web queries). When we started to write the application everything was very ok. But when the application was finished I realized that the new interface screwed up everything. Since your upgrade I cannot export a desired record in Excel so the application is unusable. It seems your upgraded design does not allow me to have live
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.
Form Cannot be Deleted
Strange problem: The form linked here cannot be deleted https://creator.zoho.com/buzzap/form/324/edit/ I think it's because a file upload field got on this stateless form? Not sure how I did that... App is shared to support Cheers, John Whitney ZOHO Creator Developer
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:
Why m.zoho has not leads?
I am confuse , If i use m.zoho I can see my leads, Why? If a use zoho mobil app I can have an emails control. Which one You recomended to use? M.zoho or zoho mobil app Thanks
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=")
launching Skype with hyperlink
With the wonderful little tool for launching Skype out of CRM, it got me to wondering/playing to see if it could work in Creator. I've come oh-so-close, but not quite. I've used a notes field to simply create a 'DIAL' with hyperlink that launches: <other> skype: +xx?call This is enough to open skype and attempt the call. Now I'm looking for some advice on how we might be able to incorporate the phone number from within the form. I've tried all kinds of quote/bracketing without success: skype:
'Access this Application' link has DISSAPEARED!
This is a HUGE navigation issue that is making it IMPOSSIBLE for me to work. Replicate problem: - click on Creator Icon from the list of applications from the HOME screen - you get a list of your applications... click on the application to access - you get a list of views and forms etc... click on 'EDIT THIS APPLICATION' - takes you to edit screen. PROBLEM - once here, there USED to be a link 'ACCESS THIS APPLICATION' that would take you back to the views and form so you can actually view your DATA
Next Page