Adding Sum of fields
I am trying to track some payroll information I have used drop down menus: (supervisor, driver, parts employee, Crew Member 4, Crew member 5) that, when selected, automatically input each employees wages (martha mae wages, marcia troyer wages etc) by using formula of calculating the "Clean Time" field * whatever I input for each employee hourly rate. For example, we input 1.25 in the "Clean Time" field, and drop down select "Marcia Troyer" under Supervisor field, the number 13.75 automatically shows
Returning String field to Null
Can anybody tell me how to updating a single-select picklist string field to null? This portion of my application is an html view with three embedded forms and one embedded view User Navigation From Administrator Navigation From Chart Search Form Found Charts View When the Chart Search Form is submitted, the record is saved in Zoho and the html view is refreshed with a session paramater which causes the Chart Search form to reload for Add. [There isn't anyway to get it to reload for edit and
The server encountered an unexpected condition which prevented it from fulfilling the request
I am getting the above error when i am trying to access zohocrm api through a creator application. Can anybody say why i am getting this error? I am attaching the screen-shot of the error here too. Thanks in advance for the reply.
Update Syntax
I have a look up field to a table that stores the agent name and commission rate. On returning the agent name from a drop down list id like to place the commission percentage into another field can someone point me to an example. Thanks.
Setting Value to "" in the OnLoad Portion of a Stateless Form WAS Working but Isn't Now
I have a set value script in the OnLoad trigger of a stateless form that was working last week but is not working now. I need the value of a 2 radio button field to be set to "" nothing (whatever you want to call it) so that the user must select something which futher triggers updates to dropdown list lower in the form. input.Report_Type = ""; hide Class; hide Region; hide Planting_Type; hide Report_Filter; hide plain2; Was there a change made that may have affected this recently?
Tracking
I want to track the source of a new completed form (using creator) to see if it came from google adwords. Is this possible, and if so an someone give me the steps or point me to a doc, couldnt find anything through searching. Thanks JK
Permalink of view's search result in iframe
Hi, I understand that we can pass open url commands in form submit to make then open in an iframe (when the form & iframe exist in same HTML view) - Ref http://help.creator.zoho.com/Open-URL.html However, i am trying to do a search form (stateless form) , which looks for company names that contain the search term(s). The search part if working fine. But when i try to display the search result, I am unable to use the View-Permalink of company ( separate view that has only company names, and record
Multi select names to email
I need to have a multi select box with a list of names for an email form. I would like the names to be listed as a name rather than an email address like so: Bob Frank Nancy Tom but once the form is submitted the emails would be directed to bob@domain.com frank@domain2.com nancy@domain3.com tom@domain.com The user would be able to select one or more of the names in the list to send the email to. How do I write something that can send out the email to the appropriate people that were chosen when the
Question about limits of e-mail sent in a shared applicaitons
Hi, I have question about limits of e-mail sent in a shared applicaitons: When I shared my apps to the users "toto", and in my apps i have sent 500 e-mails today (the limits of the apps), so does my friend "toto" can use this app to send also e-mail? Thanks for your help!
I'd like to be able to import from Groove Forms
I have developed some 20 internal apps for our company using Groove Forms because it was, a few years ago, the easiest way to develop shareable applications. Microsoft has failed to grasp the beauty of Groove and is now making it just an extension of SharePoint, a product I don't want to use. I have played around with Zoho Creator and am reasonably convinced it could do everything we need. I would like to migrate my apps to Zoho Creator but I dread the thought of re-creating so many forms and
recurring service in zoho creator?
I have contacts all set up as database in my zoho creator. I need to set recurring appointments for our weekly, every other week, and every four week clients. How can I do this? I want the view to be calendar view (which it is already, but not sure how to create recurring services for each client). SOS
Self-Customized Layout
Hello; I love Creator to bits, I just started using it lastnight, I just have one, take note ONE problem: As this is a Database, I need to customize a view with personal layout preferences so that I can print a form based on Relational data. My application needs to have a "Order Form" and an "Invoice Form" with a specific layout as per the Invoices that the company uses now. How do I do this pleeeease, or is there a 3rd party tool that can access the data and records on ZOHO, then create a "Report"
date stamp records
How do I add a Date stamp to data entered from a web form? I want to have it so the date that the web form is filled out gets recorded in the database.
Quickbooks Integration
When will quickbooks integration be available for zoho creator?
create a PDF of completed form
Hi; i'm not a developer but i have been able to create an application that suits my needs, just have one last problem. i have created a stateless form that auto-populates data from another record within the application, but is there a way to print the form once the user has completed it? ...or even better yet, to create a pdf of the form, say by clicking one of the form buttons at bottom of form? alternatively i could redesign the form so that it is not stateless if that makes it easier. mike
Url Submit Form Questions
I want all links to show up in a new page. How do I set that to be an option that is automatically checked and cannot be changed? Also, can I propagate the "Link Name" field automatically and make that unchangeable as well? I would like it to say Visit Our Website by default.
current date and time
Hi. I am pretty new to this. I am exploring as much as i can and I am very bad in programming. I am trying to create a form whereby the first line on the form needs to indicate the current date or time as long a user wants to enter a field. But I am not sure to go about doin' that? any experts here could lend me a hand?
Count laboral days
Hi, I want to know how can I count laboral days between two data. Any Idea? Sergio Galiano
Labels for Subtotals & Grand Totals in View...
I've enabled the sum function for a numeric field, and I get subtotals and grand totals for that field in the view. The downside is that my users might not readily know what these fields are. Can I add a label in the view to define them? I've attached a screenshot for reference.
Dynamical Line-Item Form
Dear all, I would like to create a typical form-document in ZOHO Creator. With a Header, table and footer. For example a Sales Order Document: User can enter the Customer information, Dates, ... on the Document header. Then user wants to select the Products in the Table area. The table area should add more and more lines dynamically, as more lines the user would enter. For example the first line will be displayed per default with columns like Product Code, Product Name, Quantity, Price, Tax, Discount,
Filters for Dynamic Picklists
I've created a dynamic picklist using script. When I attempted to filter a view by that field, I noticed that there were no options (since the picklist is populated from another form). I thought then I might have to use a lookup field (because I tested it and noticed that the field values were available in the filter) but then noticed from the help topcics : Note: You cannot set the criteria expression based on field values in the current form. The lookup field could not meet my requirements because
Using "if" statement if nothing is selected in multi select box
I would like to send an email only if at least one item is selected in a multi select box. However, I am not sure how to do this. I've tried (see highlighted text): if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != null)) and if ((((input.SenttoEncode != "") && (input.STPandDolby == "No")) && (input.Force_Eval_Email == "No")) && (input.Videographer != "")) but neither of these work. What is the
Subject of your feedback
Hi - Is there any way to script something to delete old records (say, records prior to 1 year from today). Thanks Alfio
Scheduler Workaround: SOLVED
I know the ZC team is working on the Scheduler (to be released in June I guess). However, I have been toying with a workaround using free serveries that send scheduled emails. The idea being to kick-off some code when the email is received. My question is, how to I get this to work with a private application? I get this result: "You are not authorized to add record"
Hitting 2 birds with one stone
Hello friends, Is it possible to fill in 2 fields at once using lookup in Creator? My database has 2 forms: sales report and tax rates. From the tax rates forms I have 2 fields: COUNTY and TAX RATE. Both these fields are also in the sales report form. Instead of using the lookup object for both, can I not just select the COUNTY and have the corresponding TAX RATE automatically filled in? Or do I need to write a script? Thanks!
Sequential Dropdowns
Hi I am trying to alter the options available in a dropdown field based on the values entered in 2 preceding dropdowns. So, for example dropdown 1 allows the choices "core", "higher" and "advanced", dropdown 2 has a choice from 10 values (e.g. general, acutely ill, cardiothoracic) and then dropdown 3's list depends on the combination of values from dropdowns 1 and 2. That means Core-->General-->dropdown 3 choices will be different from Higher-->General-->dropdown 3 choices. Can you give me any guidance
Change Email
Hi, How can I change Zoho.UserID (Email), in order to send emails using other email (not the one in my account?) If necessary, how can I change my account email? Thanks Nuno nunoalexandre
Reset radio button on edit record?
Is it possible to reset a radio button to a certain value when I edit a record? I have a radio button with the simple options of "Yes" or "No". How can I make it so that when I click "Yes" and then submit that the next time I edit that record the radio button goes back to "No" automatically? Thanks in advance for any help
How do I assign an image to image upload field?
I have an image upload field in my form. The image upload is optional - but I want to provide a default image for those cases when the user does not upload an image. Sorta like a "no picture available" type graphic which gets stored with the record. How can I get the form to pick up my "no pic avail" image into the image upload field? And where would I store the image so that the script can access the image?
For each record criteria & formula fields
I have two forms (A & B). Form A has the following fields: Lot Description formula field combining the two fields Lot_Desc. Decision box Form B has a lookup to form A using the Lot_Desc field. In a script on Form A I am using a For Each Record in Form B with criteria to match on Lot_Desc. No records match. However if I change the lookup to use just the Lot field the criteria works correctly. Are formula fields not allowed in the criteria? for each x in Batch [Lot == input.Lot] works for each x
Google Calendar iCal feed setup question
I am trying to add a Zoho Creator ical URL to Google Calendar without success. In Google Calendar I go to Add/Add by URL then paste in the following ical URL and select 'Add Calendar'. I get the following error...."Failed to add imported calendar at https://creatorexport.zoho......... for user@gmail.com" I followed the ical feed steps at http://help.creator.zoho.com/iCal-Feed.html My Zoho App is private, so I selected the link that adds in the encrypted code. I've tried two versions of the URL.
Set a variable in a FORM from a VIEW
I've figured out how to do some custom actions / functions within zoho -- but now I'm trying to figure out how to have a custom action in a VIEW populate 2 fields in a FORM. This is an application that helps us manage child sponsorships in South Africa, Moldova, and Brazil. We're trying to add a little more functionality -- and have photos, ages and first names available for people to look through as they are setting up a new sponsorship. User Action would be like this: User goes to VIEW - which
script for returning values in a Multi-Select field
Dear Friends: I'm a newbie to databases and scripting, so I need a very basic helping hand. I've created a database to collect data about metrical events that occur in lines of poetry. The fields I've created, together with abbreviations I use for the individual events, are these: Lines (Single-Line) Properties (Multi-Select) Penthemimeral (Single-Line) (pc) Hepthemimeral (Single-Line) (hc) Bucolic Diaeresis (Single-Line) (bd) Homodyne in 4 (Single-Line) (hm4) Heterodyne in 4 (Single-Line) (ht4)
In a view, how to prompt for text and then set specific fields to that value for all selected records
Subject pretty much describes it.... Want to have a custom action which prompts for some text, which then sets a specific field of all selected records to that text. Any pointers anyone? Thanks in advance
Syntax error: function doaction(recType)
I have a form that has three fields: one drop-down, one text entry, and one checkbox. I have this code in the checkbox, on user input: if(input.Tickybox == null) { enable DropdownField; disable TextentryField; TextentryField=""; } else { disable DropdownField; enable TextentryField; DropdownField="-Select-"; }When I go to the form, I can check the box once and have it work as it should, but subsequent checkings don't work. In Firefox's error console, this comes up:
Query a XLS table
I'm new to Zoho creator and I wonder if it's possible/where to find a working example of what I plan to do. I basically want to create a status checking application where I will import an XLS sheet that contains email, password, status and other info. The users will be present with a form that contains email and password field. When submit, it will query the table and depends on the value of the Status column, will return different custom message. I will update the XLS offsite and upload the XLS
Can I create an online calculator for my website?
Hi, I am a wedding photographer and I am considering building an online calculator which will cost up wedding packages for prospective clients online. They would enter information from dropdown lists like year and month of wedding, then choose which services they want with radio buttons and checkboxes - this will then calculate a price for their package. They should be able to print that quote out - and I should get a copy of it emailed to me. However when the page gets refreshed it should go back
Ability to perform an action at a future date
hi im new to creator, so this might be a stupid question, but an answer to this might get me to work on creator. you could even point me to the right direction i need to create a very simple tool where we feed in a future date and time with the comment and the comment goes to a web URL on that date and time. basically like a reminder thing. is this possible with creator. thanks in advance
How can I sum the field of all the entries of one form?
How can I sum the field of all the entries of one form and show it in a field of another form like a "formula field" for example. I have two forms, one with people and another one with bills. The bills form have also one field with the price of the bil, and another field with the name of the person ( of the person form). I wanna do a form that shows me the sum of all the prices of the bills that have one person, for example. is the solution a formula like "count"?? Which formula? Who it works? Thanks
Opening pop-up views with multiple criteria
I have created a relatively easy function to open up a pop-up view: openUrl("#View:vwLangAvail?cboLanguage=" + input.Language + "", "popup window", "height=100,width=100"); Is there an easy way to have the view open with multiple languages selected? Thanks, Leo
Next Page