Embedded URL Row Limit
Hi, I was using the "Embed to Website" link from a Application generated report to provide a feed for a Power BI report. This appears to be working great except that I only seem to be able to pull out the number of rows that are displayed on the first page of my report. I have 200 Rows visible on the first page of my report, but there are 357 rows of data in total. When I pull the refresh of the data to my report it only gives me the latest 200 rows. Is there a way to have the embedded report to
Change portal name
Can you please change my current workspaces http://creator.zoho.com/workspace/valeriano.bonacina to http://creator.zoho.com/workspace/bcccarugateinzago is it possible?
Timesheet Totals
Hi you clever people We have a form TIMESHEET with the following fields TIMESHEET_ACCOUNT - (Lookupfield ACCOUNT NAME field from ACCOUNTS Form) TIMESHEET_START - Date/Time Field TIMESHEET_FINISH - Date/Time Field DURATION (h) Formula field - ((timesheet_finish - timesheet_start) / (1000 * 60 * 60)) timesheet_transferred_to_accounts - Decision Box Is it possible to have two read only fields in our ACCOUNTS Form as follows: Hours Billed - which provides a dynamic total of all the durations where
How to auto populate based on previous field entry from linked lookup?
Hi, I've got 3 forms, Customer, Product, Quote Quote is comprised of Lookup fields Customer.Name, Product.Name and I want it to get the Product.Price field from the Product Form. So to generate a quote I will only need to select Customer from a drop down, select Product from a drop down, then the price of that product I've selected will be automatically filled into the third field. Any ideas about how to go about this, it seems a simple thing to do but I have limited experience with the scripting
Zoho Creator - Embedded - Zoho criteria -
Dear Team, Can anyone suggest the solution for below use-case . Use case Model I am using Zoho creator for Form - data entry User Login in Zoho creator via Customer Portal self registration mode Populate Data from creator to Zoho Reports and do all analysis and generate dashboard in Zoho reports Use "Page" component in Zoho creator - embed "Zoho reports dashboard"". End user can now view "Zoho reports" embedded dashboard in Zoho creator page What we could not achieve ? We are unable to restrict
Adding images
Hi everyone I would like to know how I can add images to my form from my computer when i create the form. Thank You
Selecting records based on a dropdown
I have two data sets (reports), properties and bookings. I want to create a form that uses a dropdown to select a property (from the property report) and then have all the bookings (from the bookings report) for that property displayed. I know I can do this by searching but can I do via a form? I'm new to Zoho Creator today so still trying to find my way about.... Thanks!
How to show a hidden single line field by a multi-list selection?
I want to create a form with a hidden field that is only shown when a specific selection is made in a multi-list drop down box. Say the list is of choices of what the customer is contacting me for. Their choice is not in the list, so they'd choose "Other". When "Other" is selected, a single-line field is shown. I've been able to hide the single-line field, but when i have not been able to make it appear with the "Other" selection from the drop down box.
Sales Order Items to Creator Form
Hi, I am looking to see if I can transfer the items on a sales order to a form created in creator using tick boxes Example, we sell a basic pizza with various topping. The products on the sales order are Pizza, topping 1, topping 2, topping 3, etc. Can Creator take this information and populate the form as a Pizza with check boxes ticked if a topping is on the list? Hope this makes sense. Thanks Richard
two lots of data to import
Hi we currently have one set of data in creator (customers equipment) linked back to our zoho crm via contacts name. We would like to import a set of data into a second form (service calls). these are currently in zoho crm and are also linked to contacts name. the aim is to be able to print service sheets in creator for customers showing the site engineer the equipment and previous service calls for that customer. I am at a loss on the best way to create the link between customers equipment and service
CRM Task Question
Hello everyone, Based on what I have read in here, I may be one of the few people on the messageboard who aren't super experienced with coding. I am learning bit by bit, though. I'm posting here because I'm trying to get a handle on the different tasks associated with the CRM field. For example, I have read the articles on searchRecords task for the CRM, but there are still gaps based on the examples that they give. In the example, it's already predefining specific data that you know will be looked
Merge 2 Calendars Together
How can I merge 2 calendar reports together?
Sales Funnel / pipeline report
Hi! I would like to know how can I create a sales funnel report using Pivot charts. I haven't found any information related to Zoho Creator and when I try to do it myself, I choose the sales funnel graph and it starts to load but nothing happens and the chart goes back to the previous chart format. We have a grupo of predefined sales stages and I would like to show something like: For the current month: - Stage 1 -> 50% leads - Stage 2 -> 30% leads Something like this: Any information will be welcome
How can I make when a person enters a report are hidden / display fields depending on which report is?
Hello everyone, I have like 7 reports, and in every report so i want to show/hide the fields when the boss enters to edit the report depending what fields i show in the report. something like: I'm the boss, so I have permission to see all reports, and if i go to the report 1 the fields that have to show will be "field1", "field2" and if the boss go to the report 2 the fields that have to show will be "field3", "field4". so "field1" and "field2" will hide how can i do this?
How do implement my Zoho database in my Wordpress webpage?
Hello, Me and my fellow students are working on a project for school. We've made a database using Zoho creator. We are trying to link our database to our Wordpress webpage. We want the filled in data on our webpage to be updated to our online Zoho database. How do we make this possible? Do we need certain plugins or upgrades? Kind regards, Koen
Custom Themes
Hello, The custom themes do slow down the responce time of the form very much. Even a small change causes this effect. Haddo vuputten
Why appear in the report the total of the fields disoriented?
Here is the total that is disoriented:
Transfer of applications from creator workspace to developer workspace
For the past three weeks I tried to get my applications transferred from my normal creator workspace to my developer workspace. The sollution from customer support is to export as ds file and import resulting in the loss of all my records in the applications-database. Please provide a sollution because I am seriously frustrated with the situation.
Record Count Issue / Usage Details
Went into our usage details this morning and saw that we had 85,000 records of 100,000 available. In order to reduce the number of records, I did a backup and downloaded and exported the application as a file and then proceeded to delete 2 years worth of our oldest orders in the system to see how much this would reduce the record count. After deleting these "orders" and refreshing the usage details, our record count went UP by 10,000 records to 95,000/100,000. It's not possible that we input 10,000
I want to build a Flipbook App.. Could It Be Done?
Hi, My question is... I want to build an app for a magazine.... So I want that app has a Flipbook inside..... But Not in a HTML space that shows a web site inside the app.... I want it lie Native... I don't know if this could be done with ZOHO templates or if it has a plugin that works like an ebook or flipbook native in the app. Thank you for Helping me, and if you have already done an app like this, gimme your link and i will download it ir order to see how does it works!! Thank you Very VERY Much!!
phone number field
I would like to use a phone number field so when I pull the record up on my cell phone, it will be highlighted and I can click it to dial out. Tried numerous things so far and nothing works
Calendar View First day of week
Cannot find how to change First Day of week to Monday in Calendar type of view. Can anyone suggest?
I need a dialogue box to determine what action to take next
I have a form with a lookup dropdown of 5 fields. If a user selects one particular option from the dropdown I would like a dialogue to appear along the lines of "Would you like to create a new record in [FormName] for this record. If the user selects Yes, another form opens and data is transferred from the one form to the other. If the user selects No, the dropdown in the first for is change to a different pre specified option. I can handle the actions and data transfer, but do not know how to create
How to read Whole url or Read URL parameters using form script ?
Hello Sir, How to read Whole url or Read URL parameters using form script ? We need url's parameter for parameter value in form.
Help with creating a quote form...(new user)
3/27/17 - Been using Zoho for just over a month and need help with creating a Quote Form: On the Quote form I have 2 lookup fields that both are radio buttons : Field 1: Field 2: When any of the first 3 options in Field 1 are selected and any of the 4 options in Field 2 are selected, I need it to update the Monthly Rate Field on the Quote Form from information on the Storage Rates Form below.
Help! Help!! Help!!! "Unable to send message;Reason:554 5.1.8 Sender Address Blocked"
Hi Everyone / Moderator/ To whom this may concern, My Name is George; This is the 5th message i am sending to request assist from the moderator on my account. I noticed that i have been blocked from sending messages without sending any unwanted or promotional emails whatsoever. Please, Can you help me unblock my email, so i can reach my clients as this is my company email?? Email: info@bbmilleniumllc.com I am counting on your guy to help me resolve this effectively and swiftly, Thanks for your anticipation.
dynamically add fields?
is there a way to dynamically add fields to a stateless form? e.g. user selects 3 items from a list (a, b, c from the entire alphabet). then generate two fields per entry, such as: a_method: a_result: b_method: b_result: c_method: c_result: obviously this could be done with show/hide, but for higher numbers of items, using iterations would be easier if it's possible. it would also be helpful to be able to then insert these into another form using iterations.
importing data from zohocrm
Hi i have hit this barrier again. We would like to move some data from zoho crm to creator. We have a field that links this data to a contact and would like to keep that intact on importation. Does anybody know how to do this as all we get is a number
Customer Portal User Groups
I have been told by a customer that in the next couple months they wish to move away from generic accounts per dept into user based accounts. This means that every user will have an account so I'm looking at at least 1500+ users, at first i figured i could use the customer portal of the application but because this doesn't support group creation like the normal global user setup it'll make user management a nightmare. the second option would be to have each user signup for a free account but because
Accents can't be used for true/false values in Reports
This is pretty self-explanatory : Is there any way we can have this working? This is especially a problem for our french-speaking clients, because in French, past tense verbs used as adjectives often end in "é" (ex: "Ajouté" means Added) which is counted as a special character, when it shouldn't.
Users and Perimissions
Is it possible to restrict users so that they can see and edit only records that they have entered into the database? I am developing a subscription application for orthodontic offices. Of course, I don't want the users from different offices to see, and edit the data from other offices. I have created a profile named "client" and given them permissions to Access, Create, View, Edit and Search. I have also shared these forms with the "client" profile. When I use the client's log in, everything
Conditional formatting for duplicate field in a specific column
Hello, I need to highlight the values in a specific column when that value appears more than once. How can I do it?
Help! Help!! Help!!! "Unable to send message;Reason:554 5.1.8 Sender Address Blocked"
Hi Everyone / Moderator/ To whom this may concern, My Name is George; This is the fourth message i am sending to request assist from the moderator on my account. I noticed that i have been blocked from sending messages without sending any unwanted or promotional emails whatsoever. Please, Can you help me unblock my email, so i can reach my clients as this is my company email?? Email: info@bbmilleniumllc.com I am counting on your guy to help me resolve this effectively and swiftly, Thanks for your
Best Excel import and form setup method to reduce work manually re-creating lookups
Hi I have just starting using Creator and learning its features. I have a single Excel sheet with many columns, that I have imported into Creator. In one of the early attempts, one of the columns was imported as "Drop Down". This is close to what I want to do (forcing users to use correct and full customer names - rather than the free for all data entry that was happening in Excel). What I actually want to do, is to end up having that 'column' of data split out as a separate form - to be used as
Is it possible?
If we have a table containing tests which are grouped. Can the groups of tests be "pulled" into a new table/report for "Test Results" as a group. For example, the "Test Steps" has a field called "Test Template" which is used to group multiple rows which are the test steps for a particular device. I want to be able to select say "Test Template 1", "Test Template 2", etc and have a new table created. There will be multiples of each template i.e. multiple devices in the new table. For example, "Test
brindha
Im new to zoho creator.i want to create a quiz application .anyone guide me.
Understanding User Management and Counts in my Zoho Creator Account
1. Are external users with access only through the customer portal counted and billed for the same as shared users ? 2. I have 36 active users in my User Setup Page whose usernames do not always match that listed in the application's shared list despite having the same email addresses. Why? 3. Customer Portal users show up in the application shared list but not in the Zoho Account User Setup Page. Why? Zoho Account User Setup Page: "johnsmith" (App shared list below shows same username with additional
creator drop down issue in ipad and iphone
hello, i m new to zoho. i couldnt see a dropdown list in my ipad and iphone when i could see it as a drop down in laptop. if i customise many in listing it shows as drop down but 3-5 options in my listing all 5 are shown which makes my form look bigger and complex.pls help me out
Pivot Table based on Form input
Hi Support, I want generate pivot table based on user input in a form. Example below. Form1 (Has below Field): Country: Section: No of sales: Form2: Country: No of Sales: When user select the fields in Form2 and click on submit, a pivot chart needs to show based on data from Form1. Your help is appreciated. Thank you.
How to add a new field to an existing form
Let's say that I have a form with a dozen fields and thousands of records. How can I add a new field to this form and import the new data into it? I have the data in an Excel file. The only way I can see to do this is to import the XLS and just make a whole new form, but this will break all the relations I've made with the original form. This seems like a simple and fundamental thing to do, but I'm not seeing it. Thanks.
Next Page