Protectting a Form
I have a number of forms that I only want to be added as subforms. If they are added via their own form alone it causes issues. Is there a way of preventing forms being added when they are not being used as subforms? The particular issue I'm having is in calendar view, clicking an empty date adds a clear form that is intended to be a subform only. With Thanks!
Published report, still looking for login from emailed File Link
Hi, I have a problem where my customers cannot download the files from the link I send them in an email. Link works fine when I login. The report is published. I have logged a support request and enabled access to support. This is urgent, please help. Thanks, Rob
Import problem with console mode
Hi, I am having problems using the zohocreator.exe tool to import excel files into Zoho. I receive the following error : The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine What are the technical requirements to launch zohocreator.exe ? Do we have to have Office or Access installed ? On the server I will launch it, I will just have the xls files. Many thanks for your ideas !
Emergency! Trouble with sharing Apps
Is anybody else having problems sharing apps in Zoho Creator? About a week ago I started getting calls from Users with whom I had shared apps. They were logging in as usual but getting an error message: You have logged in as (xyzabc). You are not allowed to access this view. When I checked the apps it showed they were still listed as shared users. I had not exceeded my user quota. My own login (as Admin) was working fine. Despite all that, when I tried to log in as them, I got the same error message.
info in OnInput script
Hi peeps, does anyone else find it annoying that you can't use info() - the debug command - in OnInput scripts? I've got an OnInput script that is generating an error but I can't put info calls in there. I vote that info() be allowed in OnInput scripts. cheers, Jeremy
Want Zoho CRM integration with my database in Creator
I have an account in Zoho Creator and I have added 3 other colleagues as users. One of the user has an account of Zoho CRM. How do I integrate this Zoho CRM account with my Creator?
File upload
I have a field in my main form that for file upload. I have a stateless form which allows the autopopulation of the information in the main form. Is it possible to show the attached file? How do I allow this access without login access?
is it possible to link two tables that share the same lookup?
I have 3 forms A, B, and C. I want to report and associate data between B and C. They are both linked to A via the same lookup. is this possible?
Time lost in Pivot Chart Report
Hello Everyone. I would really appreciate any help the forums can provide. Here we go.. Overview I have created a simple form for our technicians to record two gas volume readings in our lab. The data is gathered from two "Decimal" fields (2 volume processes being monitored) and one "Date-Time" field (date/time each reading was recorded). I created a Pivot Chart to graph the data. My Y-axis displays all volume readings and my X-axis displays date/time, thus allowing me to compare performance of the
Signature Image HTML display
Good day, I use the following deluge script to get url images to catch signatures and display in html reports. I open the report with my developer user and it works perfect, but when another user open the report the signature images appears as a broken link. I try publishing the report where are located the signatures, but I have the same issue. imagelnk = FetchRegistro.Firma_Capacitador_1; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri);
Edit Access to Single Record via URL
I'm developing a system to allow public users to request meetings and to include an approval process. What I'd like to do is have some way to allow the application to be reviewed by a staff member and approved, rejected, or sent back for comment. Where I'm hitting a snag, though, is in figuring out how to programmatically allow edit access to a single record without requiring the user to log in. The workflow I'm envisioning is roughly: 1. User submits request 2. Staff member reviews request and sends
How to fetch the min-max date from a subform
Dear All, If I have a subform with dates and I want to show ( when I click submit) in a html page only the min (28/3/2015) and max (22/4/2015) date how can I do that?
Two way data sharing: Zoho CRM and Zoho Creator
Hi there - me again! I wondered if anyone knows if Lead module data can be pulled from Zoho CRM by a Zoho Creator form so that the user does not have to re-enter field data already in the CRM Lead module? The Zoho Creator would enter a unique case reference to call up the data for that record. They would then add new data via the Creator firm to update the CRM Lead and trigger workflow. If any of that make sense, it would great to hear from someone! Thanks, Marc
Customer Portal access
Currently I'd like to create a customer portal with specific access to certain forms and views for one customer and another one would have the ability to view other different forms and views than the first customer, but some forms and views they would share. The permissions are currently able to only allow permission to everyone or no one for whatever forms or views I choose. My alternative is to have another app created that has a seperate customer portal but would need to be able to apply
Creator Reports suddenly giving error with linked fields
I have some reports in Creator that have overnight stopped working, the broken piece is columns that point to another form. These were working last night but not this morning, and it doesn't appear to be all linked fields just fields in certain forms. Has anyone else seen this or have any advice on bypassing the problem until it is fixed. -- Gabe
Sub-form
Hello, I'm trying to build a communication module in a form in Zoho creator. I got three fields: 1. Message 2. Zohologinuser e-mail 3. Logging: Date and time Field 2 and 3 are filled in automaticlly and are disabled. I would like to disable the field message in a row after user input. Is this possible?
Fomratting text strings in Zoho Creator
Hi I am developing a small app which will generate emails based on a status field. But i can't figure out how to format different text strings. At the moment its a big if else if else if else ... construct , and within each condition it has a SendMail and all the appropriate text is formatted within that condition. It would be much better if i could format a number of strings like emailHeader, emailBody, emailFooter, and then just have one SendMail at the end which sends emailHeader+emailBody+emailFooter.
Converting to a negative number
I'm working on a trial basis so please forgive me on the simplicity of my questions. I would like to convert the amount entered based on another field. So... If TYPE = "expense" I want the AMOUNT field to be negative or else positive Thatnk you
Position of OpenUrl Window
Hi, Is there any way to I can Open the popup Window (openUrl Task) in the Middle of Browser now it seems always opening in the upper left hand corner ? Arfater
Publish Deluge script on own server
Is it possible to host the deluge scripts on my own server? Oliver
Execute Zoho Creator App without credentials
Is it possible to publish a Zoho Creator App in such a way that it can be executed without the need to log in? I'd like to use Zoho Creator to develop an app for my website that all visitors can use. Thanks Oliver
New Field in Existing Form is not showing up!
Hi Can anyone help please? I'm new to Zoho and my husband created my database and forms, but I've added a new field to the form. When I want to create a relationship from another form to this new field, it doesn't show up in the field listings? Very strange considering I can see it in the Form and the reports too. Any ideas? Many thanks, Nicky
Who is the best partner in the south of the UK who really knows Creator?
I am considering a project that I think needs to involve creator so I would like to talk to somebody who really knows its capabilities
Subform field details in email
How do I include subform details in an email? When I create a record summary to attach to an email (using senmail function) to display details of both the form and subform, the subform fields appear to be empty. Please help!
Form Automation not working on script update of decision box!
I'm trying to dynamically limit the number of subform rows allowed based on number field in form. I have setup form automation to hideAddEntry in subform on a decision box. This works when I manually click on the decision box. However when I use scripting to update the decision box, form automation does not work. Is this default behavior? Damien Cregan Hire an Expert
HTML image view issue
Good day I have an HTML output where I need to display a image for a signature, I already have the link for the signature but when I display with the HTML img src I can't show correctly. for each x in FetchRegistro { link = x.Firma_Url; LinkFirma = "<img src='" + link + "' alt = 'test' height='30%'/>"; output = output + "<tr class='rowVal'><td>" + LinkFirma + "</td></tr>"; } If I replace link with a sample value of the Firma_Url it works LinkFirma = "<img src=" + "https://creator.zoho.com/czambrano1/recursohumano/Firma_Diaria_Report/2357982000002871223/Firma/image-download/1426707525078_signature.png"
Currency cannot handle commas
Hi. Extreme newbie here- Made forms for a client and LOVE using Zoho creator but having a hard time finding a fix for one issue: Have a field set to "currency" specifically "USD" , but if someone types in 100,000-- the form will not take the comma at all. Since this is for real estate, we will be dealing with larger amounts. Is there any way to have a number field, specifically currency, that will handle commas? Thanks
Wrong Language Dates
Good day, I setup my application in Spanish and in settings I set the following date format (spanish tag) The problem is that in my reports date appear in English (all the app is in Spanish), I already check if there is any wrong translation but everything is Ok,
Using "Fetch" In Script Builder
Zoho wrote this script for me to Fetch information from one form and pull it into another form. rec = Freight_Schedule[ID == input.Freight_Schedule]; Invoice_1=rec.Invoice_Number; Invoice_2=rec.Invoice_2.toLong(); I tried to add to the script using the "Script Builder" and I came up with this script but it doesn't work. rec = Freight_Schedule[Carrier = rec.Carrier]; I tried to changing it to Carrier = rec.Carrier; but it still doesn't work. I'm using "Workflow" "Field Action" "On User Input" Any
Creating a group and sub-items
I would like to create a form that will allow me to enter a group, and then enter items in that group, which individually also have their own attributes. Each group can have one ore more items. What's the best way of doing this inside one form?
Want to make a public form
Why cant i make the form i made public? It will only allow me access to private sharing. I'm not sure what to do.
Using formula data to create another formula
Hi.. thanks for reading and hopefully pointing me in the correct direction. I have a simple formula with a field name of "Actual Buy Price $" The fields include: Regular Buy Price and Discount The expression: (Regular_Buy_Price - Discount) This works fine and as intended. What is needed now is a conversion inserted into a different field named "Actual Buy Price ₱" based on the result that is displayed in the field "Actual Buy Price $". Basically I need to multiply the result from expression (Regular_Buy_Price
BUG: "Users" type field cannot be referenced
Hello, It seems "Users" type field sometimes can and other times cannot be referenced. My app contains a form called Users, having one field of being type "Users" and named Username 1/ "User" type field cannot be used in list The code below create error UsersList_SelfLookup = Users[Organization == LoginUser.Organization].distinct( Username); UsersList_SelfLookup.sort(true); Trips_Approver:ui.add(UsersList_SelfLookup); 2/ "User" type field can be used while fetching record "On User Input" but
Passing values in the URL
I've done this before in PHP but just can't seem to work out how to do it in Deluge. I have a form called FormA. It contains a field called ID_name. When submitted, I want this form to send the user to another form called FormB, with the value of ID_name written into the URL. THAT MUCH I can do. It's working fine. I use a questionmark between the URL and the ID-name value. However, I now need the second form to read this value (ie what follows after the question mark) and to use this as input
Calculating Grand total from subform subtotals
Hi, Ive created a form that calculates the grand total. This grand total adds the values for each new row in a subform. Here is the code ive been using Quantity_Ordered on user input: row.Subtotal1=(row.Quantity_Ordered * row.Unit_Price); Total_Due=0.0; for each item in Items_Ordered { Total_Due=(input.Total_Due + item.Subtotal1); } I keep getting an error message Error details: Error in executing On User Input script of the field, Quantity Ordered Error Error in executing For Each
URGENT! error when buy add-on
hi try to buy +500 schedules there is error. please solve.
more than 5 records per page for mobile applications
Hi, is there a way to show more than 5 records per page in a summary view when oppened in a mobile device? I saw a post about this with a negative answer but that was a few years ago. Perhaps something can be done now? Mobile usage is key these days. another question, the "next" page button shows in the header of the view. Is it possible for it to show also at the bottom? Thanks Luis
Unique requirement from client to create a product module
Dear Anbu, I have a unique Requirement from my client. Client is Using EE CRM and we can't customize the Product module so I want to go with Creator and please give me some suggestion related to this Unique Requirement. I have attached the screen shoot for your consideration and When i click on the add product in CRM..Frist screen shoot.I need to get all the products with line items(product name,Product code,Product family,Category,Ad sizes/Special Ops,Position, Currency) when we select the products
Populate subform from unsaved parent form
Hello, I'm getting my feet wet with Zoho creator. I want to create a rudimentary parts management system that will have records for manufacture, testing, orders, RMA, etc. I am trying to create a form for orders, consisting of a PO#, date, and customer (which is a lookup from the customer form). I have an order item subform that includes PO lookup from the parent form, a lookup for the item part number from the 'item' form, and quantity. The problem is, the PO# can't be looked up until the parent
errors running zoho creator native app on iphone6
We have written an app that required users offsite to use, and therefore need to implement a robust mobile platform. Problem so far is we are having different errors appear over various platforms. Is there a known issue with the zoho creator native app running on iphone vs android vs mobile browser ? Also, what is the most reliable mobile browser to use on either apple/android if we wanted to run the application via mobile browser rather than the zoho app ? Getting very frustrated with inconsistencies
Next Page