send email to a filtered selection of database entries
I've created a database of students. I've found it simple to filter the main list by instructor, program, age, etc and I'd like to be able to send an email to filtered selections of students. I've read the SendMail doc and experimented with the SendMail sample app, but I don't understand Zoho Creater well enough yet to implement any filtering. It seems like I'll need to create a new type of form for composing the email, and add fields for the desired filtering. I'm a professional programmer, but
Bug with conditional syntax in new App Builder
Hi Zoho, I was debugging some code a colleague wrote. I eventually tracked it down to this issue: He wrote if((input.Shipping_Status = "Received") which is not valid syntax. It should have been. if((input.Shipping_Status == "Received") In this situation, I would expect the compiler to throw an error. It should not be possible to write if((input.Shipping_Status = "Received")That would invariably be a syntax error. I'm pretty sure the old app-builder didn't allow this.
Zoho Creator
Hello, The views are getting deleted . Can anyone tell what went wrong ..???
Can Zoho Creator be used for GoCardless integration?
Gocardless offers its own APIs that we can use for third party integration, so wondering if Zoho Creator can be used for the same? If yes, can anyone give any working sample of DELUGE? I am not able to set HEADERS for GoCardless API calls in Creator.
Approve form data for webview?
I'm building a complaint form for our association that business owners can use to file complaints against members (and non-members) of our association. I want the business owner to be able to fill out a form, and have it posted to our complaints committee. I also want to display those filed complaints embedded in our website in a searchable form, but ONLY after the compaints committee has "approved" the complaint to be visible on the website. I can build the form, and have it submit to our committee.
Re Old Fields Value for Subform
Hi When in a form with the form of Edit mode, how to know whether a subform data is updated, is there any like normal form, there is a validation of Old Fields Value? Or could you please guide me how to know the subform data has been changed. Thanks Stanley Guo
Zoho Creator Form Captcha Not Working on iPad
Hi We have had several users complaining that the following embedded form Captcha does not work an iPad: http://www.rentlondonflat.com/property-application We have tested this and can confirm the Captcha does not seem to be accepted on an iPad. But same form works on laptop or Samsung Pad. So error seems specific to an iPad. Please advise. Thanks
SubForm Fields in Email?
I am trying to populate parts of an email with fields from a subform. I am triggering the email with the subform field's On User Input action in the parent form. When in the email builder I select the desired field from the subform collection presented in the Input Fields tab. In the email it looks like this <%=SubForm.SubForm_Item%> However when I try to save the email script I get the following: Error at line :1 Variable 'SubForm' is not declared Any ideas?
Add Record to a Dynamic Table Name
I have a variable set that is a table name and it can one of many tables with the same layouts. Is there a way to use a variable for the table name in an insert? insert into Variable_Table_Name [ Added_User = zoho.loginuser Customers = input.Customers Marketing_Manager = input.Marketing_Manager Project = input.Project Service = input.ID ];
Julian Date?
Is the Julian Date format supported by zoho creator? I cannot find documentation on how to call it.
how install date in native language?
hi in my creator's app there is date field how can i change it from "31-October-13 12:30:28" to "31-октябрь-13 12:30:28" name of month change from english to russian?
Can't get form to autopopulate
I need to populate a vendor form from fields in a client form. I have a dropdown field that I've populated with First Name and Last Name fields from the client form, but I'm not sure of the syntax for the, "on user input" function that will populate the rest of the vendor form. Here is what I have so far from your examples: if (Voucher_Clients[First_Name Last_Name == input.Select_Client_Name].count() > 0) { temp = Voucher_Clients [First_Name Last_Name == input.Select_Client_Name];
did not changes name of field
working app try change field name in dashboard name changes but in app it still previous how to make changing name of field?
Recover Field Content Using API
I want to recover a field from an application form to use in another website as a java variable. Trying to use the REST API to GET values, but with no success. Can anybody help? If there's a simple way that I'm missing, then I apologise in advance :-)
One Click commission
Does anyone know which is the difference between "Quota" and "Annual Quota" in "OneClick commission Tracker"? It looks to be something confused. Thank you Matteo
How to segment fields
Hello everyone, Do you know if I may segment fields on my app page so that I get a clean presentation when I log onto my app page. Basically I would like to have the following display: GENERALITIES (as to the title) 1) 2) 3) DEPARTMENTS 1) 2) 3) 4) Indeed, I need to allocate those information to each title. I tried using the GROUPING/SORTING option of zoho creator but I don't get the desired display. Thanks for your reply
How to embed an uploaded css file in an HTML view?
How can I use an uploaded CSS file in my HTML views? I've tried two different ways, but neither seems to work: <link rel="stylesheet" media="screen" type="text/css" href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>x&viewLinkName=Supporting_files_View" /> and <style media="screen" type="text/css" src="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Supporting_files_View"></style>
Clarification on ways of displaying content in Pages
I want to check my understanding of the use of pages. Can someone confirm I have this right, or correct my misunderstanding, please? To display Zoho data in a "page, there are three ways: 1. Use a "div" statement 2. Use an iframe - With the URL explicitly included - With the URL generated by a call to OpenURL 3. Embed fields explicitly within the page Am I right in thinking that, when using a "div", you cannot perform any filtering on what gets displayed. For example, if I want to display a single
Dealing with & in URL parameters
I am dynamically creating URLs to display filtered views of tables based on some table values. When those table values are strings that contain the & character, the search does not work because the & is taken to be a parameter separator. e.g. /view-perma/Contacts_List?Org_Site=B&M%20Services doesn't find any results. But if i replace & with it's ascii value, and use /view-perma/Contacts_List?Org_Site=B%26M%20Waste%20Services-Cheshire that works fine. Now, I COULD write some code to do that replacement
how do i submit zoho forms to android market? can i change it to apk format?
how do i submit zoho forms to android market? can i change it to apk format?
Sharing forms in a section
Hi, I have numerous forms that I organised by building them into pages, and then putting the pages into sections e.g.: Section 1 --->Page 1.1 (with Form 1, Form 2, Form 3) --->Page 1.2 (with Form 1, Form 2, Form 3) Section 2 --->Page 2.1 (with Form 1, Form 2, Form 3) --->Page 2.2 (with Form 1, Form 2, Form 3) I use Deluge to share specific sections with invited users, but when the users log in, they cannot access the forms on the pages. Also, there doesn't seem to be a way to share pages, just sections
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj.
How do you convert number to string?
For my Products I would like to create a new SKU which consists of several Single Line fields and the Auto_Number field. When I try the following: input.SKU = input.Auto_Number; I get the following error: "Variable 'Indd_File_Name' is already defined of datatype 'STRING' but trying to update 'BIGINT' datatype" When I try input.Indd_File_Name = input.Auto_Number.toString; I get Invalid collection object found But it also won't let me put String values into a Number field: E.g. when I try: input.Number
Barcode Integration: iPhone Scanner
Related: https://help.zoho.com/portal/en/community/topic/barcode-integration I have been attempting to use the iCody iPhone app as a barcode scanner: http://www.appthology.net/de/iphone-apps/icody There are some technical issues with ZOHO Creator forms the Appthology support staff finds for error-free integration. They are talking about DOM and tables (what?). Anyway, would ZC support have the time to speak with them to see if a mutual solution could be enabled? I have been speaking with Frank,
After editing in summary view, don't see the edited record
When I display a single record (via a Summary View), then edit it and press Update, the next record shown is NOT the record just edited. Is there a way to make it so? It's very confusing otherwise. It seems to make no difference whether I use a URL like this: ..../#View:Organization_Show?recLinkID=1526298000000079110 or like this: .../view-perma/Organization_Show?recLinkID=1526298000000079110 I get the same result of it NOT displaying the edited record. Thanks Alex
Google Apps Users
Help! I have an application I started building back in January. I've come back to update it, however the GoogleApps Users function is not updating to my current USERS. Many have left, and need off my list and many need to be added... How do I update this field?
Confused about record selection in URLs
I've created a Summary Report to display a single record. However, the id selector doesn't seem to be working. Whatever ID I use, in the form of: ....view-perma/Organization_Display?id=1526298000000079470 (the IDs I use ARE valid!) I get exactly the same record displayed, which is the one displayed by: ....view-perma/Organization_Display BTW - I've used the same format to do the same thing on another table, and it works perfectly. Alex
Custom Styles in Embedded Reports
What is the best way to create custom CSS or other styles to a Zoho Creator Report? Do I have to create a separate "Page" and build it from scratch? Certainly not.... All I have found so far is very limited color changes but I need to adjust the font size of various records and even better would like to highlight certain groups or records differently. I am new to this so maybe this is not too complicated of a question... Thanks
Primary_Contact=crmResp.get("First Name"+"Last Name"); Not Working
Apologies for the seemingly simple question but I am very new to the whole Zoho world. I have built an app in Creator that has a Zoho CRM field that pulls from Contacts to populate fields on my form. One of the fields is called Primary Contact which I would like to put the Full Name (First Name + Last Name) I CAN get Primary_Contact to equal First Name OR Last Name but not both, I don't know if I can concatenate First Name and Last Name but everything I have tried doesn't work :-( My code below works
Grid View not working due to "on edit" action that I did not add
According to this thread, https://help.zoho.com/portal/en/community/topic/changing-the-display-type-of-view-to-grid-does-not-work, you can't have a Grid view if there is an "on edit" action. Fair enough. I have a form that I did not add any "on edit" actions to, but when I go to the Form Definition (With Action) area, it shows the following: actions { on add { submit ( type = submit displayname = "Submit"
New auto-hide dashboard's horizontal scroll-bar doesn't load always.
Steps to reproduce: 1. Create as many forms as it would take to exceed the 3-column listing on the auto-hide dashboard, such that a horizontal scroll-bar would be required to reach all forms. 2. Logout and login (or just open a new tab). 3. Go to the "Forms" tab in the auto-hide Dashboard menu. The horizontal scroll doesn't appear. However, when you navigate to other tabs ("Pages" or "Reports") and return to the "Forms" tab, the scroll bar starts to appear. The problem occurs consistently. -Varun.
Sync my API with Zoho CRM
Hello, I have my own API that already contains info, and I want them info to be transfered to the crm I don't want to use your Zoho CRM API I want to use my own API I want to know if it s possible to do that ? I am awaiting your response. Sincerely,
Graphical view of a referral network
Hi, I would like to create an application to manage a referral network. I have a table with members info (name, referred by, reffering to, etc.) Is there any way to have a graphical view of members? I mean to see who is reffered by who in a view, not searching in DB. Thanks
Keywords used in HTML Page disallows saving it but with an irrelevant message.
If a variable is named after a keyword (like say "count") in the HTML page, the save fails with an error message that asks the developer to contact the support. A relevant error message would be beneficial. (more relevant the better. if the parser can report use of a keyword, even better) -Varun Yagain.
set variable to portion of lookup field
I have a lookup field in FormB that is pointed to FormA. That lookup field is pulling a string and a date. I am trying to look at the date associated with the string to figure out if the item is acceptable or not. When I create an if statement looking at the portion of the lookup field it says it cannot access child fields. Am I coding this wrong or what way should I go about it so that I can get the information I need. Thank you.
Segmenting fields on Zoho Creator
Hello everyone, I would really appreciate if it is possible, using zoho creator to segment fields on the (SORTING/GROUPING menus) so that I get the following presentation on my form, instead of having all the data in random order. Thank you very much for your quick reply GENERALITIES 1) 2) 3) APSECTS 1) 2) 3) PARTS 1) 2) 3
How do I fill a field's value based on the value of another field?
When I am in the Cases (or other modules) of CRM and Choose an existing Contact (lookup), the associated account is automatically filled in for the Case. I would like to do the same thing on Creator form's I have created. The first thing I would like is exactly what I described for CRM Cases. If I get that to work I would like to fill other fields (e.g. phone number based on contact). I am new to Creator programming. I've been searching the forums, KBs and help for this problem. I've found a few
Script to generate a new form
Hi All, Is it possible to generate a new form and view by scripting? I have an application where the user will enter a name for the new form and somehow I'd like this to be created On Success. Alternatively, I could have a template form and somehow script that it should be copied and renamed to the name the user entered. I'm stuck :) Any help, hugely appreciated!!
Inserting bidirectional subform without display type
I'm trying to create an app with a bidirectional subform that doesn't display the linked field below the subform. I have two forms. Main form is "Clients" and subform is "Appointments". I want to be able to enter appointments in on the clients form and have it be a bidirectional link, but when I do it adds another dropdown field below the Appointments subform. There is an Application called Employee Management that I'm trying to mimic, but I don't know how to accomplish it.
Formula field looking up Child of input
I have two forms. Clients - Has First_Name and Last_Name fields. Attendance - Has Client lookup field, Date, and Status. I want to add a formula field to Attendance that will concatenate Client.First_Name + " - " + Status When I try this, the Client.First_Name I get 'Client' is a lookup field and child fields cannot be accessed When I try Clients.First_Name I get Variable 'Clients' is not defined When I try input.Client.First_Name, it accepts it, but returns null for input.Client.First_Name If I
Next Page