How to Add Criteria to a API Request Using Form Method GET
I'm following the API directions to fetch a single record from a view using the form Get Method. I'm not a programmer and the documentation says you can add criteria to your request, but I don't know how to add the criteria. I can successfully access the view. The request returns the entire record set, I just want a single record returned. Can anyone help me with adding criteria to my API Get Request Here is my request with an attempt to add criteria as a parameter. Not working of course. <form
Attachment via subform
How can I send an email notification via a sub form attachment? Any assistance in this matter would be greatly appreciated.
Pull multiple fields from Form A into lookup field in Form B
In Form A I have 3 different fields, Contact, Contact 2, and Contact 3, plus Email, Email 2, and Email 3. In form B, I have a lookup field that currently will only lookup the value of Contact and auto-populate the associated email. In the lookup field of Form B I need to pull the values of Contact 2 and Contact 3 also (if value is present) into the lookup field. Is this possible?
Skip weekends formula
Hello, I am building a database that will allow a user to set a target delivery date and choose a shipping zone. Based off of this information the program will auto populate the "needs to ship on date." My issue is i can not find a formula to add in the extra two days for the weekend if there is a weekend in the middle. This is what I have so far. Thanks in advance for any help. if (input.Shipping_Zone != "-Select-") { days = ((input.Shipping_Zone).subString(0,1)).toLong(); if (days >
Time field and average calculation
Hi, I have submit several tickets since almost 2 weeks, we did not had any reply back?? I hope someone an help me here, here are my questions : 1- I'm trying to create a simple form for my employees to fill the working hours. - Is there another way to have Date and Time separately? We found really hard to fill the time into the Date/Time field. - Also we need a field that will deduct the lunch break, Here is the formula used into the total field : (((((((Finnish - Start) / (1000
Problem with condition for disable subform
Good day, I have a subform in which I want a radio or checkbox type field by selecting an option from the list in the same place two fields subformularia DISABLED. and trying to do it this way. if (sfrmSubActividades.chkSubnivel3 == "Si") { disable sfrmSubActividades.txtValorSubcUE; disable sfrmSubActividades.txtValorSubcGN; } InvalidTaskInSubForm get error, can in some way?
Bi-Directional Relationship
FormA has a multi-lookup to FormB, with ability to "add new" FormB has an "existing relationship" lookup to FormA. My expectation is that, from Form A, I can add new values in FormB - the problem I'm having is that: I think FormB should automatically KNOW the value of the linking field, without my having to enter it, and it doesn't. Should FormB be able to automatically know the value of the linking field, because of the bi-directionality? Or is it really necessary to add the value manually????
How can I save a photo to an app with an iPhone or other mobile device?
I have an app that requires photo documentation in the field. I want to be able to enter text data into a form and then take a picture to be attached to the form in a field. I want this to be done with a Blackberry, iPhone and Android phone. Can this be done? Snap a picture and then attach/ upload? If not directly, does anyone have any recommendations on how to do?
no reply from support
I sent an issue by email 2 days ago and have had no reply. The subject line is "automation not working" I have logged this again via the support request form today. I am not receiving any auto-reply from support that even indicates that my email or form submission was even received at your end. Please advise.
ZC and ipad - date picker
Odd, but.... from the ipad, when I select a date using ZC's datepicker, the date that gets populated into the field is one day earlier than what I selected. Any ideas how to isolate what's going on here?
Custom Scheduler not working for add record
I have a script that adds records to a table. I had created a custom schedule on 27th July with following settings to see if it works: Start Date: 28th July, 2014 Time: 00:00 EST Repeat: Frequency: Monthly, Day of Month: 28th. I expected the script to run and add records on the 28th July but it did not. (When I click on 'Execute Now' in the scrip builder for this script does not give any errors and the records get added successfully). Am I missing something here? Any pointers will be helpful. Thanks!
PHP form sends data to Creator
Hello everyone! I have a problem that I can't solved. I have a PHP form on my website and I want to add a record by this form to Zoho creator. Now the action for this form is to send an email (by mail() function) and I need some additional function which will send all information from form to zoho creator. I was searching on the Web but I didn't find any idea - maybe because Im a beginner in API and I dont know what exactly I need.
"Failed to submit data. Please contact application owner."
I'm using the free version of zoho creater and have created an extremely simple form. However I cannot add any date to my database. When I try to submit the form I get the error message "Failed to submit data. Please contact the application owner" There are no fancy validations or anything on the form, it's simply a zohocrm look up (I'm using the enterprise edition of zoho crm) and 3 date fields. Grateful for any help and advice.
HTTP JSON request - return no such view error
Hi I am trying to fetch data in JSON format from one of my views The below fetch call returns There is no such view in Zoho Creator http://creator.zoho.com/api/json/<application_name>/view/PriceSheet_Report/apikey=XXXX I like the above url to return the data in JSON format. Can please help me? Cheers -Jag
Script error when evaluating old field value
Becoming frustrated with ZOHO Support Found that you can't apply an IF or SET statement against any old values (any old code still works) For example if you create a new form say ZOHO TEST and create a single line field called TEST In the Workflow Script, On Edit Validate if you create an IF statement to look at the old content of the field TEST this error occurs Error at line number : 1 Variable 'old' is already defined of datatype '1013228000006314713' but trying to update 'zoho_test' datatype
Cannot duplicate applications
Hi, I'm trying to duplicate an application, but every time I click duplicate it says "duplicating" and then nothing happens. How can I fix this?
REST API response speed
Hi ! I think that something wrong going with REST API. I testing 2 different way of fetching data from Creator. 1. REST API GET https://creator.zoho.com/api/json/<application name>/view/<view name> (with credentials) response time - 390ms 2. GET https://creatorexport.zoho.com/showJson.do?sharedBy=<zc_ownername>&appLinkName=<application name>&viewLinkName=<view name>&privatelink=<privat key> (privat key is part of url for public link) response time - 160ms note 2-nd way is undocumented ... but more
can you key data into a date field?
can you key data into a date field? I have several employees who find it easier to key a date than select it from a date box. is it possible to key the date?
Assigning "Numeric Value" to Radio Buttons
This is a two part question (I will take one answer at a time if not one person can answer both LOL) Q1: Is it possible to assign a value to each individual option on a radio button? e.g. Radio Button Field 1: Was the Main Objective completed? Options: Yes = 50 No = 25 Radio Button Field 2: Was the minor Objective completed? Options: Yes = 50
importing apps
Have imported the Apache OpenOffice app for my linux documents, but while it seemed to install properly [even has own icon], when try to access it, all get is message that have lost contact with the page -- again and again and again. Anyone have a solution?
Support Issues
What is the best way to get Zoho support? I submitted two different support requests (and left voice messages) last week that were critical to not only the usability of my application but the roll out of the application (which has now been delayed by a week with no solution or timeline in sight). All I get are "we're working on it" emails but no solutions? These issues are still not resolved. Is this typical of Zoho support? It doesn't seem like they place much of a priority on their customer
view an image or a file in a stateless form that is fetching data from another form.
Can this be done? I would like to be able to view an image or open a file that resides in another form in a stateless form.
search not allowing decimal entries
Form A has a lookup field <diameter> <diameter> is defined in Form B as as 3 decimal with max 10 digits when in view of Form A, and I search for a diameter with a decimal place, I get error "please enter valid number to search". but I can search for the decimal in FormB no problem. What is the cause? How to fix?
anyone know why this happens?
From the iPhone app, when loading information from a lookup field, it only shows the following, 1 option selected instead of showing the actual info in the field.
Seeking Help with autofill
Hello there, I'm new to zoho in general and I'm loving the service however, I am unsure how to go about something. I was wondering that if a user input their CRM name into a form that the creator would be able to fill out the rest of the form based off of that field alone. For instance, Joe Blogs has a quote, a purchase order and a sales order but doesn't want to have to type each out in the form. Would it be possible to just enter his name and grab that information from CRM. If this doesn't make
Copy form to new form
I have been trying to figure out a way to create a new form based on the completion on a previous form. Im creating a master manufacturing record. Once that form is filled it & saved I need to create a batch production record based on that info from the MMR each time I make a production run. The MMR includes a subform that is built while completing the MMR. For example it includes mfg steps. Some MMRs will have 5 steps while others have 12. This subform is built using the add new option to certain
How to set column formats in table chart view?
Hi there I have a table chart pivot report. I would like to be able to configure the format of data within each column. For instance, I have a date column and I have selected "Month and Year" but instead of showing "Mar 2014" it shows 201403. Similarly, I have a column showing Average. This is an average of currency so I would like to restrict that to showing 2 decimal places instead of default (12?) Thanks for your help
Filter a Lookup
I'm new to Zoho and have tried to do this ... https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup However, I'm getting an error - In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid Here is what I have build. 3 Forms Leases - Lease Name Tanks (multiple tanks per lease) + Lookup Lease Name - Tank ID Gauge Form + Lookup Lease Name + Lookup Tank (only want
Integration Zoho mail app shortcut with Zoho Creator sections
Dear all, My question is simple and short. As you can see in the attached image, I would like to know if there is any way to create shortcuts in the Zoho mail apps shortcut (in the left of the panel) with some sections of my Zoho Creator application. In my example, I would like under the Links shortcut to have Admin Functionality and Inventory setup shortcuts. If there is no way for that, then is it possible to have a shortcut under the Links with the name of my whole application?
Import form and subform data in zoho creator
Hello Situation There are two forms: Customer Account and Additional Contacts. Customer Account has a subform for additional contacts. However, the additional contacts were added separately before the subform was built. I need to connect up the additional contacts with the appropriate customer account. I have exported the data for both in separate excel sheets. Details The parent Account for a contact can be found by matching the "Ship To numbers" field.
Can I have 2 pop-up windows open at the same time?
I have a report, and I have a custom action that opens up another list, in a pop-up window. While that pop-up is open, can I use a 2nd custom action to open a form in another pop-up window? The only work-around I've come up with is to open a 2nd tab in the browser....
Fetch record in Subform with criteria
How to fetch record in Subform with criteria in script? I try same with fetch record in Form, but not working: x = From[ID = 0001]; for each x.Subform[Active == true] { } ---have error x = From[ID = 0001].Subform; for each x[Active == true] { } ---have error Criteria cannot be applied over fetch object
Data in form "A" not saving in form "B" in a nested IF/ ELSE statement
I have a customer service app (Form "A") that needs to save a date back to (customer_Info) form "B". The code is nested in a IF/ ELSE statement. The rest of the function works, but the updated date is not saving back to form "B". It is populated by the ID of form "B". ---> SiteInfo = Customer_Info [ID == input.Site_ID]; This section sends the email ok and with all of the info from form "B". It dose not save the date into form "B". What am I missing? // If the service is marked completed and the
Must be missing something
Have created a simple form. Data is organized by item number 01 to 99. I want to open the form view, & when a user enters an existing number into the item number field, I want to display in the form and have available to change the data associated with this item. Submit button at bottom. Not rocket science, I know but we all have to start somewhere. I have chased around help and forums and can see all sorts of good stuff but cannot get a handle on where to start with this simple function. Any pointers
esignatures
is there any way withint the zoho creator (or zoho writer) to add an esignature?
Allowing external access to just one data record - possible?
We have a membership database with about 750 records in Creator. We would like to enable members to access just their one record in order to make personal information updates. Is there a way to create a view that would allow a member to look up his/her information, and then make updates to just his/her record without having a Zoho account? When we talked with a Zoho pre-sales consultant, he assured us that we would be able to share direct links to records in order to do this, but we have not been
Email download link of uploaded file.
I want an email sent with the link to an uploaded file (say input.uploaded_file) to go out when form submission is completed. I see a several forum posts about this but none of the code suggested seems to work, seems like code is outdated. Can some one please suggest what I put in the Sendmail funtion to create a link for the uploaded file so the person can download the file.
URL link for uploaded file v. download link
Is there a way to link directly to an uploaded file via a standard URL that allows the email/browser app to handle the file accordingly. For example: http://creator.zoho.com/zoho.adminuser/zoho.appname/FILES/uploaded_file.pdf I don't know what path 'FILES' would be? versus: http://creator.zoho.com/DownloadFile.do?filepath=/input.File_Upload_1&sharedBy=zoho.adminuser&appLinkName=zoho.appname&viewLinkName=yourViewName The form scheduler option to send attachments with emails is limited to 100 per
File download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certain
Rest api access of zoho creator
I have a free account on Zoho creator. I have one form developed in creator. When I am trying to add record through rest api access, I am getting redirecting to Zoho home page. My rest url is - https://creator.zoho.com/api/skagrawal10/xml/copy-of-mtech-database/form/registration/record/add/ Post Parameters are authtoken scope NAME Please guide me in this.
Next Page