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
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
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
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
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.
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
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
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]
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
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
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
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
Feature of Creator
Hi, there, Creator Html View support Dhtml or html5? dhtml or html5 is a good feature. Thanks, Andy
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
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
invio automatico di email
Salve , ho creato un form con un campo col nome invio email di tipo dropdown con valore (si, no) ed un campo per l'email Vorrei che se in nel record invio email seleziono si il sistema invii in automatatico un'email all'indirizzo messo nel campo email. non so assolutamente come si fa lo script
Can contacts be linked to different profile types?
I am trying to create a non-profit organization database (using one of the shared applications as a start). I have categories of contacts like "donors", "volunteers", and "event staff". Is there a way that I could create the database so that a contact can be in more than one category? Such as, a contact is a donor and also a volunteer, with all the fields pertaining to both categories on their contact page? Is there any way to do this in Zoho Creator, or am I trying to make something work that just
record exist
short Q check if this record exist before adding the new record detailed Q now i have a form that i entered data to a data base using it and i want to verify that this new record is not exist before how can i do it?
Simple Question - How to auto update a field?
Hi, I am very new to Zoho Creator. I am trying develop my first application for a small company I work for. My problem is as follows: I have a one form called Estimator which has 2 fields Estimator's name Estimator's Email Id The second Form is called Estimator's Log where one of the fields is Estimator which is a "Lookup" field and the values are looked up from the Estimator list. I also have an Estimator's Email field in Estimator's log which I want the program to auto update as soon
relation between tables [forms]
how can i make a relation ship between tables? is it a MUST that i make it using MDB first and then import it to zoho?
Prevent Adding Record within To/From Range
I have a form that has "To" and "From" fields for a range of days (e.g. FROM 0 TO 30). There are multiple records in the table From To 0 30 31 60 60 90 I would like to prevent the user from adding a new record between these numbers on the form. I tried to do this with a on validate action as follows, but it does not seem to work: if (count(Cancellation_Policy[((Property_Code == input.Property_Code && From_Days >= input.From_Days) && To_Days <= input.To_Days)])
Deluge scripting failure
Hi support team, In july, I wrote a deluge script using apitite Creator-CRM library from the market place. The purpose is to retrieve a few records from a CRM custom view and populate a table in creator for reporting purpose. Everything was working fine in July, but it appears now nothing works anymore for no reason. After half a day trying to understand what was going on, deleting script parts in order to pinpoint the issue, upgraded to the latest apitite version, I tried to follow the running script
auto complete for multiple textbox
I am having 2 autocomplete textboxes. One for 'product Id' and another for 'product name'. If I change ID, automatically name should be updated and vice versa. How can I do this.
Edit a checkbox to completed
I am having the following issue and can't seem to find the answer. I have 2 forms in my application. 1 creates a request and the second for is used for follow-up. On the second form I created a link that pulls a drop down list of the requested with completed == false from the first form. What I wanted to do is on a succesful submit the field of the selected record ID the Completed field becomes true. Any ideas on how to do this? Thanks in advance for the assitance!
create and search question for public database
I am trying to build a publicy available database, that will accept data from approved sources from various states across the country. It will essentially list a restaurant. Then on the same website, i need to build a search feature that allows the general public to search through that filtered data to find specific locations. I got the first part down pat but I'm stuck on the second. Can anyone help? This has been great so far!
Links inside of PDF export
I have a form with an upload field. I have run the form and uploaded a picture. I have seen the sample app which displays the picture with the standard view or html view and been able to get my application to work the same way. If I export the view to PDF however the picture comes across as a img link which is not a hyperlink inside of the pdf. Same is the case within the sample application. The HTML view exported to PDF does not show the image either. Within the pdf doc how can I either show the
Counting Form Cells
I have an app that a client will enter in a bunch of information about customers and who is the salesperson. What I am wanting to know is if there is a way for another form view to show a count of all the entries for a particular salesperson. So I would need it to go through each entry of the other form and check the salesperson then keep a count. I know how to keep a count and stuff but I do not know how to check each entry like that.
Displaying complete records (not just a few fields) from 2 forms in 1 view? Possible?
Hello, I have built two forms for a client organization with groups and service centers (called intergroups) worldwide. Groups and intergroups have to register with the main office, hence the two forms, group_registration and intergroup_registration. I have thought about consolidating the two into one, but each one collects some specific data that the other does not. The forms are made, but nothing is being used live yet. Both forms have 2 multiselect fields, named identically, Country and State/Province.
on click script in stateless form returns an error
Hello, I am developing two stateless forms to insert data into a main form. All I have is an insert code, an alert, a sendmail, and a reload. When I test the form I get the following error. Error details: Error occured while executing on click script. Error occured. (this is what I get when I'm logged in as admin) If I'm logged out, I get 'A problem has occurred, contact the administrator' The form I'm referring to here is "Group Registration S", which inserts into "ROOT Registration Form". I
Populating Drop Down list from Form
I am creating a class website that will have information for my students regarding test, homework, and other information. I would also like to add a scheduler so that the students can set up times to come see me. I know basic html but I am not familiar with databases which I learned is need to populate the fields for the scheduler. I thought Zoho would be the solution to my problem however after creating the form Im wondering is it possible to connect the information from the database to the drop
postURL not working
For the life of me I cannot get the postURL to work. My objective is to post for example id, name, address to my own PHP website. The PHP website reads the variables and creates a PDF file which is flattened and loaded into the browser. I have tried everything, read everything, but cannot get it to work. There must be a way! Somebody please help me. I am stuck!
Recommendation to relate 1 form with another?
I have a form, Policy. On it I have field Policy Number and Expiration Date. I have another form, Attachments, since a Policy form can have multiple attachments related to it. One attachment is only relevant to one policy. On Attachments, I have fields, Title and File Upload. What is the recommended relationship direction and why? 1) Put a lookup field on Policy to lookup the Attachment title (multiselect) or 2) Put a lookup field on Attachment to lookup the Policy number
User login without "zoho user login system"
Hi. I had created a input data form on Zoho creator and i woud like to grant access rights only for or a list of specific users and password provided by me. Is it possible i design the user/password system without to use "Zoho Creator login"? Cause i have a free signature and needs to grant access rights only for a list of specific users. Thanks. Regards. Juliano.
Cannot add records
I cannot add new records in form or list view. Below is the error message. 1 . [t_650582000000012062] Exception occured while setting value in PreparedStatement for the Column [Strategy_N_650582000000019535] Check whether the datatype for this column is given as specified in the data-dictionary .[t_650582000000012062] Exception occured while setting value in PreparedStatement for the Column [Strategy_N_650582000000019535] Check whether the datatype for this column is given as specified in the data-dictionary
Next Page