Using the calendar view to show durations
Hello, I'm a new customer of Zoho and I must say - I like it a lot!!! Very powerful application platform. I have a question: I'm developing an app to help me share some tasks with my team. I have records that has the fields: "Task", "Start_Date", "End_Date". Is there a simple way to show a calendar view that will put the "Task" field across all the days between the "Start_Date" until the "End_Date"? For example: If a task called "Test Zoho site" starts on Monday and ends on Thursday, I want it to
Viewing form entries as forms after saving?
I'm having trouble figuring out how to view the data saved in the spreadsheet in the same form structure it was created in? I was hoping there would be a way to switch the view back to the form after saving for printing, emailing or converting to a pdf? I'm also wondering if there is a way to have the form embedded on my website and when filled out a copy of the form is emailed to me? Thanks Phil
Slow replies from Zoho support?
Hi, I am getting a bit frustrated with the slow replies from Zoho. I have sent about 20-30 emails to support@zohocreator.com over the last few months. None of them were answered within 7 days and many of them were never answered at all, leaving me to fend for myself. What is Zoho's service SLA? Does anyone else find this or is it just me? Any tips on how to get a swift reply? Usually what I do is create a forum topic (so that other people with the same problem can find the solution) and use the 'email
Form On User Input Not Evaluating
One of my forms stopped working. When adding a new record, everything worked great. But when I edit a record, things stopped working. For example, I've deleted my entire On_Edit->On_Load script but many fields do not appear when the record first loads. Furthermore, when I edit a field, the On_User_Input does nothing while editing a record but it works fine when I'm adding a record. How do I fix this very strange error?
Migration Tool Error
I'm trying to upload an MS Access Database to Zoho Creator, and I get the following error: " at line 52, column 28. Was expecting one of: "-" ... <NUMERIC> ... <DECIMAL_LITERAL> ... I've searched the forums for similar issues and the errors that come the closest to this one are related to an ID field that must be manually removed. If that's the problem, how can I find the field that should be deleted? I'm working with a template and I don't know where everything is placed. Thanks!
link to crm
I am new to Zoho does creator have the ability to link with the crm data?
Importing Data and on success scripts
I have a form to submit payments from my clients. When submitting the data , a on success script updates some fields in another form. While importing data from an .xls file, will the above mentioned script work for all the records Will be imported?
Send an email containing data from three forms
I need help to create an email comprised of data that exists on three different forms, all of which have relationships between them. Specifics: The email address the email is to be sent to is on the DONOR form. The email is triggered to send via a checkbox on the DONOR form. The email needs to include data located on the WISH LIST form. The email needs to include data located on the FAMILY form. Relationships: The DONOR form has a lookup field to associate donors (DONOR form) to families (FAMILY
Are multiple Forms for the same table somehow allowed?
I need to have several different forms available to enter data into the same zoho 'form' or table. The reason is that I want a simple form with only essential fields in one case and a full form in another case with all fields and some for in between. This is for different users of the system. I can hide or show fields conditionally in the 'on load' script based on the zoho.loginuser Just wondering if there is another way such as creating alternate forms for the same table and then changing the
Bug when importing a Deluge script file
Hi, I've found what appears to be a bug where a particular part of a form is lost when exported and then re-imported. Here's the issue: When using a lookup field, and checking the "Show a link to add new entries" box, the exported .ds file will contain this: allow new entries = true [ displayname = "Add Example Data" ] But when re-importing this file, those four lines are missing. This means that there will not be a link to add new entries in the lookup. Is this a known bug with Deluge script import?
Updating script. . . never ends
What does this mean when trying to update a script? Specifically, I am updating a form script on edit / on success. When I try and navigate away from the screen it warns that I will lose changes and indeed they are lost. I am trying to isolate the offending line, but it is difficult because of dependencies between different lines re. referenced variables. Regards . . .
Font color is wrong.
When I try to set red color by editor to the text in rich text field - I see dark green :) second (red) line was added by inserting HTML. If we look inside we will see: <font color="rgb(255, 0, 0)"><b>should be red</b></font> - by editor<br> <b><font color="#ff0000">should be red</font></b> - by inserting HTML Could you please repair it?
Now I have One Column instead of two.
I built my form, the made it a "Stateless" form. Now it is all out of whack and in "One' column. What happened?
How can I prepopulate one form with data that has been previously entered in another form, in another application?
I have seen this https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form from the help center. But apparently it is only used for the same application. Please help thanks.
I would like to create a report that pulls data from two tabs
Hello, I would like to create a report that pulls data from two tabs. Is that possible? More specifically: I have two tabs: Tab 1: Where information on each round of investment in a company is entered Tab 2: Where general information on the type of company is entered I want to be able to sum the data from tab 1 (amounts, etc) but using data from Tab 2 as well. Is it possible to create reports while sorting data from 2 tabs? Thanks!
RegEx trouble
I copy&paste texts into ArticleText field (rich text) from word documents. Due to text is always long, I create for a ArticleText View - ArticlePreview formula field, which should keep first 100 symbols of ArticleText field. Formula calls function getPreviewText(ArticleText, 100) Due to value of ArticleText is not a clean text, but html formated text, so I need to clean it from tags by string getPreviewText(string srcText, int len) { str = "<(.|\n)*?>"; input.srcText = (input.srcText).replaceAll(str,"");
Edit display of formula results
I have a formula that uses a conditional expression to determine how to divide the numbers in another field. I want the results to display as a percent. How can I control the display of a formula results (e.g. control the decimal places, convert to percentage etc.)?
Best Way to Invite Many Users to an App?
A related topic https://help.zoho.com/portal/en/community/topic/register-without-email is under review (account provisioning). However, I'd like to know what others have done to get a large number of people signed-up with Zoho Accounts. Cheers, John Whitney
Send e-mail based on StartDate Field
Hi, I would like to send an e-mail notification containing Form data related to Startdate. For example, I would like to send e-mail listing all records that have a startdate of 3/18/2013. All records occurring based on the StartDate filed.. -----Email------ StartDate Unit Assinged 3/18/2013 231 Megatron 3/18/2013 605 Optimus Thank you very much
Strange Error Message
Attempting to identify what code would be impacted by changing a field-type, I got this. Cheers, John Whitney
Unable to Fetch data from form
any idea? We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
Creating a Form which can call data from another form
Hi, I have created a database which is essentially, like an excel spreadsheet, with columns defining variables, and rows of data. I was wondering if it were possible to create a stateless form, which when a user selects a certain record e.g. title, the form then calls data from that record for certain fields. To explain further, incase I am not doing it well. I want a user to be able to go onto the form, select a title, from a dropdown box (the titles are stored on the database), and then when they
Is there a way to add a custom action to the predefined all contacts view???
Hello, I need to synchronize data selected by the user (single or multiple) in the contacts view to my database using a web service. So i need to add a custom action or a button if possible.Is it possible to add a custom action to a predefined view(e.g. Contacts view) ??? If not please suggest me some workaround for it... Thanks
How to transform rows to columns in view
I'm exploring online database solutions using Zoho Creator and so far, the experience has been quite good. We're hoping to pilot the solution and if accepted, upgrade to a paid account. However, one of our databases requires a particular view. I understand that each entry is displayed as a row, and the data for each entry is displayed in columns. This works for one of our requirements. But for another requirement, we actually have only 13 entries with quite a lot of data for each entry--about 30
How do I add a form to my website?
I would like to add a form that I created in Creator to my website. Is this possible, what are the steps. Thanks, Brad
Our Scheduler Doesn't Seem to Work
We have a couple of nice, simple email functions whose scripts execute flawlessly, but we can't seem to get them scheduled using the Scheduler. As "When" we set the date and time with a "daily" frequency, then set "What" as a call to our email function - thisapp.emailoverduereminder.EMailOverdueReminder(); Never happens. Never occurs. First of all, why does this fail? Secondly, can we set the date for some day in the past; meaning the schedule will automatically occur today at the determined time?
Subform and form relationships
Hi Everyone, I have am working on an order tracking app. This is for tracking orders for items which require custom production (not just items off the shelf). I have an Orders form, which generates an order ID for each entry, and within it a sub-form for Items. As each one of these is a custom job within the order, I have been trying to import the order ID from the parent form into the subform, but if I do a standard lookup, it makes a dropdown of all the IDs in the Orders table. Is there any way
Create CRM Event from Creator
I am trying to create a CRM Event from Zoho using the following function: crmEvent = zoho.crm.create("Events", { "Subject" : input.Name_of_Patient, "Start DateTime" : input.Time_of_Appointment, "End DateTime" : input.Time_of_Appointment, "Type" : input.Type_of_Appointment, "Project
Setting values and display when creating a drop down
Hi, The script below runs when a JobID is selected on an invoice form. It creates a dropdown of all the customers associated with the job. The dropdown is of names only, which are the keys in the "contacts_map". What I really want is to display the contact names as display only, but have the ContactID as the value held to the form. <select> <option value="ContactID">ContactName</option> <option value="ContactID">ContactName</option> <option value="ContactID">ContactName</option> <option
Download attachments
I've created a form in which appliacnts have to upload some documents - is there a way of downloading all the documents in one go? The export option gives me atable of their details, but not the documents they have uploaded. I can access each document by clicking on the link in the form, but I'd rather download the whole batch.
What do I do so that 00:00:00 is omitted from date fields?
When I import my spreadsheet to Zoho, it works beautifully except the time stamp that appears in the date fields. How do I stop it from doing this?
Can I embed a zoho report to Add Notes field？
Hi Akash I don't want to jump to open a html view for display a report, like embed in a picture to Add Notes field , embedded in a report to Add Notes field, I tried the following code, but it can't work： plain ="<iframe height='500px' width='900px' name='zoho-report' frameborder='0' scrolling='auto' src='http://creator.baihui.com/stanleyguo/theone/report-embed/report/'></iframe>"Hope get your help.. by the way the Add Notes field extremely useful. Thanks Stanley Guo
Add new records inline in GridView
One of my clients wants to request the functionality in the below screenshot. Use Case My runs a softball fan site (TheInsideCurve.com). He wants to crowd-source the data entry so the fans can put in the schedules for leagues rather than him having to do it himself. Ideally, the fans would be able to bulk add several matches at the same time. Grid View seemed like the best way to achieve this but unfortunately you cannot add rows 'inline' in Grid View. It would be great if Zoho would consider this
% of total in report column showing value when data is zero
I have a report in which I am showing a whole lot of specific activity across a large number of items, and I want to show the % of the total for each item based on the total activity for that item as a share of the total for all items. Sometimes this seems to work, but in many cases the specific % is irregular. For instance, if there is no activity value in a particular item (0). It lists this item as .39% of the total. Other times, there is wide disparities in the amount and the % value. For example,
Can't insert user in Zoho Creator with API
I have a custom app built in zoho creator where 1 field is an accounts field in Zoho CRM. I can insert into every field using xml and cURL but I can't seem to get the user right.. I get this error when trying to insert in the field "User" Failure, Invalid column value "Test" specified Where Test is an EXISTING account. The strange thing is that there are 2 actual fields but 1 visible field. User is visible but User_ID is invisible.. not sure if that has to do with anything. But that's my problem..
Help passing a parameter to an HTML view with a view embedded
I want to pass a paramater to a view that is embedded in a HTML view. Below is the code for the "on submit" action from the form in which I wish to pass the paramater from. form_link = input.Form + "_HTML"; if (input.Search_Options = "Yesterdays Records") { openUrl("https://creator.zoho.com/jpiajr/food-safety/view-perma/" + form_link + "/todays_date=" + input.Start_Date + "&Added_Time_op=58", "same window"); } if (input.Search_Options = "Date Range") { openUrl("https://creator.zoho.com/jpiajr/food-safety/view-perma/"
Set Email Notification on Edit
Can a feature be added to send a formatted email on edit or delete. This would be identical to the Set Email Notification on Add. There have been several applications where an audit trail is needed. In these cases I have used a sendmail script to list all the fields. This works but it would be nicer if I just have to check a box to get a nicely formatted email. Herb Wexler
Creat a Rule
Hi, I apologie if my english is not too clear at times (its not my primary language) I would like to ask the following: Having two fields as shown on this picture I want to make it so that when you select "Finalize" it turns the last field ( shown as Number) into required field validation! Is there a way to do this? Any help is very much apprecited. Best regards.
A question regarding subforms
Hi. I am building a simple project management application and have run into a problem. Background: My application consists of 4 "objects". These objects are: Projects, Activities, Employees and Roles. Every project consists of several activities and every activity has several roles. Each role is connected to a employee. I want the application to have 2 "tabs", "Projects" and "Employees". The problem: The activities are created within the "project form" in a subform. I want to create the roles while
Show value upon User Input (Auto-Fill)
This should be easy but I am not completely familiar with the zoho scripting. I have two form: CARE STAFF MaxValueCAREstaff When you input a new staff member, the maxvaluecarestaff.CARE_Staff_Number gets 1 added to it, thus giving the next staff member a unique staff number. This works fine but I want the input form to show the current staff number. Right now there is a single line number field for STAFF_Number which is assigned the current MaxValueCAREstaff.CARE_Staff_Number value. I don't want
Next Page