Zoho Creator Report: large-number formatting
Hi can anyone tell me how to format large numbers, say "3 billion", into comma-separated format like 3,000,000,000, in a report?? Thanks!
Look-up a fields 2 forms deep
I have a form called "Shifts" with a look-up from a form called "Employees" Employees uses an other look-up from a form called "Functions" Is there a way to show a field from "Fuctions" in the "Shifts" form? Thanks in advance Perry
how to deluge for negative dates
I'm trying to create a report that will filter to identify records with no activity over the past 5 weeks and feel like there is probably a deluge script that I'm just not finding. Any suggestions on how I tweak the following to also exclude records that have activity in past 5 weeks? show all rows from Accounts [(Activities.Activity_Date >= (zoho.currentdate - '5W:0D:0H:0M:0S')]
Pages editor: wysiwyg! Suggestions?
I have no experience in html coding, and do not know how to get around to make decent looking dashboards and reports using Pages in ZC. What would be realy helpfull is if it was some kind of external wysiwyg html tool. Perhaps I then could copy the code generated from this into ZC. Then replace some "placeholders" with the data I pick up via deluge? Happy for any suggestions on how I should start to be able to make some simple html page reports in ZC. (To get the data itself from ZC is not the
Combining a date with text
Hi, I am creating bookings and I want to give them a title of 'service type' followed by date and time, for example Cycle Training - 12-Nov-2015 13:00:00 This will enable me to have a clear name going forward as I assign other tasks to it. What is the code for this? Thanks Ben
Make a date with a parameter box date
As I get to make a date parameter a date box. Example: Fecha_on_sale "Date": 14-Sep-15 Fecha_on_sale in "Date" Month Fecha_on_sale in September "Date": 14-Dec-15 Fecha_on_sale in "Date" Month Fecha_on_sale in Dec
SEARCH and SIGN IN
I have been having one separate database (all the same) that I can post that will not allow anyone to make any changes, AND one for only me to post and add and make changes. All of a sudden, all of my databases would come up as SEARCH ONLY (including me) which is what I want. And off to the right would appear SIGN IN. I could sign in and I could make changes but others still could not. Today, this all changed back to requiring me to have the two different databases to post. What happened ? I want
Error Occured while publishing
Hi! I am new here. When try to publish my site the very first time, I got"Ërror occurred while publishing" right away. It is registered under http://audioreplayph.zohosites.com/. Hoping for your guidance.
embed form with logout
Hi, how do I insert a logout button on an embed list view?
Need a mass update solution...
Hello all, I am a beginner here... So please be patient :) I need to do the following: I have two forms. Form A contains product informations. A few thousands or records. There is a field named "Categorie" and it is written in French... Form B only contains two fields, first the same category infos than Form A (a few hundred types) named "Cat_FR" and the translation field (in English), which is named "Cat_EN". How can I "mass edit'' the Form A to add the field "Category" (with the info from
mass update via Deluge
To mass update 5,000 records, if I use Deluge do I have to use the Iterator method? Is there any other day of doing this? Thanks.
Duplicate Record with different information subforms
I have a form with a subform. I want to know if I can make a function that allows me to register, for example: I have: 1 record, with 4 different entries in the subform. I want: 4 records, each with 1 entries subform Delete the original entry. Result: Record 1 With entry 1. Record 1 With entry 2 Record 1 With entry 3 Record 1 with Entry 4 What I want is to separate the original record, to have one record per entry that was in the subform.
popup window in visible area of embedded forms
On embedded forms, popup window is displayed in the center of iframe only. So, when you scroll to the bottom or top of the form, this message can be seen only by scrolling all the way to the center. How to display popup window near "+" Add button in visible area of iframe. Thanks!
Calculate Duration with Time in text-fields
Trying to subtract to decimals and get a time in minuets and seconds. When trying to add the formula Duration_in_Decimal - Duration_in_Decimal.toLong() * 60 to a text field I am getting error : Error at line number : 4 Variable 'Single_Line' is already defined of data type 'STRING' but trying to update 'DECIMAL' data type
Creator N duplicates on workflow
Can I duplicate N records from creator DBF with an instruction on workflow for certain conditions?
Re-set Auto number ?
I need an auto number value to count sequentially but be re-set to zero at the beginning of every year. Any solution?
Taxes to be added on the zoho website commerce through PayPal
I am using the zoho commerce on my zoho website. When a customer makes a purchase and the PayPal window opens, no taxes are added. Does anyone know how to do this?
Zoho Creator access control by Report
I understand that for each form I can suppress certain fields to prevent editing. But is it possible to suppress specific fields on views, so users assigned the views can only edit certain fields I want them to? I believe this is extremely important because I can control access to views, and then further granularity down I can control the fields. I believe this is essential for Zoho Creator to become a mature on-demand business-application platform.
sending a mail not including just the fields the user didn't fill
Hi, I have just asked this question but I didn't solve the problem. I would like to send a mail to my costumer just including the fields they have filled. If editing the notification mail I insert costum fields that are not filled by the customer the Mail will be full of square brackets [] [] [] or code-words like "null" Is it possibile to do it? I hope I made myself clear...my english is not very good! Thank you very much!
Only grant permission to view end edit specific records within a module
Hi there, At the moment we are using Zoho Creator to manage our customers (module 'customers'). Each customer gets assigned to a project. The different projects are added within the module 'projects'. We are collaborating with various real estate agents. These agents are assigned to specific projects. We would like to share our application with the real estate agents. But they should only be able to see and edit the records that belong to a specific project. In a word: they should only be able to
Formating and align numbers in a subform
Is it possible to format and align a number on a form or subform ? Like 1.234.432,2340€ If possible , how it can be formatted according to the country setting s?
Percentage values in formulas. Literal number instead a %
I have a percentage field (%) on a form Scripting I copy the value of this field in a similar field (%) in a subform The subform formulas percentage field is interpreted as a literal number : for example , 15 instead of 0.15 (15 % ) Am I doing something wrong or you need to convert the numbers in the formulas , for example : 1/15 ?
trying to fetch data from parent-form into subform-form AND creating a report of ALL subform-records of ALL parent-records
Hi please have a look at the attached pdf Thanks Kind Regards Paul
button suggestions or information?
I would like to add a button as shown in the photographs. A button or icon for suggestion to explain or put a little note in the boxes. It would be possible?
page of customer details
i have no idea how to make customer details page for each customer with reports associated with the client like this: https://creator.zoho.com/demo/stompalot/garage-managment/zsdemo3/#View:View_Customer_Details?CustID=4082000002338235 Customer view report : https://creator.zoho.com/demo/stompalot/garage-managment/zsdemo3/#View:View_Customers When i choose customer and click "Go to customer" i go to page of customer detail. Could you help me with that which functions are involved here or may be free
Form hangs
Could someone please look at the following form and tell me why it is hanging on submit Thanks https://creator.zoho.com/appbuilder/mrcomputer/moto/form/Agents/edit
RTF Memo field
Can an image - JPEG - be placed and visible in an RTF memo field?
Calendar sync with Google
I was wondering if there was a way to sync my Zoho Creator calendar with my google calendar?
Do not send Report if empty
Hi, I would like to create a schedule to send a daily report as an attachment via e-mail but I would like to avoid sending a report/View a blank report with no data. any help will be greatly appreciated Thank you. .
Download Attachment Need Actual File not a Link
I tried using Image Upload app. I can upload an attachment. However when I download to excel I have the following: <img width='100' src='http://creator.zoho.com/DownloadFile.do?filepath=/1272213556146_Ev_YMCA_Testimonal0001.pdf&sharedBy=sampleapps'/> However I really want the contents downloaded. How I am able to get the contents downloaded instead of the info above? If it isn't possible then is there any additional workarounds. Thanks
customer portal redirect between pages/form
Hi, If I use permalinks in the link there is the login name... this means that the link is fixed for that user and the same permalink doe not work for all the Customer Portal User. Imagine I have an Html Page that is a sort of "menu" and redirect to several html pages. Customer Portal User has to log in, access to the menu and then navigate and access to the html pages... how to do it? tks, Pippo
Transparent forms
I was wondering whether or not you can make the background on a form transprant? I have just made a form and embedded it into my website and the white background clashes with the web page and makes it look very unprofessional. Is there any way you can change this?
What video tutorials would you be interested on?
Hello everyone. Just made a video on how to mass update your database in zoho creator. You can review the posting here. http://www.creatorscripts.com/blogs/post/How-to-Mass-Update-your-database-in-Zoho-Creator/ but i am interested in finding out what other needs are out there to plan my next video tutorial. If you can comment on the post or drop me a note would be greatly appreciated. Francisco Riojas Creator Scripts Smart Software For Maverick Entrepreneurs www.creatorscripts.com
How to manage the "Approve Lead" list
I have a problem since my Webforms return a new Lead record which quite often is a DUPLICATE. 1. If I go to Lead/Lead Tools/Approve Lead/Duplicate Lead this shows me a list of Duplicates that need approving but at present I have 1500 records and I have no means of SEARCHING or FILTERING this list to see what does it contain. Any ideas how to manage such a list 2. Is there a way of including Unapproved Leads in my general CRM SEARCH? 3. Is there a way of adding fields to be shown on the Duplicates
Simplified input of the DATE -TIME field
I am using the the Date-Time fileld in my application because it facilitate date and time calculation. But on the other hand the users are complaining about the time being not user freindely or entering wrong timing is recurent. How can I simplified the look and feel of the time entry section ? Something like the date in a separated field and the hours in a dropdown field would be workable for me. But always keeping the same single date-time field? Thanks
Tip: How to work around issues of a Lookup field when it's definition includes appended child fields
When using the very nice feature, in a Lookup field's definition, of appending child attributes, such as Property_Name + ", " + City + ", " + State The result in the dropdown is a NICE combination display that really helps the user identify the correct choice. And, the appended fields are even included in the search-as-you-type. However, the result on Reports is not necessarily good, because that combination is always shown as the field's value. (Or if you use field.name it is not clickable to
Current month in Report-Pivot-Chart - filter on the current month
HI, let assume I have a table with the following fields: Date (date); Quantity (integer); Should be possible to create a bar graph with: on axis x the date; on axis y the sum of quantity for that date; a filter on the current month? tks, pippo
One payment for multi zoho services
Hello I don't know if there is way to pay one time for different services , I have to pay for Books in different area than Creator than Email ..etc. need one page to pay multi services ! Thanks
Capital letters
Hi and hope you can help If I have a field called Name and someone enters their name nigel cross How can I capitalise each name so it reads Nigel Cross Thanks
wildcards and queries
Hi, I have a Table "SALES" with a Field "Name". Name can have the following 4 values: 1 "Name 1" 2 "Name 2" 3 "Name 3" 4 "" I have to pass the Name value in a function "EVALUATION" that execute a Query in "SALES". The query has to filter on "Name" values and if Name is "" has to ignore the filter on "Name" and take all Name Values ("Name 1", "Name 2", "Name 3"). I can see form other post in the Forum that wildcards are not allowed. Is there any trick in order to pass a "*" value
Next Page