Dynamically filter page content based on User
I am trying to build a page inside of which goes 3 different reports. However, I don't want the user to be able to view all the records in each report. Is there a way to automatically filter the data in the reports on the page so that when a user logs in, they see a filtered view based on their log in? I can create different pages for each of the 15 users I am building this for, but that would cause a lot of work whenever I change the look of one of the pages, I would need to then go to the other
Hiding Search From Customer Portal Report
EDIT Sorry this is meant to be in Zoho Creator Forum - could an admin pelase move? I'd like to start using Zoho Creator as a Customer Portal but am finding it a bit too leaky on information. I'm trying to setup a simple report tracking contract dates
User Permisisons Export Pivot Table into Excel
I want a user to be able to export a pivot table report into excel. I have a form (Form A) that records therapy visits, it pulls data via Lookup field from a Client Form (Form B). I have created a pivot table report where a user can see the total minutes
Replace number in formula with text
Hi I want to replace the number of counting days in a formula box (((zoho.currentdate - input.Date_field)) / (1000 * 3600 * 24)).round(0) in the column "COUNTING_DAYS" with a text "Finished " when the "status" of the operation shows COMPLETED or CANCELED
O que seria Coluna Base e Coluna dependente?
Olá sou Leigo no assunto, porém tenho uma frota de veículo e sempre controlei as manutenções pelo Excel, vih por aqui que consigo criar um app através do upload do meu arquivo CSV, mais quando subi o arquivo pede pra Eu escolher essa coluna Base, alguém
Deluge Workflow: Cannot insert and retrieve a new record
I've got a calendar app that lists events for different high school sports. It needs to import non-standardized excel spreadsheets - the school does not force standardized sheet layout from each coach - and create events for the season. I do some manual
Checklist from form
Hi, I've got a form where a manager can specify all the IT requirements for a new staff member (devices, folder access, software, etc) It's a pretty big form with a lot of show/hide fields. I'm looking for the easiest way to create a checklist from this form, so an IT staff member can go through and confirm that each item is provisioned. Is this easily done in Creator or some third-party integration? Much appreciated Levi
Zoho Creator User Group meetups in a city near you!
Greetings from the Zoho Creator team! We're excited to announce that we're hosting a series of Zoho Creator meetups in various cities across India. We invite you to join us for an exciting day of learning and fun. Our meetups are a great opportunity to
Is it possible to Embed an Image in an Email Notification?
I am trying to add sponsors to my email response/notification. Is it possible to add images to your email notification? Thanks!
ZOHO CREATOR
Zoho ceator
Attachments between Creator and CRM Leads module
Hi, I developed an form on Zoho Creator. I added a Workflow on Submission that sends an email to the user, attaching the record's PDF template to the email. I need that PDF to appear as an attachment in the CRM Lead module. I've already tried to add the following script on Submission, as reported in other posts: file_object = invokeUrl [ url: "https://assets.pcmag.com/media/images/431075-zoho-logo.jpg?width=810&height=456" type: GET ]; response = zoho.crm.attachFile("Leads",4770XXXXXXXXXX,file_object);
Is it possible to script for automatic export of reports in Zoho Creator?
I have an app with a few reports that I would like to automatically export on a daily basis. Is this possible to do through deluge script, or would I have to set up some sort of flow between Creator and CRM/Analytics?
Mirrored images when using web browser to capture photo
I've built an app that requires capture of a photograph on a form using the image field. I'm using the app in google chrome (and/or microsoft edge) on a microsoft surface pro. When taking the picture using the rear camera on the device, the image is mirrored.
Need Image in Rich Text Field (Solved)
<img src="https://i.imgur.com/iV4suDK.png"alt="MenuImage" style="width:500px;height:600px;"> does not work.
How to work with getFieldNames formdata functions ,Any Examples
I don't find any example showing usage of getFieldNames. Where do i find .is there any Help documents available
A search function for dummies
I see from the forum discussions that this subject is a recurring topic. I need a simple search interface to allow users to search a list of publications by keyword. I've seen the form at https://creator.zoho.com/sampleapps/search-records-in-a-form/# which is where responders usually point people asking this question. I understand how to copy the search form to my account. I cannot however figure out how to modify it to return the results I need. I can't 'follow the logic of the form' because I don't
Sandbox deployment error
I have a Creator app which I'm modifying in Sandbox. But when i tried to publish the changes to live it pops an "Error in publishing" without any description attached. When does this error occur and can someone explain how to fix it? Thanks
Enhancements to make your portals more powerful
Greetings from Zoho Creator! We're happy to announce the rollout of some exciting enhancements to the Portal. We've designed these enhancements to ensure compatibility with new upcoming features that we're working on, which will be available later. The
Using Subform in Invoices
Hi there; In a billing project in Zoho creator, within a form, I use a Subform for the items, which is very normal. The problem is that for Zoho record consumption purposes, Zoho considers each rows of the subform as a record. And causes consumption of
First day of week [FIX IT PLEASE]
@Zoho, how many of your users use Sunday as first day of week? I mean, you have a whole feature about localisation/translation and date formats... how hard would it be to allow for user based "first day of week" variable? Currently, filtering reports
When will standard Theme fonts be supported in Pages?
First of all, great to see the new options to customize Theme fonts and color options, all though a little change, it makes a huge difference to the perceived value from the perspective of the end user. However, what seems very much out if sync is, that
How To Pass Parameters To Filter Report By Address Subfields?
I have an Address field with Subfields...I am trying to pass parameters to filter by State or Zip Code in a report. Can this be done? state = "CA"; For example: report_url + "?Address.state_province=" + state; ...does not work.
Zoho People Integration in Zoho Creator Through Deluge
Hello , I am doing zoho integration in zoho creator through deluge , I got the records when i am doing this: zoho.people.getRecords("P_Task") ; , zoho.people.getRecords("P_Employee"); etc. but i am stuck here when i want to get the LMS data which is a
Best of Creator App Examples
Does anyone know of or have examples of really awesome Creator examples? Perhaps some great HTML pages? I've been digging into the app for several months, and have been trying to find examples online of very well designed Creator app examples, but come up short. I know there are the pre-made applciations in Creator, however, they all appear dated looking. Would be great if Zoho would periodically provide a showcase of great Creator examples and the back-end code to make them.
Introducing Blueprints
Hello App Creators, Greetings from Zoho Creator! We're happy to inform you about a new feature called Blueprint—Zoho Creator's process management tool. This feature enables you to customize every detail of every process you design in your Creator application.
ZC6 - No custom order for sorting/grouping ?!
Hello There, Upon analysing we could see that you are in the C6 version of Zoho Creator in which the custom order sorting/grouping is not supported as of now. I have raised a user voice for the same and our engineering team is working on the possibilities.
Dynamic Filter for CRM Integration Field
Is it possible to filter an integration field in the same way you can filter a dropdown or lookup field, by using ui.add() with a list of the module record ids I need to show? I am working on a Creator app that will be integrated with CRM. I need to be
Redesign - Rearranging sections in ZC
Regarding rearranging sections in ZC, I think the current layout of the panel could use a very simple tweak to make it way more usable. Currently you are trying to fit the "active" and "inactive" components in one columns while you still have tons of
NodeJS version
Good day! I would like to ask what NodeJS version is used in Creator. I am planning to incorporate node scripts on a POC project that we are making. Thanks!
Trying to send email using CRM template via API from Creator
Hello Everyone, I have been trying to send an email template that has been stored in CRM via an API function that I am executing in Zoho Creator. I am using the following function: email_mp = Map(); email_mp.put("from",{"user_name":"xyz","email": zoho.loginuserid});
How to use a dynamic value in and API call with invoke url
I am working on a form that will autofill multiple fields based off of a parameter (Case_Number) value that is passed through url. I want to append that value to the endpoint in my API as query so I can grab the corresponding data to that Case_Number
How do I collect single-row checkbox value in a report?
Hi Zoho Community, I would like to collect a report checkbox value and would like to execute some Deluge code based on checkbox-checked report rows. Is there any way to collect this checkbox value?
Zoho Creator for Agriculture
Greetings, I am starting to work on Zoho Creator specifically for the agricultural field, any recommendations, tips or ideas that might be helpful ? Also, if you are interested by any means in working on such project, kindly contact me. The project is
Calling function in another app
I have 2 applications in our account. I want to call function1 in app1 from app2. I have tried to create a function and use the following code: myvar = app1.function1(); But I just get "not able to find 'function1' function. I've tried with the function
How do I fill a single form two relational lookup fields data with select data?
Hi Zoho Community, I have created a zoho creator form with two dropdown lookup fields and I have set the query to filter one lookup field's data based on another look field's input data. But When I have filled the lookup field value with selected data
Conditional enable/disable of subform rows
My app contains 2 forms: MainForm = Contains some data in various fields Subform = contains comments in the form of multiple rows My users can add new comments by adding rows. All this is working fine. What is needed is: 1. Disable all rows "comment field" when the MainForm is edited e.g. "disable comment;" 2. On Add Row, enable the field e.g. "enable row.comment;" I can successful achieve #1 by adding "disable comment;" in the Edit -> On Load. However, when I add "enable row.comment;" on the "On
Pass This Year Filter in zoho Creator Report URL
Hello Team @Bhoomi Joshi How we can pass this year's filter in Report URL Inside the zoho creator? Please update on this asap. Thanks & Regards Piyush Goyal
clear all the data
kindly need to clear all the data from my app trying to buy the app but need some help to understand it
How to utilize a callback URL with Zoho Creator (OAuth 2.0 authentication)
I have successfully made calls fetching public data from the Socrata API, but I am attempting to work with a private dataset that requires OAuth 2.0. I am having trouble with figuring out how to use a callback URL to handle the token. Any feedback on
new system field
what is record status(system fields) in zoho creator?
Next Page