Fields
Hi all, Can i create a field with block in it? more like separating the filed in lets say 5 blocks for the user to put data in the blocks Thanks.
Paypal issue
I am having an issue with some payments from PayPal, when completed and returning to merchant the screen just say transaction being processed please wait, this just goes and on. The payment is being completed and the confirmation email is sent, but the hang screen is worrying customers. Is this ipn settings in PayPal and if yes what is the return url address I put in, and will this work for forms and creator? Thanks, Simon
How to remove applications in Zoho creator I no longer want?
I do not see these applications in my account through the computer in order to eliminate them. I already deleted them but I know it's still there. I know they exist because I see them through the application of the cell phone and when I try to create another it tells me that I can not add any more. I see the application of the Electronic Teacher's Book as four times and I'm not interested.
get link value of URL field
How do you get the value of the link from a url field? I want to use openurl to open the url from a url field. If I use openurl(url_field, New Window) It uses the Link name not the actual link.
Zoho Creator iOS app 3.7.2
Good day, just updated to latest version 3.7.2. which in the release notes says to feature offline support. Is this to be interpreted as now possible to enter data while no network available?
Embedded Report in HTML page: Header title being cut off
How can I fix the issue below? The Header title is being cut off
Average weekly visitors
Hello, I count daily visitors, have unique names. Users want to have the statistics, where they see average Distinct weekly visitors in a month. Lets say first week I had 11 distinct Visitors . Next week I had 15 distinct visitors. So the proper calculation would be that I had (11+15)/2 = 13 .. on avarage in one week I had 13 distinct visitors. Is it possible to do this in Pivot report? It gets more complicated when I have the whole month andin this month 4.5 weeks, I have then to do the maths as:(11+15+12+17+6)/4.5.
Cash register
Hi all, Is there a possibility to have a cash register with zoho creator? Where simply i can get a record and print out a receipt with a epson printer? Thanks!!
User permission for application?
Hello Zoho Team, is it possible to setup my application for the user's (Login via E-Mail) that he only can create a new record and not delete anything in the database? Regards Carsten
Upload File to Google Drive
Hello, Is there any way to have the "Upload File" button in Zoho Creator push the uploaded file to a Google Drive folder directly? Thanks.
How to find and set a value into a field from another form?
I have 2 forms. On occasional basis, I add new name into the first form and assign particular tax rate and commission to that name. Daily, I need to enter data into the second form. I choose a name from "lookup/drop down" menu connected to the first form and fill out couple numbers. The form calculates the rest. What I need is, depending on the name I select, to automatically look up and fill the tax and commission that were set in the first form. What would be the best way to accomplish this? Thank
How Does one print a Form?
I have created a number of forms which I would like to print out for Government record keeping purposes. The format of the zoho-created reports is unacceptable. Is there perhaps an "OpenUrl " expression that will produce a new window that can be printed? Is there another way to do this, or should I be looking to something entirely different to accomplish this? I see the "Pages" feature, but I cannot find any Zoho documentation that explains in any detail what can be done with a Page . Is there
Convertir Numeros a texto?
Quiero saber si es posible convertir números a texto en Español, Quiero enviar facturas con números y texto: ejemplo: 1000 (Mi ) ó 20000 (Veitemil) Es posible o algúna funcion similar dentro de zoho?
Zoho Api Question
Hey All, Have a quick question regarding parsing json. I believe my code is valid however it doesn't display a response when i search for specific key / value. I can however return the response->uri just fine but can't get anything other than that or the full file. function GetLeads() { $file = fopen("https://crm.zoho.com/crm/private/json/Leads/searchRecords?authtoken=API KEY&scope=crmapi&criteria=(Last%20Name:test)", r) or exit("Unable to Open File!"); while(!feof($file)) { $theData = fgets($file);
Include lookup field in function
Hi I have two forms (A and B) connected with a bidirectional lookup. I want to copy records from one to another including the value from another lookup (from form Country) which they both include. So far the function looks like this: void copyRecord(string First_Name, string Last_Name, string Email, string Profession) { insert into New_Profile [ Added_User = zoho.loginuser First_Name = input.First_Name Surname = input.Last_Name Email = input.Email
Total income calculation form
Hi , I wonder if anyone can help me. I have a job process form where by the user records a job undertaken, which calculates agains a job form. So there is a list of jobs complete in a report. I want to a separate form where the user can select a month of the year, and it will calculate the earnings over that period. I have attached a screenshot below of the "Job Proccess Form" which i would like to build this new form from. Thanks for your help in advance. Danny
Numerical format field report
Good Morning
I could collaborate, to know how to format numerical reports Zoho Creator. For the numerical field shows it without any format and I would like, if possible, to show it with scores of thousands, hundreds, etc.
Example: 1234567 see 1.234.567
Thank you for your cooperation
Add edit button to record summary
Hello, I have taken a look at these 2 posts https://help.zoho.com/portal/en/community/topic/how-do-i-create-a-link-to-a-pop-up-edit-window-in-an-html-view https://help.zoho.com/portal/en/community/topic/tip-using-duluge-create-url-field-with-dynamic-parameters-such-as-record-id But none of these posts solved my problem. When I click on a linked record from a record summary, I want to be able to edit that record in a popup view within the application. I've gotten this far temp_param = input.ID.toString();
How to get value of field in current record
Hi, I have a table called 'Classes' In that table, I have a field called "Class1" - it is a drop down field. On the action "On user action", I want to save the value that is in the field if a user removes that value. So, if the value in Class1 == null, I want to know what it was before it was removed and save that value in a variable. This gets me the value that is in the field before it was deleted. ctemp1 = Classes [ID == input.Class1]; How do I save that value though after the field value
Mobile app Zoho creator
Hi, Can the mobile app be customized like the web app? for example the layout or icons?
"?Terminal.Id="
What does the "?" in front of the "?Terminal.Id=" mean?
Alternate version of same data
Is there a way to display an alternate version of a data in certain layouts ? For example, I have a radio button field with two choices : Yes and No. In a "list" layout, I would like this data to show as Y or N instead of Yes or No (...or show as X or "empty"), but I still want the data to show as Yes or No in other types of layout. Is there a way to create an alternate version of this data and indicate which version to use in which layout type? Thanks for your help!
Pre-tick a check box in a form
Hi, is there a way to "default pre-tick" one or more check boxes in a form the same way you can "default pre-select" a radio button? Thx!
Enable and disable fields in a subform On Edit - On Load according to an other field value.
Hi Zoho, I have a subform and I would like to know if its possible to enalbe or disable a field "Quantity" according to an other field "Status" for different rows when I open the record to edit it. I was trying the following code, but I can't even save it. for each rr in Detalil_RC { if ( rr.Status == "Approved" ) { disable rr.Quantity; } } It says "rr" is not defined. Any help will be appreciated.
Retrieving zoho.loginuser variable using email address
I am trying to retrieve a zoho loginuser variable by using an email address so i can link only relevant information to the specified customer.
Record Summary to Display Collected Data
The Record Summary is a GREAT feature, and I was wondering if, after we've designed a Record Summary, if it was possible to use this Record Summary as a way to view data, such as List, Summary, or Calendar views? The major issue is I have multiple fields of data and I would like to view all of the fields at the same time, as opposed to having to scroll horizontally (as in List and Spreadsheet view) or vertically (as in Summary view). The Summary view is the one that comes close, as the List and
Pre-populate "Add New" Form based on Main Form data?
Hi, Is there any way to prepopulate the "Add New" form based on the input of the main form as shown in the picture?
Allow customer to look up record via one field entry.
I don't exactly know how to explain this so someone would understand - I have a parking citation application that I would like to be able to embed some type of search form, or report in a web page, and a driver can then go to the website, enter their license plate number (which is entered by the officer) and view their parking citation online. Is this possible? I know I can embed an entire report, but I can't figure out how to allow someone to search for their (and only their own) parking citation
Creating multiple Products for your Quotes in Zoho CRM.
Hi, We now support creating multiple Products for a Quote using zoho.crm.create task. Below is the deluge code for creating multiple Products for a Quote in Zoho CRM through Zoho Creator. string createQuote(string productId1, string productId2) { maplist = List:Map(); product_map = {"Product Id" : productId1}; product_map2 = {"Product Id" : productId2}; maplist.add(product_map); maplist.add(product_map2); resp = zoho.crm.create("Quotes", { "Subject" : "Quote for ABC Corp,Ltd",
Need help to build a Labour hire app - Developer wanted!
Hi , I am looking for a developer to help with building an labour hire app where we can get the employees to Register online Update work history bank details and tax file number availability for shifts each week online timesheet - supervisor to access to approve Employee inputs shifts worked Tables for clients rates. ie $20hr flat rate, time & half $35 , double time $ 40 Allowance: for each client table: Travel allowance $10, meal $15 Employee - payslip and update details portal access Regards
New user shows up as pending in invitation list!! Please help
Hi Team, I've created 3 users and 1 of them got created successfully but the 2nd and 3rd (admin@ewayinfosystem.com, info@ewayinfosystem.com), have been placed in the Invitation List and shows up as pending. There is a very quick short red message showing up when I try to create that last user but it disappears too fast to be able to read it. Could you please help me !
Customize Text
Hi all, Can i customize the text you see when you update and/or delete a record? When you add a record you can customize the text "Data successfully added". Is it the same for update,delete,modify? Thanks!
Using libraries
Can I make use of external libraries in any programming language in Zoho Creator for hashing passwords or displaying a CAPTCHA in a web page? I would like to put some code in the Validation part of the workflow for a form.
Find correct script
Hello, I need to use this script for count all record inserted at 06:00 AM, but it doesn't work (Error at null): void dati_per_report() { x = Dati_chiamata [ Added_Time.getHour() == 6 ].count(ID) ; } Any idea? Best regards
How can I add/fetch the data extracted from a QR code scan to a lookup field.
How can I add/fetch the data extracted from a QR code scan to a lookup field. I have a form with of all addresses and info of my customers (each has a QR code) and another form to capture deliveries. I want to give my drivers the ability to scan or look up manually the address in the lookup field linked to my customer form. Thank you for you help
View record button
Hi, The dropdown button coming by default in Zoho Creator is not practical for quick viewing/editing a field (very often you open the record just below!). To avoid this problem I have created a Custom Action called 'Edit' which is much easier to use (it is not a dropdown-list). This is better but not fully satisfying as I am viewing records more often that I do edit them. How to create a 'View' button in custom action? I could not find a command for that. Regards, Chris
Ideas Needed for Inventory Management System
Dear all, My idea is to use Zoho Creator to build an inventory management system with tracking capabilities which mimic the current Excel/Paper use in my company. It has to have the current features: 1. Able to display daily inventory level with - Base Inventory (Sum of each items until yesterday) - Outgoing (Today's outgoing) - Receving (Today's incoming) - Total (Base + Recv - Out) 2. Able to track Lot No. of each inventory. - In my test system, I am able to record
Column Hide and Show
I have a column " Lead type " with two dropdown value company and individual and other column "group" so I want when the lead type will be company then group column will show or if the lead type will be individual group column will be hide show how can I do that
API View Related Record's ID Instead of Display Name
Hi, Let's say there are two forms: 1) Person 2) Family A Person can be assigned to one Family. Let's say there are the following Families: #) ID - Name 1) 1 - Johnson Family And there are the following Persons: #) ID - Name - Family_ID 1) 2 - Mary - 1 2) 3 - Paul - 1 When I use the Zoho Creator API to download the Persons data I get the following information: #) ID - Name - Family_Name 1) 2 - Mary - Johnson Family 2) 3 - Paul - Johnson Family I do not get the ID of the Family. So if I
Access data by user owner - RLS
Dear gurus, I started testing ZOHO Creator, and one of features is of course RLS, meaning that users can access only his own data. As I read in instructions, this is the default feature in access rights (Advance sharing settings), but in my testing application each user can access all the data? I now have only free version. Can you guide me on what should I do? Rg G
Next Page