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 ..
multiplying decimal numbers resulting from dropdown selection
Hello, I have the following issue : I have a dropdown with option a, b and c and another with d,e,f. Depending on the dropdown choice, a decimal value is assigned to a Decimal Field (say x-factor and y-factor) for each dropdown respectively. I then try to multiply these fields in a formula field. For some reason I get no value whatever I do. If I just type numbers in Decimal Fields x-factor and y-factor I get a value in the formula field !!
type mismatch on code that was not chnaged?
I have this error showing when I click on save: "Mismatch data type for function 'getAge' at argument index 1 expected data type TIMESTAMP found data type BIGINT" it occurs in the line beginning row.age: if ((row.personId.dateOfBirth != null) && (input.dateAndTime != null)) { row.age = thisapp.stc.getAge(row.personId.dateOfBirth, input.dateAndTime); } this is code that was not changed but with this error I cannot make edits any way.
How to get values from multiple records?
Hi All, I thought this would be straight forward but I've lost the plot ... I have a form Customers. On Add Customer, sometimes, the customer name already exists in the table, which is fine because the address may be different. So we could have "Doe, John" with an address of "Hokitika" and "Doe, John" with an address in "Taranaki". Perfectly ok but I'd like to bring this to the attention of the user. It isn't possible to compare addresses as there could be slight differences between entries. What
Dear administrator
I am yash pandya an indipendent security researcher i have found xss vulnurability in your site link https://creator.zoho.com/eryash9/swf/#View:swf_View_img_src_s_onerror_prompt_2 step to reproduce : 1 create account in https://creator.zoho.com/ ex: my account https://creator.zoho.com/eryash9/ now, 2 go to the edit this application 3 Now in display name add xss java script like swf"><img src=x onerror=prompt(2)> and add link name = swf"><img src=x onerror=prompt(2)> 4 now click on accpet this
How to make consistent values in a field of the main Form and a Subform
Hello, how can I make it to have date-fields in an Subform be consistent with a date-field in the Mainform? Or in other words: I have a date field in MainForm, when I update this, I want that all dates in the depending Subform-rows are being updated.
Lookup fields and null state
Hi All, I have a simple bit of code that doesn't appear to be playing by the rules! Both Task_Helicopters_Required and Task_Pilots_Required are non bidirectional Lookup fields. if (Task_Helicopters_Required = null ) && (Task_Pilots_Required = null) { enable Task_Type; } else { disable Task_Type; } The above is accepted as valid script but Task_Type is immediately disabled on form load. I have tried changing null to "" and again it's accepted but in this case, Task_Type is never disabled. Am I being
Clearing Multiselect On Edit > On Load
I have a multiselect check box that I would like to clear of its values upon On Edit > On Load. I have tried input.Field = null; but the previously selected values are still selected.
Get subform records
Hello I ahve an application with Shops and Contacts. A Contacts can work for many shops. Used forms : - Shops - Contacts with a subform ShopWork with is a lookup field, drop-down list of Shops called Shop I want to display all Contacts for a given Shop. Input.ID is the Shop ID. lst="" ; rs = Contacts [ ShopWork.Shop == input.ID] ; for each Contacts in rs { lst=lst + rs.ID + " " + rs.ContactName + "<p>" ; } input.ListeContact = lst ; I get some names but, they have all the same values...
Certificate Error
Not only do I have to mess around to log in, now I get "Certificate Error" warning.
International Characters not handled correctly in so many places
Good morning ! I need all Zoho Management attention on this matter. I need a fix ASAP or you will loose customers and a also me delivering services. The alarming thing I would like Zoho to get fixed is the incorrect sort order for international languages. ( Swedish .... character with åäö are last in the swedish alphabet but å and ä is treated as a and ö is treated as o. If a field starts with åäö or ÅÄÖ it gets. - Incorrectly order sorted in Views and Reports - Incorrectly order displayed in lookups
Change color of embedded Zoho-Calendar in Zoho-Creator
Hello, is there a possibility to change the color of Zoho-Calendar (like in Zoho-Mail) when I embed it in Zoho-Creator? I created a page and embed Zoho-Calendar with the following code: <iframe name='zohoview' height='800px' width='100%' frameborder='0' scrolling='Auto' src='https://calendar.zoho.com/mycalendar#' ></iframe> Because the blue theme of Zoho-Calendar looks not good with Profesional-Black theme of Zoho-Creator → I want to use grey theme. Is there also a possibility to hide the Header
Zoho Creator to CRM
I have data in my creator account that gets sent to my zoho leads file in my CRM. However, it appears to have stopped sending the data. Is there any reason for this? It was working fine previously.
go to next url
On a form I use the Go to Next URL option to select a view in the application. At the top of the screen it indicates that the setting has been saved. However if I click on a field and then come back to Form Properties the setting is changed to blank. Is there something special I need to do to get the settings to stick?
Entering data in a format similar to an Excel spreadsheet
Hi, I need to create an application where I can enter data in a similar way of an Excel spreadsheet. Is there any way of having a form that looks like a spreadsheet with multiple rows and columns? Thanks a lot!
Pre-filling forms using the Permalink
Hello, Is there anyway to cutomize the url so that some fields in the form are pre-filled so that it appears more relevant to the person filling the form? I want to send the same form link (without login require): Send to Customer A - Name field to be filled with "Customer A" Send to Customer B - Name field to be filled with "Customer B" Is this possible? Is there a way we can append something to this form link that pre-fills the value in ? https://creator.zoho.com/form/form-perma/89OK0nb0Kd4aqjnnPgRcustomername=customerA
auto-create form and run calculations
Hi - I have a Calculations form which runs a bunch of calculations on User input of a Project name. I would like a record to be created in the Calculations form each time a set of criteria is met in the Project itself (i.e. if I enter the finished length of the project, create a new Calculation record for this project and run all the calculation statements). It would also be nice if the Calculation form would update if the Project form updated and that two of the same calculation form couldn't be
How to implement AGGREGATE functions in Reports in each group
Is there a technique in Zoho Creator Report to display the Average when grouped by specific column? Say per date. Thanks!
Next Page