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?
interface bug in drag and drop form editor (notes field)
Steps to reproduce: Drag and drop a notes field to a position between existing fields on form Format text and click done "Please wait" continuously displays until page is refreshed Note field either does not appear, or appears in the wrong place after the page is refreshed I am using the current stable release of Chrome (12.0.742.100). Anton
Is Chrome fully supported?
I am noticing that various aspects of Zoho Creator are a bit 'flaky'. This is mainly just interface glitches and does not (mostly) lead to errors in the scripts or application itself. Is this simply because I am using Chrome and it is not yet fully supported by ZC?
Formula Field
I would like to reference a field value in another form. Is this possible ? Example: Form A field 1 Form B field (formula) Formula definition in Form B Form A(field 1) * 100
Importing Street Address (multi-line) from Excel
If I try to import a field with multi-lines from Excel, the import wizard breaks the record into two records at the carriage return. Inparticular, I'm trying to import contacts that have a Street Address field that looks something standard like this: 1420 E. Main Street, Apt. #2 Flagstaff, Arizona 86004 The field that I'm importing to is a text field with multi-line capabilities. Is there special formating that I need to import the multi-line data? Thanks, Jeff
How to make more text show up in the title of a calender entry?
It seems as though there is a 15 character limit on the length of the title that appears in a calender event. So another words if i add a new calender event through creator it will only show the first 15 characters of the title of the event. This is a mojor problem for me. How can i get it to show more of the title?
Problem with "view-perma" mode
Hi again, https://creator.zoho.com/f1ps3online/campeonato/view-perma/GenerarGrupos is KO https://creator.zoho.com/f1ps3online/campeonato/form-perma/GenerarGrupos is OK Why this difference now? It worked perfectly till now
Function not working in header but works in each record
Possible bug in calling functions. I have a function that only has an openurl statement. It is called from a view the intention is to open a new view. When I set it in the View Header it does not work however when calling the same function from 'Each Record' it works as expected. An alert/info statement shows that the function is being called but the openurl did not open a new view. Here is the function void Rides_Full_Year() { //op_52=CURRENT_YEAR openUrl("http://creator.zoho.com/soundcyclists/scbc-ride-list/view-perma/Schedule_List_Full_Year?Ride_Date_op=52",
Filter a record by a certain field not being blank
Hi, I am trying to create a view that only shows records that have a value for the field "Payment_Date" I have tried setting a filter that "Payment_Date" does not equal empty (I left the field blank) but this did not work. Is there another way to do this? Thanks
Create Function to pass value from one form to another
Hello, I'm new to Zoho Creator and love it! But I simply cannot figure out how to create a function, and it appears that I will need a function to do what I'm trying to do. Here's what I'm trying to achieve: I have a web page with 5 tabs. Inside each tab is an iFrame holding a zoho form. So the user can simply click on the tabs to access the various forms. Up above the tabs is a zoho form with just a single input field. I want the user to be able to put a value into that lone input field and
error occurred while creating the report
I am trying to create a report but get 'error occurred while creating the report'. The application has 14 forms & 25 views.Currently there are no reports. I am using the 'Business Free Edition'. I tried creating a report from different views with the same result. Any idea what is causing this error? Herb Wexler
Disable RTF not working
I have a form with a RTF that is disabled. However users can type in the box and on submit the changes are saved. The RTF field is used to display information from a RTF field on a linked form. All of the toolbar controls are unchecked. Herb Wexler
JavaScript error on Rich Text Field in Form
This is probably something simple but I can't find a forum post on it. When I embed a rich text field in a form then if I try to use any of the more complicated rich text icons when completing the form e.g. font, font size, insert table icons then I am getting a JavaScript error (see below about className)..and the icon is not working. I see that those same icons (on the discussion page into which I am now typing) are working fine here on this page...just not on my application form! I am on
Share Application not working
I am trying to share my application and it simply will not allow it to be shared. At the moment the application is shared with no one, yet every time I try to send out an invite, when the person clicks on the application it signs them into MY account. Or when they log into their Zoho account it shows up on their shared applications list yet when they click on it it won't allow them access and says they do not have permission.
Next Page