Cannot pass an autonumber field from a report via an application button
I have a report for a table, for each record there is a button which triggers an application to send a field value to a form. If I set the field to autonumber (showing in the report) I get a null value. Setting the app to get the ID works. I really would like the autonumber field as I do not want the user to see the record ID in the report. Any help?
Can't add user, role, or profiles to manage security
I have a Standard Edition account. I do NOT see any of the menus or screens shown on these documentation pages Add Users or Creating Profiles or Field Permissions I do not even have Setup > Users & Permissions > XXX. as mentioned on all of those pages Under Setup > Manage Users, the + Add User button launches a form that only contains a field to enter email addresses. No invitation is ever sent to the email address. I've tried various addresses and checked spam/junk folders. In spite of never
Web form
I have created a web form in Zoho creator and I want to be able to receive a notification by email when the web form is completed by someone on our website, how do I do this?
Email Templates
We just upgraded our account to the Enterprise account and now can't get any help from anyone at Zoho. I'm very frustrated!! The main reason we upgraded our account was to access your pre-made email templates as shown here: http://www.zoho.com/campaigns/campaign-editor.html. It says, "You do not require HTML or web design skills to build your email templates. The drag-and-drop editor makes it easy for you to design newsletters that suit your need." So far we've found this completely untrue. We have
Shared users names dont show up
When i go to share users to my application creator seems to be glitching and not showing the user names on people it is shared to. You can see in the picture below what I mean. This seems to be happening when more than 8 users are shared to a view. Please fix this! Also is there a way to add users to a private group so users cant see other users in the group?
Adding to Picklist Dynamically Clears Current Input Data When Editing
Hi! I think I have found a bug. But I would like your help diagnosing. I have a form where I add to a picklist dynamically using ui.add. All works just as expected. But when I go in to edit he form and I have that same script to add to the picklist dynamically, it clears the previously selected value. Example: FORM Location: Produce Product: Apple I have a form that adds to the "Product" picklist dynamically. When submitted the data written is as above. But when I go to edit the form and I have a
New Import Errors for Currency
A client reports that in the last two weeks, they get errors when importing currency data. This was not the case earlier than two weeks ago. They now have to convert all currency data in Excel to number columns. So was something changed that we were not informed of? Cheers, John Whitney
How to publicly share an app?
Hi, How can I publicly share a Zoho Creator app? When I want to share I only have these options: I have looked how to share publicly on your website and I have found this: https://www.zoho.com/creator/help/application/application-sharing.html On this webpage, there is a 3rd option "Make public to all visitors over the web". Why is this 3rd option not available for me? Regards, Chris
Report based on a date calculation
HI There, I need to run a report that brings back all requests we have that were completed more than 2 working days after the receive date. Is this possible ? I know Zoho has the "addbusinessday" option in the workflow as I have a field that calculates a "Scheduled completion date" based on 2 business days from the received date. however I need to pull a report that shows anything that has the completed date greater than 2 business from the scheduled complete date. Kind Regards Matt
multi row reports
Hi, I need to create a plain report to export a spreadsheet. I have a Form A for "Headers" that contains a Subform that lookups "Detail" info from Form B. So users can create a Header record and assign as many rows from B as needed. When I run the report I get Header Field Detail Field ------------ ------------ A B1, B2, B3 I need this output: Header Field Detail Field ------------ ------------ A B1 A B2 A B3 Is it possible ? Thanks !
Display only newest record for given filter
Hello, I have a set of data that I need to update manually, say, once a week. To do so, I've created a form which takes the date uploaded, customer name, and the data (hours of operation since maintenance was last performed). The data is imported as a tab-separated list from our telemetry monitoring page. I'd like to have some way to either (a) overwrite the data for each customer so that only the newest data is in the log, or (b) be able to automatically pull only the most recent record for each
Replicating data and report for business partnership that is ending
My business partner and I have been using Zoho Creator to gather information and we have a report that captures this information. We are in the process of terminating our partnership, and need to make sure that both parties have access to both the data and the reports developed up to this point. Can someone please advise how to best accomplish this. Thanks!
Workflow
Hi, How to define a status based on element the item information? Suppose I have a table named 'Request' with these fields: - Date submitted - Date validated IT - Date validated Business Now I need to know the status of each request by having a status field like this: - Status=submitted => if 'Date submitted' is not empty - Status='validated IT' => if 'Date validated IT' is not empty - Status='validated Business' => if 'Date validated Business' is not empty How can I do that with Zoho Creator? Regards,
Gather Data for very month
How can i add data of aspecific person for the whole month? Because i want to send it automatically every first day of the month Hi ' Sales Agents Name ' Please review the attached file, that includes your pay statement for the Month of " Month name" If you are unable to download the file or if you have any questions, please contact you payroll administrator for assistance.
Why are my embedded public reports suddenly asking people to log in?
I have two embedded publicly available reports on my web site. Twice now, one or both of them have suddenly changed from just being available to this message: You have logged in as Public. You are not allowed to access this view. Please click here to login as a different user. Click here to go to your Home Page. What's going on? Why did the visibility change without notice, and why are they now asking people to log in? Thanks, Alex
Account suddenly canceled for no reason!
I can't access my account. After persistent calls and emails I received a matter-of-fact response that I cancelled my own account. I absolutely did NOT cancel my account. I had just upgraded and paid for entire year! I'm at a loss here. I can't get anyone to respond to my issue with any compassion or willingness to help. I'm using the account of one of my team members to post this message.
Can't Duplicate application.
Can't Duplicate application. On the home page I click on duplicate ... a popup says duplicating but that's it. The application is not duplicated https://creator.zoho.com/workspace/beller32/home. WHY?
Uploading images on a stateless form or importing bulk images
I am working on a creator app that will function as a survey, so the user interface will be public. There is an option to upload an image file on the survey. Ultimately, I want to display a sample of the images on a future survey. I see that on a form, I can select "Local Computer" as the browse option, but I would prefer not to make the form itself public. The "Local Computer" option is not available on a stateless form, so it appears I cannot make a public stateless form with the same field.
One to Many
I have the $25.00/month version of creator - I discovered it does not support one to many (subfields). Does anyone know what I have to do to get this option?? Thanks
Data deleted by error, and can't import by zoho issue.
We deleted by accident all the data from de form Presupuestacion, our last backup is from 19/05/2014. Can we restore our data? I tried to import some data about 1 -2 weeks ago, but Zoho creator give this error: Thank you, greetings.
ERROR "problem encountered while creating the application null"
Error message "problem encountered while creating the application null" any thoughts?
If else if sytnax
Can someone let me know what is wrong with this syntax. I am getting an error on the first line (improper statement) this in the deluge for the heightfield upon user input. if ( (input.Widthsizefield >= 24) && (input.HeightField >= 36) ) { input.Currency= 218 } else if ((input.Widthsizefield >= 48) && (input.HeightField >= 60)) { input.Currency = 372 } else if ((input.Widthsizefield >= 60) && (input.HeightField >= 72)) { input.Currency = 473 }
Database won't duplicate
Logged two support requests, no response to date. Can't duplicate Marine Cargo database is first issue. Second issued can't ceate new form from template quickquote in database marine cargo, error 500 appears.
New Array Intersect Function Issue
This picture explains it: However it works in free-flow scripting mode Cheers, John Whitney
Simplifying form choices and adding to DB
I imported a rather large DB (Excel) into Zoho as the base of my application. I have fields such as State which I would like to change on the form side to a drop down for the user. I would like these values to still populate into one overall State column (for ease of reporting). Is there an easy way to do this?
Free Embeded Forms
Hello, I've been toying around with creating forms in Zoho Creator. On the main page before creating an account, much of the advertisements references free embedded forms, but the only way I can find to do that is by Publishing the form. Whenever I attempt to do so, I get an error message that free/trial users are not able to do so. Is a paid account required for the ability to embed forms or am I doing something wrong? Thanks in advanced for your assistance,
Mismatch data type for function get at argument index 1 expected data type BIGINT found dataType STRING
Hello Please tell me how to solve the following problem?
Is there a way to export, update many fields, then reimport our database
We have a database where we want to update the "Status" of 500 different entries. Is it possible to export the data, update and then reimport? Or some other way to update easier then going into each entry?
How to remove all sub tabs ?
Hi, How can I remove the sub tab 'Companies Report' ? When I click on 'Companies' I already go to this report and I only have 1 sub tab below 'Companies'. So I want to get rid of this unuseful sub-tab. Best regards, Chris
Looup Filter Error .. How to solve this ?
Hi , I am new to Zoho Creator. I am creating form that contain two lookup fields . like Country and state . But In that I can't create filter . I attached screen shot . Have a loook
How to hide fields when editing report
Hi Very new to Zoho. I use to code PHP no worries and would prefer to use it but then my manager can't make changes. I don’t think the manager has setup the database correctly from the beginning but I need to make a few changes while i redesign the Zoho database for him. I have a calendar view for routing jobs for guys in the field. When you click on a job in the calendar it opens the view we want and shows the fields we want. The problem is that when we click edit from there it shows all the
Reporting showing separate row per record in a subform
Hi there, Ok title may not be clear but.... I have a main form that holds the Delivery request details and for each delivery request I may have multiple items going out and for each item I have to record the Asset number and/or Serial number. I have a products sub form in my main table that I can add the product name (default qty is 1), the serial number and the asset number. I need a report so I can run a daily dispatch report, that details a row for each product shipped and certain required fields
NO IDEA WHAT I AM DOING- Subforms
I want a field in my subform (Cust_Ref) to automatically fill from the given input in the main form (Claim_Number) I have tried using a number of things in the script builder but I can't get ANYTHING to work. I need to know how to write the code and WHERE EXACTLY to put it. I am at my wits end. Nothing I have entered has even been saved by the script builder (I am hitting save script and getting a success message)... when I go to check to see if it worked and go back to the builder the code I entered
Available CSS
I have really enjoyed using Zoho to create an app for my small business. Now that I have learned the basics I would like to begin using the powerful HTML features. This question relates to furthering that desire. Zoho appears to have some very handsome built-in CSS classes for use with HTML views (zc-rowheader, zc-viewtable, etc.) I have tried searching the Help Center and Forums for a list of these classes and their attributes to no avail. Is there any possibility that Zoho could post a list
Basic Newbie Support questions
Hello All, I am very new to zoho and have some basic questions. Can I connect a different form to the "back end" tables? I don't see any access to data structure to connect different forms. I would like to create different forms for different people. Some for just inputting data and others for changing or viewing. Can I create a form in a different view that will allow me to see ALL the records? Right now I have my one form and one report to show all the records but no way to change them. In
Create one record per multi select
Hi, I'm looking to create a single new record for EACH selection in a multi-select. I have a stateless form "Add Campaign" asking all the same fields as the main form "Campaign" except that the stateless form has a multi-select for the field "Test Name" while I would like each record in "Campaign" to only have one Test Name. Therefore, on the stateless form "Add Campaign" I would like help with the script when the user presses "submit", it will Add a Record in "Campaign" with a single Test Name
zc classes
Hello, where can I find the explanation of the classes zc available for use in html pages? example: class = "zc-edit-a" class = "zc-zc viewrow-row-1" class = "zc-zc-formheader formheader-height" class = "zc-formbutton" etc. .. Best regards David
Show / Hide / Disable fields
Hi Zoho Development, Some forms by necessity have a significant numbers of fields that often need the use of show, hide, enable and disable. Would you consider a future enhancement where the coder could use an asterisk (wildcard) to denote any characters. For example, show AA* would display all fields with the Deluge Name AA[something]. The coder would then have the ability to name fields in groups to suit their application and instead of multiple lines of show, hide, enable and disable, it might
Custom "Record Summary" changes Record Limit to default 10 in List view without consent
Hello, If using a custom Summary View, using the "View Record" function in a List view will change the Record Limit to 10 when you return from it. Steps to reproduce this are: 1) Create a new Form and View and create a record 2) Set the View's "Records per page" setting to anything but "10" 3) Create a new Record Summary under View Settings -> Record Summary 4) Populate the new Record Summary with anything or nothing 5) Right click on a record in your View and use the View Record function 6) Use
Problems with sharing applications
Greetings! I just moved us from a free subscription to Express Standard. I still cannot enable sharing for all users under our domain. I select the option, click Share it says it's enabled it then nothing. Our account in enabled for your tech support folks to access it. It's for the Policy Database...we want it enabled for all users under our domain. Help...thanks! Joshua
Next Page