Not Null question
what am i doing wrong here? I get an error on the if statement. Help if(input.Lineman_6 != null) insert into Employee_Time [ Added_User = zoho.loginuser Date_Field = input.Date_Field Name = input.Lineman_6 Overtime_Hours = input.Overtime_Hours Regular_Hours = input.Regular_Hours ]
Zoho very slow??
Is anyone else having problems with Zoho Creator going very slow? All forms & views, submitting, etc. Everything is slow to the point that it hinders our business greatly. It might speed up for a little while, but overall has been very slow for the last week. Anyone else? Support is not being very helpful. I am already researching alternatives to Zoho but the transition would take very long.
Lookup field refresh
Hello, I have a form which uses lookup fields to gather records from a given (editable) date range. However, I find that when the date range is automatically updated (i.e., I change the month string to "November", which causes a function to execute that updates the 'Report_Start_Date' and 'Report_End_Date' to the first & last of the month), the lookup field doesn't update to show records in the new date range. However, if the date range is updated manually (i.e., I click on the 'Report_Start_Date'
What happen to the Number function reference link?
Folks, The Deluge Script Reference page for Number Function under the Built-In function page is missing. It only has Math function listed now. I am talking about the page that shows functions such as toLong(), etc. That page is missing in the Reference -> Built-in Function section. It uses to call "Number Functions". So can the Zoho team bring it back please? Thanks.
How to add a sublist in a subform based on other variables selected in the subform?
Hi , I am a new user to Zoho, and non programmer. So far so good, and it is intuitive. However: How do I create a sublist in a "sub form" , based on whether certain variables in other parts of the sub form are selected? The sublist I'm trying to use is similar to a multi-select list in forms . regards Stewart
how to add search button in the view header?
how to add search button in the view header?
how to add a search button in the view header
Could you please clarify how to add a search button in the view header? I appreciate if you can give more details and step introduction.
How to add search button in the view header?
Could you please clarify how to add a search button in the view header? I appreciate if you can give more details and step introduction. Thanks
Lookup Filter in subform
Hi, I am working on a fairly basic form for placing orders. There is a lookup field from which the client can be selected, and a subform containing order items. As the products which can be ordered are unique to each client, what I am trying to do is to have the "Product" lookup fields within the subform only display products from the selected client. To achieve these I have added a client lookup field in the subform, and when the client is selected manually the product filter works as expected,
Fetch and update
Would like to select data in a look up field and have it populate data in another field in the same form. Example Select an individuals name via look up in form2 and have it fetch the data from pay rate in form1 and populate pay rate in form2.
Subscription problems!!
Hi, I've been subscribed to the Professional Edition for over a year now, never with any problems. But today as I wanted to create another Application, I get an error message which reads: "You have reached the limit of 10 apps in your free edition, please upgrade." Please fix this. Carsten Eckelmann Director, TripleAcs Expert Cloud Solutions http://tripleacs.com
Adding form data via e-mail in user-defined format
I am reading this documentation, https://www.zoho.com/creator/help/forms/email-data.html and I want to add records via e-mail. "Adding form data via e-mail in user-defined format" works fine as described, but is there any way to add more values from the email? Subject, Content, and Attachment are no enough. In our case, I want to store Data/Time, From and To address. It should be possible, but the documentation does not explain further. Any idea? My goal is to archive all incoming messages in one
Email data in user-defined format.
I want unidentified users to be able to email stuff to my database in user-defined format - and it is working fine, to a point. I can extract the subject line and body text using ZC_Subject and ZC_Content. But I don't understand how I can find out who sent me the data. I hoped I might be able to use ZC_From, but it didn't collect anything. Can this be done please?
Continue on next line: what is the symbol?
If a line of my code is very long (such as in a lengthy alert), is there a character I can use to break the command among two or more lines? (Note: I don't mean newline in the alert. That is \n.)
multi row reports
Is there a simple way to generate multi-row reports from a View? When I try to print a report from a view all the data from each record is printed on one row. Is there a way to get each record to print on two or three rows so the report will print on Letter size paper?
Users cannot edit records
I am a newbe with Zoho but have created an application for tracking care issues at our church. I have 5 users who are able to input data, but are not able to edit that data or anyone else's data. Anyone have any ideas? Thanks, Dick Bickings
Creator Application, Calendar view does not work correctly in embed
When viewed with the Creator App the calendar view shows arrows to go forward and back in months or years. I have embedded the report as a calendar view but the forward and back arrows do not display, I have no way to navigate from the current month. How do I make the arrows appear in an embedded view? Thank you
Two column layout
Hi All, I would like to have two dropdown lists on the same line, ie hours and minutes. I have never tried the two column layout before but if I select this option and add a field, the system places it right at the top of the form in the second column and not next to the field required. What am I not understanding here please? Many thanks
target="_blank" issue
Hi Folks, There appears to be a problem in Add Notes. To allow a user to get the geographical coordinates of a location, in my application I have a Note field that contains a Google Maps image and the following code: <a href="https://maps.google.co.nz/?ll=-41.343825,174.089355&spn=14.262413,33.815918&t=m&z=6" target="_blank"><img src="http://www.precisionhelicopters.com/images/site/googlemaps1.png"></a> Until recently, a click on the image nicely opened Google Maps in another browser tab, but now
Unable to Customize Embedded Forms
I have a set of forms which are colour coded for specific teams to complete. I have therefore been trying to format the Header & Footer BG colour setting. I have tried this several times with different forms, but the setting is not saving on the form. When I got back into the form, the settings have reset back to defaults. I cannot see any way of saving these changes.
does zoho creator compatible with visual basic?
because now i'm build a system that need to connect with online database...hope anyone can answer me :) Thank you
Summary View Save to Excel
Is it possible to save an individual summary view to excel file? We're expecting an individual output like this Thanks!
Is it possible to concatenate parameteres in iCal URL?
Hello, I have successfully made view data available with iCal. For example with these parameters: DTSTART=datumtijdaanvang&DESCRIPTION=Docent&SUMMARY=Cursustitel&LOCATION=Locatie&DTEND=datumtijdeinde What I would like to do is use two fields from my view to be combined as the iCal DESCRIPTION For example: DESCRIPTION=Docent+Cursustitel But unfortunately combining parameters with this syntax doesn't work. As a workaround I now have an extra field in my view that I automatically update when data is
How to copy data from text field to lookup field?
I built a new form in Creator with a State lookup field which relates to a State table that contains all the US state codes. My problem is that the contact data I need to import from Excel has the State data as a text field so when I went to import the data the records fails on a data mismatch regarding the state field. After reviewing other similar questions I created another field to store the text state code value but I can't figure out how I can bulk update the real state code field (that's
Help with Dynamic Picklists in Subforms
I have a form that are people that attend my class, for each person I have a first name and a last name field. On a seperate form I have a Class, each class I teach has a specific record. I am trying to create a roster for my classes. I have built a form for this and have a subform for adding the students. I would like to pick the last name first for a pick list, then have the options for first name filtered to show only records with that last name. I can get the last name populating correctly
Hiding the red asterisk in a mandatory field
Does anyone know how I can hide the red asterisk in a form field that has been made mandatory? All fields are mandatory in my forms. That's how I want them. I just don't want the red asterisk to appear. Thank you in advance to anyone who answers.
ZOHO Layout
Hey guys. Im new here. I was just wondering. Can the layout be change? I mean the interface layout.
Problem displaying images in a report on Firefox on Mac
Hi, as mentioned in the title images are not displayed in the report of a form under Mac OSX using firefox. It is working on Windows with Firefox, IE and Chrome and on OSX with Chrome but not with Firefox. I'll attach Screenshots for you. Can you help me with that? Thanks in advance!
Calendar embed view does not have forward and back or month name
I embedded a calendar view and allowed editing and adding events. In the embed view the top ribbon is blank, there is no arrows to go forward and back through months and the month name does not appear. I can't find any options to set this. How can I make the embed view look lthe same as the view within the app? Thank you
Filter Picklist by shared status
Does anyone know of a way to filter a name picklist to show only those people you have shared access to your application? To clarify, I have a form, emp_list, which contains all of the employees for our company with their correponding email address, which is their zoho.loginuserid. I would like to filter the employye list in the lookup field so that only users that are active in the application show up. Thanks
Clearing Picklist Record On Load
I would like to clear a static picklist record on load. I want the record to be lose whatever it had before and have no selections. This seems simple, but I have not come across a solution that works thus far.
Donation wish list
Amici, I'd like to create an online donation list in a sort of dynamic form. I"d like to create it somewhat like a wedding gift registry site: There is a whole list of objects needed by the organization, let's say Teddy Bear, Car, Lego... Then people start to register and choose one (or several) of these options. Now anytime someone ticks a checkbox of an in-kind donation (e.g. Teddy Bear) it should be hidden for the next person checking the form. So the next person could only select from the rest
Check box automatic populating issue
Hello I have a check box in the first and second view of my database. With existing records if I uncheck the box in the first view it does not reflect in the second view. Please can you advise what deluge script I should use? I’ve used a “ input.Commercial = main.Commercial; ” script which works with new records, but if I uncheck the box in the new record in the first view it still does not reflect in the second view. This is also the same with date fields. Thank you very much.
HELP Adding Delete button in a public FORM
Hello and thanks in advance if someone can help me. I work in a University and I often prepare public forms to permit students to book in activities. I need to add a delete button to allow students (If the student change idea) to delete from a subscription. Is it possible and could you explain me how to do it ? Thank you very much for an ipotetic solution. Diego
How can I add a DELETE Button in a public form ?
Hello and thanks in advance if someone can help me. I work in a University and I often prepare public forms to permit students to book in activities. I need to add a delete button to allow students (If the student change idea) to delete from a subscription. Is it possible ? Thank you very much for an ipotetic solution. Diego
Issues today
Is anyone else having issues with creator today? I have functions that were working this morning, that no longer work. I am having issues with reports pulling up and running after I have created them, and shared users can't pull up new reports. I have one user that can't access any pivot table reports, lists are okay (this is about two weeks old at this point).
Two small animated semi-circular arrows appear after updating a field by script. ??
If I check user input (On User input), format it, and then write the formatted data back to the same field, two small animated semi-circular arrows appear to the right of the field and the field contents persist into the next record. I can't find any reference to this in the documentation. Can anyone help/explain?
URL view criteria involving lookup fields
I have a view that contains a lookup. The lookup refers to an ID in another table(form). I'm trying to open the view with criteria which only displays records where the lookup has a certain value (an ID): E.g. openUrl("...#View:MyView?MyLookupField=1234567890); The functionality based url criteria seem to work fine for non-lookup fields. Can anyone confirm if this works at all with lookup fields? If so, what is the trick to work. Thank you
How to delete applications?
I've create two dummy apps in my account for evaluation purposes. Now I've got paid subscription and I'd like to delete those 2 apps and create a fresh customer facing app from scratch. How do I delete the exiting apps in my account? Thanks, Vijaya
Indentation
There has been some discussion in this forum about the editor/compiler and indentation. Some people don't like automatic indentation. My suggestion is this: whatever automatic or non-automatic indentation is provided, please at least leave my indentation alone! Yesterday I spent something over an hour going through a long script adding comments and indenting sections of it to make it more readable, just like any good code does. I saved it, but then when I came back to it all my careful indentation
Next Page