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
Import data field type : how to import from other applications
Hi all, I'm new to creator and I wish to link a form field to another form in a different application (shared or public), this form acts as a commun reference table for several applications. Is that possible with creator and how can I do that ? When I use the import field, I see a reference to app name, form name and field name, but I do not know how to change the app name (set to my application by default). Thanks
Having some trouble with creating a useful form to update another form
I am trying to create something of a project management app. So I have accounts, which relate to projects, which in turn relate to tasks. I want someone to be able to add as task through the "Add Task" form. Which is working correctly and obviously is not hard. It gets a little more tricky though when I create the form "Update Task". In this form I have it where I would select my task, and then add updates including time spent (a field not in the Add Task form, so unrelated and then other fields
setting label widths
Using "form properties" in the "more actions" drop down, i set the label width using the px/% option. after clicking "done" there is no change to the form layout. when i return to the form properties, the label width is set back to auto. what am i doing wrong or is this a bug?
using related field in a formula
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!
Can form or view title be changed dynamically?
They can be changed manually in form designer, and by changing the textual form definition. BUT: - is there a way to change them dynamically, from deluge script? This would be VERY useful, since it would allow greater application customization based on some settings, by customer information, etc. etc. Just in case, I tried setting form.displayname variable from deluge, but that did not seem to work ;) Please consider adding this simple feature if it's not there yet.
Error Message
I keep getting this error message and I am not sure what exactly is going on. 1 . [t_506841000000384059] Exception occured while setting value in PreparedStatement for the Column [invoiceDat_506841000000426035] Check whether the datatype for this column is given as specified in the data-dictionary .[t_506841000000384059] Exception occured while setting value in PreparedStatement for the Column [invoiceDat_506841000000426035] Check whether the datatype for this column is given as specified in the
Preceding space in 0 index of multi-select values.
I think I found a bug that can break quite a bit of code for users. 1. Try saving a multi-select box with multiple values selected. 2. On validate run the following code.. fields = myMultiSelectBox; for each f in fields { info "_"+f; } result...... _ home_phone _ Location _ Tour_Date _ ID_str or run this info in a list. fields = web_contact_fields; test = {}; for each f in fields { test.add("_"+f); } info test; result..... _how_did_you_hear_about_us, _ other_referral, _ doc_Name, _ pres_Location,
Feature of Creator
Hi, there, Creator Html View support Dhtml or html5? dhtml or html5 is a good feature. Thanks, Andy
Can't edit application Zoho Creator
Good evening, I can't edit my application anymore. In Firefox I still have access but can't change anything? Could you help me? Thanks, Job Sueters jobsueters
My application disappeared completely
Hi guys, I've been working on an application to manage a pilates studio, and have had so many bugs in the scripts that I decided to start over. Forms don't display correctly either, sometimes it helps to just log out and log in again, but not always. So I renamed my application to "pilatesv1" or "gestionpilatesv1" something like that, and started over with a new application named "pilatesv2". And now, misteriously, a new application appeared called "Alumnos" which should really be the name of a form
Get Contact Field with searchRecordsByPDC
Hi, I'm trying to create a formula field in a Aplication. In this formula field I want to get de CONTACTID field of a record. To get this I use zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0). Doing this I obtain the complete record but I only want the CONTACTID field. What can i do to get this? I tried to do: zoho.crm.searchRecordsByPDC("Contacts", "email", Email).get(0).get("CONTACTID") but It does not work. Thanks, Roberto
drop down list going null on success action
I am rebuilding a few (lookup) drop down lists as the user goes through the form. When I get to the success action and try to use the field values they are null. Previously it was working, but all of the sudden I was getting null values. I checked everything and put in alerts and info to see where they were being changed. To no avail. My question is. Are the input actions executed again during Submit? This is the only thing I can think of. I rebuild certain look up fields depending on previous
Error modifying the page Lexical error at line 263, column 19. Encountered: "\u201c" (8220), after : ""
I use MSWORD to write deluge scripts and paste them to the ZOHO form. I save the text as HTML prior to copying and pasting. Works fine except for the above error message when I write a script like: input.field = "x"; the syntax check doesn't like the quote notation and requires me to reenter the quotes via deluge. What can I do to prevent this lexical error? Thanks Robin
bgiframe does not work on FireFox
Hi All, I tried to create an iframe in a div, using bgiframe as below: $("#panelrightbody").bgiframe({ top: 0, left: 0, width: 1280, height: 800 }) The iframe is created successfully in IE8, but not in FireFox (v3.6.12). I used this script: jquery.bgiframe.min.js Please help me to find out the root cause. Thanks, Triet
Next Page