Questions about date/time fields
1. Is there a way to get date from a date/time field? For example - <datetime>.toDate() 2. Is there a data entry control or field to enter time of day?
iCAL Feeds
This has to be my favorite topic! I have finally identified why the ical feed is not fully compliant with many ical subscription services. There's a blog about this here: http://blog.jonudell.net/2011/10/17/x-wr-timezone-considered-harmful/ 1. X-WR-TIMEZONE non-standard advisory timezone property. 2. The iCal feed uses 'floating' time for the events and not VTIMEZONE This is a bug in the iCal feed. A fix would be to use an iCal feed that either does not use X-WR-TIMEZONE and/or uses non-floating
New ZC Variables for the iCAL Feed
I have tested various popular services that support ical subscriptions by url: Google Calendar, ZOHO Calendar, Famundo, PHP iCalendar, and k5n Webcalendar. Google, ZOHO and PHP iCalendar adjust the displayed events based on a selected timezone. Famundo and Webcalendar take the timezone from the ical's feed. All services use the original Creator view name for naming the calendar. For greater compatibility, I'm proposing two new ZC variables for the construction of the ical's url. ZC_timezone overrides
Support Specified UTC Timezones for iCal Feeds
ref: https://help.zoho.com/portal/en/community/topic/new-zc-variables-for-the-ical-feed ref: https://help.zoho.com/portal/en/community/topic/support-named-calendars-for-ical-feeds Please add a new user-definable variable for constructing an ical url that enables the definition of a calendar's timezone. Currently an ical's feed value for X-WR-TIMEZONE = UTC. I understand this offers the possibility of portability for the ical feed, but I have found a number of ical parsing calendars that fail to
iphone calendar not respecting timezone of ical feed from Zoho Creator
I have been able to subscribe to the iCal feed of a Zoho Creator view in Google Calendar and the events appear at the correct times. (That said, the feed is very infrequently refreshed by GCal, which makes it next to useless for our needs, but I assume that is not something within Zoho's control.) However, subscribing to the same Zoho Creator iCal feed directly in the iPhone Calendar app results in the events all being displayed 10 hours behind where they should be (i.e. UTC instead of UTC +10).
Always show record count
Hi, Is it possible to change the default view in any report to always show the record count? Right now it says "1 of Many" and I have to click on it to get the full number of records in a report. This makes no sense to me - why do I have to click to get the total number of records currently in my report? I'm a new Zoho Creator user with little to no coding experience, so I appreciate any help or explicit instructions! Thanks!
Error in Add Record Script
I am trying to create a record automatically in a form 1 by looking at records in form 2 that don't exist in form 1. I wrote this function (CreateClientIfNotExisting): Which is called by another iterator form called UpdateClientsFromKYCs as below. But I keep getting the following error: I don't get any additional info on what the error could be. Kindly help. Piyush
Trigger a Form from another Form (Inline Frame)
I have two key Forms (A) Which is a set of dates with associated prices and (B) A simple form to request a quotation Both forms are displayed on a web page as iframes (one above the other). Ideally I want to be able to select a date form the calendar form, then pre-populate the quote form with the specific data from the calendar form (eg - date, price & location). Whilst I could build a field in the calendar form as a URL to call the Quote form with pre-populated fields, I dont see how I could do
Some Organization Users See a Different Home Page
My home page looks like this: Some of my users not see the "shared with" dropdown. This is what they see: I think they accidently signed-up to the free creator version rather than thru my group invites. Support: If any users under the domain @siigroup.com have a free creator account, please terminate the trial subscription. This should give them the normal homepage above. It's causing lots of confusion about where our application links are! Thanks John Whitney on behalf of SI Group
Multiple customers with multiple users at each site
Hello, I am rewriting a program that I have been selling for 20 years and am wondering if I can use Zoho Creator to do it. What I have is multiple sites with each site having multiple users. I need the data from each site to be accessed by only that site but by multiple users at that site. Is it possible to do this using Creator and if needed the Customer Portal? Thank You, Paul
Create Pivot Table rpt always displaying specific date range
Hi, is it possible to create a pivot table report that always displays a date range between days of the week? I would like to create a pivot report that always show the records between Friday of last week and Thursday of this week without specifying date Ranges. I would like to embed this report along with other summarized data in a stateless from as a Dashboard. I have the dashboard configured the way i would like it so I just need help figuring out how to automatically display Thursday through
Date validation in a Subform
Dear All, Maybe an easy question but how can I validate, if the date in the first row is bigger than the date in second row then to give me an alert?
Oho Creator Image Size Limit
We have a real issue, our Zoho Creator form can only allow images to be uploaded that are less than 1MB in size. No one notified us of this, yet we require high resolution images to be loaded into the CRM as part of a form we have created. We do not store the images, but require them as part of an application process. Is there any way we can increase the 1MB allowance for images because it's a fundamental part of our business? I don't understand this limitation as 1MB is such a small file size.
Fetch Records dialogue box loading problem
I experience a problem every time I try to drag the fetch records in script builder...the odd thing is that it only happens the first time I try. When I reload the page then it works, but when I try the first time, the screen goes dim but no box shows and I am unable to do anything except reload the page. It seems to happen each and everytime. Now I realize I need to save my work before I try to add a fetch records line, at least on the first attempt, but sometimes I forget and end up losing work.
Importing Zoho data tables into JMP
Is there a way to import the Zoho data tables directly into BI applications like SAS JMP. I know I can be exported as CSV file and then read into JMP, but I am looking for a way to directly access the data using something like a ODBC connection
Cannot change primary email
Hello I am logged in as our administrator, but when I try to change the email address of the adminuser (the address we want our customers to see on automatic email notifications) it tells me to contact our administrator eddy@habidapt.com. I don't understand as I am logged in as eddy@habidapt.com. Advice please Screen shot of the error Thanks Kirby Wanner
Which app to use for Job Applications database?
Hi all, New here, so a real beginners question: I want to build a database to store resumes, which are to be entered through a form (name, DOB, eduction, desired job, etc), so as to search that database later on. My question is which of the available apps should I use for this? Thanks in advance.
How to change address of application?
Hi, I just created a new application on Zoho Creator, and the link to the application is https://creator.zoho.com/douglas42/<application name> I never choosed this douglas42 name. Can't I change this name to another one? More pleasing to the eyes of the customer?
emailing attachments help please
Hi Within my form I have a subform that holds uploaded documents, PDF, DOC, JPG doen not matter what format. I do it this way so I can upload multiple files. What I want to do is send an email from within my form and attach the document stored in the subform. What do I add here The document subform is called Files The field within the subform is called Documents So what do I add, anyone know please sendmail ( To : input.Agency_Email From : zoho.loginuserid Subject : "Message
http://js.zohostatic.com/creator/ZOHOCREATOR_Aug_04_2009/js/zcliveapp.js
A javascript error here: http://js.zohostatic.com/creator/ZOHOCREATOR_Aug_04_2009/js/zcliveapp.js is preventing all of my team members on Windows Chinese OS to fully load the pages. They are all located in China
New Form
If in a form(Form1), if I select Yes for Order_Complete, I want a new blank form(Form1) to open to take the new order. Can someone help?
dynamic picklist from mutliselect field
Hello, I have a question if it is possible to create a dynamic picklist when choosing from a multiselect field. In more detail, I want to classify the industrial sectors a company belongs to (using the european NACE codes). When selecting multiple sectors, a more detailed list of more specific sector criterias should emerge in a new multi select field, but only options that corrspond to the selected sectors that have been chosen in the first place. I have 4 forms: industrial_ sector_level1_form Field: level1_sector
URL without any html tags from URL field
Hi, I am trying to extract absolute URL from a URL field. I was trying with below code as refer here. But it doesn't extract exact url but with double quoute ("") in both side like below : -- "www.acrossplatforms.com" expected output should be : www.acrossplatforms.com code : web = input.Add_TV_Website; value1 = web.getSuffix("href= "); value2 = value1.getPrefix((" target")); Please help me to figure out exact code . Thanks Arfater
How do I search with multiple fields (free version)?
I created a simple database, and I want to search for relational topics in a category drop-down (or if then) approach. I only see a simple search box, but I want a complex way to search for my data. I want to search for Student Age: (drop down to age I want to choose: 13, 14, 15, 16, 17, 18+), then Pregnant: (drop down to yes, no, parenting, no children), then to Housing: (drop down to foster, group home, family, friends). I don't know how to find this search, but I signed up for ZoHo because it
Do not filter dropdown when Criteria field is Null
Hi, I am trying to create an order form - I have a Vendors, and those vendors offer items, which are stored in Vendor_Items form, using bidirectional (Vendor Items is a subform on Vendors). My subform in the Order Form for Items Requested has Vendors and Vendor Items. I would like to filter row.Vendor_Items by the row.Vendor, but ONLY IF a value is put into row.Vendor. If they have not put a value into row.Vendor, I would like all of the Vendor Items to be available. Is this possible? Any
Order List by more than 1 field in HTML Page
Hello, I have a HTML Page that I am using to generate a report FOR EACH record in my database that match the specified. Everything works fine however I am trying to order the list in by "input.Department " AND "input.Last_Name" Please see below Thank you PaymentList = PaymentDetails[(((Payroll_Period = input.PeriodID.toLong() && Employee.Type = input.Type) && Employee.Work_Location = input.Location) && Employee.Department = input.Department)].distinct(Employee); <-------- this is what I need to
Hide field No working :(
Hi :) I want to hide field when lookup equal specific option. in my case when Account lookup = "Assets" hide "Amount Code in "Account" on user input : if ((input.Account).toString() == "Assets") { hide Amount; } The surprise is No Working
Summary View layout helps resources
Hi Im trying to create an invoice using a summary template. The user help shows a very nicely laid out invoice template but not matter how much i try I am struggling to get things to lay out correctly. Are there alternative sources of help/support that might delve into the layout methods in a bit more detail? Also trying to work out how to create a calculated field so that I can show a invoice total, VAT etc. Thanks
Sub Form Insert code
Hi, I need some support adding subform records through script. would this be the way? motherform_record = motherform [ID=<record_ID to add subform row to>]; insert into moderform_record.subform_name [ Added_User = zoho.loginuser field_1=<field_1> field_2=<field_2> ]
Sub-grouping?
Hello, I would like to make a two level hierarchy with grouping, involving two different fields (one contained in another). Like this: - Project ABC - Clients (reports) - Employers (reports) - ... - Project XYZ - ... - ... Is there any way this is doable? Thanks in advance, António Caetano
Display Today's date in record summary?
Hi, Is it possible to get Today's date in a record summary? Using ${zoho.currentdate} to achieve this would be awesome. ** Workaround would be to have a hidden field and update it using the scheduler. Damien Cregan Hire an Expert
Fetch record and update same record without creating duplicate record.
Hi zoho users and employees, Ive created a timekeeping app for employees (users) to log hours during a specified pay period. In this application, I am working towards creating a dropdown that would act as lookup to the same forms records. Once the pay period is selected, a fetch command would be used to autofill the subform "Tasks and Hours" based on the criteria that zoho.currentuser = input.Name and payperiod = input.pay period ie.(fetchx = Timesheet [(Name == input.Name && Pay_Period == input.Pay_Period)];)
print/view the form (view) - structure view of report entry
Hi, I'm really new using zoho and don't have much time to study the programming of zoho. Therefore I have a simple question. Is it possible to have the same print layout for a particular report entry as the layout of some form you add the data to? I know that it is possible to print an entry using the "normal view" via the print option in a report but in my case the given layout is really unstructured compared to the form layout, where you can at least add fields like "add notes" to structure the
How to pass referer in heading from HTTPS?
I set up some bucket policy in Amazon S3 to restrict access from specific website, in my case from my application in Zoho Creator. I understood that the policy can work properly only from HTTP sites, since the referee cannot be sent from HTTPS as normal behaviour of the browsers. However I'd like to force to open those files at S3 from my links in my App in Creator. Can I pass these info somehow? The below scripts is working if I use my terminal window, so I can say the only thing which is missing
Printed form
I need to create a form to print with fields positioned in specific order. Basically I need to create a purchase order based on a table (or form in ZOHO) so I can print it or email it. I haven't found a way to do this. All reports I see are list or grids that show the information in a report style form. Thanks
zoho creator - can not export to a PDF
I am able to export any of my tabs (form views) to PDF except for one...instead of linknig to an open PDF option, it links to a blank html page....am i only allowed to export only so many pages to pdfs?? (i honestly doubt that is the case)..what am i doing wrong? or is there some kind of error on your end in which it should not be doing that?? i have tried everything: logging out and back in, restarting my computer, save as.., etc... please help ASAP? adam
Cannot add field to form
Hello, I have tried two days ago to contact support with the request marked as URGENT and no response. When I am in my form and drag SINGLE LINE as example across it will not create a new field just stuck on the default adding item message. Can anybody help? YES I have tried multiple browsers YES I have cleared cach/cookies history on mutliple browsers and tried YES I have tried another form and able to do so there but just not on this one.
how to take first N characters in each line of MultiLine?
hi there is MultiLine in form for automatic correction of manual input need to check entries how to take from each line first 8 characters? in characters will be text, numbers and " ". these 8 characters will be using in list manipulations - search for duplicates, to correct input data
Mobile Creator
I've been using mobile creator since Pleasanton Zoholics and have a lot of feedback to offer. Where would be best to share with you all my findings?
view filtered by a URL passed paramter
Hi, Is it possible to filter a view with a url paramter for a speciffic field without that field actually being displayerd? for instance, think of a view containing Employee group, Name and Last Name. Say I want to display all the names belonging to certain employee group selected by the user. It is easy to create a URL with the parameter of employee group desired and this way only those names in the desired employee group will show up. The issue is that the employee group has to be displayed for
Next Page