Error message when editing a record from Form View
Hi -- I keep getting the following error when trying to edit data from a form view: [t_431470000000028161_PIDX] Exception occured while inserting rows Failed to update data. Thanks in advance!
Picklist (Checkbox items) to contain clickable URLs
I expect it's a bit of a violation of things...but I would like to be able to put a series of URLs/Web Addresses as items in a Checkbox list...and allow the user to click on them to open records in other locations (in this case Zoho CRM). I set target to '_blank' so that they open in a new tab. In each item, I put a persons first name, last name, and then the clickable link.The code below 'sorta works'...I do get something clickable...but there is quite a bit of unwanted extra info...here is an example
Insert Record hanging in Stateless form
mQuotation = Vehicle_Quotation [Quotation_ID == input.Quotation]; mFields = getFieldNames(); mID = zoho.currenttime.toString(); mData = map(); for each mKey in mFields { mData.put(mKey, getFieldValue(mKey)); } mQuotation.Status = "Reissued"; insert into Vehicle_Quotation [ Added_User = zoho.adminuser Bank = mData.get("Bank") Book_Days = (utilities.configuration.Setting("Default_Booked_Days").toLong() + (mData.get("Book_Days")).toLong() - 3) Color = mData.get("Color")
Getting the First Record from a Form - how to index it? (Radio button picklist)
This was a bit trickier than I expected...and I looked everywhere on the Forums and Deluge Script for it...and eventually came up with this - it may be wrong, and I'd love to hear a correction...(so if I've missed something blindingly simple, I won't be surprised) Basically, I am populating a Radio Button picklist with a series of strings which are each a field within a form record...so firstly I loop through each record, and use ui.add to add the string from each one to the picklist. But then I
Find Last Record in Form - MAX Function?
I have a form where the users inputs a sequence number (integer). I would like to autopopulate this with a user input script (when the previous field is updated). Is there a way to find the last record number? I was look for a MAX function or something similar. Thanks,
Reusable Widgets or sub-components (user-defined widget)
I have an application that does some searching (of CRM as it happens), which results in a list of email addresses which in turn are made available to an email template preparation/customisation app, which passes the resulting email text to an email previewing application. The reason I do this is because I want to treat the searching and the email previewing activities as 'reusable' components - because they will be used in multiple customisable email template instances. I want them to be reusable
Creating Customizable Template
Hello, I am trying to figure out the best way to make a user friendly email template. Let's say that the five field are set up, such as Name, Email Date, Time, and Place. Upon Submit, these fields are inserted into an email template that is stored in such a place that the user can access it in a rich text editor to make changes to it. This editor could be something like Zoho Writer. When the form is submitted, it needs to insert the variables into the template and sent it to the email entered in
action to copy field contents
Hi, I have two fields in a form, "site address" and "billing address". I have a radio button, "same as site address", with one option, "yes" I want to add an action on user input to this radio button so that if the option is selected then the text from the "site address" field is copied into the "billing address" field. I'm sure this is simple but I can't seem to work it out. Can anyone help? Thanks Jeff
Opening Single Records in HTML View
Hello, I have created an HTML view for one of my forms, and I need to know how to execute a function that will place a button in a column in a list view, that when clicked, it will open a new window displaying the specific record in the HTML view i created... How do i do this? thank you in advanced
Simple Question please help
I have a very large form, so to make it easyer for the user i made a drop down menu that shows only the section of the form that is selected. The problem is the script is so damn big, which causes crazy lag, Can anyone suggest a more effect way to do this... the current script located below http://creator.zoho.com/jpiajr/form/492/scriptbuilder/ under the "on user input" for "select a section to view" field
Ical feed help
I created a calendar with the intention of using iCal feeds for Outlook/Google calendar. I had the Start time and end time programmed as as DTSTART and DTEND as iCal feed parameters, but the feed doesn't work? any ideas why it's not working? Thanks http://creator.zoho.com/becomgmt/reservation-management/#View:RsrvCal_All_Rooms
Integrating my Applications with my website
Is it possible to integrate an entire application like your CRM example with my web site? If so, can you please explain how? I tried to use the "embed in your website" feature, but it appears to only embed individual forms and I want to embed the entire application. tkersnick
Deleting Copy of View
I created a Copy of a FormView which contained numerous records. The Copy was renamed CopyView and then the records residing within the CopyView were deleted. When I deleted the records within the CopyView, the original FormView lost all it's data records as well. Is there a way to delete a Copy of a View without impacting the original View?
How do I view submissions to a form I have created?
Hi, I created a form under the creator application. However, I am having trouble finding the submissions or completed forms. Can someone please explain to me how I view submissions and how I can export them to excel?? Thanks. Anne-Marie
Replace All with Input Field
I need to replace text in string field dynamically based upon another input field in the form. I am trying to do this with the Replace All function but this does not seem to be working. Here's my sample code: PropertyOwnerInfo = input.Property_Owner; BodyText = (BodyText).replaceAll("PROPERTY_OWNER",PropertyOwnerInfo); input.Body1 = BodyText; If I use an actually string text in the replace all function (e.g. BodyText = (BodyText).replaceAll("PROPERTY_OWNER","Bob Smith"); it does work. Is there
Issues with Functionally based URLs on List Views
Hello. I'm having issues using functionally based URLs on List Views that have lookup fields from other forms. I use the specified format on the user guide with no success. Is this even possible or is there a different format for this type of url? The Zoho Creator User Guide says to use the following format: To set criteria for a view The criteria for a view can be passed as part of a query string to a view url. Multiple criterias are specified by appending it along with the URL using '&'
Hide/Show form cells based on criteria
For example: I have a form that has job numbers with a varying amount of entries tied to each number. What I am wondering is if it is possible that in another form if a user selects job number 574 and it has 4 entries tied to that number is it possible to have 4 text boxes show themselves with information from each entry. I know how to show information from different forms i just need to know how to toggle visibility. Is this even possible?
auto expanding list
Hello, Is there a widget in the Form creator that provides an auto-expanding list? An example: On a contacts form, I wish to have users provide one or more email addresses, phone numbers, etc. this widget would give a plus sign and allow for the user to enter multiple items (I have attached a screenshot from Google Contacts that provides this functionality). I know that you can create a faux-subform using a view but until subforms being inside of stateful forms is a reality is there any way to accomplish
email uploaded files
Hi there, Can we email the uploaded files through the form post successful data posting? Thanks ashishhattangdi
How do I delete a View Form ?
How do I delete a View Form ?
Fetching data in stateless form from other form
I have generated customer form and stateless customer form. I have generated one field in stateless form which has a condition. Suppose anybody enters sMobile NO in phone field of stateless customer form it shows name in sName field of stateless customer form provided that phone number is already entered in Mobile No field of customer form and name also entered against that Mobile No field in name field of customer form. I have generated following script and put it in on user input of sMobile NO
Record count being doubled
For some reason, the record count is being doubled. When I try to add a new record, I get the following message: Usage limit reached. Your limit is 1000. Your current count is 1788. Please purchase Add ons or delete some records. However, I have only half that many users. I searched the forums and didn't find a similar problem.
Ordering of records in a For Each Record script
I am iterating through records in a form, but I need the order to be based upon a field in the form not the ID of the record. Is this possible? If so, how?
XML RPC API, CSV RPC API, and Shared Apps
I'm trying to use the XML RPC API and CSV RPC API to view records from an application that has been shared to me and both methods are not returning any data. I can successfully use the XML RPC API and CSV RPC API to view records from an application that I created and own, however, using the same methods to view records from an application that has been shared to me does not seem to work. Should I be able to use the XML RPC API and CSV RPC API to view records from an application that has been
How can i get the lookup value when user edit the field
for example when user select the stock symbol in one field it automatically update the company name in other field matching with the correct company name in other form.
How do I take data from 3 different fields and display them in one field on results page
Hello, I have a form in which there are 3 different fields related to Invoice numbers. What i want to do is have the data displayed under one row on the results page. Example Form: Invoice Number #1 [ 0001 ] Invoice Number #2 [ 0002 ] Invoice Number #3 [ 0003 ] Results Page: Invoice Numbers [ 0001, 0002, 0003] Can someone please provide an example of the script that i would use to do this? Thank you in advanced.
Pass Dropdown values between forms
Hi All I am very new at this creator stuff. I started yesterday. Anywho I have a drop down box on a form which only has two fields on it deliberately for mobile phone access. The two fields are where are you and who are you. Based on the where are you drop down box I open another form over this form. In the new form just opened I want to dynamically alter the drop down in the new form to show only jobs requested for this site. I cannot see how to pass the value from one form to the other
Want to use zoho creator for telephone sales script - can you advise
Hi Forum: I think Zoho Creator can help me do something I want to do, but I'm not sure how to get started. I'm setting up a small virtual call center. I'm in a specific industry. I will author a sales script that gives a phone sales rep what to say and then leads them to a next step depending on what the customer says to them. I'm envisioning a block of text with a number of buttons. Upon clicking each button, I want to first, record that action in the Database and second, take the user to the
MS ACCESS databasewill not upload
I have subscribed to the free level of service and I would like to test ZOHO with a small sample ACCES database import using the ACCESS migration tool, but it replies with a lengthy error message . I was able to capture the error pop up and have attached here I'm running VISTA and MS office 2007. Any known issues? Thanks, Ron
Can I open a view directly with the search bar open?
I would like to open a view and immediately open the search bar. Is that possible? And I have the same question when I open that view using a url I use now the following url: openUrl("#View:Contacts_Donations_Search", "same window"); thanks Henk
Formula
I want to create a formula that will allow me to add a certain number of fields, then multiply by a different field. What is the best way to do this? I want it to look like below. Thank you for your attention to this Expression (A+B+C+D)*E Regards,
Default Date Format Not Working
I have a registration application I am working on which has a main registration form. The application also has a form to add available dates. Each date available for scheduling also has an associated capacity. I want to dynamically add to a picklist of dates on the registration form based on the selected number of participants (capacity). I can get this to work just fine with the code below: adate = Available_Program_Dates [Program_Available_for_How_Many_Participants > input.Estimated_Number_of_Participants]
Text field formatting
Hi, I have one form which has a text field in which I want to enter a file path (eg. C:UMydata ile name.jpg) it also has a field "Colours" In another form, I want to select the "Colour" from a lookup field, and have the file path populate another field. When I do this, the backslash is dropped from the file path, so that it is populated like this: C:UserMydatafile name.jpg Is there any way to keep the text as entered? I would have thought because it was a text field, that this would happen? I
About ZohoAPI
Guys, Can we integrate the Creator and the Writer through API? We havea creator application need use writer, give me some tips thanks, Andy
PDF generation broken again!!!
ZC team, a few days ago there was a problem in html views pdf generation, the pdfs were blank. The problem was solved, the feature worked OK, then another surprise today: the pictures are not displayed when pdfs are generated... Look at this example: see here the html view and the generated pdf here I am working at an application where the generation of pdfs is crucial, and yesterday the pdfs were generated OK, today there are again problems (images are not displayed)... so I really need to think
Zoho CRM getRecords and search question
Hello, I am looking into the Creator - CRM integration. I can succesfully fetch records with this command: zoho.crm.getRecords("<ModuleName>",<fromIndex>,<toIndex>); For example I can create a list that contains the names of my accounts. Now I also would like to search for contacts in CRM I could use the following: zoho.crm.searchRecordsByPDC(<moduleName>,<criteriaColumnName>,<criteriaColumnValue>); The fields I can search for in the module contact is only accountid For the module contacts
How can i do this ?
hello Members, I am creating a form which provides me order from my customers for this i am use two Forms first form for registration and another for Create Order on the registration time i am provide 50 Orders to my every customer. this mean my customer give me only 50 orders. Now in my Create order form there are following fields 1. customer name 2. date 3. total Orders -50 default set on load 4. Rest Orders- 5. Order 6. email ID so now i want that in rest orders filed the customer sees his rest
SUM
how can i calculate the total sum of one field but have it show in another field. For instance, i need the total amount of billings to show in the field Actual Billings. How can i do that in script
Calculating a value from related field
I'm trying to do the following in a view. In the form associated with the view I have a quantity field. In a related database (based on an item that has been selected in the form) I have the price of the item. I would like to have a formula field in the view that calculates a total cost from the quantity and the price in the related database for each record. is this possible? thanks!
Adding new entries for lookup fields
I have an application I am developing that has nested lookup fields; i.e. I have lookup fields in a form that allow users to add new entries to the form that is being looked up and there are also more lookup fields for yet more forms in these lookups. The problem is when I add a new entry for a form via this method it is not updated immediately so that I can select it as an option from the drop down lookup list. Specifically, I have a PERMIT form that needs to have a SITE attached to it. From the
Next Page