Embedded Google Calendar Permission Error - ICAL feed
I made a change to one of the ICAL feeds on my Google calendar that is embedded in an Zoho Creator HTML view and now I am getting a permissions error ("Events from one or more calendars could not be shown here because you do not have the permission to view them.") when I try to view the calendar in Zoho Creator (without being logged into the Google account that owns the calendar) I have re-added the calendar feed MULTIPLE times with the Public setting (altough I think that the first time I added
Linking requests
Hi. Is there a way to easily link requests which are related? I'd like to be able to create a new requests when a new piece of work is generated from the original, but link it back. Is this possible? Thanks.
moving entire records across applications
I'm trying to push entire records from one application over to another and can't seem to get the scripting right. There's several forum posts that talk about how to move specific fields (but the getAll() function doesn't appear to work when dealing with the entire record), and there's descriptions of how to use lookup to pull one record (which requires dealing with each record individually). What I'm trying to do is move batches of entire records. Take our call centre activity for the day and assign
Help with scripting function
Please can someone assist me with this. I've created a simple app which consists only of 2 forms to simplify the problem. The forms are Quote and Items. Items is a subform of the quote form. I'm trying to script a custom function which will add a new record in the Quote View which has the same data as the original record INCLUDING the data from the subform. Here is what I've done: void revise(int ID) { dat = Quote [ID == input.ID.toLong()]; subform = dat.Items; name = dat.Customer;
I need to update a sub-form with information already preloaded - how can I do that.
Hello everybody, I am trying to create a form of sales order but that contains all the products listed in the products database to enter quantities and calculate the sales order amount. I am trying to use sub-forms to do it, but I don´t know how to display (one per row) all the products available in my catalogue. Anny suggestion?
How do I get rid of these items on my application?
Hi there - just wondering how I change my application HomeScreen - see attached picture I have decided just for ease of use to use a stateless form instead of an HTML generated view Thank you Jonathan
form embed in website
Dear Team Zoho creator is first full feature web form builder available i m not sure how many free users you have , recently you have changed the option of embedding the form with login details . I would like to suggest to please allow us to embed form without login details if you like you can reduce the no of application to 2 or even 1 for the free users thanks
Allowing Users to Edit their profiles WITHOUT registering for Zoho
I am creating a Teacher Directory for our non-profit organization's website that will allow the students & families to search our directory for a teacher that meets their child's needs. But before I take the directory public online, I have discovered that there are several teachers who filled out our original form but left out several key fields (i.e. Address, etc...) I have developed an App that will (in theory) allow each teacher to view & update their own profile by way of creating one view
iFrame Video within a Form Notes Field
In a form notes field you can format text and insert images - I would like to embed a video - the reason is that I am creating a "Frontpage" for the application in a stateless form as its much easier that fiddling with HTML for me anyway! When I open the notes field to edit and switch to source, I can paste Vimeo iframe code into the field. Then, when I switch from source to a real view then the video still appears. I then save the notes field and it seems as though the iFrame tags are then stripped
basics offline options
would be possible to imagine a very basic offline version of zoho creator? in my opinion very basic means possibility to store locally added or modified data and upload them asap. conflicts can be solved manually one by one. working on windows at the very beginning also on bb iphone android in a short period. inm ready for a small mounthly investmnt for development nt in this direction assuming the option can be ready in aprox 6 mouths. thank you
comparing fields with nulls and spaces
I have a multiline field on a stateless form and on a corresponding master form. In the on load section of the stateless form I set the value of the stateless form field to the value from the master form field. On submit I send an email if the information was changed. The problem is the email is triggered because the master field has a value of null and the stateless field has a value of blank. Is there a better way to compare the two fields so that nulls and spaces\blanks are treated the same?
Links on Sections
I have rearranged links in the sections i want, the question is how can I hide some sections from some users when they log in?can I do that dynamically or there is another workaround?
Change or Allow Customization of HTML header Information
This may appear overly critical, but I'd like to know if the header info can be changed or enabled for customization. Example, in my app when viewing a page, the browser tab shows this because the html for the page has this Additionally, I'm using a web-service to post to Facebook as a linked post. Here's how it looks: Request: I'd like the "Zoho Creator" text removed from the header on all pages, or changed to the application name, or enabled for customization per application. Cheers, John Whitney
Email validation
I want to create a script on user inpit for email field to check if the user entered email id belongs to particular domain e.g. i only want to accept user having gmail id , i.e anyone other than user with gmail id should get error message if ( imput.email_id ! = "what shall i put here @gmail.com { alert( " Please enter your gmail id") } thank you for your help
Cannot Create Reports
As per other users, I am using a free account as a proof of concept for my organisation, but when I try to create a report I get the message that my account type is limited to 2 reports and I have 0. The fix has been to update the reports count for other users. Please fix my account as well. Thanks in advance
Formula Fields Not Updating
I use a lot of formula fields for simple things like displaying full names of a contact or creating a URL link to a details HTML page. Quite often the formula result does not update or gets somehow corrupted... This has been happening for a long time but I'm only now getting around to reporting the issue... Simple example. 'Admin' Application, 'Contact' Form, 'NameEmail' field has formula = First_Name + " " + Last_Name + " - " + Email Right now, the majority of my contacts are displaying first and
Populating fields with data from related different forms
OK Here is an issue that I have tried to simplify: My application has 2 forms MAIN DATA MAIN which has 2 fields MainSalesPerson - LOOKUP (linked to DataSalesPerson). MainEmail - Fetch data from the DATA FORM DATA which has 2 fields DataSalesPerson - TEXT INPUT DataEmail - TEXT INPUT In MAIN, on user selection of MainSalesPerson, I want to fetch the corresponding email from the DATA form field DataEmail and display it in the MAIN Form field - "MainEmail". I cannot seem to understand how to get this
Update a field in one form when field is changed in another form
I have two forms one called application the other enrollment Both forms have a field labeled status I want the status field in the application form updated when the status field in the enrollment from changes I do not to open the application record in order to have the field update Any ideas
Posting data from Zoho to REST Api
I am trying to post data from a Zoho form to an API through XML so that I can push a list of updated records upon each add or edit to the Canvas API. This should be really easy, but I am not grasping the concepts of the built in function for HTTP requests. Could someone help with some sample code? Look at the reference data API starting on page 12 of this document: http://www.gocanvas.com/content/images/file-uploads/Canvas_Webservices_-_version_1-3-0.pdf Trying to do something like this in deluge
How to get the current date
How to get the current date
Merchant Services
We are looking to Zoho as a possible solution for the database needs of a small cell phone repair company. One of our needs is Merchant Services. We understand that Zoho added a Paypal option a year ago. Does the customer have to have a Paypal account? Or will he or she be able to pay using an American Express? Please let us know. Thank you, Tom
Can you have creator return on the first character in a field
I send out emails from zoho on record updates The form includes a students first and last name I need the subject line of the email to only include first and last initial Ideas
How to enable and disbale the tabs based on some condition
How to enable and disbale the tabs based on some condition? For example iam having 4 tabs. If iam loading second tab i dont want to show the 1st,3rd & 4th tabs to the user.
problem with condition evaluation
After the last update, some of my html views generated errors. The problem is that it is a very used piece of code which was correct until last update. An example: if(recid != null && Contacts[ID == recid.tolong()].count() > 0) { // some piece of code } Iff recid is null, the code Contacts[ID == recid.tolong()].count() was no more executed . This was the behavior before the last update and it was convenient. The condition checks if the record is null and ONLY if it is not null it checks if there
Please tell me if this is possible in ZOHO.
I am going to build an audit form that will submit a bunch of building data into a database. Example data: Building Name Building Address Owner Name Existing Measure A - Potential Measure A Existing Measure B - Potential Measure B I'm then going to submit this data into a database. Here's where it gets tricky: A) I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).
Error Occurred While on Success Script
Users are reporting this error on one of our embedded forms [Note to support: it's the "Hell's Kitchen" form]. The rest of the error message isn't very helpful: "We are working on giving more meaningful error messages on script failures". What are we supposed to do with that..? The user in question received this error 4 separate times, waiting 2 hours between each submission. I have enabled support edit access. We need to address this issue very urgently.
Form Schedule Did Not Run
I have a form schedule setup to send an email on a specific date (later than today). Send Queued Posts { Execute on POST_QUEUE_FORM.DELIVERY at 01:00:00 } POST_QUEUE_FORM contains a date-field DELIVERY. However, the schedule did not run recently as anticipated. I do have the frequency set to ONCE, since I only want one email sent. Am I doing something wrong? Cheers, John Whitney
String to int
I can't find out how to parse a String to an integer in the deluge scripting language. Hopefully someone out there can explain to be how this is done. Thanks
how do I get an e-mail when a field is updated?
I have a form with multiple fields. I'd like to get an e-mail anytime one or more of the fields are changed and SAVED. However, I would ALSO like the e-mail to say: 1. Which fields were updated (what they previously were and what they currently are) 2. Give me a link to that particular data-set I know how to send the e-mail on update, but I don't know how to pull out the variables that tell me the above 2 listed items. Any help? thanks! - Quan
Reset Total value on update
Hi All, My form has several fields for numeric values to be entered. At the bottom is a total field. I set an "on user input" script for each field as follows to update my overall total at the bottom: input.Total = (input.Total + input.FIELD1Value); field 2 value etc.. This works fine and when I tab out of field the total updates. BUT.. If I go back to FIELD1 and change the value it adds this new value to the total also, so my total is way off as it has not reduced the initial value. Can someone
Want to put an intput field in Views
Hello Sir, I want to put a text field, in the views. After entering the value into that text field, that corresponding record should be updated. if this is not possible, Please try to tell me any other option.
Application Database Alternatives
I would like to create an application using Creator.......my issue.....my application database will be very large.....using Creator's database could get expensive....is it possible to create a appliaction within Creator and leverage Z Reports as my database....or any suggestions.....also are there limitations using databases other than the Creator database? thank you
total of multiple forms
Hello, I have a total of 6 forms that are linked by a single registration number per group of people. Each form contains a sum of money that is tied to the registration number. How do I create a sum across multiple forms so that it gives me a grand total of how much that person has cost me (incidentals, hotel room cost, food costs, etc). Thanks
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
link between form and subform
Hi, What is the link between a form and subform? "If I embed a sub form into a main form and enter multiple records on the subform, how are these multiple records linked with the fields of the main form?" Please help. Thanks! V
How do you reference the value represented by a bidirectional field?
I'm trying to wright a custom schedule script that references the email addresses to send to, from a form where the email address is populated from a bidirectional relation. My script errors I assume because it is receiving the ID number from the bidirectional field instead of the actual email address value I have the child form display. Here is the code I'm trying to run: temp=""; for each x in CRS[Received == false] { temp = x.Report_Type; for each e in Test_Staff_Roles[Notice] {
Zoho Reports within Zoho Creator Tab
Is it possible to embed or <iframe> Zoho Reports within a Zoho Creator Application Tab? (not a report,chart or dashboard) But the ability to use the functionality of Zoho Reports within a Creator app... To give my users a more seamless experience? Both products are great....
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com . Noticeable changes: Improved Calendar view Provision to specify event/task Start and End date is supported (to be configured in design mode) Supported Week & Day in addition to Month view Refer the example view below Resize and Drag & Drop to update the event time Radio and Checkbox field can display options in multi-column layout (maximum of 3 columns) In addition to
Modify existing record and save as new record.
Is there a way of opening a record in edit mode and saving it as a new record? What I want to do is use the data from an existing record, modify it, and save it as a new record in the table. Any help would be appreciated.
Zoho Creator Payment - pass other data to PayPal?
When I use a payment form option, is there any way to pass additional fields through to PayPal besides the Item Name, Quantity, and Amount? We are trying to track all of our PayPal purchases through the use of SKU's (stock keeping units) corresponding to our internal account numbers, so I'd like to be able to pass an Item ID field through to the PayPal portal. Any way I can do that?
Next Page