Report Views not available for users
I recently noticed that non of my users can create views when they are logged in. The report option only shows up for me as the admin. Not only that, the views that I created for applications , does not pull the right data because the view criteria is not available for the users. Am I missing something? I gave all kinds of permissions to the users. Can someone help please? Thanks Reza
Aggregate Sums within records on one form using a Formula field in a second form
Form Job has a Formula fields named Total_Labor_Hrs , Labor_Rate , and Total_Labor_Charges. Total_Labor_Hrs * Labor_Rate = Total_Labor_Charges. Form Log records the hours worked on the various jobs via a Look_up field named Job which looks up to the form Job; and also has a field named Labor_Hrs. Would it be possible to use a Formula field in a Job record to aggregate the Labor_Hrs from all Log records related to that Job? Would the expression below be allowed within a Formula field in the Form Job
Printing Record Summary cuts off part of the page
When selecting "View Record Summary" and clicking the Print button, the right side of the page gets a portion of it cut off. This is happening in Google Chrome, and happens across all my applications where i'm using a Record Summary. Is there a fix for this?
Zoho Creator entry level pricing
Dear Zoho Creator folks, I love what you offer with Creator and I am keen to try your advanced features now. But I am still bamboozled with your pricing. On the one hand I am invited to sign up for a $5/month/user deal. https://www.zoho.com/creator/pricing.html But if I'm already a subscriber per https://www.zoho.com/creator/signup.html?plan=25&users=1 all I see is $15/month/user. Am I missing something?
[URGENT] Integrate Google Visualization API (charting tools) with ZOHO HTML views
ZC currently doesn't support org chart which I'd like to add to my application. I've searched for other ways to render dynamic org chart and found a Google Visualization API (http://code.google.com/apis/visualization/documentation/gallery/orgchart.html) which can achieve my goal via a few lines of JavaScript. I tried integrating the JavaScript in a ZC HTML view but couldn't get it to work. I found later after reading a couple of posts in the forum that JavaScript is not supported in HTML views.
Remove the "View Record" link
In one of my report, I created a custom HTML page to display the record details. I have a custom actions that point to it directly. I would like now that my users always click this button and not the standard "View Record" link. Is there a way to remove it ? More generally, can I remove other options that are not useful for me ? Like "Print" menus or "View as" or "Links" ? Many thanks! Guillaume
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
Image size in views
I notice when customers download an app that has an image field in the View (report), the size of the image reverts back to it's original. In a View called Employees for example, users can upload images into the employee record and display them in the view. I set the view image size to 60x60 but when they download the app, the image field goes back to 100%. Since my customers don't have access to the code, can you propose a solution?
using a tablet
Hello I need to use a tablet for development my zoho creator application. What do you recommend between Android and Microsoft platforms? Thank you in advance. David
Action when decision box is unchecked
Hello- I have written an action on a decision box that adds a value to a currency field if the box is checked: if (input.Timestamps) { input.Rate_per_minute = (input.Rate_per_minute + 0.25); } What I cannot figure out is now to remove the value (i.e. 0.25) if the box is then unchecked by the user. Note that this is different than doing input.Timestamps == false because I only want to subtract that amount in instances where the box was checked and the user unchecked it, as opposed to situations
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?
Can I Eliminate Bulk Edit Check Box?
My users can edit certain aspects of their profile, but only theirs. To make it easier for folks unfamiliar with Zoho, I have some help text that points them to where to open the edit Form. (see attached image). The first two users did not click "Edit", they clicked the little box, causing the "Edit" to vanish and leaving them stuck. Is there a way to remove the check box? Thanks.
zoho creator Chat Integration
How do I allow my creator user chat with each other ?
Deluge systematic learning
What is the best way to learn Deluge scripting systematically? I mean a complete textbook as a PDF file or a book from a bookstore... thanks!!!
Word Wrap/Table Width Styles in Creator HTML Pages
What should I add to the css styles of tables in Zoho HTML pages if I want to avoid having the text push the width of the page out to fit everything in one line? I just want to create a table (or div) that keeps the width of everything inside within the width of the page. Below is what I have now, but paragraphs of text in nested tables will push the width out and keep all the text in one line. I don't want to set a specific width, I just want the width of the entire table be at least 500px wide
Export and Import data forms with subforms
Hi - I'm not sure that I managed to figure out the process for exporting data and importing it to another app/form, more specifically having forms with subforms. I'll appreciate if someone can post a list that describes this flawlessly. Should I use the backup option? Should I export specific views data? what are the fields that I should select from the subforms? Should I use the migration tool? What settings should be selected to export/import? Do I need to copy formulas? It feels I hit a brick
Sub-Form problem executing a deluge script
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in editing the record
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?
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!!
Next Page