Zoho Creator issues importing files
Every time I try to upload an excel file it takes me to the page where it imports the data but even when I name the label and click Finish this error message pops up "Please provide label name for database form."
SubForm edit
I try to connect records from subform into main form. I make 2 simple forms and joined it as a subform. I build simple code: Record = Availability[Date_field =="12-Nov-2013"]; Subrecords = dt.SubForm; info Subrecords; The result is: Time_Schedule[ ID in (1581254000000652651) ] Then i build next code: IDList = Time_Schedule[ID !=0]; Record.SubForm = IDList; info IDList; The result is: Time_Schedule[ ID in (1581254000000652639,1581254000000652647,1581254000000652651,1581254000000652743,1581254000000653527)
Lookup field in a subform
How can I detect if a lookup field in a subform does not equal "-Select-" please? I'm sure others must have hit this same problem but I haven't been able to find the answer as yet! I have tried null and even ID=0 but no joy so far. Many thanks for any advice
Creating a form which filters out projects that don't have assignments
Hello - I'm trying to create a report that will show me only projects for which I have no one assigned. Assignments is a separate Form from my Projects Form. The Assignment Form references the project that it's for, so there must be a way to filter just projects that don't have any assignments, but I'm not sure how. Probably involves creating some kind of flag when an assignment is created. Can someone help? and talk me through it? I'm a newbie at this, so I need baby talk... :) thanks in advance.
how to embed a specific form entry on a web page
Hi, I am building an application for real estate, and it has one record per property, with all the property details needed for that property. The data is filled in by the company staff when they are logged into zoho creator. I would like a way to then embed the record view on a web page for a particular property so that our customers can view the property details and make a purchase decision. Of course, the embedded details are not editable. How do embed only one record onto a web page? Thanks, David
Email Notifications
How do I include an uploaded document in an email notification on Creator?
Set project status to pending as long as current date is before start date
I'm Trying to create an automatic status for a project that will say "Pending" until the Start date of the project is reached. I tried creating a formula field called Status and tried to use an if statement with zoho.currentdate, but it didn't work. Can someone help?
Try Editing Records via Record ID
I have tried to editing Records via Record ID(https://creator.zoho.com/jeremy.nagel/copy-of-teacher-database1/#Form:Teacher?recLinkID=<%=ID%>&viewLinkName=All_Teachers).It work fine and takes to record edit mode. But once I click on update button it redirects to this https://creator.zoho.com/appcreator/jsp/successpage.jsp page and wants to redirect to All Teacher view Any help appreciated.
can i insert data in subform by insert expression
Hi, I have a Form "Create_Invoice" with sub form "Product_Details". I want to insert data into the by a Create_Invoice data which ID I have given. I use following codes: invs = Create_Invoice [ID == input.invId]; insert into Create_Invoice [ Added_User=invs.Added_User Subjects=invs.Subjects Itemline_Products_Type=invs.Itemline_Products_Type Due_Date=curNewDueDate Discount=invs.Discount Sub_Total=invs.Sub_Total
Filter Zoho CRM Field and change columns?
I want to use a zoho crm field in my form. Its easy enough to use the drag and drop method of this but this seems to leave many issues. 1. When using the form and adding a value to the zoho crm field, how can i control what columns show in the popup window? The columns that currently show up when using the invoice module is the Subject, Status, and Grant Total. I want to change these columns and add a couple additional ones. How can this be done? 2. How can I filter out certain records from showing
Syntax errors don't show on correct line
Hi Zoho, I've noticed that I get "improper statement" errors with unhelpful line numbers. E.g. try compiling some code like this: //send out editorial writer emails for each booking in input.Edition_Bookings { //check whether an email has already been sent to this writer writer_obj = Editorial_Writer[ID == booking.Editorial_Writer]; writer_email_address=writer_obj.Email; email_sent_to=booking.Email_sent_to_editor_email; if(email_sent_to != writer_email_address) { //either no email has been sent
Two problem with application: not run imputation to field and not run duplication and import ds
Hi, My first problem (and it is important for us) is not run imputation to field. My applications is kind of survey. I didn't check Zoho Survey, because I need integration with Zoho CRM and i want send data to my service. We have one survey but six other way. So I did one general form and seven stateless forms. One form to define way ( one of this: Women age <29,Women age 30-49,Women age >50,Men age <29,Men age 30-49,Men age >50) Every of this form have ~30 questions. We split every for 5-6 site.
Previous script logic no longer works with new application builder
All, in the old system the following code would ignore fields that had nothing selected, and would only perform the INSERT command for fields that had item selected in the dynamic pick-list. // If the serial number field is set to something other than -Select- then data will be inserted into the data capture form. else will be ignored. if(input.Serial_Number_One != "-Select-") { insert into Crossover_Testing [ Added_User = zoho.loginuser etc........................... this statement
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
Next Page