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
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?
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.
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
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"
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,
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.
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
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
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
hide print option
Hi, I am trying to hide print option in the view. I was trying with below code but it seems it is not working <div elname="zc-component" viewlinkname="MVPD_Channel_Form_Report" params="zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true">Loading View...</div>< See below output result: Can anyone please help me Arfater
HTML Close Table Borders
Good day could you please tell me how do I close the borders for this table, (bottom and right border) HTML output = output + "<table class='tableSize' align='center' frame='border'><tr><td style='width:20%;vertical-align: top;'>"; output = output + "<table border='1' align='center' cellspacing='0' style='border-color:#EEE;width:95%;margin:0px 0px 0px 0px' id='billingAdd'>"; output = output + "<td class='rowHead'>Consecutivo</td><td class='rowVal'>" + AvanceDiario.Auto_IDStr + "</td></tr>"; output
REST API Response
Hi I got the following response from REST API call. var zohochandrasekhar.kview54 = {"Welcome":[{"ID":"1205836000000077129","Image_Url":"https://pbs.twimg.com/profile_images/459764305567576064/ILQOFcfh.png"}]}; Can you please let me know why the string "var zohochandrasekhar.kview54" is added before the JSON response. Thank you
Open Form with Lookup Value as a Parameter
Hello - I'm working on solution that will send email notifications on a scheduled basis to customers to fill out a survey via a link to a Zoho creator form. The survey form data needs to be related back to the customer form, so I've placed a lookup field on the survey form to accomplish this. I need a way to include the customer ID (the value of the lookup field) in the link so that the survey form can be related to the customer without prompting for that information. Using the standard "?customer_lookup=000000000"
zoho.loginuserid in criteria
list Team_Events { displayname = "Team Events" show all rows from events [team == members[email == zoho.loginuserid].team] ( ... ) } team == members[email == zoho.loginuserid].team returns the correct BIGINT. If I set team to that number statically, it filters the correct data. Why then does this not work?
overriding report permissions
If I set the permissions for a report to allow add, edit & delete the following code in an openurl will cancel these options. "/view-perma/Board_Minutes?zc_EditRec=false&zc_AddRec=false&zc_DelRec=false" However if I set the permissions to NOT allow add, edit & delete the following does not allow these features. "/view-perma/Board_Minutes?zc_EditRec=true&zc_AddRec=true&zc_DelRec=true" Is this the way it should work or do I have a problem with my syntax. Note this is for a Customer Portal user.
Digit Grouping for Zoho number fields
we'd like to see digit grouping feature for Zoho fields like Numbers, Decimals and currency. We have an application that generates bills and printed on invoice, but ZOho currency fields are not able to display digit grouping for the values. eg: we'd like a feature that would make USD 8346073.66 appear like: USD 8,346,073.66 Any help will be appreciated
Using checkbox as workflow automation
Hi, I am using a checkbox as a means to automate the process. As of now, I have 7 different selections in the checkbox. Each will have its own email sent out after it has been marked as checked. As of now, I am using IF statements to attempt this but i get an improper statement error. For example, the 7 checkbox choices are: (1) Awaiting Approval (2) Approved/Denied (3) PO placed (4) PO confirmed (5) Receipt received (6) Shipment received (7) Payment issued If I want to send an email after "(1)
Is't possible to move Form to another app
It will be very useful to have ability to move form and all assosiated views to another app. Now I have 4 app, which are full of different data, and they are using all, but sometimes it's nessesary to change architectury of whole application and I need to move some forms from one app to another. By hand it's very difficult to do. I understand that there may be some problems with openUrl function, which are using "#Form:.." or "#View:" navigation, but may be you can do something. I think it's possible
How to NOT display "null" in empty fields
I have a form called "New Request" and a stateless form called "Update Request Status". In Update Request Status, I have a field called "Task Pending Notes" - here, the user will fill in the notes and upon submission, this will save the notes into "Task Pending Notes" in New Request, along with a timestamp. This happens every time new notes are submitted, and they are saved, collectively with each note and timestamp in "Task Pending Notes" in New Request. This is also auto-populated into Update Request
Sendmail - Email sent to multiple persons
Hi, I have used similar code on a related form and it worked, but it doesn't seem to be working here. So, what I want to do is say, there are two email address fields - one is called Email Address, the 2nd is Email to CC. I want the form to send out a certain email and cc the 2nd email address IF IT IS NOT NULL. This is what I have: if (((input.Task_Completed.toString() == "Completed") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC == "")) { sendmail (
Embed web form
What are the steps to embed the web form on my website? Thanks
Cannot share forms or reports
I am trying to share an application with one other user. I've shared several sections and forms with the user. The user sees the application on the home page, but when clicked on it says the user doesn't have access to the application. Please help, Joe
Left Expression is of type string in lookup
After reading a number of posts, I understand the issue that my lookup is returning an integer and my initial data is a string. I've tried following the advice in the one of the forums and creating a variable to convert my lookup iD to the correct field. But I get an error message now on the variable. If the two elements were strings my code would look like: Email == input.Employee meaning that the field from form Ticket_Entry would perform a look on the field employee in form Employee. Of course
Using Deluge variables in data stored inside zoho creator forms
Hi I am building an error handling mechanism for an application. i want to store the error codes, error names and error messages in a creator table and send back the data requested according to the error code called for. in some errors, for example when a variable sent has an illegal content - Example: Document type can be: 10,11,12 user sent the value 13 for a Document type. In addition to the hard coded message stored in the table, i want to include some dynamic value, in this case the value the
Next Page