Make OutBound Call to Google calender so need IP address of ZOHO
am making an small application called as event scheduling. For that i am using zoho pages. and from this zoho page i am making call to Google Calendar, but after getting Access Token, and Refresh Token from Google i want to use API Call for that Google Needs IP Address of ZOHO Creator Server. i.e. Actually i want to make outbound call from zoho to Google Calendar so for that i need IP Address of ZOHO Creator Server. if any one know this please share it with me, Thanks in Advance
My attempt at a Audit Trail Log. Fully Working + a Few Question for ZOHO Employees.
First part of the post is a script for an Audit Trail, feel free to copy it if you want. Second part, are questions i have for some advanced user or employee, please help me. I wrote an Audit Trail Log for my application, i needed a simple approach, and a function that i only need to write once and copy/paste it without changes to my forms. This is what i did. I used the function getFieldNames() and getFieldValue() to get all the fields and values in any given form without having to specify each
DAte field question
I have a begin date and need to calculate my end date by a third field containing the quantity of months. How would this be done? I have been trying (and failing) for a few days and know it must be something obvious but I need help. Thank you so much for your assistance!
Error occured please contact application owner.
The attached is an error msg if one of my user has an input on one of the field of a form. I guess it should be because of a script on user input for that field but I cannot see the error. With my admin access the form works perfectly! Form: Tower_planning Field: Quantity - On Add - On user input
Variable not declared. How I fixed it.
I need to know the number of items in a picklist. So I put a counter in a loop of the picklist like this: count1 = count + 1; Zoho didn't like it. Gave the error: "variable not declared" So I tried putting this before the loop: count1 = 0; Lo and behold, that solved the error.
Performance
Is there anywhere to check current server status? I am experiencing very slow response times while both editing and using my app. Are you aware of any problems?
Dynamic picklist updates on manual entry, but not on scripted entry to reference field.
Hello, I have a form with 2 lookup-picklists ("A" and "B"). First the picklist A selects a record from a database. An OnAdd / Success script for this picklist uses the selected value to populate two fields (field1 and field2) with information extracted from the selected value. The second lookup-picklist (picklist B) uses the values in the two fields to create a dynamic picklist to further select records from the same database based on criteria for the picklist that filters against fileds1 and 2..
Adding 2 formula fields ( Solved By me :)
Is there a way to add 2 formula fields?
Lookup on edit android app issue
Hello, When I edit a record from the android app all the info in lookup fields is lost. Any ideas???? Thanks
Adding data to a multi-select lookup field
I have a multi-select lookup field (Email_To) which contains the ID for a table of Persons. I am trying to set the value of this field to the ID of a person record. What am I doing wrong? for each sales_enquiry_record in Sales_Enquiries [(Created < "01-Jan-2006") && (Email_To is null)] { sales_enquiry_record.Email_To.add(sales_enquiry_record.Person); }
Sub forms in a view
Hi I have a view in which I display a column from a sub-form. I would like to filter the sub-form records which are shown dependent on a value in the sub form. Is this possible? Thanks Craig
Formatting a number field
I have tried to follow previous posts on this subject, but don't have enough programming skills to make things work. In short, I have a number field. I want to add "," as a thousands separator. eg 210000000 becomes 210,000,000 If I understand right, I have to create a second field (single line text) and call the input value from the numeric field, then convert it to a string and add the commas. I've tried everything, but an make this work. My numeric field is called <non_Comma> and my text field
Read Text Field and get the sum of any currency values?
Hi, Is there a way to analyze a text field and then use a function to get the Sum of any currency values contained in the text field? Thank you very much.
Google Ical Feeds Not Working
All of sudden, my Ical feeds to Google Calendar are not updating. I have been using the same ical feeds for several years and they have been fine. The same feeds to a Zoho Calendar are updating correctly. Has anyone else seen this issue
Setting null to variable
Hello!I need to set different pairs of fields, depending on the user's choice. If the field is not necessary to set, there should be empty. Fields are lookup fields with ID's value. BIGINT type, maybe? I try so: tw = if(input.tBotcl, referencies.states.getIdByEng("onClientHands"), referencies.states.getIdByEng("employee")); te = if(input.tBotcl, null, input.employee); tcl = if(input.tBotcl, input.client, null); insertConfig = insert into changeConfig [ ... tBwhere = tw tBEmployee = te tBClient =
Group Edit
I used to be able to do a search and then click on Group Edit (or something like that) and then make changes to the entire found group. Suddenly I cannot do that. Did I do something wrong ?
Problem in downloading image from Zoho creator.
I have created a form in creator and from this form I want to download the images that i have stored in the zoho view without any tool like zoho client. I want to do this programmatically. Please help me out as soon as possible.
Fetch records from Zoho CRM to HTML View
I have a report (image1) with employee details. Also I created an html view (a table image2) which fetches the employee's data and show them in each cell. My question is, if I have all the employees details in my contacts (Zoho CRM) how can I do the same? How can I add in the E-mail cell the employee's email from the CRM? I understood the tutorial https://www.zoho.com/creator/help/fields/access-crm-fields-in-zoho-creator.html but what is the deluge code to get the email and put it in a cell in my
Can I edit the captcha on the forms? Is there a different type of Captcha than the one automatically available on the form?
My users are having trouble reading the captcha and are not submitting the form. Is there an alternative to captcha on the forms? An simple addition 3+6=?, or a JS created-checkbox? Please advise.
How to add existing CRM object with the new application
Hi, I am creating a new application in Zoho creator. I want to pull the accounts tab to be displayed along with the other objects/Forms in the new application. How can I achieve that?
Look Up auto complete
Hi I am having some probably simple issues. I would like to have an autocomplete field. I have a customer list of some 5000 customers and want to be able to have a single line field (not a drop down, there would be thousands of drop downs). When you start typing it narrows down the search to auto populate, like in Zoho CRM accounts etc. I am a bit new to this but have set up a new form with the customers and cannot work out how to do the rest. Thanks in advance. Michael
Submit to Url
Our services follow RESTful standards fairly strictly. A successful api call is indicated by a http response code in the range: >= 200 and <= 299. Any other http response code is a failure. Our services respect common http headers if you need to customize the response to a specific encoding or format. If you run into a problem, be sure to look at the http response code and headers as they usually provide specific information about the problem. When posting data upon transferring a prospect to us,
Zoho Creator backups frozen
Hi I have a number of backups that were started on the 2014-03-04 but are still in the Backup In Progress / Failed section. Does anyone know how to make zoho finish these backups or a way for me to delete them so i can start again? Kourtney
fetch record from zoho crm to zoho creator
Why i cant fetch data from zoho crm to zoho creator? I have a lookup field to the module of zoho crm accounts In zoho crm. a dropdown field (active / Inactive) My plan is when that field in zoho crm updated. it will also update my zoho crm field "Account Status" which is also a drop down I've done many way but still it cannot fetch the data
Do I need one or more forms
My contacts take many different classes from our organization of which we need to track and print their date of completion of each class and all the classes they have taken. So far I have a contacts form. Do I create another form for the classes we offer? What field/s do I use to get both class name and date?
Getting Error Message while creating new Form Action for On Click
While i ma creating new Action On Click button i am getting following error:- Error at line number : 1 at column 2 In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator != is not valid
Branding
Hello, I looked all around the many pages of ZOHO information but I do not find information that advises if I can develop applications and have it branded with my own company logo. exclusively. Any advice appreciated
Field heights on forms
Is it possible to change the height of a field on a form? If I use the two-column view I would want the fields in the two columns to line up, but if the adjacent fields are not of the same type (e.g. one is a date field and one is a lookup field) then the default field heights for these types are different and the rows do not line up. This looks messy, especially if the two adjacent fields are related. It would be nice if Zoho can add a feature to be able to design the look of the form so that we
What happens to uploaded files if the associated record is deleted
Hi, if there is a record that has a file uploaded with it, what happens to the file when the record is deleted? Does it remain in the database and if so how would it be accessed? thanks Kevin
Passing a multiple select field to a function
I am struggling with to get a list of record IDs (in this case from a multiple select field) to a function without the following message: Wrong DataType specified. The Template Variable Person_ID_List should be of type LIST. This is the function: void Functions.Send_Document(list:int Person_ID_List) { for each person_record_id in input.Person_ID_List { .......... and I'm calling it from here: email_list = List:Int(); for each person_record_id in sales_quote_record.Email_To { email_list.add(person_record_id);
404 message for every forum topic
Why do I get 404 message for every Creator forum topic I click?
Prevent users from users viewing same page via back button
I have some pages that perform certain actions on load. If a user visits them, moves on, then passes through them again using their back button, the load action is performed again. How can I prevent users from using their back button? Or display a different page when the page is visited from the back button? Or prevent actions from being carried out on load when visited from the back button? I was wondering about a solution using a unique ID generated per page view - but that would create a crazy
I had deleted one user from my existing and now trying to add new one but getting message that I have reached Maximum limit of creating users.
I had deleted one user from my existing and now trying to add new one but getting message that I have reached Maximum limit of creating users, whereas it is still showing that 1 user is available. Can anybody tell me how to add a new user now while I already have 1 available user. Regards.
Credit Card Information
I got an email from Max We do see that you are collecting credit card information in your zoho Creator form. According to zoho security policies collecting information like Password/Credit card/SSn is not supported . Please remove those fields , failing which might result in account de-activation. So I'm wondering what workaround to suggest to my client that asked for these items to be included? Can I create an form that just sends an email with such information to the admin? Please offer suggestions!
Automatic Field Name Updates
Cleverly, ZC propagates changes to field names to all functions, forms, pages and apart from headings, reports. Unfortunately, because of the nature of the openUrl statement, field names passed as parameters in the URL are entered as quoted strings and are therefore, not updated automatically. Has anyone come up with clever way of making openUrl statements update automatically as well?
Report embedded in Web site shows numbers instead of words
I have embedded a Zoho page in my website, but instead words it is displaying numbers. Any ideas on what I have done? It worked yesterday! This is how it looks in my website And this is how it should look.
Zoho Mobile app subform field limit
We have been using the mobile app for my database for a few days now. After the fix zoho did, and with the new version, I have been trying to enter my "Parts Used", but even when i try to do a search, this list only will show about 20 items. If I try to do a part search, it will not find it in my database. It will perform correctly via laptop or pc, but not via any android. I do want to thank you guys for fixing the auto Populate. It is just another bug that needs to be fixed. Any Ideas?
I can't fetch data from Zoho Reports table
Hi there, I sent a ticket to Zoho creator support but didn't get an answer as yet, so trying my luck here. Since yesterday all the forms in my application have stopped fetching data from Zoho reports to Zoho creator dropdowns: //QUERY FOR Usernames query = "select DISTINCT Username from Usernames where Status='Active' ORDER BY Username;"; url = "http://reports.zoho.com/api/<username>/<database>/Usernames?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=XML&authtoken=<authtoken>&scope=reportsapi&EMAIL_ID=[emailaddress]&PASSWORD=[password]"
I had deleted one user from my existing and now trying to add new one but getting message that I have reached Maximum limit of creating users.
I had deleted one user from my existing and now trying to add new one but getting message that I have reached Maximum limit of creating users, whereas I have maximum limit of 5 users and currently using 4 users and 1 user is available. Regards.
Feedback form not working
Can't use the zoho-help-feedback form, because the Capcha is not working properly. No image is appearing.
Next Page