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?
Creator Fetch and Email Forms Help
I am trying to understand this support article: https://www.zoho.com/creator/help/script/fetch-and-email.html I want to add a script on Success to fetch the records with the same email as indicated in the form (as a summary of form activity) and then put the records into the body of a sendmail. The article has this: (excerpted to show the part I'm focused on) ... for each r in Subscription_Form [isUnsubscribed == false] { sendmail ( To : r.EmailId ... Code Explanation ... for each r in Subscription_Form
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
Zoho Creator Spreadsheet Import defeats me
Dear Zoho folks and support team, why is importing spreadsheet data so elusive ? I thought I'd give your app another try as I am partial to the Zoho approach: I've been a happy subscriber of Zoho Invoice for four years now. One option had been to wrestle with your CRM but I preferred the design and elegance of Creator. Yet I can't import any spreadsheet data at all. I am clearly missing something, but what? I've tried smaller versions of my data with an Excel spreadsheet with just five (5) rows.
Field number of characters is different in the view tab
Hi, I made some modifications to an application where the number of characters for one of its field changed. The field max number of characters was 12, now it's 22. The field is a concatenation of 4 other fields (4 chars, 6 chars, 6 chars, and 6 chars), and is updated automatically when adding a new item in the form. This is working fine, and I can see the 22 characters when the field is updated in the form itself. However, when it's submitted, the view only shows the older number of characters (12
Assigning permissions for shared apps and reports
Hi, I need to know how I can assign viewing and editing permissions to those with whom I've shared apps and reports. More specifically, I created a database in Zoho creator, to which all shared users can add records. I would like (1) to have the users be able to view only those records that they've added, and (2) to have certain users be able to edit records, and others not. How can I do this? Thanks, Jeff
how to disable for user - any export of report's entries ?
hi how to disable for user - any export of report's entries ? see screenshot
Share my app with my subscription users only?
Hello, I would like to Share one of my apps with a friend of mine that has a paid professional zoho creator account. It appears that I can only share with accounts that I pay in addition to my single user account in my subscription. Is this true? How can I Share with an account that is not part of my subscription?
Adding ASCII characters to strings
Is there a way to add an ASCII character (e.g. new line = CHR$(10)) to a string? I want to display messages in a multi-line field in a stateless form and I want each element of the message on a new line.
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
how show in reports only entries for last 30 days?
hi there is few full reports (#1) for all entries how can i make "light-weight" reports (#2) so that in #2 there will showing entries of #1 only for last 30 days?
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 !
Merge multiple fields into one
The below script updates a string field Details but only with information of 1 record even tough its a for each record script. How could i place all records information into Detalis field? for each EOS in EOS_Report_Form [LTE_Site_ID == input.LTE_Site_ID] sort by Date_field desc { TN = Tech_Names [ID == EOS.Technician_Name]; S = ALU_Items [ID == EOS.Scope]; if (EOS.Site_Completed1 == "Yes") { show Details; input.Details = "Technician Name:" + " " + TN.Name
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,
Update values in the table based on another table.
I have a table(Stock) where the values are populated from an import excel option (say 10 records). I have added an additional field in the form for ModelCode. Now the value for the ModelCode in the Stock Report is empty. Another table(Products) has the value for ModelCode. Based on the condition as model no same in both the tables, i were to update values to the Stock table for ModelCode. Pls suggest me how can i do it.. Thanks in advance.
Pasting in FreeFlow gives a Null error
I am trying to make a near duplicate of a form. I went to FreeFlow scripting and when I paste in a working segment from the original form it gives me a null error when I try to save. I am just trying to do segments in the Form Definition without Action. I don't remember this behavior 4 months ago. My brackets are correct. The new form is a stateless version of a state form.
Form is blank after import
I have made a copy of an existing app and added some bells and whistles to the main input form. I have then exported the data from the original app and imported it into the new version using the migration tool. All of the information is there in the database report, but if I try to edit, view or print any record, the form just shows up totally blank? Please help!!
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.
Comparison Website with user logins
We need to make a comparison website to compare features of around 5000 products. This will be based on type of product and then model comparison within a type. Users will be able to get registered to the website for detailed features. Therefore this website will be based on a database which will hold types of products, models of products, manufacturers, suppliers and different types of users (with different user levels) Professional with similar portfolio please contact ASAP Many thanks
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
how - view field but can't edit?
hi for app there is few users who works with incoming entries. need functionality: 1) for new incoming entry there is auto-fulfillment of entries (already works) 2) user for assigned to him view can open and edit entries (already works) 3) how can i make access restrictions for fieldA so that user can open and view inside this fieldA, but can't to edit text of this field ? example - fieldA is phone field. this field auto fulfilled via web-site. user can open entry and view all data, but he can't
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.
Dynamic Picklist based on radio button selection
I can't get the following code to work. if (count(Surface[Type == "Film"]) == 0) { clear Top_Surface; } else { film = Surface [Type == "Film"] sort by Type ; Top_Surface:ui.add(film.Film_Tafetta.getall()); } It seems if i change the above code to the below code, i do not get an error but i have another problem instead. if (count(Surface[Type == input.Membrane_Configuration]) == 0) { clear Top_Surface; } else {
Form object instance: function for pulling data?
For a form-object variable defined for a custom-action , say variable formObjectInstance1 , what system function can I use to pull all data in a form and put the data in an email message? somethine like input.formdata; for formObjectInstance1 it would be something like formObjectInstance1.writeAllFieldValues() ? I have been trying to find such a function/method but could not... can you help ? thanks.
Reports module in Zoho Creator is not working properly after adding a field from another table to a report
I have problems with reports based on a "Transactions" table. For instance, the reports and graphs don´t show all values in the field "State" and the aggregation of a column "Amount" is not given the same results compared with the same operation made directly over the table view. The problem arouse after I added a column called "budget" to the table, which is the ID to link to a new table where we have another field called "budget amount" (money type). After that I developed a new report based
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
Updating mass records
I need to update 4,000 records with one try. Do I need to use Deluge scripting to do this? To learn Deluge systematically what is the best resources/training courses/ Thanks!!!!
Automatic email for a form
I have configured Zoho Creator in a form, so that whenever a record is updated an email is sent. I can see that the emails are successfully sent when the records in a form are individually updated. But when I mass-update/bulk-update the records, the emails are not sent. Is there a way to fix this?
Help. Form should trigger invoice, however on public hosted website this isn't happening.
Hi Team I have an inspection booking form in ZC. This form creates an invoice in ZI and sends it to the client on submission of the form. This works perfectly if I run it in the same browser as my admin account. However, if I submit this form from a clients machine (or any other computer) the invoice is not created. I can only presume this is a security issue. What security settings do I need to set to allow a form that is publicly hosted to generate an invoice? My account is under vic@thepestmanager.com.au.
Fetch Records Explanation
I am not familiar with coding and I'm having some trouble understanding the Zoho documentation for how to fetch records. Would someone be so kind as to break down this function for me in a way that is easier to understand than what Zoho documented?
Improve connection between Notes and Tasks
Apologies if this has already been raised - could not find any reference to it. Currently in ZohoCRM Notes and Tasks are two separate areas. As a work flow, it is common that while entering Notes there is usually a direct Task that needs to be added as an Action . As an improvement, it would be cool to invoke a Task directly from within the Notes section and link them too, to avoid having to close and save the Note and then start a Task separately. (Currently if you maintain lots of notes on a
WHY is Developer Status No Longer Available??
WHY is Developer Status No Longer Available??I have been a developer for 2 1/2 years. I have always had my clients assign me developer status, which makes it very easy to provide on going support. I found out from a new client that Zoho no longer provides developer status for applications. This makes it much more difficult for me. I have to log on to the clients account with their userid and password. This is very unwieldy and cumbersome, and makes the clients uneasy about security. Existing clients
Eliminate Table Borders in Rich Text
Hi, I create tables through code in rich text fields to get data to line up. It works well, but I cannot find a way to eliminate the borders. Any suggestions? Bruce "Speedy G" Peaslee The World's Fastest Programmer
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.
Next Page