View
Hi, Can a "View" be customized based on user's login id? Basically, I want a user to see info related to his user id only on the view and not about other users. Thanks! V
Schedule criteria not saving
Hi, I have a decision box on a form for sending out a task reminder 10 days before the event and the schedule code looks like this: Task Reminder { Execute on 10 days before of Tasks[day_reminder == true].Due_Date at 01:00:00 } It saves fine and no errors appear but when you reload the schedule page it changes to this: Task Reminder { Execute on 10 days before of Tasks[day_reminder].Due_Date at 01:00:00 } Need to get it run the script only when the decision box is ticked..... Any ideas? Thanks
Application Ownership
I have added an administrator to my account who created a new application. While my current account states I have 10 user capability the application the new administrator created says it can only share 3 users on a free account. Since he is an administrator on my account shouldn't it be possible to share with all users? Thanks Bilmathis
Subforms on views attached to scheduled emails shows record ID
I have a form with a subform which shows correctly in a view. However when the view is attached to an email as a PDF in the schedule system the column only displays the subform record ID. Herb Wexler
CASE INSENSITIVE EXAMPLE PLEASE
I don't know coding and i would like someone to post an example of the contain() functions. i want the search field of my stateless form to be case insensitive.
Creating full-fledged app with Creator
I've set up a basic Creator application, with several tables. It's intended to keep track of application specs, functional tests against the specs, and defect reports. However, it's unclear where I go from here. I'm used to doing database apps using C# and SQL Server. I realize that one option would be to keep using C# and the Creator API to manipulate the tables. But I'd rather do it all in Zoho. So I'd appreciate help in getting started. Maybe there's a tutorial I've overlooked. Anyway, here's
crm.create doesn't seem to be working for me
Hello, thank you for your help in advance I am trying to do a simple zoho.crm.create("potentials",map) I have placed the script under the submit onclick button, but when I look in the crm I do not see the new potential added. Any help would be greatly appreciated (I also have it so you can edit the application already) it is under test/add_potential this is how the script looks NewOpp={ "Description" : input.Plombier, "Nom de l’Opportunité" : "Test!", "Nom du Compte"
Column Widths
Hi, In trying to adjust column widths I'm not seeing any significant decrease in size. I need this app to be as straightforward as possible as I have users logging in that are not very computer literate. Having to scroll through multiple pages of data is going to be problematic. Any help would be appreciated! I'll make my application accessible to Zoho staff. Thanks, Diana
I have two identical (lookup) (checkbox) lists. I need them to have the oppsite selected
Okay, I have 2 fields. Each field is a lookup field that looks up the exact same data in another form. I have them set to checkbox fields. What I need is for them to be opposites as far as what they have selected. Say for example I have them lookup the following data: (A, B, C, D) So the form will look like this (the "X" will represent a checked box and a "O" will represent an unchecked box) FIELD 1 X - A O - B X - C O - D FIELD 2 O - A X - B O - C X - D I'd like it so that whenever you check or
Limitation With Multiple Calls to Function?
I have an HTML view that creates a table with 15 x 10 cells. Most of these cells contain a number that is called from a function. If I include this function-call (line 20), the view fails to load. If I remove it, it works. If I call it just form one cell, it returns a number. htmlpage SUBSTATS() <%{ TABLE = "<table width='400' border='1' cellpadding='1' cellspacing='1'><tbody><tr><td>Mailing List</td><td>Total Subscribers</td>"; for each sec_list in LISTS [LIST_TYPE = "Secondary"] {
Lining up a Decision Check Box
When using a decision check box it lines up to the left edge even when the Field Alignment is set to Right. This makes the form difficult to read. This is the only field type with the label to the right of the data entry portion. Perhaps the label can line up with data entry portion of the other fields on the form. Herb Wexler
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com. Noticeable changes: Short Circuit evaluation is supported in Deluge IF statement - more info OnEdit -> On Validate/On Success actions will get triggered when values are updated through drag/drop action in calendar view - more info Dialogs (eg: alert/warning messages) in IE are positioned exactly in the center of the window Complete change logs are documented at https://help.creator.zoho.com/Feature-updates-and-bug-fixes.html.
Excel formula to Zoho
I'm trying to adapt the next formula from Excel to Zoho but, it changes the formula: This is the formula what I'm trying to insert: 4.6 + (0.182258 * (Kilometers * 1000) / (minutos + (segundos / 60)))) + (0.000104 * (Kilometers * 1000 / (minutos + (segundos / 60)) * (Kilometers * 1000 / (minutos + (segundos / 60))))) And this is how it channge: (4.6 + 0.182258 * Kilometers * 1000 / (minutos + segundos / 60)) Please, someone can help me, I've tried everything.
using payment form
when submit is clicked and it goes to payment, if the payment is not completed, the form still creates a new record. i don't want it to create a new record unless the payment is successfully completed. can this be done?
Find maximum date/time
I use deluge scripting to find the record with the maximum value in a date/time field. To fetch that record I have to advance the maximum value with AddHour(2). Does that make sense to anyone?
ALL APPLICATIONS MISSING!!
Logged on to my personal account this morning and found ALL MY APPLICATIONS with my data MISSING. I Tried to edit the application but no application in Zoho was found. Is there something wrong with the service??
Subform edits not persisted
After updating a form in which subform data is changed, we receive the "Data Successfully Updated" message, but sadly, the subform data remains unchanged.
On Add --> Validate : Script Action Fail
What I am trying to do is have an alert box pop up if a field value is null, but I only want this to happen once on validate and if the user decides this null field is ok then the user can submit again without having an alert box pop up. Currently I am trying: if ((input.Radio_1 = null) && (input.hiddenvalue != "nullcheck")) { input.hiddenvalue = "nullcheck"; alert "You have not completed the form are you sure you want to submit? To submit click ok then click submit again."; cancel submit;
Report based on date range
Hi, I have created an application to track jobs performed by each individual. I would like to generate a report based on how many jobs a particular person performed based on a date range and get a total amount of jobs for example: Example. ......DateRange: 06/29/2012 - 07/02/2012..................... UnitSize: QTY: Rate: Total: 3 Bdroom 8 $10 $80 4 Bdroom 10 $20 $200 GrandTotal
Trying to autofill potential using the creator
Hello and thanks in advance for the help, I am new to Zoho but know how to program. I am building a form that uses labels to find 1.a contact (using Zoho CRM label) 2. an item serial number(using the database lookup) 3. and then creating a simple activation code for a product(using a function that returns answer in a label. Now I want to have the user to create a new potential (that will be set up with a Zoho CRM label) but on creation it autofills the values that have already been input (the contact
Again, what script will the new Drag & Drop calendar date change feature call?
I'm desperately trying to negate the effects of the drag and drop feature because it does not allow me to control the manner in which users change record dates. I haven't been able to get any script to call upon a drag and drop[UPDATE: the problem was on my end...I was testing older dates that didn't have my control field value loaded.] If someone would please post here an example of calling script with the drag and drop I would greatly appreciate it.
joining two forms
If I have a form of orders that includes zip code and a form of userid/zipcode (they can service more than 1 zip code) how do I create a view that shows each userid only the orders that match a zipcode in their userid/zipcode list?
Issue with duplicate entry
Hi, I have a form that asked user choosing an id channel (a device), a timestamp and a value. I would like my application does not record the value for duplicate timestamp but only if the id channel is the same. If id channel is different, I would like my application records value even timestamp is the same. In attachments, the 1.png shows the different id channel. the 2.png shows the first record I made for id channel Z0 the 3.png shows the issue I met : The id channel is different but as the timestamp
Messages section error
When I enter in my account - Messages section, I can see the following Regards, George
service not responding
The service is unresponsive or has slowed to a crawl. Our internet connection is working fine. Please resolve urgently.
Help Writing a Script
Hi All - I have a form that I need script form and I can't get it to work. I have a series of five check boxes with the responses ranging from 1 to 5 and want to add those responses together in another field when the user enters a response. For example, if the user enters the response of "5" for each check box, I want the total of each check box to show as "25" in another field. How do I write script for that? Thanks.
Lookup fields and report
Hi, I am developing an application with lookup fields and I would like to make reports with filters from anther form. https://creator.zoho.com/kevin.loussouarn/consoadapt/# I allow access to support. In form Production -> Usine de Reims, the user select the id channel thanks to a lookup field related to Standardization form. Each id channel have a zone area and a consumption type: Z0 total A1 - South Wing - Air conditioning A2 - South Wing - Lighting B1 - Amphi A - Lighting .... Now, in report, I
concatanated Fields
I am new to zoho Creator and I am trying to join two fileds to make one filed. Example: firstname, lastname= fullname.
Update one field from another Form.
I want to Update Form C using (Form A and B). I had tried stateless Form(Form B) which enable me to update Form C . But I want to update Form A also. I needed to keep the records or history of changes made. For example, an Item may be transfered from one to three sections in a year. From Add Item Form (Form A), I had added the current section the Item is used. When an Item is transfered to another section, I will need to Update Item Movement Form(Form B). Form B is to enable me to track the
What constitutes a 'user'?
I have the freebie account which allows 2 Users, but does this include a person who can only view the file, but not edit? Thank you.
Search Function in Form
Hi, I am new to Zoho Creator. I am creating a form, which need to search the invoice number. However, the invoice number is consist of 10 digit. Is there a way I can just type in a sequence of 3 digit of the invoice number + customer ID, and I can find the record? Thanks TM
Toggle radio button to show/hide responses
Hi, I'm trying to create a form that has a series of yes/no radio buttons in response to questions. I want to hide/show a specific response to each question based on which radio button is pressed. Getting the form with the questions and radio buttons to work is easy, but I can't work out how to set up the answers to the questions and then 'call' the correct answer to display. I'm thinking there are two ways to do it: 1. Have the answers hidden in the script of the form 2. Have the answers in a separate
Calculating Averages problem for use in Reports
I am hoping that someone can help me with a way to accurately display information I am capturing in Creator into Reports. The just of my form is that the user fills in the number of safe and unsafe observations of a given activity. The sample data would be as follows: 1. 3 safe, 2 unsafe 2. 90 safe, 10 unsafe 3. 1 safe, 1 unsafe I have built in formulas behind the scenes of the form to calculate the total number of observations and then also the % unsafe of each record. So for these records
Dynamic picklist in Stateless form
Hi, I use a stateless to add or edit existing records in a master form. In this stateless form, some fields have dynamic criteria (fieldB == input.fieldA). My problem is when I need to fetch records from Master Form. I open StatelessForm with : #Form:myStateless?myID=1234 Script in StatelessForm > OnLoad : myData = MasterForm [ID == input.myID]; input.fieldA = myData.Country; input.fieldB = myData.Town; As fieldB has a dynamic criteria, the value stays on "-Select-" instead of MyData.Town. Is it
Provide EDIT option for CRM integrated tasks in Deluge script builder
Hi, As of now, all CRM related tasks in ZC apps are performed by manually typing the code eg: <CRM Response> = zoho.crm.create(<CRM Module Name>, <Field values as map value>) <variable>= zoho.crm.searchRecords("<moduleName >", "<criteria>", fromIndex, toIndex); These are working just fine.. However, we dont see a EDIT option, for these lines of code in scripting mode. Not all are code-savy. Having this in script mode will make things easier for not-so-code-friendly-people as well What does the rest
Calculate Based on Field Entry
Hi, I have a formula I am working on to calculate a weight/score for a particular entry. Basically the part that is giving me trouble is that if there is an entry in the "Program_Manager_2 field, i need it to divide the weight/score by 2 and then multiply by .8, if there is NO entry in Program_Manager_2 then I just need it to multiply by .8... This is the formula i have been working on (I have highlighted the parts that I think are wrong): if((Program_Manager_2 != ""),(Staff_Requirement
Exporting of reports in spreadsheet format
Currently, reports cannot export in spreadsheet format, only PDF. This is not helpful. I can create a regular View with groupings, then export that to spreadsheet format, however, that doesn't give me the aggregated grouping I desire and get with Reports.
Get ZOHO Ticket using PHP (CURL)
PHP GET ZOHO TICKETS I had to search high and low to get this information. I was not easy and finally I managed to do it. Without a ZOHO cookie capability there has to be some way to track users who are logged on through ZOHO's own user management system. The following PHP program can be used on your own server. It requires the CURL module of PHP to be activated. CURL allows you to send POST and URL inquiries to other applications. In this case we request ZOHO to give us an API Ticket number
Amazon SES Now Offers SMTP
I'm using Amazon Simple Email Service as the backend part of my ZOHO Creator app to send thousands of emails per month (see buzzable.info) - way beyond the email allotment from a native Creator app. Just today Amazon announced SMTP support. So I'm wondering if ZOHO Creator's email service could be configured to use another SMTP service? I'm not familiar with how SMTP works, so also comment on the server resources. John M. Whitney
Bulk import in Grid view.
hi, Can i have a use of bulk import functionality using Grid View. Please help me out, im not able to get it. Thanks in advance.
Next Page