Yet another question about dynamic lookups
I have two tables/forms: Franchises and MasterFranchises. Each has a field named Franchise_Name. The forms are identical except that the Franchise form also has a field for MasterFranchise. All franchises are "owned" by a master franchise. In some other forms, I have a Franchise field that looks up franchises in the Franchises table. So far so good. But in some forms, I would like to have a Franchise field whose picklist is a combination of both franchises and master franchises. Is there
Account address to post in contacts
Can you develop a quick and easy way for Account address info to copy or be posted to contacts, it is time consuming to have to enter that info more than once?
existing study id
So I have a form and have uploaded 160 study ids into this form. I want to be able to enter data only for these study ids and also have other people add data to these study ids. How do I show the study id? For example in an access db you would just go to the next id enter data then select the next id. But I am new to zoho and don't know how to select the study id. Currently it is a text box field. do I need to create a dropdown box with all the studyids? Then I can write a script to excluded the
Performance REALY SLOW!!!
We are using a html view that has been in place since Feb, but over the past two weeks the performance of the HTML view has gone from 3-7 secs to load upto anywhere near 3 minutes!! This is particularly evident around 3pm UK time. We checked the obvious things and broadband but need some answers pretty sharpish. I've included the customer on submission so they understand some of the frustrations being experience by your customers. Please advise.
What is a User?
Using Zoho Creator, we are starting a sports fantasy league. Individuals will sign-up to participate. Are each of those individuals considered a user?
Need help on sendmail
I am trying to use the sendmail function to send an email to the person that a task has just been assigned to. The form is New_Task. The table with the employee information is emp_list. I have a lookup field from the New_Task form to the emp_list that pulls up a function field concatname which combines the last and first name. Here is my code below, please let me know what is wrong with it, thanks. { assignedtaskemail ( type = string ) assignedtaskemail = emp_list[concatname = input.emp_list1];
Nested checkbox list
Hi, I am wondering if it might be possible to accomplish the following through deluge and a standard form (seems you can do it as a html page but I'd rather not go there). I have a set of checkbox lists that look like this Checkbox 1 Checkbox 2 Checkbox 3 Checkbox 4 These items are not hard coded but rather are dynamically added from a table in the application. What I need to be able to do is to nest some items under each checkbox. So for example, if you click on checkbox 1 you would see something
File Storage Options
Is it possible to use the file upload more like a virtual drive, where files can be easily aggregated through copy and paste function and then linked from fields in the form?
Create a relationship between two records?
Hi pals, I'm building a marketing content inventory application to keep track of all the content my marketing department produces. (Brochures, white papers, case studies, etc.) One way a content department makes itself more efficient is by deriving one piece of content from another. For example, if I write a 3-page white paper, I can derive a blog entry and a newsletter article from the white paper with very little effort. Each one of those items are a "content item" on their own. They're all entered
Pivot tables not showing correct field values
I have a magazine application with two basic forms: article and issue. The issue contains four fields: IssueID, Month, Year, and Issue. Issue is a formula that combines all three fields to display something like "302 May 2014" Article references the Issue field so that every article has a "302 May 2014" like field, depending on what issue it belongs in. When looking at a report of every field of my articles, they all show that format under the "issue" field. However, when I create a pivot table totaling
Loading image in HTML view.
When a user is looking at the view there is a custom action that loads an HTML view and loads all the info based on the value. Everything works fine except the image. For some reason the image is just a broken image and I cannot figure out why. Here is the image link I am using <img src='https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=job.Art%>&sharedBy=zoho.adminuser&appLinkName=XXXXXX&viewLinkName=XXXXXX'> What view do I need to put in the viewLinkName? I have been using the default
Column limit
Hello, How many columns can I have in a zoho creator database? Is there a page with all of the limitations and/or specifications? Thanks. Iram
Concatenate Issue
I am attempting to combine a fixed text string and two number fields into a formula field. The fields from the form are Number and joblist. Number is calculated as the greatest value of number +1, while joblist is a lookup field for job number. I used the following code: "H13" + Number + "-" + joblist The formula result is: H133614-1619928000000252808 Everything to the left of the dash is correct, the number to the right should be five digits and is nothing like what is represented. Thanks for
How do I display the sum of a column in a page?
Hi, I want to put a sentence in a page that says "Your balance is x dollars". x is the sum of a column named "budget" in a report. I'm sure its a simple thing for those who know how to use deluge. Thanks for any help you can give me. Caz
Question about error message I get when I use filters in "Create Dynamic Lookup"
Hi, I'm quite new at Zoho Creator, I like it so far. I have a certain knowledge in mySQL and PHP but not enough to develop my own CMS. ZOHO is perfect in my case. I'm building a simple data structure for a project I have with 3-5 forms to organize my data. In one of them I need to create a drop down that contains only the results associated with the previous drop down. In my example, I have 3 applications: - Clients ( simple name of the customers ) - Filiales ( french name for branch ) - Panneaux
RELATION OF FORMS
HELLO PEOPLE. I AM NEW HERE. Zoho Creator is one of the coolest things I've seen in the last 10 years. I saw how that funicona, but I'm doing something wrong. See with is simple. I have a table 1 (Form 1) - Registration of equipment MODEL EQUIPMENT INVOICE SERIAL NUMBER (SINGLE) START DATE OF OPERATION I have another table 2 (Form 2) - Registration Problems DATE OF ISSUE SERIAL NUMBER OF EQUIPMENT I need data from one table to appear on this form when I enter the serial number of the equipment ....
dropdown data creating merged categories
I'm creating an app to inventory my marketing content. A piece of content can only be one KIND (e.g. datasheet, brochure, white paper), but it can have many audiences (e.g. CIOs, CEOs, CFOs). The form that I've created uses dropdowns to select the audience, and the user can select more than one. However, in the reports, the system is creating merged categories, instead of listing the assets twice in each category. Here's what I'd like to see: AUDIENCE = CFO Assets A, B, D AUDIENCE = CEO Assets A,
Best Approach (working with dates)?
I am re-creating a an app I created in MS-Access. What I am trying to do is to create an amortization schedule which means I have to work with dates. Dates seems to be handled differently. Here's how I did it in Access. I had a table the needed periods. Period ID, Date that would be the month end. Then I had a decision box to close the period when complete. So I feel like I want have a table with periods. Where I maintain the assets, I use a lookup field. The challenge is I am not able
Month End Calculation
I have created my first function in Zoho Creator. Something I think I'll use often throughout the project. date MonthEnd(date MyDate) { WorkingDate = input.MyDate.addMonth(1); WorkingDate = WorkingDate.subDay(input.MyDate.getDay()); return WorkingDate; } This gives you the last day of the month for any date given.
Duplicate reports - same name, different filters
My app has several different sections, for continuity, each section needs to contain a list of the same report titles. Within each new section the reports, although duplicate in structure, vary by their constraints/filters Example Section 1 - Cyclones report - Financial Support (filtered to only include cyclone data) report - Business Support (filtered to only include cyclone data) report - Personal Support (filtered to only include cyclone data) Section 2 - Drought report - Financial Support (filtered
how to change section name?
is this possible? i can download the DS and import it back in but i dont want to make a whole new application.
Some help with a specific requirement
I am trying to build a membership database, and attached to each member I would like a field that tells me the date and time they used their weekly "once a week freebie". Not sure which field type I should use and if I have to make 52 individual fields (table) that's attached to each user. I would basically like to track when they come out and know that we are not giving them more than one a week. I would also love to get a report that would show me both a single users weekly usage or all my members
Date-Time function - "getWeekOfYear()" not working
Support, I called the function getWeekOfYear() for 29-Dec-2013. Basically, it should return 53 but it is returning 1.
A sendmail function from an individual record in a report that will permit the user to attach a file?
A function can be created to send an email from an individual record in a form. This is useful because the record Filename can be used to create the email subject line. However i wish the user to have the opportunity to attach a file to the email before it is sent. Is this possible? Merry Christmas to all in the Zoho community and to Herb who has answered so many challenging questions:)
subString() not working
I am trying to validate and format North American phone numbers They should always be ten digits in the format (xxx) xxx-xxxx. Here is my code: // get input without special characters rawno = input.Cell_Number.getAlphaNumeric(); // remove letters rawno = rawno.removeAllAlpha(); // get number of digits noln = rawno.length(); if (noln != 10) { alert("Number must be ten digits.\nYou entered " + noln + " digits.\nPlease re-enter number."); } else { areacode = rawno.subString(0,2); etc.
Where can we store/find functions?
Is there anywhere where we can save any functions we have created that might be useful to other people? Examples: validate email address on entry, validate and format phone number, etc. It seems that a lot of people must be reinventing the wheel all over the place here. Also useful items that can be cut and pasted for drop-down lists, such as US States, Canadian Provinces, Months, Days of the week, etc.
Second level lookup question
I have three tables/forms: "Franchise" lists details about each franchise, including Franchise_Name. "People" lists details about each person, including the lookup field Franchise, which looks up from Franchise_Name in the Franchise table. "Call_Record" which a person completes when they make a sales call. It contains their name in the Caller field (which is inserted automatically by matching zoho.loginuserID against email addresses in People and then extracting the person's
Show-Hide Columns
Hello. In any View I can hide colums only in finally View. And then save it as a basic View I need. But nowhere in editing of this View - neither in "Column properties", not in "Definition" - I can't see, what columns are hidden. May be, for example, describe it in "Definition" as type as "Type" hidden And, may be, simple icon or button in "Column properties". Thank you :) Ulia Sivridi
Public share using permalinks
Can I share my ZCreator form PUBLIC (without login) using permalinks in Professional edition? Which edition is required to have this feature?
How to schedule an immediate email of an uploaded file attachment?
I see time as 00 and hours as 00 are options in Scheduler but it does not seem to have the desired result.
Zoho Creator app for Iphone and Itouch shuts off
I have noticed an issue with the free zoho creator app for the itouch. A colleague of mine has also noticed an issue with their iphone. This is an important feature for our agency and would like to know of any knowledge on the subject. Problem - When accessing certain forms and reports, the app will just shut off. I have never seen this issue with any of my apps before. I assume it's an issue with the app and not the itouch device itself, but I'm willing to be wrong. Thanks, -Robby
Fetch and update Multiple fields in one Form Data with Data from another form
I have two forms Crew Form and Timesheet form The crew form has multiple drop downs, i want to input from a drop down in the timesheet form and it fill in the fields on the rest of the Time sheet form. Example Crew Form (Single Line Field, Crew Number) "1" (Look up Field, Name) "John Doe" (Look up Field, Name1) "Jane Doe" (Look up Field, Name2) "Bob Doe" Time Sheet Form I want to Look use a Look up Field on Crew Number and have it update the record with all of the fields associated with Crew
"if" statement causes error.
I keep getting an error from a simple "if" statement. noln = rawno.length(); ... correctly returns the length of rawno. But... if(noln != 10) { etc. ... gives an "Improper Statement" error for the "if" condition. Huh?
Happening this May, Zoholics 2013, our annual user conference and Zoho Creator training sessions
Our annual user conference, Zoholics, is scheduled to be held from 29th to 31st of May, 2013. The agenda includes product training sessions and keynotes on mobile and cloud computing. Zoho Creator training sessions will be held on Day 2 & 3 of the conference; between 8 AM and 5 PM on the 30th and 31st of May. Join us for training on creating custom apps for your business, and customizing them further using scripts. There is an early bird advantage too. Register Now! Team, Zoho Creator.
Restriction on RTF on Load of Stateless form
Are there any restrictions on setting the value of a RTF in a stateless form? In the on load section I'm setting a RTF equal to a RTF field from a fetched record. Nothing shows in the screen field. An alert statement does show the value. So I know I have fetched the record properly. I can put the value of the fetched RTF into a multiline field with no problem. Once the form is loaded I have a field that fetches the record and properly loads the RTF field with the correct value. It is only in the
Can't duplicate an application.
Neither is the export and create new application from DS file feature working. Please help. App URL is: https://creator.zoho.com/appbuilder/360hvpl/health-vectors Access has been granted to Zoho Support -Varun Yagain.
I'm having trouble importing a .ds file
When I Create New Form / Import File It takes me to an error page after selecting my .ds file and clicking the Create button; An error has occurred. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home I don't know why I was unable to import my .ds file.
Can I link/upload entries/records in Zoho Creator to document like a PDF?
Also, can Zoho be used locally or must I always be connected to use it? Thank you in advance.
Double count on validate
Hello, I have a problem. I am using the count function. Here's an example: if (count (zzz[xxx == input.xxx])> 0) { double = true; } But now I have another need. I need a double condition that occurs in the same record. Using a double count it seems to me does not work. Here's an example: if ((count (zzz[xxx == input.xxx])> 0) && (count (zzz[yyy == input.yyy])> 0)) { double = true; } In this way, however, does not work, because the function does not work on the same record. How can I tell to the application
xss vulnurability in zoho creator
Dear sir i am yash pandya i have found xss in zoho creator i have attched screenshot for poc ..
Next Page