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
Convert dropdown values into decimal number
Hi I have a dropdown menu with this values: 1 1,5 2 2,5 But I cant work with this values as number I tried with toLong() but it does not work with decimal numbers. Thanks in advance
Problems with Custom Themes
When I change the theme choosing to create my own (Custom theme), the chosen properties are not applied and I get a sort of text+hyperlink version of the UI (see attachment). Sometimes saving the application, after changes to the custom theme, takes a very long time (3-4 minutes and the changes are applied but then if I logout and in again I get back the bizarre UI. I use Firefox.
Auto-compile date-time field when other field's been modified
I have a field where to manually input a number. I need a date/time field to be automatically filled up with current date/time when the above field has been modified. Thank you, Gianluca
Conditional field labels?
I have two fields on my form: Country and State/Province. If user selects "Canada" I want the field label for State to say "Province". I the form definition I added the following code but when I go to save the script, it never stops saving. Am I doing something wrong? Thanks, Jeff
Enhancement Request: Conditional field labels.
I propose an enhancement which would allow developers to conditionally set field labels on forms. Example: if (input.Country=="United States") { displayname = "What state do you live in?" } else { //Canada displayname = "What province do you live in?" }Thanks, Jeff
Create CRM Event from Creator
I am trying to create a CRM Event from Zoho using the following function: response = zoho.crm.create("Events", { "Owner" : "carlgifford", "Subject" : "Test", "StartDateTime" : "08/01/2012 10:00:00", "EndDateTime" : "08/01/2012 10:30:00", "WhoID" : input.CRM_ID }, 2); It does not seem to be working, I am thinking that the date formats are incorrect. How do the dates need
About toDate(), why the "15:00:00"?
I've put a Formula field which converts a time (which holds date and time like "May 5, 2011 18:08:01") to a date ("May5,2011"). I used "Deadline.toDate()" to achieve so, but it always gives a time like "May 5, 2011 15:00:00". Why the "15:00:00"? Shouldn't it be just "May 5, 2011"? Please help. Thanks very much!
can HTML be added to related list for contacts using custom functions??
Hello, I need to display some data associated to each contact on the contacts page. So,is it possible to use an iframe in a related list or load html into the related list directly?? I didn't find detailed information regarding custom functions for adding new related lists. Please suggest some examples regarding the same or some workaround if its not possible... Thanks
Looking for a ZOHO Creator developer in Amsterdam area
We are looking for a ZOHO creator developer in the (greater) Amsterdam area NL who could develop a relatively simple Assignment Tracker System for Master Students fo a University department. Please respond to this message if possible.
Xml rpc update on a field in a form with subforms failed
Hi i am trying to update field in a form with couple of subforms. When i try to update the field after payment i get weird errors that are not related with the form i am trying to update, but instead it is related with subform in this form. I tried removing this subform but then it gives me same error with the next subform in the form. My question is, does zoho suports update on a form with subforms ?? Or this is some other issue. I checked the code multiple times and there are no errors in it. This
How can Admin see every record with zoho.loginuser active
I have a form that my salesmen use to ask for maintenance for our customers. I used a zoho.loginuser so that each salesmen can see ONLY his entries. Once they submit a form, I have to edit the entries in view mode, in order to let them see when I've processed their request. PROBLEM: I can't see their entries because I'm logged in too, but with my userId! So I could see only my entries (which I don't need...) Any suggestions?
System restore has not restored data
Hello, I have done a backup of my application 'KiwiOz Childcare.' I have then completed a Restore and renamed the application kiwioz_restore. However, in the restored application kiwioz_restore, none of the data has restored. I have also backed up and restored my other application (Cafe Nanny). This restore worked and the data was restored. Please advise, thank you (I have allowed edit access to support for both of these applications).
webhook keeps firing
My webhook keeps firing every 10 minutes, instead of just once. It is configured with a workflow action on create/edit that checks the existence of a (custom) field, and fires if it is true. The webhook service returns an empty response with status 200 OK. It completes in 10 seconds or less -- btw, what is the timeout on webhooks? It has fired 15 times now in the 2.5 hours since I "tested" it by saving a record, firing every 10 minutes with the same data. There is nothing listed in the errors tab.
How to sum up pre-added field?
Please see photo, i need to total every amount that is added on the subform. Hope you guys can help me asap. Thanks.
Issue with deluge script executing in a sub-form
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in when editing the
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field I don't think Zoho has an explode type function
Can't use dropdown form fields as display fields
Hi, I have a SERVICE subform that has a SITE look up field. I want the SITE lookup to display the site name and site address. However, when I go to Edit Field ->Advanced Options -> Display As, I do not see all the SITE fields. The ones that are missing are the dropdown fields so I cannot select site address. Note, site address is a dropdown in the SITE form. Is there a way that I can use the site address field as a display field in the SERVICE form without making the site address a textfield in the
Sending notification from one app using email ID of another
I need to send notification when data is entered in one application to the email ID of registered users of a different application.
Refresh Fields Within A Form Without Reloading or Submitting the Form
Is there a way to refresh fields within a form without reloading the form? Problem #1: I have a Jobs form. And I have a Contacts form that is linked to a contacts database. Within the Jobs form, there are two places to look-up contacts and add them into the Jobs form. But one of the places also allows adding a new contact. When I add a new contact at this place it does not appear in the look-up list for the other place. I need a field.refresh() option to refresh the look-up so I can see the
allow shared users to have edit or add permission to records
Hello, How do you give edit/add permission to shared users on your application. I would like to be able to allow users to add or edit records on certain form or view. I did not see any functions that allows me to do so. Please advise. Thank you
zCreator Emails are treated as junk by Microsoft Smartscreen Filter
Dear zCreator Team, I would like to bring to your kind attention that zCreator emails are being treated as junk by Microsoft smart screen filters. ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
Convert string to numeric?
Is it possible to convert a string or portion of a string to a numeric variable that can be acted upon in a function? E.g. I want to take a string like "5 - High", extract just the "5" substring and create a function to multiple that by a separate numeric value. Currently failing because the substring is still a string. Thoughts?
Layout of Charts and tables
Is there any way to have headings in a table or chart wrap so I can make the columns smaller but still read the headings.
Next Page