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.
Calendar view: if StartDate = EndDate, event not displayed ?
Hi, in the new calendars, we can choose StartDate and EndDate. But if we have an event on one day, means StartDate = EndDate, it's not displayed at all in the Calendar. It works with 2 days minimum. Any suggestions ? Thanks ! Cyril
how use together zoho creator and zoho calendar?
Hi i use for order entries a date field (date of order performing). how can i unite together creator application with zoho calendar? for viewing calendar view of orders thanx
Short circuit boolean evaluation
Good evening... I was wondering how creator handles boolean evaluations, does it use "short-circuit" evaluation? What I mean is if I have the following statement: if (a || b) { ... } Then if a is true it will NOT evaluate b and execute the if block (a or b could require counting records that meet certain criteria or other complex operations). Similarly, if I have: if (a && b) { ... } The if a is false it will not evaluate b and skip the if block. Thanks,
Lookup Function
Hi, I am using lookup function to pull a field from another table called "Info Part1". The field that I am pulling has many records in it. Some of the records are duplicate. Now the lookup function is listing all the duplicates on the drop-down list. Is there a way to just list unique records in the drop down. Please see the attachment for details. Thanks! Vishal
Employee management System
hey, There was an application called Employee Management systems. I am not able to find in the Market, can any one help me out. thanks in advance.
Cannot delete records from a view
Hi, I'm trying to delete all records from a view (we're developing and all data is wrong). I do from views, checking all records and clicking Delete option. But, the system keeps thinking all time, showing the "Loading" message, and nothing happens. I've tryied to remove all possible relations (has zoho creator something like "cascade delete"?) but, nothing. Please, are there something else that I have to keep in mind? Thank you.
Slow iframe
The iframe form loads very slow on our website (it's a non-US site), compared to the rest of the page. The script is very basic so that does not slow down the application. Is there any alternative to using an iframe? Some online database systems offer a javascript code to embed as opposed to an iframe which seems to be much faster. Is this possible?
no more email sends:
hi, i hv face a problem whwn i m using a email field in build custom field in app @ adds-on in zoho creator..after sending a one/two mail this field become unresponsive .no mail can send to any one what actually the problem it is pls short out this problem.. thanks
color text as a return value of an IF function?
Hi, Is it possible to have color text as a return value of an IF function? for example, i set up a priority level. "RUSH" should be red. makes sense thanks
Is multiple simultaneous login possible?
Can many users login and access the database at once?
upload data and radio button
I have a form with several text fields and a radio button. The radio button has two choices (Open & Closed) with a default of Open. I upload data from a spreadsheet for the text fields but dont have a column for the radio button. After uploading the data the view shows all the data accurately except the radio buttons field is blank. When I edit a record the radio button is marked Open as I would expect. Is there a way to force the radio button to use the default value specified on the form? The spreadsheet
Email Submission when email addressed to multiple users - no longer working
I have a form that allows email submission (Public). An email is sent to this form and the database is populated with the data. This has been working for about 2 years without fail. The email that comes in address to TWO email addresses. Suddenly on June 1, this stopped working. Was there a change to the email submission to not allow the system to process it if it has multiple recipient email addresses. I know that I used to have to ensure that the Zoho email address was the first address in
Create a search box on remote site
Hello all Is it possible to create a search box, where you can search on difference parameters of the database, and get results based on that. Eg. I have a database, which registers cars. Make, model, serial and location. I have a website, on which I want visitors to be able to search on these 4 parameters and then get the all the cars of the specific make they searched on, or the one car with that serial, if that was what they searched. When I embed the "view" on my site now, the whole database
Only submit form if expression is specific response
Hi, I have created a form and I have a field containing a formula whereby it compares another formula total (A) to another formula total (B). If formula total A is bigger than formula total B, the field shows a "NO" message. If formula total A is smaller or equal to forumla total B it shows a "YES" message in the field. I want users to only be able to submit the form it shows "YES" rather than "NO" (ie: if total A is small or equal to formula total B). The formula totals are simple number additions
Next Page