Problem with copying the application
Hi. I was explained in one tutorial, that I should copy Zoho application via the following link into my account: "Once you are logged in, go to this application on Zoho. We will start by cloning the application used for this prototype, which makes life a lot easier. On the application you just opened, click on More Actions > Copy Application. This will make a full copy directly to your account with all the settings already in place." But I do not see any buttons with possibility to copy this application.
Setting Link Name for URL
I would like to set the link name of an inputted url to be the inputted date of a document. User inputs Date_of_Document User inputs Link_to_Document In workflow, on User Input and Update of Date_of_Document I have entered the following code: input.Link_to_Document = input.Link_to_Document + "/'>" + input.Date_of_Document + "</a>"; The Link Name stays blank when the Date of Document is entered, and upon submit it records the full URL link for the Link Name. I would like it to just display the Date
Limit Image Size
Is there a way to limit the size of images uploaded, or better yet, automatically resize to a certain dimension?
I can't open my new domain name purchased at ZOHO for the web site I created
I created a web site on ZOHO , then purchased a domain name through them. Then clicked the link to verify it. Now when I try to go to the web page all I get is a error code "404- file not found. There is no web page matching your request" I emailed zoho 3 times and only wasted more time. First they said the site was linked to my email and sent me a email. Ok the email works, but no one can go to the web site? Some one else gave me a link to a page saying to register the name in searches such as
not null date field
Is there a way to create a "not null" condition to indicate that an email has to be send when the date field is not empty? Something that replaces null on the code below if (input.Date_Time1 != null) I have also tried if (input.Date_Time1 != null) { //do nothing } else { //send email } but it is not working.
Stop Click on URL From Opening Record Options
My form has a URL field that populates the column titled "Invoice URL" on my reports. Every time I click on any link under the "Invoice URL" column, the link opens to a new window AND also opens this additional box on the right-hand side of the page that shows options available for that particular record. I'd like for the links to ONLY open to the new window and NOT show this additional box on the right-hand side. How can I achieve this?
Print order form
Hi Guys I have a question, I have built a simple application to collect information on my customer and the product they wish to purchase. The idea is to meet with them and walk them through the interface collecting data about them, their order needs and some other personal data. With in that application I have put the terms and conditions of the deal (like a purchase agreement) using the "add notes" field. I cut and paste the information (about 3 pages long) into that add notes field. Following this
Change settings
Following some problems, I am trying to change my password and email address. I was successful in changing the password. But I seem to get the run around when trying to change the email address. I find the correct place to do so, but it tells me the address already exists, even though it is showing me the current address. Both are different.
How do I create Bold or Italicized formatting that can transfer over XML?
I am trying to create an XML feed for a job site and I would like my formatting to go to the jobsite. How can I get my bold and italics to go through the XML to the job site (Indeed)? Do I need to use <b> </b> or <i></i> in Creator ? Thanks
Font size
I did something while adding records and the font size became much smaller, maybe 6 or even 4. How do I get it back to "normal" or larger?
Mass update form according to another form or an upload file
Is there a way to mass update a form's columns with data from another form? Or update a form according to data in an upload file? Thanks.
Use URL to filter a view (report) with criteria for form field not in the view
I would like to call a view via URL with criteria for field "Customer." Works great, except I don't need the "Customer" column to show in the view. Unfortunately, if it's not in the view, the URL criteria does not work. Am I missing something? Work around? Way to hide the column when displaying the report? https://creator.zoho.com/egutshall/task-manager/#View:Client_Report?Customer=16085000007371003
How to search checkbox, dropdown, and multiselect fields in a record for specific input
Have you been trying to search a checkbox, dropdown, or multiselect of a record to see if it matches a specific word that was inputed into a stateless form? Here is how you do it. for each Record in YourFormName { if(Record.FieldName.toString().toLowerCase().contains(SearchCriteria.toLowerCase())) { //do something when you find what your looking for. } } Record.FieldName is the field name in the form you want to access. .toString() will change
Filter for for Creator Report: count of a certain value for a field > 1
I need a filter for a Zoho Creator report, where I only want to display rows where a value in a field has appeared more than once in the form.... This filter does not work: (FORM1 [FIELD1 == input.FIELD1] ).count() >1 Any idea?
Update and insert into form at the same time
I need to write a script so when importing records into a form, the existing records are updated, while the new records are inserted. How can I start writing such a script? Thanks!
Avoid duplicates while importing, with a composite key
I am trying to import records into a Form, and need to avoid duplicate entries ; the key for each row is a composite key made from field A and B. if ( (FORMX [A = input.A && B = input.B ].count() >= 1 )) { alert "Duplicate! Please check your entries！"; cancel submit; } But the same script does not work for ON ADD validation . Can someone shed some light into this?
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record?
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record? I would like to go with Zoho creator to interact with existing records. If not possible, any ideas? Something like this.
How to show an activated checkbox in an order listing to indicate that the "notes" field contains additional info
I have set up an orders application in Zoho Creator which includes a “notes” field for additional info. On the order listings form, I want an activated checkbox to show up indicating that the “notes” field contains additional info (if the "notes" field is empty, the checkbox is non-activated). On the orders entry form, I need to include a checkbox, which, when activated, shows the activated checkbox on the order listings form. Any help would be very much appreciated.
unable to schedule quarterly task in "zoho creator"
how do i schedule a quarterly and semi-annual task in zoho creator
View complete working ZOHO database off-line
I want to show my complete working ZOHO databases to some important military visitors from their Embassy in Washington, D.C. this August at Camp Atterbury, Indiana. The camp does not have available WIFI, nor can a civilian computer be connected to their lines. I visited the camp yesterday, and on the one available military computer, I was able to pull up my extensive website (www.IndianaMilitary.org), but when I selected, within that web site, to view the ZOHO database, they would not load. Just
[Question] How we can export application
How I can "give" application on other account ?
Tips on modifying an HTML Page with existing embedded reports. ??
I'm looking to try and place 4 reports into 4 equal quadrants on the page for a more effective view for my customers. Any help is greatly appreciated.
dlookup
When I use a dropdown to pick a part number how do I get the equivalent of this VB code to work in ZOHO??? Private Sub PickPartID_AfterUpdate() Description = DLookup("[Description]", "TblParts", "[ID] = PickPartID") Retail = DLookup("[Retail]", "TblParts", "[ID] = PickPartID") Price = DLookup("[Price]", "TblParts", "[ID] = PickPartID") Cost = DLookup("[Cost]", "TblParts", "[ID] = PickPartID")
lookup field displaying ID instead of value
Hello all, I have searched the forums but I can't seem to apply it to my problem below. The input.First_Name is retrieved from a lookup field. I know it is in numerical ID form, but how can I edit it to retrieve the actual value? sendmail [ from:zoho.adminuserid to:"jli@asiajet.com" subject:"Crew Visa expiry alert (30 Days Notice)" message:input.First_Name + "'s " + input.Visa_Country + " visa will expire on " + input.Visa_Expiry_Date + "." content type:HTML ] Thanks!
How to hide sub forms
How do you hide an entire sub form (not just subform fields) based on conditional statements? The subform comes as a greyed out option in Deluge Script Builder when using Show/Hide function?
Open Google apps (gmail) or Zoho Mail by clicking a link in Zoho Creator
If I have a list of several customers, including their email address, would it be possible to set it up so just by clicking the email adress, so would I automatically open up Gmail or Zoho Mail directly with the list of all the communication with this customer? Any suggestions how this is done? Thanks
Project Database
I have two requests please. We have created a Projects database which has a number of subforms, one of which is comments. It has three fields - Date, Who, Comment Elsewhere on the Main Form there is a comments field from an earlier version. I would like to move these comments to the subform and then delete the original comments field. Is there some code that would achieve that please, or do I export and re import. Any advice appreciated. The second request relates to managing Project value. On the
report seach
In my report have a field named warehouse locations, how do I do a search for entrys related to both the carson and fontana location at the same time? neither a space between the words or a comma works. Help is appreciated
How can I change the "displayname" which is displayed on the top of the form on edit>on load, dependant of the view which is editing?
I want to give different "displayname" to the form depedant of the view I am editing. Is it possible? Thank you.
Message Box function
Please provide a function to display a message box, ideally of the CSS later type rather than JS. EDIT: oops, I meant the "CSS layer type".
Self-referencing forms
I am setting up a form field as a lookup to refer to the same form. I found it not possible/allowed.... Several years ago there was an example but I can't download/copy the app: https://help.zoho.com/portal/en/community/topic/self-referencing-tables Can anyone help? Thanks.
How to use the "search" property correctly when embedding forms
Hello just a pretext I spent a few hours trying to get this thing to work properly and officially there still isn't a data entry in the deluge documentation resources on how to use it so I'm making this to supplement that till they fix it. I got an email from zoho customer support which was nice and I got it to work right after. So don't worry I was already helped, but its still is kind of a problem that the deluge documentation isn't being updated in a timely manner. Onto the main course, if you
Is it possible for a contact to add colleagues in the Portal?
Hi all, My clients wishes to enrich his database to add more Contacts to his Accounts, Should we create a Customer Portal where the main Contact of the Account could create new contact persons? Or is there an easier way?. My question is whether this is supported in ZOHO Customer Portal? Can a Portal enabled contact manipulate (add) contacts for his own Account?
Record Summary Template Format
Hi, I'm looking for some help in formatting a Record summary template to look similarity to the example on the following link. I would like to produce a simple invoice with two items based on a small data set. I'm not able to get the correct marine size and table to line up correctly. I've tried using a tow column and a single column layout but I stlll can't get the right look in feel to the invoice. https://www.zoho.com/creator/help/views/record-summary.html Thank you for any help.
Using different From when sending an email
How can I send an email to someone using a different email address than my zoho.adminuserid Thanks
twitter link from zoho creator report
Hi, I want to use a database to schedule my future tweets. The idea is to make tweet as a string to add to the following link http://twitter.com/home/?status= my first tweet URL will lead me to a separate window to tweet (click) Somehow function keep shorten OpenURL "http://twitter.com/home/?status=" line into "http://twitter.com/home?" any idea how i can tackle this? thanks Halit
Add calculated number of hours to date
I'm not very much into Deluge yet, so I am having a little bit of trouble of with below, where the ultimate goal is to add a calculated number of hours to a date specified in the form. My first five lines works fine, but the last do not return a value. (I.e. 16-05-2016 12:00 + 72:00 hrs = 19-05-2016 12:00) input.Ops_Time1 = ((input.Reporting_Time - input.Operations_Commenced) / (1000 * 60 * 60)).round(1); input.Moves_Performed = (input.Units_Discharged + input.Units_Loaded); input.Moves_Remaining
Update record by other form
I tried to find the article but I cant see it anywhere. My case is like this for example: Form A [Product] which will have name of product and its cost. From B [Order] which will lookup the product name from form A and fetch the cost of that product from form A too. For adding record in form B, everything is fine. Now when I update the cost from form A [Product], how can it automatically update in form B [Order] too? I will have for example 10 records in form A [Product] and just some of them need
Problem Importing number field
Hi I am having trouble importing number fields from an Excel file. In my form I have to Number fields, one for the ID number and the other for the phone number. In the excel file the columns are defined as number columns and they have numbers like 1144035567 for ID´s and 3155467898 for phone number´s for example. When I want to Import the file I get an error alert for this two fields saying that those are invalid numbers for numeric fields. Error details of records that could not be inserted Row
Pretty Link Pro URL shortener
Has anyone tried to use Pretty Link Pro to brand published form URLS? Does it work?
Next Page