Invalid json for View Records API
Hi, I am using the View records api to get a list of report. I ask for json response, while sending the get api. But in the reponse I get an invalid json. Please let me know what should be done to resolve this error. Below is the code for ref $service_url = "https://creator.zoho.com/api/json/*************/view/Images_Report?authtoken=*************************&zc_ownername=*********&scope=creatorapi"; $curl = curl_init(); $headers = array( 'Content-Type: application/json', 'Accept: application/json'
Need help with "for each ..." when using list() function.
I want to collect data from Zoho Subscriptions via the Zoho Creator/Sub interface. I can see that I am fetching the data, but I am unable to insert the data into my creator table. My guess is simply because I do not know too much about the list() function. Any help on this short piece of code? I get the error in the line "for each ....." ======================================================= vRespons = zoho.subscriptions.getList("Subscriptions", "xxxxxxxx"); vtext_Subscriptions = vRespons.get("subscriptions");
import email field and send email
Hi, I have two forms - 1 for employee details & 2 for item allotment. Employee details contains - employee name and email Item allotment contains - item name and emp details (lookup used from employee details) I want to schedule an email to be sent from item allotment page to the emp whom am selecting from the dropdown. How I can do that please help. Thanks
iOS Creator - Pivot Table Report View Issue - Minor
Zoho Creator v 3.5.4 for iOS in IOS (on an IPhone 6), a pivot table report that generates more then several columns is difficult to view because the "Rows Popup Tab" remains up and will stay up until the user coaxes it to go back down. Seems it should drop back down momentarily after making any scroll changes without user intervention.
Is there any problem with the display type in reports?
Dear All, Can you please check if you change the display type of a report from List to Speadsheet or Grid for example (from the Summary Settings), does it change for you?? Because in my reports it does not do anything!!! It still shows me as List!! Example: It shows a LIST
Inventory counting problem
I work in a restaurant and i have to make ordering forms for diferent vendors. I would like to have an easy way to display the records with a dropdown menu with the quantity i want to order. And save each orders with the quantities in a separate form without afecting the main inventory form. Thanks
Ampersand in field being converted to "& amp;" in lookup field
Hi, When using an ampersand in single line field and then using that field in a lookup it is displaying as "&". See http://prntscr.com/8haopw Thanks, Damien Cregan Hire an Expert
exporting data from creator to crm
I would like export the data that I have in Zoho Creator to Zoho CRM under the Vendor section. Can I do this?
Customer Portal Profile as System Variable
Hi, is it possible to have as a Deluge System Variable the Profile associated to the login is using Customer Portal? tks, Pippo
Problems with shared application
Hi, since few days many applications that i have created for work and accessible to all the visiotrs on the web ask a Zoho e-mail and password. For me It's a very big problem because many students cannot use my applications. Please help to fix this problem because there's no need of LOGIN. Diego
Copy aplication from another environment
Hello, i created a application in a zoho creator instance, but now i want to copy this application to another zoho creator accont. I did and downloaded a backup of my application and tried import the .ds file but the creator returned a lot of errors. Is there another way to copy/import my app?
Creating a task to assign leads
Is there a way to have all leads go to one user who can then assign them to different members of staff to follow up on? These leads then need to go back to another one user when the first assigned user is finished with them to be reassigned to another staff member. Is this possible?
Search multi select fields
Is there a way to use the built-in column search (Is, Is Not, Is Empty...Contains, etc.) to return records that contain multiple values? For example, the multi select has options for dog, cat, horse. I want to see all records where the user has selected only dog and cat, but not horse.
User interface header glitch
We have had a strange glitch in the User Interface of zoho for quite some time. I will explain it in words then i have provided a video as well. Any one else had this problem is there a fix? Basically if we execute a function that opens a record list in a zoho overlay popup then delete a record we are left with the header of the record view being covered by the one from the popup. The page needs to be refreshed to get the interface back to normal. http://screencast.com/t/2RkzK3YQ5 I have included
Display "Title" of an image field on the record view
Hello, I want to display the "Title" that can be entered when making the entry for an image field on the record view as a headline of the image. I'm also confused that the functions of the "Alt" text and "Title" for an image don't work at all as it is explained on the "creator help" website. I couln't find a similar post and look forward for any recommendations. Thanks. Best Hans
zohocreator.exe upload authentication issue
Hi - in running an established daily csv upload with zohocreator.exe, we are suddenly getting an "Username or password is incorrect" error message. We have not changed anything at our end. Please advise, further details on the issue have been forwarded to support.
How to send a mail including just the fileds that have been filled but not some other that are not useful?
Hi, I would like my customers to receive via mail a summary of some products and services that they have selected and purchased in my form. How Can I automatically send them a mail that contains just the fields they have filled but not some others that are not useful? Thank you very much and sorry for my English. Paolo
Refer to field in another database
I'm working on script for a basic form. On that form, there is a Lookup Field that connects to a form in another database. I'd like to pull-in information from the form in the other database based on what's entered in the Lookup Field, is that possible? Here's a bit more detail: There is a Task form. It has a multi-select Look-up field: Person(s) Responsible. The dropdown menu for that look-up field (Persons Responsible) is based on a Team Members form in another database. Included on the Team Members
Bug when adding share permissions through API
When adding permissions to a form via the API although the form displays the permissions correctly, unless I also add permissions to the Section container the page loads incorrectly and although the forms are listed when hovering on the section when clicking on one of them nothing loads, just the same broken page as shown below: The only way I've found to fix this is to add permissions manually to the section via the GUI, however this is a pain when i expect to have close to 15k users Once the permissions
Can I log on as user when I am Admin?
Is there a way for me to log on as a 'User'? I am testing out some of the security and I can't figure out how to log on in 'User' mode. So far I have just used a second email address, but I am migrating to a paid version and I don't want to pay for a user just to test. Thanks.
Restrict days and or holidays
What would be the best way to restrict day(s) or upcoming holidays? Ideally restricting days or holidays from a calendar date field from being selected. Any ideas?
Update all records (except one) in subform with for each
I have a main form called Quotations with a SubForm called Agents_Prices The Agents_Prices subform have a Decision Box field called Go When a user checks Go in one row of the subform we want to uncheck all the others true values of Go in all the rows in the subform (except the current row) After consulting the help and this forum I try with this code if (row.Go) { for each row in Agents_Prices { Go = false; } } row.Go = true; But don't work
ACCOUNT DELETION
Every single time I try to access my subscription to change plans, I'm directed to my creator dashboard. I'm getting pissed off. How the hell can I downgrade my subscription if I can't even get to the right page.
Can't modify an application
All of a sudden when I try to modify any of my database applications, I get the immediate error message "500 Something went wrong - contact support" This happens on several, if not all of my databeses and I am unable to make any changes whatsoever. I can still add, remove, etc. data, just cannot change the format. 04/19/2015
Zoho Creator Mobile Breaks images if more than one on Form
I was excited to see the Zoho Creator Mobile app get updated today. I was hoping this bug would get fixed but I quickly learned it did not. Process to replicate: 1) Create a form with two images on it. Call them image1, image2. 2) Fire up the mobile app. Take a picture and upload it in the app as image1. 3) Go to desktop and mobile app and image looks great. 4) No go to mobile app and take a picture as image2. On the mobile app it looks great. 5( Fire up desktop app and now image1 is corrupted.
Unable to add new records - have an infinitely spinning icon
Good Morning I am unable to add new records. Below is a screen shot with data blurred for privacy. The date has a infinitely spinning icon as well as a lookup field. The next field is a filtered lookup that remains unpopulated. I am experiencing this on multiple applications that worked fine last week. Please advise. Thanks for you assitance.
Lookup form data instead of ID in email
I am sure others have had this issue too but I couldn't find the info. How do I get the data ie: Name to show up in my lookup field instead of the internal ID? I have successfully set up my email notification but I can't figure out how to insert the Name of my customer instead of the internally generated ID. All of the other fields are displayed correctly except it is showing the form lookup field internal id instead of the actual field data. Thanks
How to create a formula that decreases the Due Date - zoho.currentdate by 1
Dear All, I would like to create a form with a date field (name Due_Date) and a formula. My scenario: When I give a date to the date field (for example 22/7/2015) then I would like in the formula field to calculate the date (22/7) - zoho.currentdate and to return me the number of days. In the report, each day the zoho.currentdate will decrease the number of days by 1. In that case I wrote the following inside the formula: days360(Due_Date,zoho.currentdate) The problem is that in the report it does
sign in to support
Why can't I sign in to review my requests Tells me my user name or password is incorrect. User name (my email) is correct. Tried to reset password and get message no such user (which is my email)
Customer Portal - All Portal Users
For some reason when I edit a report, restrict visibility changes and it keeps adding all Customer Portal User group to the visibility group....not good. Is there a setting I need to change? I don't want to check visibility every time we edit a report.
Call Main Form from Subform
I have a Main Form "Projects" and a Subform "Project Status". Each PM updates "Project Status" -- details of the project status. In some cases, they need to update the Main Form "Projects". I am able to create a url for the user to click to access the Main Form "Projects" record id from the subform "Project Status" when it is necessary for the user to edit a record on the Main Form "Projects". However, this does not work if there is a filter used in the report per zoho. The filter that I use
BUG: Mis-aligned fields and values
The first view is normal edit view of a Custom record. Then I created a Profile called Drafter, who uses Field Permissions to make certain fields non-visible. When this Drafter user logins to view an order, then click on the customer name to open up this customer. Things start to go wrong. See 2nd image, how fields mismatch the values.
Apps missing from Personal Apps list
In the past 5 years or so, my company created a number of Apps. With some technology and staffing changes, our paid account lapsed for a few months. I just reactivated the account with a new credit card and now a number of the Apps are missing. Most importantly, I need the Diagnostic Form app we created. I left a voicemail for support yesterday morning and haven't heard anything back-- very disappointed with customer service.
How to reload a page with deluge
Dear all, I have an HTML page which consists of a form (embed form). This form has a lookup field. I would like when I choose something in the lookup field then to reload all the page. Is it possible to do that? If yes, what can I write in the on user input of the lookup? I found that I can use the Navigational URLs. But I do not know if I can use the #Script:page.refresh Furthermore with the usage of reload; in the on user input it reloads only the form
Record Limit Reached - Innacurate Count
I have a custom plan that includes a million records, i received an email stating that i had reached my limit, i have added all the records in my applications and they do not add up to 1.4 million which is what my limit screen shows as being used. I tried calling support and sales and got a voicemail on both, can someone please explain to me what is happening here? Thank you.
June 8th Update Removed Formatting on Calendar Report?!
I have a Zoho Creator Application, which has been in use for a year and a half, that tracks Email Marketing Campaigns. My team uses a Calendar Report to help review the scheduling of past and future campaigns, which occur multiple times per day. The name of each campaign, that is displayed on the Calendar, is generated from a formula field called "Calendar Name", that combines a couple pieces of information along with a 10px by 10px jpg. or gif. of a solid color, which was uploaded to the application,
Images showing in Firefox but not Internet Explorer
Any idea why images would show in Firefox and not IE? I had no idea this was an issue because I use Firefox but some of my employees use IE and can't view images. I logged into Zoho in IE and I can't see the images either...so it isn't a permissions / share issue because I can't view them either.
Calendar views are broken
Yesterday ZOHO rolled out a change to the platform that has BROKEN the calendar reports. The current week's events are showing as very small boxes that do not fill up the space between the start and end times. And it is not possible to click to the next week or show the monthly view. We need this fixed URGENTLY as our staff cannot book clients and manage their schedules. PLEASE roll back the changes that messed up the calendars! Anton
appointment form for beauty salon
I need appointment sistem for beauty salon.
New Application or New Module?
Any tips or advice on when you should stop added modules to an application and to start another application? From my little experience it is easier to manipulate data between modules than between applications. How do you know when a group of modules need to be separated into a new Application?
Next Page