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.
Auto calculate fields when another is selected
Hi, I am trying to see what I want to do is possible using Zoho Creator. In my application I have a field that has a list of names, a field called Placement Price, and another called Commission. When one name is selected, I want the Commission field to auto-calculate this person's commission percentage from the Placement Price. Is this sort of thing possible in Zoho Creator? Thanks, Elizabeth
Need to add rows in an entry form
i want to create a form that askes for previous experience in jobs. I want to capture about 3 column headers and have a row for each one, how can i create "rows" in the form builder. All my questions have to come one after another in a vertical manor any help will be great. i have created a similar form in XLS but want to put it online in a form. any help? Thanks
Can't remove shared app??
One of my shared users wants to remove/delete an old app that someone shared with him over a year ago and he never uses. There is no clear way of how to do this?? How can you delete old shared apps you no longer want? Thank you!
Form Schedule Frequency
I have a form schedule below. My intention is to have it run constantly, identifying records to delete based on the criteria. Since the Modified_Time is only a date record, the frequency = Once. Does this mean the schedule will only one Once and then quit forever? When? Identify_Recs_to_Delete { Execute on 28 days after of REQUEST.Modified_Time } What? rec_ID = (REQUEST[(STATUS == "Complete")].ID).getall(); for each element in rec_ID { delete from REQUEST[ ID == element.toLong() ]; } Cheers,
Grid View
Hello, I would like to use a grid view in order to allow for a various edits for various records while they are displayed on the same page and without going through editing each record. I realized that I am not able to do a grid view because I have deluge scripts (on-edit and on user input) on the form the view is based on. I noticed that you do not currently support it. Are you going to support it in later version, and if so, when? any suggestions for a work around where I can change the values
Adding Criteria failed
try to add search criteria in app's view "Adding Criteria failed. Please try after some time or refresh the page and try again." how to resolve it? app https://creator.zoho.com/vsavonkin/view/40/edit/
Captcha not working?
I have gone through the Captcha help files and successfully added the function to my bespoke web lead form but whilst testing if I enter the wrong code in the Captcha field it still allows me to complete the form request. Can someone help as we are having a large amount of spam currently?
Style based URLs Embedded forms
Hi, parameters looks to be omitted in certain cases of embed forms : for example, in a HTML view, we embed a form with : <div elName='zc-component' formLinkName='FormName' params='zc_Header=false&zc_LblFontSize=18'>Loading...</div> The parameter in bold works correctly, but is omitted when we use the permalink of this HTML view (zc_Header=false is ok but not zc_LblFontSize - not tested with other customization parameters). There's no problem when we use Iframe instead of div. That's minor but good
Maintaining Links when exporting html to pdf
Hi, 1. Is it possible to maintain the <a href="link"> when a html page is exported to a pdf? 2. Does anyone know of a solution using creator/zoho to create a report/document in html and then turn it into a pdf with links. I would like to have thumbnail images that link to larger files if the user wishes. I realise that the application has to be public if I want to be able to export the images. 3. Is it possible to export a html page to pdf and then attach it to an email? Thanks,
Overview of data from different forms (But from same application)
Hi, If i create a single application with several forms, will i then be able to create a view/ report where i can see all data from all forms in just one view? Or can i only see the data form by form? Kind regards, Bo Thygesen
Grabbing the field names for a form
Hi, I want to grab all the field names for a particular form fieldslist = getFieldNames(); // would be from the form itself in the onSuccess action But what if I'm working in a function. Thank you Guy
Help with button
So in my form I have a check box or radio button (doesn't matter which) that when I click if activates the script sendmail [ from:zoho.loginuserid to:input.Agency_Email subject:"Message from Nigel L Cross (Kent)" message:input.Email_Message content type:HTML ] What I want is to have a button within the form that does this instead of using a check box or radio button. Is this possible please Thanks. Nigel
Script Won't Save?
Hi, I came across this issue multiple times, and it is starting to get really frustrating. Basically, my script will not save. No error message shows up, it just keeps saying "Updating Script", but it never actually updates or saves. It happens when I am using a conditional statements where I use "&&" to add another condition. For example, this script will not save. //Alert Box that shows a pop up message if the user tries to select a bike that is already online x = Bike_Listings_Current[Bike_Serial
Refund Requested - No Reply
I've requested that my account be cancelled and a refund issued, but no reply. How do I get someone from Zoho to confirm that my account has been cancelled and a refund issued?
Edit form fails to load if Zoho CRM User look-up field has value
Hi, One of the forms I have been building for a client has a look-up to Zoho CRM's Users module and this Zoho Creator form fails to load in edit mode, when some user record is already selected for this field. When I make this field empty, by using the Bulk Edit option, the edit form opens up without any issue. I have provided below relevant images.. Error scenario : Same form loading with the field is empty : I also have another such Zoho CRM look-up field (referring to Accounts) in another Zoho
build a report based on form and sub from
Hi all, I have built and form and then a sub form with in it so that a person registers their details in form 1 and then in the sub form enters there interests one at a time "submitting" each one as they go. Now that i want to report the details i cant seem to join the two forms to produce one output. Any ideas? Regards Duncan
Running History Information (Change Log)
Hey all So I have a form set which is a project, on the records there are multiple changes happening, for instance costs, allocation of the owner etc. Im trying to find a way to record all the changes; Within the for set I have a Multi line field which ive called history, when the field is first created I would like to enter in the history "project created by " && zoho.loginuser - this returns an error LHS cannot be a constant, not sure exactly what that means but obviously doesn't like having text
Next Page