Explain conditional formatting in calendar reports in live mode
Hello, It would be useful, if you use color code in your calendar report, that the user could see the meanings of the individual colours. Maybe not a big deal, and other users would like it too. Kind regards
How to add relational filter based on start date column in table
Hi, I have created a table with Company name, A start date, and time (mins), which is data from desk. Each company has a different start date. I want to filter the data so that the time (mins) shown, is relative to the data that has taken place since each company's start date. The issue I have run into is that this date is different for each company. I have tried adding a filter with the start date, chaning the setting to relative and adding 'this year', however this doesn't work. Any ideas?
Unable to find Map function
Hi, Here is my script: DealId = ID; mp = Map("Mise_de_fonds" : Prix); resp = zoho.crm.updateRecord("Deals", DealId, mp); ID is a refer field. I get this error: Not able to find "Map" function (See screenshot). What is going on? Thank you.
Xero
How do I get Zoho and Xero to download information and integrate to each other?
Hide scrollbars in embedded report.
I have embedded a report in a page. The page displays three scrollbars. How to hide the additional scrollbars. Please see the attached screenshot.
Set iframe width?
I am experimenting with iframes and how to add them to sections of Wordpress sites. How do you set the iframe to occupy a certain width? If I leave the width at 100%, then it requires the user to scroll side-to-side on the web page. https://photos.app.goo.gl/vapWharBSyjwWqjR8
Reports - format decimal number
I have a decimal field in my form. I want to show the decimal number with comma and decimal formatting in the report only. Is this possible without using a formula field?
Microsoft BI & API
We currently utilize Microsoft BI and will continue to do so. We are trying to connect (only need Read access) using the API utilizing the documentation found at https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html. We are not getting any errors when connecting however we are displayed a table with the following columns {kind, name, children, text} (see attached image). We have verified the authtoken is correct, scope and zc_ownername are also correct. I am the owner
Backup Creator 5 App with Basic Plan
Hi Zoho community, I'm trying to decide whether Zoho Creator 5 is suitable for my small business. I think that the Basic plan most suits my 1 person business. If I were to go with the Premium Plan I would still only be 1 user so would get no more than 25,000 records. My main concern is that there is no off-line backup facility within the Basic plan. That's the only extra option that I'd need from the Premium plan. I'm reluctant to pay double the price just to back up. With the Basic plan it seems
Can't view component in Published Page
As the title, perma-link: https://creator.zohopublic.com/hoangnl.tst/viking-account-service/page-perma/ORDER_TRACKING/xU2E6OQ6xkEeQ0s2CE1Gn4SjEfeTYeG0HZVJtY8B8gWyhM9Uf1DsQfWV1MPCT9Ej5eMMePskOgmJ2g5ZPHZMvdqFGmEqCuFGCurw It shows: "We failed to retrieve this form. An error occurred when we tried retrieving Order Tracking Key. This error has been reported to Zoho Creator support." I try to publish all the component but it's sill the same. Can anyone help me with this problem. Thank you,
is there any way to create a customer for my portal via script?
what i want to do is, if i create a record( lets say a client ) on my custom module in CRM i want to create at that same time the customer login for my portal via scripting, that way my zoho crm local user wont have to login to Zoho Creator to make a login for that client to be able to use the customer portal.
report with multiple forms
I wanted to open this up to the community to see if I am on the right track or if there is an issue with my design. To fully accomplish what I have in mind with my application in Creator it would take 141 fields in a form to have all of the data in one place. Knowing I cant do that I wanted break down those fields into common areas with each area as its own form no more than 30 fields. For testing, I simply created a contact form, call results form, & email result form. Each form will have a auto
Filter lookup to prevent selection of previously selected values
I have a main form which stores profiles of children. A second form creates a health record for each one. I only want one health record per child. The health record's first field is a lookup to select the child it stores health information about. How do I dynamically adjust the pick list to only display the names of the children who have not yet had health records created? I assume I need a Deluge script for this and it's a bit beyond me at the moment. (Still learning!) Any hints would be appreciated!
Zoho Creator - Public Form - Prefill data in url
Not sure but I have not been able to succeed in getting data prefilled in Public form. I want to sent person form with details prefilled to know his opinion for that particular project/row. Kind of getting rating from client.
Subtract the value of the field in the subform from field in the mainform, When user deletes the record in Subform
Hi, i have a field called subtotal in the subform and a field called GrandTotal in mainform, when user deletes the record from the subform i want to subtract that value from the GrandTotal . Please help me with the deluge script . Thanks in advance .
About zohot
How to get a number as User input ?? and How to process it ??
Toggle for Iframe or PopUp in Pages
So the default behavior for the edit button in embeded tables on a custom page is to load the edit form inside the iframe/table. If one has multiple tables on a page, some of these tables are only 100px hight. To load the form in an iframe makes for a horrible user experience when the iframe/form is only 100px height with a scroll bar. The only way to get around this is to create a custom button/action that would edit the form in a pop up. Now I have over 20 tables in my application so now i have
Zoho Creator filedownloader
Hi everyone, I need to download all file uploads from my Zoho Creator account because we lost our external backup with the pdfs. But the filedownloader does not let me log in to the account (incorrect passwort or username) which I double and triple checked is correct from my side. Is this a known problem? Any other ways do download all the files? Thanks in advance for your help
Zoho data storage in Canada
We are thinking of using Zoho Creator to create an app for patient information. For information loaded into the zoho creator app, can the data be stored on a Canadian server?
Creator 4 subform hide delete
I have not been approve to upgrade yet, so I'm still using the old creator. I have a subform that has a red "x" to the left of the each entry. When I hover over it, it says "remove." I cannot figure out how to hide this. I do not want users to be able to delete these entries. Is there a way to disable this delete? Thanks in advance!
Return the days between 2 date fields in a list
Hello, I have two date fields "From" and "To" I would like to return a list with the dates between these 2 fields. How can i do it? Example: From: "15/9/2019" To: "18/9/2019" List: {15/9/2019, 16/9/2019, 17/9/2019, 18/9/2019}
Upcoming updates - August 2019
Hello App Creators, Before the end of August, the Zoho Creator team will be rolling out the following features updates: Pin customization in map reports Criteria support for schedules Enhancements to rebranded mobile apps New UI for groups We'll comment below and update our changelog as these updates are made available. And here's the link to our previous post: Upcoming updates - July 2019 - - - - - - - - - Pin customization in map reports Applicable to: Zoho Creator 5 It's here! A feature that many
Update Date Field(AddDay)
Hay, I have three fields 1. Terms- is lookup field - number field from different form 2. Today's Date - is date field - which is zoho.currentdate 3. Due Date - is also a date field i need whenever any number put in Terms field, automatically that numbers of days add on Due Date field example if Terms - 10 Today's Date - 6 Sep 2019 Then Due Date - 16 Sep 2019 Is That Possible ? if Yes then How ? Any Help is Appreciated . Thanks in Advance .
Has ANYONE had a Bad experience migrating to C5 from earlier versions?
I have some large C4 apps and am looking at the upgrade as I am told the deluge framework in C5 is faster and will then allow me to use C5 features like the kanban report. BUT I don't want to dive into other bugs or issues with C5 at this stage... anyone had any experience they are willing to share???
Retrieving image file size and dimensions from an Image Field
When an image is uploaded into a form, I need to get its file size and dimensions for validation. Is there a way to access this information? Perhaps using Deluge?
Parsing json response in deluge Script
Hi, I am using a rest api call which returns the response in JSON format. How can I process it in deluge script to get access the values from that response? For example my response looks like this, {
"name": "mkyong",
"age": 30,
"address": {
"streetAddress": "88 8nd Street",
"city": "New York"
},
"phoneNumber": [
{
"type": "home",
"number": "111 111-1111"
},
{
"type": "fax",
"number": "222
zoho integration with salesforce
how can i integrate zoho with salesforce
Connecting to an Oracle Database
How can I connect to an Oracle database inside my company so that certain data and charts are refreshed periodically?
Dynamically Filter Street Address Lookup Field
Hi - Form A collects data for incident reporting. It includes a lookup to Form B that includes a single standard address field. Is there any way to dynamically filter the address field when completing Form A, either through a series of separate fields, i.e., Country>State>City that lookup the same address field in Form B, or within a single location field that drills down as the user inputs Country>State>City. Hoping to do this through the single address field in Form B without separately collecting
Send Email - <table>
hello, i have a form i which your fill ifnormation with products, quntity, price, etc, (you can select multiple products) and after you hit "Submitt" button an email is send with the detail in a table, but the problema y have its that all proctus, for example 4 products, are filled at the same row and i need to be filled in one row for each product. information is showing like the image below: next its my code if you could help me please: sendmail [ from :zoho.loginuserid to :Despacho_Realizado.Customer.Email,Despacho_Realizado.Customer.Email_2
Rename a Templat as PDF
Est-il possible de renommer un modèle lorsque nous avons envoyé un courrier en pièce jointe? Par exemple, j'ai un modèle nommé "" DevisJour "" et quand je l'envoie par courrier, j'aimerais le renommer "DevisJour & N°" où N° représente le numéro de dossier renseigné dans le formulaire. Merci de votre aide
How can we shared creator app to public ?
Hi ,I have a customer who wants to create app which will be shared with its customer. Customer should be able to book appointment via app and pay via app. Customer will also get various reminders and offers via push notifications. In this case, number of customer is not fixed so how can Zoho creator license will work ? If my client has 500 customer does he requires that many licenses ? Regards, Nishith Shukla
Let's talk about Zoho Creator 5 (2018), Online App.
Hi everybody, I'm a fan of this product. So much potential ! Why are you guys not communicating about this product ? Promised by the end of 2017, it's now expected in 2018... Any issues ? Beta testing ? Unsolved bugs ? I was analyzing and testing (virtually) the plans from my subscription page when I have been pleasantly redirected to what's looking like to be the new Zoho Creator homepage. But no one is talking about it ? This page also leads to a new subscription plans that won't make everyone
Scope a zoho creator app
I’m developing a checklist app with zoho creator, so that each checklist is scoped to a particular entity and year. What’s the best approach to select and “scope” all forms to a specific entity and year, so the user doesn’t need to provide those details in each form/report/page?
How to display specific data in a form ?
I am trying to create a form for entering data of received orders of a store . *The products vary according to the store My requirement is to populate products according to the store selected . I already created a form for adding products in that while adding i made a drop down label for mapping the items to the store .
Multiselect Lookup field not available in Form Builder?
I need to create a Lookup Field where the user can select a single item or multiple items. The User Guide says to use the Display Type in the Field's Property Sheet to select "Multi-select" to achieve this. Yet when I use the Lookup Field's Property Sheet, the Display Type is greyed out and disabled. My Lookup links to a table of items which I want to be able to ad to - so I don't want to use a Multiselect field type which only allows for a static list of items. Can anyone advise me? Thanks!
How to use a template and send information somewhere else
I used Creator to build a form. I successfully created an approval process. I also successfully created a contract template with fields mapped to the form. However I cannot figure out (and the Zoho developer I worked with couldn't figure out) how to send the approved form information into the template and output into the CRM and attach to the account. In other words, the approved form data is stuck in the Creator app and I don't know how to export it to CRM nor how to use the template. There should
Reduce image size uploaded by user
Hi guys, is there any workaround that can reduce or resize the image uploaded by user as in the storage size provided by zoho is limited. thanks Jeff
CRM API V2
How to create auth token using deluge script for v2 api for CRM ? as they share "https://www.zoho.com/crm/developer/docs/api/access-refresh.html" this document for createing auth token required lot of steps. and for this browse mode auth token does not support for api v2. deluge does not support for redirect url extracting data for get auth token form redirected url.
Wrong language of zoho creator's app
I have installed the zoho creator's app version 5.17.1 on my iphone 7 version 12.4. The OS language is set to (swiss) german. Unfortunately, since a couple of weeks, the zoho creator's app appears in dansk language! log in = Log ind, logout = Log ud, settings=Indstillinger, and so forth. I have deleted and reinstalled the app but the bug remains. I want to use the app in german as it used to be. Can you please check this bug? Kind regards, Daniel
Next Page