ability to reorder the filters
Could you please add the ability to order/reorder filters either in Live mode or GUI mode....preferrable in Live mode. For example, I want my 'Status' and 'Priority' filters at the top of the list. My 'Status' filter only includes 'open' and 'closed'. However, my 'Company' filter contains hundreds of companies. Therefore I have to scroll through hundreds of company names to get to my 'Status' and 'Priority' filters to select them. And typing the name of the filter doesn't always work because, for
Confirmation Page Link
Where do I put the confirmation link so that after my form is completed, it takes them to a confirmation page?
How do I create a link to associated records filtered by the record?
I have a form where I create projects. I have an form where I create messages, some of which are associate with some of those Projects. In a Projects View, I would like to have a hyperlink to the Messages that are associated to it. How would I do this?
HTTP Status 401 - Unauthorized access
Hi, I can't access Zoho Creator, I got this message : Unauthorized access and this status HTTP Status 401. Thanks for your help, Bruno
Custom function not pulling individual record
I got this to work on a separate section of my application but can't get it to work here. It's pulling all the records, not just the individual record matching the ID. Situation: I have an Equipment form and in that form is an Invoice_Number lookup field. I'm trying to create a custom button that when clicked will pull up the invoice record based on the Invoice_Number field. I used the same script for a maintenance custom button for the equipment form and that works fine. However, when I modified
On User Input script executed at On Update
Initially I thought that the problem is related to a single application belonging to one of my clients, I reported it to support a few days ago, but it seems that it was not even understood. I discovered that the problem is in fact a generic one, not at the application level, probably introduced after a recent update. The fact is for some fields, I did not test for all kinds of fields, On User Input is executed also at On Update for a field. See a sample application as example (it is also shared
Criteria : Since last connection
Good evening everybody, I apologize in advance if the question has already been asked... I'm triying to have a different view for each user, in which will appear the contacts entered since the last connection of the user. Explanations and details: My contacts have a State field (NY, NJ, CA...). I have one user for one state. Each user can add contact for any state, but is allowed to view contact only for his own state. For each user I want to have: - a view with all the contacts from
Changing field from single line to multi line
I have a form with a single line field which has been populated with many records. I'd like to change this field to multi line but when I do this Zoho reports that I'll loose all the previous data entered as single line. Is there anyway to keep the old data and change it to multi line? thanks
Script to Send Email if Value is Null for Field, Date Ranges, Batches (oh, my)
I did a quick search in the forum for this topic but came up empty. Please redirect me if this thread exists. I use Zoho as a tracking mechanism for international shipments. A lot of the tracking has to do with dates - e.g. ETA west coast, ETA final destination, ETA delivery, etc. What is the syntax for the null "if ETA west coast = null" send email? Does the "null" in the code need to vary depending on whether the field is a string, numeral, multi-select, etc.? Another question I have is that
Colour Highlighting
Hi there! Its been a good experience using Zoho Creator. I'm working on a task report. Where I have different categories I would like to colour code my data for ex: Those rows of records which have Status as Pending, I would like to colour code them some colour. Please help ASAP Thanks
A list of reusable functions!!!
I was wondering if there is a list of the sample applications to show how certain user created Functions work? If not I think it would be a really good idea to have a list of Functions with a link to the sample app which uses the function. Maybe a Sticky Post? Just an idea!!! Damien.
export parcel label from form data
I have put a form on my website using zoho creator, into which customers can enter data. Now I would like to export this data to a custom parcel label to print out and send using snail mail, displaying for instance: ***************************************** Parcel Label Customer: Harry Potter Hogwards This is my autograph: _____________________________ ***************************************** The cursive entries will then change per customer. I've just started using Zoho, and I have looked around
How to get monthly calendarview of sessions
I have a table with sessions. Each session has start end enddate with about 3 days long sessions. How to get a monthly calendar view of this sessions as html-site? What about using Google-Calendar? Ralf...
How do I create a view :One to many relationship with nothing on the "many" side
How would create a list (view) of one to many relationships where "the one " exists but there is no matching "many"? An example of what I am trying to ask ( but doing poorly ) would be to create a view that shows all projects where there are no tasks created. In this example, the tasks table ( form ) would hold a field for projectID which would hold the relationship. thanks in advance
Using checkboxes or multiselect with import fields
I am trying to create a lookup formula that aligns with input fields within my form (see example: https://help.zoho.com/portal/en/community/topic/can-forms-do-nested-lookups). It would be like completing this example, but trying to allow for selection of multiple cities and/or states. I can designate the column as 'checkbox' or 'multiselect' after I make it an import field, but am not seeing this when I got to access my application. Any ideas?
Has Daluge Script compiler changed?
Hi, appreciated ZC team, Until now, this code without first statement did not compile, and now it's possible and necessary without first statement to work: records = MyForm[ID == 0]; if(someCondition){ records = MyForm[Field == "Value1"]; }else{ records = MyForm[Field == "Value2"]; } for each record in records{ doSomethingWith(record); }Have there been changes in the core programming? This change affects me in several HTML views.
How to lookup values for preset or viewonly
I have a form CourseType where every coursetype is explaind with name, duration, price and so on. At a form "Courses" i have a LookUp for [coursetype].[Name] and [trainer].[name]. I like to have a field [duration] which should display (on editable) the value of the matching [coursetype].[duration] of selected coursetype and a field [price] which should preset (and editable) with the value of [coursetype].[price] of selected coursetype. Any hint how to do? Thank you Ralf...
Both the expression should have same datatype
I'm getting the following error when using a conditional statement in a formula field: Error in statement at line number 0 Both the expression should have same datatype Here is my code: IF(input.Spend1>0,0,input.Spend1) What am I doing wrong?
How do I get the information I created in Zoho Creator to automatically upload to Zoho recruit.
I am a paid subscriber to Zoho Recruit and I am trying the Zoho Creator free version. I would like to create an application in ZohoCreator, post to my website and have the data automatically upload to Zoho Recruit. Can someone please help me with this? Jason
Help ICal Feed Works for Zoho Cal, but not for Google Calendar
https://creatorexport.zoho.com/rrsaddleclub/test/ical/google_calendar_feed/**********/DTSTART=real_zoho_start_date_time&DTEND=real_end_time_date&SUMMARY=First_Last_Name&DESCRIPTION=Riders_Names_Ages_Weights&ZC_FULL_DAY_EVENT_VAR=ALL_DAY Yes the access by I cal is turned ON I have just hid the access code to limit access on this forum This worked for Zoho Cal just fine, but I need to get Appts to go to Google calendar for access by android Suggestions?
Collecting ZOHO Signed-in User Names
ZOHO Creator team, I recall plans being discussed to disable our ability to collect emails and user-names for people signed-in to our applications (private, public, or mixed private-public?). Please let the community know if this is still the plan and when can we expect it. Thanks, John M. Whitney
How fill Field with Average of 5 Fields in Form
I have a form with 5 values each between null or 1 to 9. Now i neet a dynamic field with average of the fields with a value (non NULL). Any hint? Ralf...
Special character problem when switching between Script Builder and Free Flow Scripting
Dear ZOHO, In an html view, I want to be able to display the text with HTML codes etc. I'm building a view for this. I have two problems. 1 When I switch between Script Builder and Free Flow Scripting, special ASCII codes get interpreted into the (finally) intended character. This is very annoying when developing. Why can the code not be exactly kept. This is an example of code that gets flattened. Before: Stem = (r.Stimulus_RT).replaceAll("<","<"); Stem = Stem.replaceAll(">",">"); After Stem
Linked forms: Can a lookup field picklist be set to display only un-picked records?
I so far have not discovered an indication for a linked lookup field between two forms, for example, from a child form "B" to a parent form "A" to display only un-picked records to link to. The relation is one-to-one in this example. Can the lookup field and displayed picklist be set to only display unpicked linked records? Many thanks.
Criteria area is hidden on choosing "deselect" twice.
I'm using MSIE8 on Windows 7 64-bit. Steps: Navigate to the user input scripting section of a field. Make sure Script Builder is displayed. Drag "deselect" over. Select the "DeSelect All" option. Select a field, obviously. Click "Done". Drag "deselect" over again. Bug: The "DeSelect" option is selected by default, which is fine. However, the criteria area is hidden. Selecting "DeSelect All" then "DeSelect" redisplays it. But, a bug is a bug, you know. MSIE8 is apparently fundamentally incapable
The deselectAll function has (<value>) in it, and I can't save the script.
Steps: Navigate to the user input scripting section of a field. Make sure Script Builder is displayed. Drag "deselect" over. Select the "DeSelect All" option. Select a field, obviously. Click "Done". Bug: The function is inserted as: FieldName.deselectAll(<value>); When I click "Save Script", it errors out at that line.
Grid View option suddenly dissapeared
Hi, I have a view that I have always (Past 1.5 years) had the option to switch to grid view on, and it has always worked perfectly. This morning I went in to do my regular editing, and grid view is no longer available. I see something in the forums about grid not being available if there are any client side deluge scripts on the associated form. I have various scripts on my form, but have always been able to use grid view. If this is now going to be disabled, this will pretty much completely
Zoho Creator REST API: JSON result string formatting?
Hi there, I'm new to Zoho Creator and I may be about to ask an elementary question. I am using the REST API to display some view output in a web application. But when I make an API request in this format: http://creator.zoho.com/api/json/<app_name>/view/<view_name>/apikey=<api_key>&ticket=<ticket> The resulting string I get starts wtih something like 'var zoho1234567view2 = ' and ends with a semicolon, meaning I have to do some string parsing before I can run json_decode() against it. Am I trying
How to loop a number of variables one by one with the split added to a list？
Hi How to loop a number of variables one by one with the split added to a list？ do you have any function sample for take a number convert English words like : ($1,234.50 convert to One Thousands and Two Hundred and Thirty-Four and Fifty Cents the “for each <element> in <list>” can do criteria？ Thanks Stanley Guo
Dynamic form field generation
I need to create survey forms that allow users to add and fill out as many of a particular field as necessary. For example, I have users who need to enter information for each property that they own. Users all have varying numbers of properties. I would like to the user to start the form with one "Property" fill-in and then have a button below that which says something like "Add another property." When clicked, this button dynamically generates another property field on the page. I know there is
Number to Text converting function!!!
I have a client who would like to display in words the number entered, in portuguese. This could possibly be written in a function. Anyone have any examples of one? Thanks, Damien.
Datatype Error Driving Me Nuts!
Hello. I'm brand new to Zoho and Creator, so forgive me. I'm attempting to port over an excel spreadsheet into a Zoho Creator application. In setting up my form, I'm attempting to calculate a value based on two other values in my form. Paid_Miles -> Number, Required, default value = 0 Actual_Miles -> Number, Required, default value = 0 Variance -> Formula Here's my formula: if((Actual_Miles > 0),((100 - (100 * (Paid_Miles / Actual_Miles))) / 100),0) This is supposed to check if Actual_Miles is zero
How to Use Formula on Another Formula-derived Field
I'm trying to calculate a value based on another calculation. Example: Pay1 + Pay2 = Total Pay, where, Pay1 and Pay2 are fields in the form and Total Pay is a formula field. Total_Pay / Hours = Wages, where Total_Pay is the formula field above and Wages is another field. When I attempt this, I am given an error saying the variable Total_Pay is undefined. What is the newb doing wrong?
How do I evaluate for NULL?
I want to trigger an email alert when a record is updated and a specific dropdown is set to "-Select-". The following statement does not work: if (input.Guide == "") thanks Glen
Link in embedded form stuck in the iframe
I have a link in my embedded form that opens in the iframe of the embedded form. How do I get it open up from the browser?
What if I want to change from Zoho
I am a novice just to start. I plan on developing (with help) an online Electronic Medical Record where all information is input online from Ipad/Iphone/pc and then is stored on a fairly extensive database. I plan to use the database to extract data to autofill PDF reports and nursing evaluations then to store as permanent electronic documents that can be signed. If I use this to help develop my online forms and database will I be forever stuck with using this product or can I then move to another
HTML VIew: calendar-win2k-1.css Failed to load resource: the server responded with a status of 404 (Not Found)
I am trying to optimise the loading times in some of my HTML views and have come across an error that is not actually part of my specific HTML view but looks like it might be part of the html views in general. This is not major, but should be addressed. calendar-win2k-1.cssFailed to load resource: the server responded with a status of 404 (Not Found) - When I look at the HTML view via Chrome Developer Tools, I find that it keeps trying to load this CSS file - I had thought it was one I had linked
Getting Negative Numbers
I created a form called business plan and basically each field has a calculation in it. For example i have fields quarter 1, 2, 3 and 4. And it breaks down how much money a person has brought it for each quarter. but if i enter in data say for quarter 1 and 2, quarter 3 and 4 will have a negative 3 instead of 0. Can someone please look at my script and let me know how i can fix it. I have allowed edit access to support. Thank You
Functions are Broken
So I'm making a new function: Now I click to create it and get... OK, so I now remove the input variables and it allows me into the script editor... Next I add those variables back in... Clicking Done I get this Now I try to save my changes and see... Hummm. OK so I decide to edit the input variables again but this is displayed... Um, FAIL! comes to mind. John M. Whitney
WYSIWYG HTML Graphical Editor
I wish to create a customized view for Dashboard in HTML code. Is there a WYSIWYG graphical editor which hooks into Zoho Creator with little problems?
Next Page