Adding text as part of the form page
I am creating a form. I want the form to look like this: Already registered? SIGN IN below User Name Password Forgot password? (this would link to a different page) Question. I know how to create the user name and password fields. how do you just add text as part of the form? How would add a hyperlink to the text?
how to add logic within a field
Reuben: Rob thought you might be able to help. I am new to Zoho...and am trying to understand a couple of things. I am creating a form. I want to add logic to a drop down box....or a check box. The first check box choice: Add a new customer in the data base. OR Edit an existing customer record If they select the "add a new entry"....the form should then display the fields they need to complete for a new customer. If they select the "edit an existing customer" they should see a list of
are there any videos showing us how to use zoho?
Are there any training videos that show how zoho creator works? thanks
creating an application from an excel spreadsheet
Has anyone built an application where the original code/logic was stored in an Excel spreadsheet. Is there a way we can view the results? Does it work if you have multiple worksheets in your existing Excel logic? thanks
Formula result not showing in View
I created a very simple formula ((Revenue_Amount * Revenue_Percentage / 100 - Deposit_Received), but it is not showing up in the Application View (I know it's not supposed to show up in the Form, but it won't show up in View, either). No error message is returned. Any ideas? Julia
Lookup with two keys
Hello I have created two forms, form 2 needs to reference form one by a combination of two fields (i.e. a composite key). How can I do this ? Thanks
Can only the administrator edit applications
Hi, I am currently using zoho creator whereby my colleague is the administrator. She has shared the application with me and set me up as a developer with the permissions of editing adding and deleting files. However the administrator has the option to edit applications (on her home page she has edit, duplicate... buttons I don't) and has a whole range of other tools that I don't have e.g setting up relationships and the ability to change fields. My question is can only the administrator have these
Need help with figuring out putting an HTML view's PDF file into another form
Hello. Thanks for reading this post. I need help or ideas on how to put an HTML view's PDF file into another form without having to save the file and then upload it to the other form. Is this even possible in Zoho creator? Scenario: I have an HTML view that generates preset letters with the Print & PDF capabilities. I have a function/script that allows me to select various letters to generate based on the contact info and uses the HTML view mentioned above to make these letters. I would like to be
number of lookups depending on another dropbox
I have a max number of students in a class, and it all depends on how it is set by the tutor. The number can range from 1 - 10, however, because if the number is only 4, then i want only 4 lookups to be added(or enabled, if not possible to make the rest disappear) The lookups are used to look for student names and add it to the class. Thanks for the time!
Empty upload field is no longer empty after record duplication
I check whether or not an upload field in my form is empty with the following code: if ((searchProfile.File_Upload != null) && (searchProfile.File_Upload != "")) This works fine if I created the record from scratch. If I duplicate a record with an empty upload field in it, the code above no longer works. Checking if the field is empty with searchProfile.File_Upload.isEmpty() is not supported. Adding the code input.File_Upload = "" in the On Add / On Load event does not work either. Please advise.
Calculating time
Hello, I'm creating a web application to manage information from an Online Racing League and am currently having an issue tracking time. I'd like to have lap time data of the various races then be able make calculations against that data to get "Top 5 Lap Times" or position the grid based on lap times etc. I currently have the time entered in a single text field in the format of M:SS.SS so for example 2:12.234 (2 minutes and 12.234 seconds). THis works fine for sorting but I cannot use it in calculations
Multiple dynamic drop down
Hi -- I have three fileds : ARTISTE_projet ; ARTISTE_date ; ARTISTE_seq I'm trying to populate _date from selection in _projet, then _seq based on selection in _date (like cascading). Based on this tutorial, I tried this: In ARTISTE_projet on user input I have this: if (count(JOURNEES_Form[JOURNEE_projet == input.ARTISTE_projet]) == 0) { clear ARTISTES_date; } else { datelist = JOURNEES_Form [JOURNEE_projet == input.ARTISTE_projet] sort by JOURNEE_DATE ; ARTISTES_date:ui.add(datelist.JOURNEE_DATE.getall());
Creating form to search dbase?
Hello. I'm not a dbase programmer, just a guy trying to use Zoho to help out a worthy cause (supporting organic farming in Nepal) I've set up a database application, with a form and a few views. -- http://creator.zoho.com/nepsan I'd like to create a form or view (not sure which!) which would be, essentially "Look up my Listing" -- allowing a user to quickly and easily search by first and/or last name (or whatever fields), and then - if no results, have the option to enter their data (via the form
Any reports (chart) for showing the trend of using Zoho Creator.
Is there any report that shows the trend of how many people start to use zoho creator? Just curious. I am getting more inquiries from my clients to build zoho creator application. Thanks.
Backup of uploaded files ?
Hi -- How do I backup uploaded files ? I've got pictures uploaded, and when I download backups, they're not included. What would be the way? What would happen is something went wrong and I do a restore, would there still be pictures attached to my records? TIA.
My app is non-responsive to edits
I'm trying to edit one of my forms, and I can't add or delete some of the field types. When I try to add a field it hangs at "Please wait" and doesn't do anything. If I try to delete a field, it vanishes, but if I reload the form it is still there. This is the case with several of the field types. I also cannot add views for the form, or change the columns that are viewable in any of the views connected to the form. It seems that something is "stuck" with that particular form in my app. I've
Need Verification Does not Work
Greetings, I need to use the Verification turned on for my forms. I check the Verification Needed feature, hit save and it does not turn the feature on. Is there a problem with that feature? Bartley
New Records not Created in Issue Manager
New records cannot be created with "Add Issue" in the Issue Manager. The email addresses are valid, however when the issue is submitted, the log reports: Error details: Error occured while on Success script. Unable to send email Invalid Email Address found
Images - desappearing from view
Hi, I see not more images in my view... any problem in zoho server? Or it's my application? Thanks Mic
Send mail - autoincrement problem?
Hi I've a form https://www.creator.zoho.com/misca/form/459/edit/ with send mail function. When I set up autoincrement funciont stop running. There is some mistake in the script? x = MaxValueHolder [ID != 0]; autoincrmentval = ((input.Universit + ((input.Data.getYear() * 100))) + (x.maxval)) + 1; input.Codice_Lezione = autoincrmentval; x.maxval = (x.maxval + 1); Thanks Mic
Reports- User Filter by Weekday
I am trying to create a report to show Usage trends. The Form I have allows the User to input the Date and Shift, and then the Quantity for each Product. (There is also a field on the form that calculates the day of the week on Date_Field.getday()) The User needs to be able to select the Day of the Week and select how many weeks to return, and then the report needs to output the usage for each day, with the averages. Example: User could Input Weekday = 1 (for Monday) User could request the last
with "Helpdesk" what URL to enter a ticket?
I signed up for the helpdesk trial. I see the admin dashboard, and the technician dashboard, but not the the dashboard - or whatever - for helpdesk users. Where do users go t enter tickets?
zoho application
Hi friends, I dont know how to access the shared applications from my project.Please help me. Thanks, Raja
How can I create a View displaying data from Two or more Forms?
Hi there I don't get this solution How can I create a View displaying data from Two or more Forms? What exactly is "the child form"?
Contact Form
How can we configure the 'Send Email Notification" in Zoho Creator to send a notification to another Zoho user other than zoho.adminuserid? Thanks, Mark
Can a public app use another app's records for lookup fields?
If I sell an app in the Marketplace, is it a good design to have it use another database app to manage the lookup fields that is not purchased? Can this be done? For instance, I have an app with lookup fields. The user cannot add to or access these records directly- only through the lookup field. I would like to add to these records without needing to republish the app for a user to upgrade. Can I have the lookups get their lookup data from another separate database that I maintain in Creator?
Functions fired on client side or server side
Hi: As we know, for a database driven online application, usually we write code and the code will run back on the server, but sometime we use script (such as: javascript) which can run on client side. I am a little bit fuzzy on Deluge, I noticed from Deluge help: 'alert' can be used only in 'validate', 'on load', 'on user input' and on click actions (so I suppose it runs on client side). How can we choose or tell if we want to run the code on client side or server side? (for example, some validation
Multiline appointment in calendar view?
Hi there, I was wondering how I would be able to have a multi-line item show up in the calendar view? Right now in the Calendar view, it only shows one line item per appointment. For example, if I create a new item in the calendar view, it'll show my name on a single line. I want to concat my name with other important info such as 'venue', 'time', and I want those to show on lines below my name. How would I be able to do this? I've tried using the formula field and adding <br> to the script, but
Signature/scribble field
is there a way to insert a Signature field ? Should be useful when we need to authenticate some data with the customer's signature. It could be an image field with an ole export capability. Thanks
Best way to include record edit popup in HTML view?
Hi folks, I have a query about using record edit functionality in the HTML view type. I have read this interesting post in the forum: http://help.zoho.com/portal/en/community/topic/edit-link-in-html-view-dialog-problems but unfortunately I have not got as far as the original poster. I think this is because I am building the link in a different way. Background: I have a list of tunes (musical pieces) and would like to be able to edit these directly from the HTML view. At the moment, my view is extremely
Display field from other form based on other field in form
Sorry; cryptic thread title, didn't know how to call this... I think I saw threads relevant to this in the Forums in the past, but I can't find these back. Sorry. Hi -- Let's say I have four forms : - Projects - Dates - Tasks - Users Basically, When I enter a new task, there are mandatory date field + project field. Then when I assign a task to a user, I would like to be able to retreive the corresponding date and project for this task in a user view, for filtering/sorting, without having to manually
PDF's are broken AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN
PDF's are broken AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAINAGAIN AGAIN AGAIN AGAIN AGAINAGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN AGAIN How many times? Please fix.
Allowing edit of a record without login?
Is there a way to allow someone to edit a record without logging into ZOHO Creator? I have a form that emails users in a list when a record is added. Once they get the email, there is a link where they can respond Yes or No. If they choose Yes, then a hidden field is supposed to change to Yes as well. If they choose No, then nothing happens and the record remains unchanged. If I am logged in, this works fine and there are no issues. If I am not logged in, it takes me to the form from the
Public Access vs Private Access
If I begin my form with public access and my visitors do not create an account, can I go back after the fact and make the form private and force my visitors to create an account to have access to the information? If I make them create an account, can they access information that they have entered previously when the form was public? Thank you.
Limit the # of Formulas in a Form?
Is there a limit to the number of Formulas that can be included on a Form? I have a form that has 13 formulas, and I have tried to add another one, but no matter what formula I put in there (I have even tried to copy other formulas already on the Form that are working) it keeps disappearing. I will put in the formula, and click "Done" and it will save and appear in the screen. But when I go to View to try to add it to the View, it has disappeared, and when I go back to the Form, it is no longer
How to add Data from a record in a form to HTML view
I want to add data of a record in my forum to a HTML view. I am using following scripts htmlpage HTML_Test1(Ref_No) displayname = "HTML Test" content <%{ rc = Shipment_Details [Ref_No == input.Ref_No]; }%> when I test this script in the preview it works fine. But when I access this view I don't get any result. Can anyone help me with adding data of a record in a forum to HTML view. Ashish
Passing params to ZOHO
It would be extremely useful if it would be possible to pass data to a ZOHO application. I work with a content mgt. system and I would like to pass some variables from there to ZOHO creator when it starts a form. Example. I would like to be able to pass first-name, last-name, personal-id and sex to an application so that the form is already pre-filled with the information I already know about that user. Would that be possible??? Could It be made possible?? And of course - this would be my next question
When specifiying parameters in the URL for a view, can you filter for results based on param1=value1 OR param1=value2?
Hi, I would like to be able to display a view with results based on a parameter, but would like the results to be shown for records where a parameter equals one of two possible values. Is this possible when passing the parameters via the URL? ie it would be something like urlToView?param1=value1¶m1=value2¶m1_op=xxx where xxx is an operator for OR. Anyone have any ideas on how to solve this? I might be missing something basis regarding parameters, I am not an expert. I can't find an
Newbie Question - Group Sort by related field
I would like to be able to group items in a view in an order that is not alphabetical. Is there any way to do this? I was looking at the map functionality. is this the correct method? Also, is there an app that uses map so that I can try to understand it better? Thanks in advance
Sort Values in Lookup Box
I've created script that populates a lookup box. Despite setting the field's property to sort alphabetically, the values are not sorted. Any ideas? Martyn martynhale
Next Page