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
MS Access upload with PDF file attachments.
HI, I would like to upload a MS Access database with PDF files attached to different contacts. Is this possible. Thanks Mark
Report accuracy
We have a system with over 8000 records. Our reports are inaccurate and even after refreshing they are still inaccurate. We also need to do multiple "regenerations" in order to get the accurate information. I have enable "edit access" to my applications. Please can you investigate and respond? You mentioned in older posts by other users a year ago that you where working on the problems with respect to reports not displaying accurately. I trust you have ironed out the bugs in your software within
Adding form data to multiple records
Been using Zoho for a while, but now wanting to elaborate on something we tried to do a couple of years ago. Our overall setup is quite complex, but the part in question is probably so simple for someone that knows how to do it. If we have a FORM, called "New Job". Within this form we have a lookup field linking to another FORM called "Customer Records". Now we can create a New Job and attach this to either a new customer, or an existing customer..... We go to a VIEW created on "New Job" form data,
can I add a Link in a form
My form has lots of fields, I want to use a "Line" to divide those, so easier to tell what group is for what. If I have a html web page, only need a <hr/>, but I don't know how to do that in Creator form Thanks
Stretch a not filed across 2 columns
I created a form using the default 2 columns. At the bottom of the form, I need to stretch a note field that has 2 paragraphs of information that the user must agree to before submitting the form. Ho do I get this note filed to stretch across both columns instead of being bunched up in the left column? Thanks!
Counting Schedules
I need some clarification on counting schedules. If I set a schedule to run daily at 8:00 AM, are you going to count each daily run against the number of schedules that I have per my contract? Thanks! Vishal
Custom CRM fields in an application?
When I add a reference to Zoho CRM to an application, I can select a module (i.e. Contacts). Then the application user is presented with the ability to look up contacts to select or add a new contact. 1. What I want to do is skip the look up portion and have them create a new contact. How do I do this? 2. The Quick Create dialog for the new contact only lists a couple of fields. How can I designate more, and can custom fields from our CRM be included in this dialog? Thanks
Allowing two sets of form data to be combined
Hi all Been using Zoho for a while, but now wanting to elaborate on something we tried to do a couple of years ago. Our overall setup is quite complex, but the part in question is probably so simple for someone that knows how to do it. If we have a FORM, called "New Job". Within this form we have a lookup field linking to another FORM called "Customer Records". Now we can create a New Job and attach this to either a new customer, or an existing customer..... We go to a VIEW created on "New Job"
error on Creator's homepage
I receive the error below when I try to access Creator's homepage while I am already logged in. Regards, George Baltatescu Zoho Creator Developer
Performance issues?
Creator is really, really slow. Has the system crashed? Can it please be fixed?
Business Free Plan
I'm with Zoho creator since 2008, I have seen all your up and down features, and one of thing you really don't bother is disturb your existing users. Previously I had 5 users, logo, 10 Apps and backup plan included. Suddenly I noticed my plan shifted from Business Free to Personal Free. Now I'm getting 2 users, No backup, No logo and 3 apps. It feels like bluff, this is not the way you treat with your loyal users. I will really appreciate, pls remain me in my existing plan.
creating pdfs from zoho creator
how does the zoho creator pdf function work? can I merge data we collect in zoho into a predefined pdf? our challenge: we want to create a form from the data we collect in zoho...we don't know how to do this. can anyone help?
Actions on Bulk Update
When will this feature be implemented? The request was made years ago.
plz help me
how to insert the online weather report value into zoho database? please help me want to display the current conditions based on a zip code plz help me................
Email from Another
I need email confirmations to appear to come from someone else rather than me. I thought I might be able to accomplish this by adding a secondary email address to my account, but I don't think I can choose this email in the from spot. When I manually enter the email address in the from spot, the form complains upon clicking save that the mail must have zoho.adminuserid in either the from or to spot. I understand that this behavior is desirable from a anti-spam position, but is there some way to
Better usability on mobile
So I've created a form. When I go to the URL on iPhone in portrait orientation, I cannot see the entry fields to the right. I only see the field descriptions, and it isn't clear that the boxes are over there. Pinching and stretching doesn't seem to do anything. Changing the orientation to landscape, I can then see that there are boxes over to the right that need to be filled in. This is confusing. On a Galaxy, I can at least scroll to the right when in portrait orientation. But how would I know
HTML View
Is it possible to send HTML view as an attached report on a daily basis? Please let me know. Thanks! Vishal
Creator removing "/" from URL
Hi, we are using a Creator contact form extensively through out our web site. Example: http://2base.com/en/contact/ The contact form is catching the URL of the site where the form is used. (This is hidden for the users). But for some reason it also removes one of the "/" in http://.... So for the above mentioned site the URL shows as http:/2base.com/en/contact This causes problems in CRM, since Zoho CRM does not recognize http:/ as an valid URL, but only http:// Why is one of the "/" being removed
Can Creator be used to create a web form for CRM?
We have done some customizations within Zoho CRM and want to create a form for our website that allows for the creation of an account, associated contacts, and an invoice for an annual payment. Then we would also like the form to allow for returning members (accounts) to look up their account and renew without having to re-enter all their contact information. So does Zoho Creator allow me to create web forms based off of the information and structure within our Zoho CRM? Is this all available within
execute events
Hi, What changes should I make to the following script in order to execute an event only on weekdays and not daily? ---------------------------------------------- Reports { execute event on '2012-06-11' at '05:00' daily } ---------------------------------------------- Please help. Thanks! Vishal
Link with zoho CRM
hello, is it possible to display in zoho creator the attachment witch are in Zoho CRM Case ? The attachement are PDF, image... thnaks
Date & time picker
I think it will e great if we can simply date and time picker , may be we can have some thing like this for date-time field Date-Time: MM/DD/YYY HH/MM Where separate box is given for date & time thanks
String to hyperlink
How to convert a sting entered by a user and convert it to a hyperlink?
How to round the decimal number to last two digits.
How to round the decimal number to last two digits. Example: decimalnum=66.88888888888888 Result should be 66.88
Documents management
I sometimes attached multiple documents to a main record. Can Zoho develop a way for me to download multiple attachments in a single package, like a Zipped file, like Gmail is doing? Thanks.
Send email to everyone minus name on single text field or in subform field
Hi, I have a single text field "Name" and a subform with another single text field "Name", I send emails warning with data, but how can I change this so that 1. if(input.Dept11.contains("Qualidade")&& input.Nome !=) { sendmail [ from:zoho.adminuserid to:zoho.adminuserid,"john@xxx.com" subject:"Lembrete Portal Inovação - " + input.ideia + "" message:"Ideia - " + input.ideia + " colocada por " + input.Nome + "para avaliação na área de Qualidade" content
Next Page