Set Default Gateway when creating an invoice
Is there a way when creating an invoice from Zoho Creator into Zoho Invoice and setting the PayPal Getway to Checked. We are currently creating 300 invoices at the first of each month and I don't want to open each invoice and Select the check box to enable a paypal payment for each invoice.
Subform script not working correctly
Hello! We are having some difficulties with the subforms script in some of our apps. The subforms have 2 or 3 lookup or dropdown fields. Sometimes they work correctly, but if we add some code in the other subforms fields (on user input) they stop working correctly, even if they are very simple tasks. E.g.: "Products" form contains all the products available with prices and category. In the "Order" form, there's a "Order Details" subform. Subform fields are: Category (We tried dropdown and lookup
i how do you create workflow with the forms?
i see how you can build a form. how do you add workflow? how can you move the user from one screen (form???) to another screen (form?) how can you add navigation buttons and link a form(workflow) to a particular navigation button? thanks
Using CURL to Edit Records
When trying to edit records with REST API via a CURL POST I receive a 2900 error. I am however successful when adding records. Here is the code I am trying to use in PHP to edit a record. I am convinced the issue lies with reloperator or criteria. $url = 'https://creator.zoho.com/api/xml/myApplication/myForm/update/'; $fields .= '&authtoken=<authtoken>'; $fields .= '&raw=true'; $fields .= '&scope=creatorapi'; $fields .= '&reloperator=AND'; $fields .= '&criteria=field=92';
Importing a csv file. Matching records and updating fields.
Hi, I have a 'Contacts' Form in Creator from which I export the following CSV file to email marketing software. Export File: ID,Title,Name,Email It returns a report after the marketing is done in the form, Email,Date,Status as below. example1@gmail.co.uk 2012-12-17 22:47:00 Email opened example2@tiscali.co.uk 2012-12-17 23:47:07 Email opened example3@btinternet.com 2012-12-18 21:18:26 Email opened example4@btinternet.com 2012-12-19 12:06:50 Email opened example4@btinternet.com 2012-12-19 15:34:21
Criteria
I am not a programmer and would appreciate some help. I have built an app to control the rental of vehicles. I need to ensure that I do not duplicate the hiring out of a particular vehicle. I need to search the database and if a vehicle is already rented out, someone entering data must be prevented from hiring out the vehicle again. How can one achieve this? Derek
HOW TO DELETE RECORDS IN ZOHO CREATOR?
hi how to delete all records in zoho creator by using Deluge Script, is there any help link pls send. thanks hareesh
Shared Users - Access to Print Reports
I have shared one of my apps with several users in my office. I have built reports for them to use, but the system does not allow them to download to CSV and print. They have full access to all reports and views. Any ideas why they don't have the CSV download function after they run the report?
Make radio button default
Hi I have a section where when joining the customer must select if they are male or female. as its a male orientated site, i want the male default radiobutton to be selected as default, but i dont know how to do this... thanks hareesh
radio button make checked
hi how to make a radio button default checked in creator Thanks hareesh
how to delete a "field" in form definition?
hi i have created some fields in a form, and now i have to delte a field from by using form definition script,i know how to delete visually, i want to delete a form field in field definition.
gmail
hi can i make all gmail users send mail to add new row to the database ?????????
Deleting children/detail records
When deleting a record in the parent form of a master-detail (Parent form to sub-form) relationship, I am finding that the children records are NOT automatically deleted, they are left as zombies! Does that mean I have to create a foreign-key field in the sub-form that relates to the primary key in the parent form? if so, then I have to create a deluge script on "Delete" at the form level to fetch all the related records in the sub-form and delete them. Am i correct on this, or is there something
Accessing a field in the parent form
I am trying to build a deluge script in a sub-form field (on user input) but I need to use a value from a field in the parent form. I thought they were linked together but I did not see the list of fields in the criteria section, so I tried the following: (Form_name.Field_name), but that didn't work. Example: I have a field "Gender" in a customer form (parent), but the detailed sub-form is where I perform calculation based on the gender of that customer. Can you see/access the parent fields
Problem: View not being displayed
I get the following error message when I attempt to view a view. How can I see the data? We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
Send views if new data
I currently have two schedules that periodically send views as spreadsheets to me. I'd really rather them only send when I have new data. My idea is to have a table that keeps track of the last maximum record ID and if the current maximum record ID is higher, send the views as spreadsheets. Is this possible? Ideally, I'd have it done as part of the success event, but it says that file attachment is only applicable to scheduler actions. Thanks, Carl
Selecting Dropdown item to display relevant Fields
Hi to all i have one Dropdown in a Form ,the dropdown have two choices one is LAND another one is HOUSE.based on above two choices if end user select the LAND choice to display relavant fields and hide HOUSE relevant fields. is there any way to implement. Thanks Hareesh.A
Set Criteria for Lookup field
last_name == input.last_name Gives me error "Variable 'this' is not declared" Can't the Set Criteria under Zoho use an input from the current form as a Criteria?
Based on dropdown selection,how to show and hide the "Add Note".
Based on dropdown selection,how to show and hide the "Add Note". Iam able to do the thing like,On form Load event iam hiding all the "Add Notes". But once i will select some value form dropdown based on selected value i have to show the selected value "Add Note".(This iam not able to do).For example,i have 4 "Add Notes".On form load iamhiding all the 4"Add Notes".And on selecting the dropdown only that note i have to show. Please help me out of this.
Email
How do I send an uploaded image file in my email message?
500 Server Error when trying to change application name or link on Settings page
I made a copy of an existing application. That application was entitled 'Copy of ProjectName'. When I go to the settings page for the copied application and attempt to change the application name or link, it gives me a 500 server error. Robert
Does Zoho have servers in Australia?
Hi Zoho, I love Zoho Creator but find that applications load very slowly. For example, look at www.cocoride.com.au, a website I set up with a Wordpress backend. The wordpress pages load within 1 second, but the Zoho Creator HTML view takes 11 seconds to load on average: The interesting thing is, it's just for Australian visitors: I also note that Zoho's server status page does not list any Australian servers: This creates major problems for me as an Australian Zoho developer. My clients are dissatisfied
Scheduler script stops if it encounters an email address it thinks is bad.
I have sever custom scheduler scripts that are supposed to iterate through and send emails to our staff. If the script encounters what it thinks is a bad email address it errors and stops. The additionally troubling thing is the error logs aren't detailed enough to figure out on which address the script stumbles. Below is a streamlined version of the script. How do I get it to keep running if it encounters an email it doesn't like? for each e in Staff[((Email_Address is not null) && Notice)] { eml=e.Email_Address;
How to apply styles to ZOHO Form.
Hi, How to apply styles to ZOHO Form. Please help me out of this.
Formula Syntax
Can anyone help me get the syntax right for this formula? I have 4 fields. field1 is true/false field2 is a number field3 is a number field4 is a formula I want field4 to perform this function: If field1 is false, then field4 = (field2 * field3). If field1 is true, then field4 is null. Thanks, Tom
How to send a customised email
Hi I am new to Zoho and am trying to build what is probably a relatively simple application.... I have a View embedded in my website, that contains a list of people records. The email addresses of these people are purposely hidden from the View but are still part of the record. I am trying to create a script that allows you to select a number of these records and then send out a message via the website. The message has to be customisable via the website and the email records have to still be
on validate performs only the first check
Hi, I need to perform several checks before the datas are stored. To do this, I have a script on when validating - submit. The problem is only the first "if" seems to be evaluated, not the following "else if" When the first condition is true, the datas are added... Any idea ? Here is the code: Submit ( type = submit displayname = "Valider le projet pour enregistrement" tooltip = "Cliquez sur ce bouton pour enregistrer votre projet
Remove Decimals
Does anyone know how to remove decimal places in a expression? I'm trying to calculate the amount of nights a clients stays. ((Stay_End - Stay_Start) / (1000 * 60 * 60 * 24)) this will come up with 7.00 I would prefer it display just 7 Thank You, Phil
show multiple fields/rows from one form in a Add note field in another form
Dear members, How can I fetch some fields based on a selection from a form (FormA - normal form) and show them in a Add note field inside anther form (FormB - stateless form)? The story is this: FormA = contain fields: User_acc (single line), User_link (single line) FormB = contains fields: User_acc (single line), Note (single line) In FormA is saved all the links (User_link) associated with a User account (User_acc) ... so we will have a database like this: User1 | Link1 User1 | Link2 User1 | Link3
Using ZC form (with dynamically generated url parameters) on NING
Hi Team Ticket ID:1745299 Subject:Trying to integrate ZC form (with url parameters) witn NING (Community page) I am trying to integrate ZC form into a NINGpage. This is a three part process WebForm 1 -Basic ZC contact form embedded on client page - with predefined field values passed as static url parameters Works good, no problem here Form submit > initates an email with a link to Webform 2 Email is passed as parameter url parameter is generated based on the user-email in webform 2 URL is getting
set up field when pickup field
hello. I have 2 forms: 1. FORM "blogtext" whith pickup field "name" (i pick it up from form podr1) and field "mailto" 2. FORM "podr1" with field "name" and "email" What can i do to: when i choose the name in form "blogtext", need to set up emal from choosen person to field "mailto" Thanks
Please ! urgent... Update a total after deleting a row
Hi, Thanks to you folks, I'm now able to have a total in the main form that sum values from a subform. This part works fine. But there's still a minor problem I can't solve: if the user delete a row with a value in it from the subform, the total is not updated. It seems logical, given that there's no "user input". So I tried to apply the same script on "on delete row" but nothing happens. Any idea ? Here is my script: temp_total = 0.0; for each x in FPA1 { if (x.Montant != null) {
More effective Group Member management
We have hundreds of volunteers in several counties around California, each of whom will be a User in our Zoho account. We are creating an Application and a Group for each county's volunteers, and Sharing each county’s application with that county’s volunteer Group. Volunteers come and go all the time, and only current volunteers should have access to one of our Applications, since the Applications will contain sensitive information. Thus, we need to be able to easily compare each county’s list of
How to hide/show forms based on user selecting "Accept" on terms and conditions page?
Hi, We have the following requirements: 1. User (Not Admin) visit our site and will show the terms and conditions tab only each time 2. Once he click the "Accept" radio button and click "Submit" button then shows other forms (which are tabs) to him/her. 3. If Admin login, it should show all tabs. Please let me know how to implement it. If having code snippet that will be awesome. Thanks, Winson
Double Vision in Chrome Version 23.0.1271.64 @ Freeflow script mode
Hi ZC team Double vision happens in all apps (personal, shared, developer access) when viewd in chrome irrespective of form / view / Schedule / Functions etc This happens only in FreeFlow script mode Script builder mode is working fine Please see attached jpeg. Thank you Best Regards -Deepa Govind http://homepreneur-online.com/
Submit through mail
Hi there, I have a doubt. When I fill in a form it sends a mail with the information to my client, is it possible that if he replies to the email then it fills in back to the form with the rest of the information? It´s like the submit through mail option but it has to fill back regarding the ID. Thank you
Populating Subform through Deluge Script
Hi, I have looked extensively through the support section, and while accessing subform data is relatively easy, I have still found no way of adding subform data through Deluge script. I am trying to automatically generate invoices when a booking is made, but the line items for the invoice are in a subform. Any pointers in the right direction? I have already inserted the non-subform data into a new invoice: Customer_Invoice_ID = insert into New_Invoice [ Added_User = zoho.loginuser Address_1
Add Items in a PickList Dynamically - Not Working
I am trying to add some Products to a picklist dynamically. I have a form where there is a lookup field called product1. By default it gets all the products from a separate form. I then have another form called "Setup_Delivery_Locations" where I have another lookup field back to the same products list. I want the products list to be filtered by the "Setup_Delivery_Locations". So here is the code that I have: VShiptoProducts = Setup_Delivery_Locations [Delivery_Locations == input.Delivery_Locations];
Adding records to zoho creator with REST API
I'm trying to add a record to one of my forms in zoho creator using the REST API and python. My code looks like this: from httplib2 import Http from urllib import urlencode access_token = 'AUTHTOKEN HERE' h = Http() data = { 'authtoken' : access_token, 'scope' : 'creatorapi', 'zc_ownername' : 'reviewpro', 'external_id' : 1 } resp, content = h.request("https://creator.zoho.com/api/json/desk-com-cases/desk_cases1/add/", "POST", urlencode(data)) print content And I always get the same
Missing tabs even log in as site admin. Please help!
The site works before but just missing all tabs all of the sudden. Thanks,
Next Page