How to create statistics for each employee who add records through form?
Dear developers and colleagues! I am just one month zoho user. Even I have not yet discovered all the abilities of Creator I believe I can develop exactly what I want: simple and effective application. By now I am almost done, but there is one thing left which I never thought I could stuck at...a super primitive statistic report showing performance of each employee who added records in certain date range, e.g. Today, Current month, Last Month, Total. Showing the count of both, total records added
Automatic CSV Import/Upload
Hello All: I am attempting to set up a daily import from a local CSV file into my Creator Application. I have found the migration tool and understand the parameters. I just don't know how to edit the commands within the zohocreator.exe application. No doubt this is simple, any help would be appreciated. Further, I may be overstating my knowledge so specificity would be helpful. Dave
Please share your experience with the NEW UI
Hi Zoho Users, I'm a long time Creator user and I have been testing the new UI for a while now and I feel like 90% of the bugs have been fixed. However, based on my testing it seems that the new UI is about 2-3x slower! I love the new UI and and I'm willing to give up speed/performance for a more polished look. I'm curious if anyone else has seen the same results? Have you switched over the the new UI? If yes, do you have any issues? If not, what's holding you back? Thanks. Zalman
Customer Portal User change of email
Hi, I came across the following situation: one of my customer portal user changed his email address. This mean, I have to create a new user with his new email. The problem is that I want that he keeps access to the data he added with the previous one. Someone has had the same situation? Any help appreciated
Go back to dashboard in mobile app
Is there any script or way to close a form after successfully submit a record and go back to the dashboard (screen showing all forms/reports etc in my app) in the mobile app? My employees use the mobile app with QRcode capture in our main form. This form displays the camera screen (before displaying the form) and never closes after capturing the QRcode. I need my users to go back to the dashboard after every QR is captured &recorded so they are able to open other forms (which is not always the
driving a SIP softphone in Creator
I've already installed a SIP phone client (Bria) and set the browser default. Not sure why this won't open a new window as an easy way to drive a softphone call? varX = input.Main_Phone_Number.getAlphaNumeric(); openUrl("sip:" + varX,"#Script:page.close", "same window");
Feature request: CSS editing in record summary
Hello, I really like the idea that I can customize a record summary template to fit my organization's needs. However, I feel that the HTML editing feature is very limited by itself. Would Zoho consider giving users the option to edit the page in CSS? I think this would be an extremely useful feature which will give users the ability to further customize the templates. Thanks!
Problem with search form code
Hi I'm new in programming and really need help with my code that I modified from tutorial link here: https://www.zoho.eu/creator/help/application/search-interface.html What I need to have in my application is search interface where I can find records by user input and show them on page. I modify code form tutorial to my app where all data are stored in Item_register and I want to looking for records that have same value as input in fields Model_Name, EAN_CODE_Value and Item_category. Problem:
help to fit graph report into dashboard / screen
Hey guys maybe somebody can help me 1. Can I change the graph report size to be seeing in the window without using a scroll bar? 2. I am embedding reports like the previous in my dashboard, however the graph, even with a scroll bar, won't show the whole X axis, below the code I am using in it, I'm using a previous dashboard code so maybe I need an extra line to fit it in, thanks .monthFrame{ width: 99%; min-height:380px; max-height:100%; //margin-left:10px;
not receiving emails
hi, this is now the 3rd time within a week that we have not received emails sent through sendmail in Zoho creator. we have a production system that has been affected each time. zoho made a fix twice but the problem's back again? i called support and no one picked up. i've sent an email to customer support but no one's responded.
Can't access my uploaded documents
All of a sudden I can't view or download the documents that are uploaded to my application. Last week my staff and I could. Now they are denied access (even though they are granted access) and When I click on them nothing comes up. Anyone experience this? There is nothing in field permissions that has been changed. Help! Christine
Access Image from API
Hi, is it possible to access a image with an authtoken It is not a good solution to save the complete HTML tag into a database. Why was this done? I am currently getting the picture url with regex but unfortunately, i can not access the picture because I have to log in. Is there a way to get the picture with an auth token? Thanks Daniel
Figures don't show up when creating report chart
As shown in the picture. There are a lot of thing that are in the form but are missing in this column to be chosen. Can anyone help me ? tks
Fetch XML response from Zoho Creator rest api
Hi, I'm having trouble figuring out how to use their rest api. I read their document but the explanation was not clear enough for a beginner like me. Can someone give me a simple example of how to use it? I really appreciate any help you can provide.
Duplicate Application
Hi, I am trying duplication my application before making any changes, in home screen I click Duplicate Application under ICON, but nothing happens. no errors no message appears. Thank you in advance for any help or suggestions Lee
Import data problem
I'm having problems importing data. The import file was exported from a Zoho Creator App and now I'm trying to import it into a copy of the same Application. I'm going to use the copy of the App for development. I'm trying to populate the forms in the copied application with the same data in the original application to get a realistic development environment. The import works fine on most of the forms/tables, however I'm getting strange non-descriptive errors on a few of the forms. It seems the
Summing fields in a subform
Hello. I'm relatively new to Creator and Deluge and I'm hoping someone might be able to help me solve an issue I'm having with a Creator app I'm building. In this app, I have a mainform and a subform. Each row of the subform has a "Total" field which I have managed to automatically calculate. What I am trying to do, however, is sum up the amounts in every row's "Total" field, and display that in a field on the main form. My early attempts at scripting this resulted in various form execution errors,
Finding and editing records of a form using another stateless form
Hello, I have two forms in my application. One has data (Form A) while another is a stateless form (Form B). Form A (the form with data) has various fields and one of those fields is a unique ID field (Ticket ID - put in by me). Here's what I want to accomplish via the stateless form: The stateless form records data entry in a single single-line field I want to use this data just entered to search the Ticket ID field of Form A If there is a match in the Ticket ID field of Form A then I want to modify
Open an specific form when mobile app is launched
Is there any way to automatically open an specific form when the mobile app is launched?
Accessing and editing records from another form
Hello, I have two forms in my application. One has data (Form A) while another is a stateless form (Form A Check In). Form A (the form with data) has various fields and one of those fields is a unique ID field (Ticket ID - put in by me). Here's what I want to accomplish via the stateless form: The stateless form records data entry via barcode or manual entry I want to use this data just entered to search the Ticket ID field of Form A If there is a match in the Ticket ID field of Form A then I want
Remove Set Filter Limitation From Report
Hi - I have a form that collects employee names, and then a form that collects notes for each employee, using a drop down field for name pulling from the employee name form. I have used "set filter" to limit the drop down to active employees, which is set in the employee name form. I would like to create a report that shows notes on inactive employee with a filter by name. However, when I add the employee name as a report filter, it applies the same "set filter" limit so I only see active employees.
How to implement price into the form?
Hello. Could you please explain how I'm able to implement prices to the form. The idea is when person selects a certain service, the total sum should be seen in the bottom of the form. So each time when person selects extra services the total sum is changed. Thank you in advance.
URL criteria syntax
Hi, I'm trying to open a report based on a set of criteria. The criteria are: The BkCourse_ID field is the same as the one entered on my stateless form that I'm invoking the report from. The Booking_Status field is not like "Cancelled" The Booking_Status field is not like "Exchanged out" I can successfully open the report with the first two criteria as the filter, but I'm struggling to come up with how to add the 3rd to the URL coding. Here's what I have so far: rec = Courses_Setup [ID = input.Course];
I wanna create an application that can search and view the CRM i have.
I wanna create an application that can search and view the CRM i have. I need a professional guide how to do it. to where i can fetch the record i want to be viewed with, fast searching for the information inside the CRM, and possibly published to either Google Play and/or iStore
logging in using userid instead of email/phone
Hi, I understand that when the zoho account is created - a userid is created eg bkmaithili I am able to login using email or user id But today i have created a new zoho account - but am not able to login using the user id.. It throws an error asking for email/phone number My query is that 1.how to login using the user id? 2. can we create our own user id... the application will be used by few people - are we dont want to have a login based on email id - just a generic userid - eg Appuser1
Auto fill form field with the same value as the last submitted record
How do I fetch a value from the last submitted record so I can set that value as the default value on loading the form?
Populate Form Fields from values in another report?
I need to create a form that takes attendance at a staff meeting. I have all the staff listed in a report called "Active_Members" (which is just the records from a form called "Member_Entry" with a status of "Active". I need to have a form that lists all the members so that the secretary can call the list of names from top to bottom, and mark whether each is "present, absent, or excused" I'm trying and can't figure out how to do this.
Delete uploaded files
1. The form at https://creator.zohopublic.com/registrocivil/registro-de-nacimiento-doble-ciudadania/form-perma/Envio_de_Documentos_inicial/UbUsnYy7X5gyZhpJCjjt9hkAj01Y0AtV1kAM9kGsjJ3hBBQtRgVvsZQQsd2qjFrTZvOeMPNh5kFpNV7BqHbsjpNG29DQAqRehUYY is uploading files. How can I erase some of those uploaded files ? Thank you.
Count records which have had a subform record added this week / month / year
Tried to post before but it never appeared in forums - just said waiting approval but I can't find anywhere!! Anyway straight to the point.. I have 2 forms of interest (Company, Call_logs) Call_logs is a subform within Company I also have a page (Monthly_Report) in this page, I want the following date to return the number of Companies that have been called this week / month / year Company A = 5 Call_logs Company B = 2 Call_logs Company C = 7 Call_logs Company D = 1 Call_logs Ie 4 companies called
Zoho creator old version
how can i go back to old interface on Zoho Creator?
API Integration
I'm trying to create an app to record our press mentions. I have created a form which creates a record for each mention, with one of the fields being a URL. In the report section, I want to show the number of times each URL has been shared on social channels using API (ex: http://graph.facebook.com/?ids=https://www.marketingtechnews.net/news/2017/may/31/how-drive-media-buying-roi-through-integrated-platform/) How can I get help doing this?
How to Make Pre-Filled Form to build an attendance register
Trying to build an attendance register for small manufacturing company - can be used for schools, hospitals etc. Up to about 30 names can be displayed on the same page, The default radio button is set to Present - most people come to work most days. The manager, supervisor, teacher explicitly chooses absent. I tried to do this with look up field in the form but could not succeed. This is a best approximation of how people work today. then ensuing reports can calculate attendance, pay, leave records
Catching failed lookups from zoho.crm.getRecordById
I’m using Zoho Creator to pull record information from Zoho CRM, using the method zoho.crm.getRecordById, as such: potential = zoho.crm.getRecordById("Potentials", My_Zoho_CRM_ID);
When My_Zoho_CRM_ID is an ID that exists in the CRM, everything works fine. However, when My_Zoho_CRM_ID does not exist in the CRM, I’m given the following error: Error in executing Set Variable task. Unable to update template variable potential.
Error evaluating MAP expression :
Is there any way to catch this
Deluge Name Panel Disappeared
During Free Scripting we used to have a Deluge Name Panel on the right hand side, its super handy, however its disappeared since last week, wonder how to get it back?? Thanks!
Help for making my aplication please
Hello, first of all i am a new user of Soho Creator. And please sorry if it is not the right place for doing this question. I need some help for making an aplication for our organization. Well, my question is, that while we have a "form" where we charge our campaigns, each campaigns maybe have more than one work in it, so we have a "subform" in it, where we can just press "add" buttton of the subform and add every work in it, in each work charged in this Subform, we select the Personal who
Reg - Calendar report
Hi, Good day to you! I want to know how to make the availability of office timings alone ( say 10 AM to 6 PM ) in zoho creator calendar report. Its shows time from 12 am to 11 pm in day view. Thanks, ITKES
Convert IDs returned in a list to the names they're associated with
Hi there, I have a multi line field on a statless form that I want to populate with a list of names fetched from a set of records meeting a certain criteria. There are 3 forms connected to this process: Client_Info (this just holds the basic client info like First Name, Last Name, Client ID, email, phone no. etc.) Courses_Setup (this holds a uniques record for each course that has been setup, with fields for course title, room it's held in, strat and end dates, teacher etc. Class_Bookings (this holds
Can we call Zoho Migration tool through deluge script or can we extract data from Excel or CSV
Is there any possibility to extract data from excel file and from pdf we need urgent response . Thanks.
update record instead of create new
Hi guys, firstly I am new to this zoho, trying to remeber my ms access days, i hope you can help :) Where I'm up to, so far: 2 forms - form 1 : Customer Details, Name, Address etc - form 2 : Drop down - which displaying customer name and a Rich text format box What's happening at the moment is: Access form 2 - select Customer by name (drop down) - enter text into the Rich Text box - Submit this creates a new record every time: What I'd like to
Gettype function
I wonder if anyone can help me, please.... I have 2 applications:- Application1 contains Form1 with fields Name1, date1 Form 2 with fields Name2 (the data in this field is copied across from Name1 in Form1), Number1 Application2 contains Form1 with the following fields:- Name3 - A Lookup field - the relationship is to Name1 in Form1 in Application 1 Date2 Number2 When someone goes intro Application2 and looks up the name in Name3 field - I use the gettype function to find the associated record in
Next Page