Expense Tracker Question
I have my layout set up with the Tabbed Pane Left. I have added a few new Reports (Expense Report by Employee) etc. On the left pane it shows them at the bottom. What "View" do I need to modify or change to update the way Left Pane list order? Update: Nevermind... I found it.
In a form, custom function to recalculate a number of fields on update of multiple other fields
I have a form which contains 2 fields (disabled from entry) that I want to update with a recalcuation based on updates being done to anyone of 4 other fields on that same form. Have tried a number of different way, but it seems the only way is to put the code against the 'On Update' action for all of the 4 dependant fields? Thanks in advance
how to set the url field to open in a new window as default?
Hi, in my appliclation i have a couple of url fields, when the users add a record on the list i dont want to let them coose the target of the link, i need the target set as new window as default, there is anyway to set this up? The problem basicaly, is the kind of users i will have, the 99% of them wont have any idea about the new window / same window option, and if they by mystake choose same window, i will have a visual problem because my application will be embeded on another website, so i just
Formula IF or Case
I need a formula that looks at a numerical field and returns a text result. if (FIELD_A),'1','one' if (FIELD_A),'2','two' if (FIELD_A),'3','three' Any help would be appreciated tom
Pass data from form A to form B
I have a form called "Add Showing" (form A) When the form is submitted, an "on success" script autosends an email to a recipient specified in the form. In the body of the email is a link for a form entitled "Feedback Survey" (form B). Both of these forms have a field entitled "Property Address" When the email recipient clicks on the link to open form B i would like the Property Address data from form A to populate the Property Address field on form B. Is this possible? P.S. right now i am sending
Help Plez before I Jump
Hi Anyone Just made a form with a calendar and e mail return for my site. I am now lost, it looks ok, but how do i know it works?, how do i get the code to put it into my site. Been at this for 3 days now, love the form but Im totally lost now, can anyone help as I’m quite new to this. Plz help me Regards Euni
Make form public but view private?
I just created an application to prescreen job applicants. I want to send them to the form without having to sign up for anything, but keep the view hidden from them. So basically the form should be public for anyone who finds that URL to be able to submit, but the view would be limited to users. How do I do that?
Changing the value of zoho.loginuser
For testing purposes, it would be great if a developer of an app could change the value of zoho.loginuser. I've written an app that behaves differently depending upon who the user is. For testing, I have to login as each person to verify their roles. It would be better if I could simply change the value of zoho.loginuser and effectively become that other user without logging out and back in so frequently.
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
Next Page