upgrading formula if result value is too small
I have a formula in my calculation form that caculates price from certain measurements and displays the result. (dit_x / 100 * dit_Y / 100 * dit_q * dit_pricem2).round(2) I would need to upgrade it conditionally in a way, that if the result is less then 2 it would display number 2 in the field (which is the minimum we charge). Is this possible, how? Thank you.
Scheduler and getUrl
I put the following in a scheduler: HTML = getUrl("http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_Stockholm.html?mod=topnav_2_3002_europe") ; where can I view the data?
Rich Text Data by Email
Sending a rich text email from GMail to a Creator form results in plain text data being transferred. However, if you send the email from a Creator form using the rich text editor field to another Creator form, the rich text data is transferred! I have identified that this discrepancy is due to how Creator sends an email. In most "normal" emails, there are two MIME blocks, one for plain text and one for rich text. For example, the parts will be separated and designed by this: Content-Type: text/plain;
Print customised view or form
Dear Sir I am using Zoho to keep data of enquiry, quotation, purchase order etc but I wonder how can I make up my own layout and can pull whatever data I want on a single A4? For example, how can I print the data with my own template where I can choose to pull which data I want to print out with my own letter head?? So I can print Quotation Form to my customer or Purchase Order to my supplier?? Please kindly advice Boyd
reports not updating
It seems like, more often than not, my reports are not being generated correctly. I have to always go back and regenerate the report. Is there a way to do the regeneration via a deluge scripting preferrably in in the schedule environment. IE. when a schedule is invoked it will do a "regenerate" then it will send email.
Anyone else having problems with saving scripts tonight?
Steps to recreate: 1. Views > Select a view to modify 2. More Actions > View Definition > Save Script Green message area just spins saying "Updating script..." -Jeff
Date list variable returning as a string
I have created a date list and I am trying to use the dates stored in the list to fetch records from a form. I use "for each element" and create an Instance variable called tempDate. I then try to use tempDate in "fetch records" but it shows that tempDate is now a string variable. How can I pull records that match the dates stored in my list? Thanks, Walter
On submission, can the form go back to the previous website?
Here is our website... www.newlifeinfo.com After someone fills out the forms we have online and clicks "submit", how do we code the "submit" button to make the form go back to the originating website? Right now when you hit submit, the form just restarts again with a confirmation message at the bottom. To go back to the website you found the form on, you have to click back a few times and we would prefer it to just automatically adjust back to the page before it rather than clearing the data and
Referencing a record with a lookup field
Hi Everyone.. I have been getting a lot of great feedback from the forums and its been a good response time so I thought id put this issue forwards, maybe its a limitation or maybe i'm just doing something wrong; okay so the following is my setup Regions Form Region - Single line for each region (Europe, ME, Africa) Customers Form Customer Name - Single Line Region - Lookup field for Region in Regions (Works Fine) Project Form Has Lookup Field for Customers Customer Name (Works Fine) Region - Lookup
Select Records valid for a Date
Hi, We have a form which has fields such as From_Date, To_Date plus few more. This form serves as master data which is used by other forms & application. To get the required information for a specific record from master form for any given date i.e. we would like to search for a record in master table for a date which should fall in between from & to date fields. We have tried fetch record command ( Xdate >= from_date && Xdate<= To_date) but it returns a null. The data in master is like We would
Help with script please
Hi. In a form I am working on i have the following requirement. One of the fields in the form is Date Another field is Post_Code Another is Map Now lets say I have 6 records that have say 6/4/2013 Google maps uses the format https://maps.google.com/maps?q=from:sl45sf:to:da81hg:to:me103de Now what I am trying to do is when ever I make a change to the Date field doesn't matter if I am creating a record or amending one I want the map field for each record with the same date to recreate the same entry.
Not able to set criteria
When I try to set the criteria I receive the following message: "Exception ocurred while publishing message to the topic :: [DataModelTopic]" it was working ok and suddenly it didn't let me do it.
Really struggling to set up a domain account in Creator
Hi Team I am really struggling to set up a domain account in creator. I have edited the CNAME field with my domain provider to the value requested and have left it for several days but verification still returns the error message "CNAME Verification failed for the domain itmooti.com.au". My domain provider is www.crazydomains.com.au - do I need to contact them? My domain is www.itmooti.com.au I have sent several emails to support but am not having much luck with responses. I am desperate to get this
Adding numerical values to drop down options in conditional statements
I am making a custom form through the dynamic content that deals with buying items through paypal etc. I'm trying to make it so that I can add in financial aid meaning a discount is given and the amount of discount depends on the option they select from the drop down. Currently, when I submit the formula, it does not give me an error message, but instead, erases my IF ELSE statements with no notification. I have net amount on the bottom as an amount the form calculates based on the price of the item
Can't Copy the Application
Hi All, Need help with high priority I have an application which i can't make a back up (Copy or Duplicate). kmkr :)
Simple Excel formulas
Hi, I have uploaded my excel file into creating and it created a form to add new data automatically. However, it didn't import the formulas as well. For example, Number of items: 5 Price :10$ Total Amount:50$ I got the total amount result automatically in excel however, I couldn't get it in the creator. How can i use the simple math formulas in the creator? I couldn't find a satisfied documents which are giving brief information about these issues. By the way, I extremely suggest a guide which is
Upload image from my own website and own form
How can I use my own and external form in order to upload an image to my Creator database? At this moment I'm able to upload text fields, for example the image name, but I can not find the way to upload the image file itself. Can you help me with this issue? I hope you can understand me because my English is not so good as I would like. Thank you very much in advance.
what makes fields unique in a form?
I am adding records, by using script in FormX On Add/On Success script block I am duplicating records of FormX but modifying a few fields weeklist = {0, 1, 2, 3, 4}; for each week in weeklist { var = insert into FormX [ EmployeeID = input.EmployeeID someField = input.SomeField +1 ]; } New records are not created and I get the error "Some of the fields are unique" I did not intentionally make any fields unique. I don't understand why I am getting this error
Script
Ok, I give up. Hours and hours wasted trying to get this simple script working. I have hidden a number of fields upon form load (no problem). I am trying to get some of these fields to display upon selection of a Multi Select Field. e.g Multi Select Field (called Cakes) Contains Whole Cake Sliced Cake Specialty Cake So when I select say Whole Cake then I would like 2 hidden fields called Whole Cake Description and Whole Cake Cost should appear. The script Im trying to use is as follows - Cakes -
Formula Field not Updating with Large Data Sets
Hi, I have a data set that is about 2300 entries. I have added a simple formula field to this form. Unfortunately the formula field does not update for any of the entries. The same formula field works fine with smaller data sets. How do I get around this? Thanks! Mike
Using getUrl in Creator to get data from Recruit
My URL shows XML data from Build XPath as well as in a browser. However, in deluge script, there is no responseText data being returned. My code is: url = (((((("https://recruit.zoho.com/ats/private/xml/ClientContacts/getRecords?apikey=") + api_key) + "&ticket=") + ticket) + "&searchCondition=(Email|=|") + input.email) + ")"; mapvar = getUrl(url,false); stringdata = mapvar.get("responseText"); The url resolves to: "https://recruit.zoho.com/ats/private/xml/ClientContacts/getRecords?apikey=40820606c514b452c1ba83c8386c2ddb&ticket=f440b1de14a0a74cd4320d7ec2f2d81c&searchCondition=(Email|=|fn@ln.co.za)"
Fetch date of last donation
Hi all, I've got a question that I've been trying to figure out for a while now without success. Here is the scenario. I work for an organization that provides foster care to blind orphans. (queue violin music in the background). I've made a Zoho database to track sponsors and their donations. I can register new sponsors, link them to a child, and record their donation. When an existing sponsor makes a donation all I have to do is select his/her name from a drop down list and the form will auto-fill
Electronically sign form.
Hi guys I have a few forms that need to be signed by clients at the moment we are printing and then signing. Is it possible for the client once he/she has filled the form on one of our tablets they can digitally sign it? With their finger?? Or can I embed this to the form and get it to attach the file to the record ? http://www.realsignature.com/ Any help would be great :)
Text Link to Populate a Field
Next to a text field I'd like to have several text links that when clicked would populate the text field with a certain value. Sort of like a short cut to populate the field with a pre determined value without typing. Any ideas on how I can do this? Thank you. Greg
Remember Field Value After Submitting
After submitting a form, I'd like the new blank form to have one field pre-populated based on what the value was in the previous record entry. Any tips on how to do that? Thank you!
wrong error message when adding duplicate values
If I try to add duplicate values in a field which has "Do not allow duplicate value" option checked, the error message which appear is the following one: Error occured while on Success script. Unable to update variable Error occured. This is displayed even if there is no script at On Add - On Success. Regards, George Baltatescu Zoho Creator Developer
Preformance calculator
I would like to make a simple preformance tracking app calculator and would need some help The basic app is like this Fuel entry form - here one enters each time the car is fueled (let's say inserts date and liters) Car performance - here one enters car type, consumption and client charge Daily mileage - here one inserts counter mileage of selected car each day (maybe even inserting empty miles and loaded miles, each having a certain income for the driver / company) Ideally one would need have two
2-Level Conditional Picklists
Is it possible to create two levels of conditional picklists? I've found and successfully implemented the following: https://www.zoho.com/creator/help/fields/configuring-conditional-drop-downs.html#Create_Dynamic_Lookup To carry forward their example, I want to add a third field, City. The new City field would be dynamic and the values would change based on the State. It seems that it should be possible, but I can't quite wrap my head around how to apply the instructions above to this situation.
Options button on shared view
Hi, I have created a Zoho app and am sharing the view with my collegues. However, when I load it as a tab in our 'normal' Zoho CRM, I don't have the options or print button at the top of the view, to make exports for example. In the actual application I do have them, but I don't want to send them to the custom app (and lose all the 'regular' navigation in CRM). How do I make a tab in Zoho CRM that does display the Options button? (just like all the other tabs) Thanks! Pieter
Pull Multiple Fields from One Form to New Form based on Lookup Field Selection
I have two forms - an Event form and a Volunteer form Event form has Event Name, and includes Coordinator Email Address . My Volunteer form has lookup to Event form. I want to create a field so when the Event is selected I also pull in the Coordinator Email Address so I can send an email notification to the Coordinator when a volunteer signs up What is the best way to do that?
How can users log in and directly go to the shared up, without having the shared link.
I use a Creator database for a small startup. The other employees are set up as shared users, but unless they sign in directly from the bookmark, they can't find the database. In other words, if a user goes directly to Zoho Creator and signs in, there seems to be no place for them to find and access any apps that have been shared with them. Is a shared app only accessible via the link URL?
excel formula to deluge ...number^power
Dear all I am converting an excel formula to deluge i.e. =10^((0.0031-1.4/($C4+273))*($B4/100))...(works fine in excel) $C4 = Operating_Temp_C $B4 = Operating_Pressure_kPa =10^((0.0031-1.4/( Operating_Temp_C +273))*( Operating_Pressure_kPa /100)) but get this when I enter it? Lexical error at line 1, column 3. Encountered: "^" (94), after : "" From the web page https://sheet.zoho.com/functions I found the following? POWER Returns a number raised to a power. POWER(number; power) Returns number power,
Urgent Help - How do i update my data from an xls sheet
I keep my data in an excel sheet and have uploaded the data to create the form and database. However, I cant work out how to update the data in zoho creator. Some data in each form will change offline and i need to be able to upload the new data overiding the fields in certain records. Please help
simple report to show data entered
Hi all, I am looking for a report that lets me simply report back the data i have entered. I have 20 items to enter and then i just want a report that shows 20 column headers for each row. All i seem to be able to do is pivot tables which wont allow the large number of columns. Any help with reporting many thanks
Can I enable real time column Filtering in Views for Related Fields
Filtering the data in Zoho Views is a convenient feature to allow the user in Acess mode to customize the display. I have just recently added some Related Fields to Views, which allows one to view related data in a 'lookup' field. However when I choose 'Set Filters', I see no options to enable filters on the related fields and in access mode, there are no filters for the related fields. Is there any way to enable filters on Related Fields? DJ
Function, dynamic input record
Hello, We have an educational center. We have a form to add presences of our students. We have a form to add ABSENCEs of our students. We always like to replenish the absences. So, we have a function called "Replenish" and it is a button next to each row in the Absences view. I would like when I push the Replenish button, a popup to appear to ask me to input the date that the specific Absence will be replenished. Is this possible??? Thank you.
How to revert back to GUI on criteria dialog?
After clicking 'advance' on the criteria builder for views, how to I get back to the GUI mode? There doesn't seem to be an option.
Grouped items get broken up for no apparent reason
I have a problem with a view https://creator.zoho.com/ecgnet/ecg-work-programs/#View:Sector_Thematic_Evaluations I am displaying items by group (specifically, Sector/Thematic Subclass as designated in my database). I am not sorting the items by any other means. As you can see, some items that should be under one subclass (in the screenshot, it is Climate Change) are listed apart. Another group, Climate Change, Social Development, cuts into the list. Am I doing something wrong or is this a bug? Thank
Duplicate entry
I'm trying to change a single-line field to a Dropdown field and I get the following error. (with many of my categories) [t_1368016000000063427] Duplicate entry 'Centre pour l'�galit� des chances et la lutte contre le racisme' is not allowed as duplicate entries already exist. How can I solve it?
Recurring Tasks
Is there a way to format a date field to recur? For instance, I would like to add tasks that recur weekly to my calendar view. The scheduling feature does not look like what I am looking for and involves scripting which I cannot do.
Next Page