How to create relationship between forms which are not related to each other.
I have two forms in zoho creator Shipping and Product Info. Shipping Form has Bill To, Address, Ship To, Ship to Address and a auto number field id. And in Product Info form we have "Product Id, description, qty, unit price and list price" fields. Product Info form is subform in shipping form. I have to fill all the information in forms and on submit I have to display these fields in page. When I submit the form then shipping Info is displaying fine from shipping view but I am not able to displaying
How to combine multiple view into one without related to each other.
Hello Team I need some help. I have created two form "Shipping" and "Product Info". Shipping Info form has "Bill To, Address , Ship To, Shipping Address" fields and Product Info has "Product Id, Product description,qty,unit Price and List price" fields. Product Info is the sub form in shipping Form. These forms are not related to each other. I want to know following things: 1.) is it possible in zoho creator to combine forms which are not related to each other?
Dynamic Picklist: Add to picklist dynamically not working
I have a form where I am trying to add to a picklist dynamically. Form: Terminal Field: Terminal Name Company (Bi-directional relationship) (longlist) Form: Company Field: Name Terminal (Bi-directional relationship) (longlist) When I use the code on another form called Order_Form: VDFCompany = Company [ID!=0 ]; FilteredTerminals = Terminals [Company in VDFCompany.Company_Terminals]; Terminals:ui.add(FilteredTerminals); It works for other fields, but for one of my specific fields it does not work.
How to add a table in a FORM?
Is there a way I can add a table in the ZOHO form? I cant find it in the list of controls on the left side. Please see the attached image.
Zoho Creator: How to export roles, profiles and field permissions configuration?
Hello, I have developed an application using my Deleveloper Edition account. After that I exported the application and import it from the customer account (Enterprise version). However all configuration of roles, profiles and field permission are missing. What can I do in order to avoid reconfigure? Its a lot of work. Is it possible to export and import the permissions configuration? Thanks, Rodrigo Garcia G.
Help regarding updating field from subform to main form.
I am facing a problem regarding the updating field from sub form to main form. There is not relation between main form and sub form. I have added a code on add row of sub form. But it is not updating the field. sum = 0; for each SubForm r in Shipping { g = (sum + row.List_Price.toLong()); } input.Total_to=g; Please reply asap.
Invalid Email
I keep getting the following error when attempting to send an email via function. It seems to only occur when a certain email address is used in the from fields (rec.Return_Email and rec.CC_Email) however it is definitively a valid email address so I'm not sure why this happening. Error details: Error in executing sendemail2 workflow. Error. Error in executing Send Mail task. InValid email Address Found. Here is the function: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\"
How can I know the users logging my applications now
Hi, How can I know the users logging my applications now? Omar
Application that filters from other application to give results immediately in new window
I'm really new to Zoho creator. I've made some pretty basic applications, but what I am trying to do is pretty complex for me. I'll explain what I do and what I would like for Zoho to do for me. I have a tenant placement company with over 100 properties. I would like for when a person calls and specify what they are looking for, ie. I need a 3 bedroom with 2 bathrooms, on the east side in the price range of less than $1,200, I want to be able to choose from a drop list their specified requirements,
Push information to form
Is there a way to push information to another users form? A user might open a form or a report and stay on that screen for a while. If other information has changed can I show a message on the users screen. For example if the user is looking at a report and another user adds records to the report how do I tell the first user to refresh the report to see the new information? Or if the first user is on a form and another user changes something critical to that form is there a way to display a message
Freeze Columns in Creator views.
Is there any way to freeze a column in Zoho creator when you create a view.
Import Permissions?
I've shared a Creator application with other users, but they don't have access to the "Import" option. They can see the "Export" option, but not "Import". Is there a way to give other users permission to import data, or is the individual that created the application the only one that can import data? Thanks
Lookup form data instead of ID in email
I am sure others have had this issue too but I couldn't find the info. How do I get the data ie: Name to show up in my lookup field instead of the internal ID? I have successfully set up my email notification but I can't figure out how to insert the Name of my customer instead of the internally generated ID. All of the other fields are displayed correctly except it is showing the form lookup field internal id instead of the actual field data. Thanks
Shorten string
Is there a way to shorten a string to a maximum number of characters. I have an html page where I don't want to show an entire text field, just the first 50 characters of each post, as some of the descriptions are very long. I would have though trim(50) would do this, but instead it just trims any spaces out, rather then actually "trimming" a string.
How to show specific data into zoho crm fields.
I have a from which contains two zoho crm fields. One is bind to account and another is bind to contacts. When I select an account from crm fields then another crm field should only show contact related to that account name. How is it possible? string default.getAccountName(int id) { crmResp = zoho.crm.getRecordById(("Accounts"), input.id); accid = crmResp.get("ACCOUNTID"); Billing_Street = crmResp.get("Billing Street"); Billing_City = crmResp.get("Billing City"); Billing_State
Form hangs
Could someone please look at the following form and tell me why it is hanging on submit Thanks https://creator.zoho.com/appbuilder/mrcomputer/moto/form/Agents/edit
Inserting image into HTML
I have an HTML view that gathers "blog posts" and displays them. I have an image upload in the form, and I want to display the image, but only if one has been uploaded. At the moment I can't get the image to load. I also can't seem to insert an IF statement after the for statement below. Any help greatly appreciated. htmlpage Blog_View11() displayname = "Photo and Video HTML Blog View" content <%{ for each post in Blog [(Department.contains("Photo and Video") && Expiry_Date > zoho.currentdate)]
problems with export and view number of records
A week ago the option of Zoho Creator - to display number of records and pointer of leaf through dissappeared. So we cannot export the base. Can you help please to solve this problem?
Transfer a date field value
Hello, I would like to transfer from CRM order to a customer module a date field “Event Due Date” value. I proceeded as following: void OperationForOrder ( int orderId ) Edit Arguments orderDetails = zoho.crm.getRecordById( "Salesorders" ,input.orderId ) ; orderSubject = orderDetails.get("Subject") ; orderEventDueDate = (orderDetails.get("Event Due Date")).toDate() ; newOperation.put("Order number",orderSubject); newOperation.put("Order number",orderEventDueDate); createOperation = zoho.crm.create(
Permission Denied
My app users are getting a "Permission Denied." message when attempting to submit forms on their iphones. Everyone has appropriate rights and privileges. I would love some help.
can we apply approval and rejection method in Zoho?
if user add any data ,before going to save it to main database it will first go to Manager. when manager approve it then only it saves to database. i want to implement maker and checker concept,is it possible in Zoho.
How do I format a phone number in a number field?
Ugh!!! I've read all the post on formatting a phone number but I'm confused. Is there anyone out there who could provide baby steps on how to do this in Zoho Creator? I've looked for videos but can't find anything. Even screenshots of each steps would be so helpful. I've read all the tutorials and none of them make any sense. Please help, Lisa
How to Invoke a function in subform.
I have created two forms shipping and product Info and embed the product info form into shipping form. There are no relationship between shipping and product info form. I have created a custom function which get the product id and fill the unit price. When I invoke the function on user input, it doesn't execute the function and gives and error product_id doesn't exist. When I run Product Info form individually, It is working fine. But when I embed it to another form it doesn't work. Please tell me
RTF Memo field
Can an image - JPEG - be placed and visible in an RTF memo field?
How to use auto generated ID in Main Form to subform.
Hi I have created two forms Shipping and Product Info. Product info is the sub form in Shipping Form. when I submit the form then two reports are generated which contains the Forms details and a auto ID is generated. I want to know can I used that auto generated ID into sub form to create the relation between main form and sub form ?
Auto Populate Forms Error
I have built several forms which successfully auto populate the fields based on information in other forms. I have used the instructions from Zoho. However, I am finding that often, probably every other time I try to use this script, I am given the error: Error modifying the page null. My past fixes have been to redevelop the form, but I am getting tired of duplicating my efforts and wasting my time. When I build a new form, I paste the exact same script and it works. Any ideas on how to avoid
How to Copy a Form?
Greetings Zoholites, I have to create 39 individual forms for a survey. Is there a way to create a base form and copy it and then edit for each individual? Grateful for your assistance, Lisa
postUrl broken since last hour
Hi There, All of my functions that use the postUrl function are returning errors at the moment. This has been happening for the last hour. Regards, Ben
How to display a jpeg image stored in a file upload field in record summary print template
I am trying to customize a record summary template for printing a database record. One of the fields is a file upload field that always contains a jpeg image. I am using the file upload field because it can handle images greater than 5MB. I need a way to display the contents of the file upload field on my printed report, but have been unable to figure out how. I have been trying to use HTML in conjunction with deluge scripting, but have been unsuccessful.
Importing from Excel - field matching
Hi I have a Zoho form. I have records that have been typed in Excel which I wish to import into the form. I need this at automated as can be. The form has 30+fields. When I try an import from Excel the field headers have been typed exactly however Zoho doesn't recognise the field matching headers and I have to match the Excel fields to the Zoho fields manually every time. I tried exporting the form from Zoho to Excel then copying my data into the Excel spreadsheet then importing back into Zoho
Multilangual App
How can I build a multilangual application with Zoho?. Means not Zoho to be multilangual, my application to support different languages. The LABELS of the menus and messages to be linked to my database with different languages.
Zoho Creator App - Not working for users
Hi All, The iPhone app for Creator seems to work for myself (admin) but not for any of my shared users. They are able to access through a desktop just fine but the smartphone app just says "no shared apps" when they login. Does anyone have any insight?
How to create a formula that decreases the Due Date - zoho.currentdate by 1
Dear All, I would like to create a form with a date field (name Due_Date) and a formula. My scenario: When I give a date to the date field (for example 22/7/2015) then I would like in the formula field to calculate the date (22/7) - zoho.currentdate and to return me the number of days. In the report, each day the zoho.currentdate will decrease the number of days by 1. In that case I wrote the following inside the formula: days360(Due_Date,zoho.currentdate) The problem is that in the report it does
Dynamic filter
Hello. I have 3 forms: Company Data>>Property Data>>Roof Section Data Property Data is related to Company Data via company name lookup the Roof Section Data is related to Property Data via property name lookup. I created a view based on Roof Section Data and have it filtered by company via the "Criteria" function. I'd like to create a drop down similar to the auto-filter in the below view and restrict the list to the properties belonging to the company name. Is it possible to do something like this?
Issue creating app
Screen displays are all over the place when accessing app to edit and such. Screens are all jumbled up. Cannot access field values to change, screen stays on Form tab. Refreshing screen just jumbles everything on my screen worse. Emailed app comes in as SPAM and shows this on email. Firefox 39.0
What is the best practice for editing fields of a form from a list on an html page?
I have an html page. In this html page I have a table with iterated records from a form. I need the ability to click a button on one of the rows, which will then allow the user to edit only a few of the fields from the form. The primary field that will be edited is a dropdown. What is the best way to do this? It seems there are multiple routes to go: From the page, create a stateless form that pops-up or iframe with the fields to edit. Have buttons that use url variables that correspond with the
Alert Box on HTML Page (Creator Page)
I would love the ability to quickly debug my code in a html page by using the alert(); function. But it can only be used on a form in the onload section. The only workaround is to email to myself. BUT, its more than the debug function though. I would like the ability to alert my users as to change they made. Like, you just updated your subscription preferences. How have others been able to do this adequately? Is there a workaround?
User Field with zoho.loginuser
I have a main form with User field that is populated with zoho.loginuser upon add. As an admin, when I change the user field to another user, I want my subform to reflect the same loginuser. The subform has a field called User_name and it is a string field (not a user field). In the On Update of the User field in the Main Form, I wrote a deluge script to populate the User_Name field (string) of the subform so they are in synch. It does not appear that the functionality is present for User fields?
Custom Action Sendmail and set field value
I have my sendmail function setup and working so that when the user selects multiple records they are emailed. However, i would also like these selected records to be marked as "emailed" so that another user does not come along and email them again. How do I accomplish this? Here is my sendmail function if it's relevent: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\" style=\"\" width=\"90%\" cellpadding=\"5\">\n <tbody>\n <tr>\n <th align=\"left\"
Form created to filter records in report
Hi, I have created a search form which is supposed to filter the records in an existing report. On this search form, I have the option to search by three different criteria (you can only search by one given criteria). For example you can choose to search by Name. I am not sure what I am doing wrong here; I would like to use the public link of my published report. This is what I have: if ((input.Search_by == "Name") && ((input.Name != "") && (input.Name != null))) { openUrl("https://creator.zohopublic.com/zoho_jchan5/copy-of-requests-for-purchasing/view-perma/New_Request_Report/Xy2yfT1JP48sAa9ZbTmP6Yh8qtPAXvYBVvOgrxnkABdnrjU2f3Tat66zKN8V7XUz3xUTugdx2OnMMsBMP2k0fr4GxBSQqN9nJ5fv?Requested_By="
Next Page