user login not working
i created a very simple tracking db and embedded it into my website login required i am the admin i created a user account for my partner i can log onto the database but when my partner attempts to it does not recognize the username and password I verified that he is a zoho user and logged in as him
Zoho Creator - RSS includes to many fields
Hi We have in our cafe/bar a Zoho Creator for our events. I have a RSS feed off these, which I would like to implement on our website. I have how ever run in to a bit of a problem. The RSS feed includes to many fields. In the Description field it includes: * <b>Eventtype</b> * Koncert<br/><b> * <br/><b>Entre</b> : * <br/><b>Billetpris</b> Is there a place where I can specify which fields it should include in the RSS feed ? Please help a newbie in becomming experienced in Zoho + RSS The RSS
Render image in html-view on a view-perma page
Dear ZOHO, I'm trying to display rendered images on a HTML-view page. I display this page via a view-perma view (example: https://creator.zoho.com/sdraaijer/qdst-nl-dive-conv-support/view-perma/Print_page?MAIN_TOPIC=Cellen ..) I try to diplay the image with the following code: <img src='http://creator.zoho.com/DownloadFile.do?filepath=/<%=r.UPLOAD_IMAGE%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Questions'/><br></td></tr> Now the difficult bit for me is the viewLinkName
Code to check if the file upload field is empty
Dear ZOHO, How can I check in deluge script if a file-upload field is (or is not) empty. I tried the following code, but that does not work. r.UPLOAD_IMAGE != NULL What is the code for this? Thanks in advance. Silvester
"On Success" emails ending with <br><br><br>
They end with <br><br><br><br><br>-------------------------------------------------<br> I have no codes or anything at the end. I have two "send mail" functions there and both are having this problem. The forms are also not recognizing HTML.... it sends all the text together without line breaks and won't recognize URL codes with <a href> </a>
Email Formats Problem
Hello We are using Zoho creator to maintain the complaints. In the Zoho creator the mails are sent on several phases. Till couple of days back the mails were coming properly in HTML, table, color etc format. Now these mails are not coming in formatted way. Is there any problem with the mail system of Zoho?? Please suggests some solution as the complaint logging system is live and it is causing the inconvenience. Thanks in advance. Umesh
HTML formatting in emails is not working
When I use the "send mail" function on Deluge Script, it no longer respect the HTML tags for bold, italic, underline, etc.. When I am in the Script Builder, the preview seems right, but when I test the forms and the mails are sent automatically, the text is all written as if it were plain text aligned to the left. Also, it doesn't show some characters (such as à, ó, ñ) and sometimes it doesn't even respect line breaks. I didn't have any of these problems before, and I didn't change anything in the
Deluge script: IF (condition) in On User Input is behaving oddly
Since some days ago, most of my forms behave oddly when I use the "if" and "else" in On User Input, to show or hide fields. The application seems to completely ignore the condition and always executes the "else" part. I didn't change anything in these forms since a week ago, and everything was working completely right, so it's not an error made by me writing the script, I even reviewed the script and everything seems to be OK. This is one of these scripts: f((input.medio == "Página Web")) {
Using Amazon Simple Email Service with ZOHO Creator
Those of you that follow my posts here know that I have a love/hate relationship with mailing lists. I love the idea offering the service to my large community of users, but hate the various implementations available. Right now, I'm using Mailman. This required purchasing a VPS and learning my way around CentOS and dealing with python script craziness. At the same time, my community of users visit my ZOHO Creator site to publish calendar events and emails (sent to Mailman for distribution). I have
Is it possible to use deluge to update a field with web data 'on view'?
Hi there, I'm using web data in one of my application and it works great. However, this data is prone to change from time to time. I can get fresh values by editing the form, but I have not figured out how to do this automatically. Is there an 'on view' function or a scheduler for getting new values from dynamic data sources?
Use of Amazon SES
Always on the lookout for mailing list applications, Amazon recently released their Simple Email Service (SES). The developer guide shows an api using get and post commands to send an email http://docs.amazonwebservices.com/ses/latest/DeveloperGuide/ Post example POST / HTTP/1.1 Host: email.us-east-1.amazonaws.com Content-Type: application/x-www-form-urlencoded Date: Tue, 25 May 2010 21:20:27 +0000 X-Amzn-Authorization: AWS3-HTTPS AWSAccessKeyId=AKIADQKE4EXAMPLE,Algorithm=HMACSHA256,Signature=lBP67vCvGlDMBQ=dofZxg8E8SUEXAMPLE
Required fields
Hello, How or where can I translate a error messages of type "Enter a value for ...." or " Invalid entries found. Please correct and submit again." please? I need that to localize to another language thank you in advance Miroslav Osicka
Equipment Booking
I am trying to create an equipment booking database. What I'd like is for the person booking the equipment to pick the item from a lookup field (if possible to do multiple items at once would be great for those who need to book multiple items at once for the same time/date) then they would pick the from and to date fields. From this point when they submit I want it to check if that particular equipment is booked at that time and if so to alert the user that it's booked and to choose another time.
Passing string longer than 255 characters to an HTML view
Dear ZOHO, I want to pass a string longer than 255 characters to an HTML view. I generate such a string when I invoke a function. In the html view that is generated, I have to set this variable as type STRING. There is no type such as LONGSTRING for example. Please see the attached screen shot. How can I achieve this? Thanks for any help. Silvester
Create View that accepts a URL parameter for record retrieval (for use with REST API)
Hi there, I have searched high and low through the documentation and forums and can't figure out how to get this working, so I'm hoping someone here can lend me a hand! I am using the REST API to pull in data from my Zoho Creator app to an external website. Data entry happens in the Zoho Creator application, but public perusal of the data happens elsewhere -- and I'm using Views to aggregate and build the data I need to pull in as JSON objects. I need to create a view where I can pass a URL variable
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?
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
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
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...
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?
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.
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
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 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
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
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
Next Page