Linking information from two forms together
I have two forms: One is a database, and one is from the Autumn term. If I add a person to the Autumn term, I want to be able to view this in the database as well, I want the class they have enrolled for & their booking number I have entered under the Autumn Term Form, to come up automatically in the Database view. Is this possible & if so, how can I link this? Help!
Need guidance to build my app
Hello, I am new in Zoho and what I'm trying to do is to build a simple app to place my customer's orders in and have my customer check my website to see the order status. 1. I have built my form and populated it with my customers' orders. 2. I have built a view to update my customers' orders. That I will do myself. 3. I need a view that I will imbed in my web for my customers to type in their invoice number then when they click submit they will then see the order status information. I need
Subform looks in form view/mode
I have a form with subform, and I want to have the subform to be showing in the same design as the form. Currently it shows as a list inside of the form. Like when I crate a lookup field, and click on +Add link next to the lookup field, it opens a new form on top of the main form. That's how I want the subform to work. Please let me know if that's possible to arrange. Thanks, Anri
exporting field data
when I input a new item in a form, i want data from one field to be copied into a text file I have sitting on my server. how do I do this. Thanks
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
Conditional manadatory
How do I implement Conditional Mandatory in a form? for example, if one field's value == XYZ, then another field becomes Mandatory. How can I implement this? Thanks.!!!!
Help with SEO
I have a database https://creator.zoho.com/mrcomputer/lts/# and embed the code to my website using an iframe http://www.mrcomputer.biz/pc-parts.php. we want the google crawler to identify the data in the form and create a link to http://www.mrcomputer.biz/pc-parts.php rather than https://creator.zoho.com/mrcomputer/lts/#.
Zoho Creator Mobile - Search
I have been able to access my Zoho Creator applications on my mobile device, but i am not finding a way to search the database for specific records. It appears that I can only filter and then scroll through all my records to get to the one I am looking for. Is this correct or am I missing something? If there currently is no search functionality, is there a plan to have this as an enhancement in the near furture? Thank you!
CRM Integration Problem
I built a form with a CRM lookup field to Accounts. When I add a record in this form I can click on the hyperlink in View and go directly to the Account in CRM. That is great. My problem is I have imported many records into my form with Account names that were not created in CRM, the Accounts were imported into CRM as well, so the Account name matches. I can't seem to find a way to match CRM Account ID with my imported Account names in Creator. Now, when I select the hyperlink in Creator View I get
Zoho Creator printing
When in the Summary View, can I have a page break separating each record? So when I print the Summary View, I got one record on each page. Thanks.
How to Hide Field in view if data is not entered
Hello, i would like to know how to make it so a row does not appear in a view when the user does not enter data in a field. for example: if I have an employment application form, and have 3 sections for information pertaining to the applicants previous employers, and the applicant only enters data for 1 of his previous employers, I want the fields that the applicant did not enter any data NOT to display on in the view. How do i do this? Thank you in adnvanced, all the help i have gotten from this forum has
Problem in migration tool from ms acess to zoho
when i am trying to upload to zoho server by migration tool , i am getting this error : "Problem encountered while creating the application , lexical error at line 465 column 35 , Encountered :&it ;EOF> aftre:" reffering" ;"
Email validation
I want to create a script on user inpit for email field to check if the user entered email id belongs to particular domain e.g. i only want to accept user having gmail id , i.e anyone other than user with gmail id should get error message if ( imput.email_id ! = "what shall i put here @gmail.com { alert( " Please enter your gmail id") } thank you for your help
Hack to sort rows of a subform and pre-populate row fields that I want to preset
Not sure if Zoho have finally enabled sorting of rows in subforms. But the hack below worked for me. Basically i take note of the random order the rows are sorted. Create a hidden field in the table being used for the subform called Order_Index. I then just set the order index to the value it appears when the subform is displayed before implementing this logic. E.g The row I want to appear first might show as row 5 so I set the Order_Index for that record to 1. I create a map() which has a key
Need urgent help: import merge
Hi I have accidentally erased the contents of one column in over 4000 entries. I have an excel backup but when I import, it tries to create new entries rather than merge to the existing ones. How can I merge the missing point to my existing entries? Thanks
CSS in Embedded Views
How can I use a custom CSS file in an embedded View? Thanks!
Best Practives Comparing Strings
Could you please share Best Practices when comparing strings. Sometimes, when I use strings that contain numbers as alphabetical characters, comparison commands only work with string.contains("____") If I use if ( check = "_______" ) , even if it is equal, that condition DOES NOT work, but if I use contains, it works Any ideas why ? Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
How do I get a formula field to equal the result of a radio field?
I'm trying to put a formula field into a form and I want it to display the result of a single radio field in the same form (text). What would I need to put in the expression? The reason for this is because the radio field is a status field (eg " JOB CANCELLED" and I have a subform view which cant create a "criteria view" based on the lookup of the status because it's a radio field. So I've been advised to create a formula field which equals the radio field then lookup the formula field to create
how to stop/cancel a form ?
Hi, i have a question : how to stop submitting a form after a period of time ? let's say i want to cancel submitting form by users after two days since i publish the form into the web page. something like a timmer.
Sending an email from a view
On a view I display a url field. When clicked it opens a new tab with the appropriate web page. Is there a way I can have this trigger a deluge script? I would like to send an email to the site owner that someone clicked on the url for their site. Herb Wexler
Get Customer Info back to Zoho Creator
After customers are created in Zoho Invoice, is it possible to have Account Balance information sent back to Zoho Creator. Again all of my customers are already in Zoho Invoice and I would like to update account balances back into Zoho Creator. Is there a .getCustomer() function?
Embedding application script to my website
Is it possible to embed a copy of my application on to my website so my employees and customers can access it via web browser?
Create incremental Number in SUBFORM if requested by "radio field" in the same subform record
Hi We use a lot of incremental numbers around our application for various things, however, I haven't had much experience with placing them in subforms on success of the parent form. This is what I've tried to write so far, and it comes up with errors: if (input.SUBFORM_NAME.RADIO_FIELD == "Increment required") { x = MaxValueHolder [ID != 0]; input.SUBFORM_NAME.SUBFORM_FIELD = (x.highestval + 1); x.highestval = (x.highestval + 1); } ERROR: expects = on line 16 I'm sure its simple,
Is it possible to use foursquare data as an input to a form in zoho?
I would like students at my school to be able to register onto a zoho database through the foursquare app - is there any way of doing that?
Help Help Help
I'm having a hard time with this simple thing. I want to set the email address according to who the lender is. Can somebody please help me with this simple. If the input.lender is "mary" then the input.lender_email = mary@test.com I cant seem to get this simple thing to work in script.
Hide all fields "on load"
Hi, Anyone have thoughts about how to hide all fields "on load" without having to enter each hide/field command individually? It would be great if there were a script that would auto hide all fields on load. Thanks. Robin Hide
Need to have "Criteria" be dynamic
Hello All, I need to find a way to set my View "Criteria" so that it is dynamic. When a view is generated, I want the Logged In user to not only see "his/her" data, but also any data that is part of a specific organization. From what I have found thus far, I can segregate the "User", but I can not set the specific organization to trigger off of the "Users" log in protocol. Any thoughts?
Help for a Newbie
Hi I am a new user to Zoho and would like to know whether the following is possible, and if so could someone give me an idea where to look in the help area to develop a solution: When I convert a lead to a potential I want to be able to trigger sending a standard series of 8-10 emails, each email being sent out automatically every 2-3 weeks, to each of the chosen potentials. Hope this makes sense and I hope someone can give me some guidance and point me in the right direction Many thanks
Different logo
Hi, I would like to know if is possible to show different logo for different application. Thanks in advanced, Regards from Brazil, Andre
Restrict users to enter not more than one space?
I have a TextBox in which user is going to enter search Criteria in TEXTBOX. Now, i want to prevent the user from entering NOT MORE THAN ONE SPACE AFTER EACH WORD in TEXTBOX. How to do it in zoho??
Show Hide for HTML View
I can see that I can't use Javascript to create a show hide button in my HTML View. Does Zoho have another solution to accomplish the same thing?
apps & add-ons
we use the add & app-ons to make cutom form and use send mail field under it.but face a problem after send a one/two mail this field dont give any response..whats the problem arise it so its dont get reply pls solve this problem.. send this to my mail id:parveen@primaryplus.org thanks
com.adventnet.workengine.task.TaskExecutionException
Hi, My system return this error for several schedules used to update a form. I don't understand what happened, it was working fine last month. Who can help me? To explain: I've got a form A and a form B. I import datas in the form B (6200 records) and I use this records to update monthly the records in the form A (6200 records too). Because of the limit of executable statements per deluge action, I use form schedules delayed in time (2 minutes) to detect the import of data and update some fields
Excel formula to Zoho Creator formula
I am trying to replicate this Excel formula into Zoho Creator; but it's not working. Can you take a look for me? =IF(INPUT>2000,(INPUT-2000)* 5%+2000*0.07,IF(AND(INPUT<=2000,INPUT>500),(INPUT-500)*7%+500*0.1,IF(AND(INPUT<=500,INPUT>100),(INPUT-100)*10%+100*0.14,IF((INPUT<=100),(INPUT)*14%,0)))) It works fine in Excel.
Find maximum date/time
I use deluge scripting to find the record with the maximum value in a date/time field. To fetch that record I have to advance the maximum value with AddHour(2). Does that make sense to anyone?
Search Function in Form
Hi, I am new to Zoho Creator. I am creating a form, which need to search the invoice number. However, the invoice number is consist of 10 digit. Is there a way I can just type in a sequence of 3 digit of the invoice number + customer ID, and I can find the record? Thanks TM
Get ZOHO Ticket using PHP (CURL)
PHP GET ZOHO TICKETS I had to search high and low to get this information. I was not easy and finally I managed to do it. Without a ZOHO cookie capability there has to be some way to track users who are logged on through ZOHO's own user management system. The following PHP program can be used on your own server. It requires the CURL module of PHP to be activated. CURL allows you to send POST and URL inquiries to other applications. In this case we request ZOHO to give us an API Ticket number
Store Several Previous Record History
I want to store several recorded values in a field so I can register the historical values of a given field, Zoho support has given the answer for storing JUST ONE value with in the following thread https://help.creator.zoho.com/Store-Previous-Record-History.html, however I want to store every change.
Getting Google Apps to work with zoho creator any trick to it
Hi I have this with zoho support but it is the weekend i am stuck I have a personal creator account and a Google apps account, i have installed creator from the apps marketplace When i click the link in Google apps to go to creator I get a login screen which asks for a user name which then goes and creates a new creator account Ideally i want my personal account linked, cant seem to get this to happen .. Should i have a domain account ? whats the secret to this thanks
Next Page