Import additional data to existing records
Hi, I am wondering if it is possible to add (some) data to existing records using one ID field as cross reference. For example I have a spreadsheet, one column 'ID', and a handful of other columns with the corresponding field names. I want to import those to exisiting records where the ID value is equal to a specified ID field in the existing table. The new value should overwrite any existing data. The default import function seems to import only new records. Could the above be achieved with a script?
How to format a text field to include spaces?
Hi all, Was wondering if anyone could help me with this. I have a basic form to collect data which collects UK vehicle registration numbers. At the moment my form just stores this as normal text but I’d like it to format the text in a certain format (ie the way registrations are displayed - at the moment it’s FG10JKP and I’d like it to store it with a space after the fourth character FG10 JKP regardless of how the user entered it. The next thing I want to achieve is to not apply this change if the
Simple application, but can't find a way to pull it off.
Good evening. We have a simple application we're looking to write but can't find a way to pull it off in Creator. Basically, on a form, depending on what radio button you select, when you hit submit, an email is sent with a specific attachment. Sounds easy enough, but our issue is, we can't see where to store the attachments. They're each just a Word doc. The hope was to maybe even store them over on ZoHo Docs or on our website somewhere, but can't figure out how to have Creator go get the file and
form-mobile
Hi Zoho, Form-mobile links are no longer supported in new UI. Do you expect to bring this back? If yes, when can we expect it? Thanks.
Mobile App Limitations
I have been trying to develop an app for an iPad kiosk. I keep getting hung up on things that work fine in a desktop browser, but not in the mobile app. - Embedded Forms and Reports in HTML Pages show up as a button to the Page, not the Page itself. I tried to embed a Report and a Stateless Form with custom buttons. In a desktop browser it behaves as expected, I see both items on the same page. In the mobile browser I see two buttons, one to the Report, and the other to the Stateless form. Not at
Field update not working in subform
Hello, hoping someone can help! I am making a mailroom app for my company. I have several forms as follows: Form A: Info about packages being delivered Subform A: Collects info about each individual package, includes 'Package No.' field which is unique and is input by user, and also 'Package Status' field (package status are either 'Signed In' or 'Signed Out' Form B: Info about when people collect their parcels from the mailroom, and has a signature field Subform B: Collects info about each individual
Convert a 'Single Line' field to 'Drop Down' without data loss!
Is this possible? When I try this I get an error message that says: Warning: Data Loss Detected All the records and report columns associated with the field will also be deleted. This action cannot be undone. [I understand, Proceed] [Cancel] Thanks.
How to nest forms within forms (not subforms)?
I tried using subforms already, but they force you to list everything horizontally, causing an unacceptable amount of scrolling. I need the exact same functionality as a subform, but with a vertical orientation. Can it be coded manually?
User added set of fields ...
I'm trying to develop a tool for our factory to organize product requirements, data from product tests and then a report compare the requirements against the test data to see how much of a variance there is. I think I need to create one form to log the product requirements, then a second form for logging the test data, and finally a report comparing the two. All of the data can be gathered via regular fields, but I need the user to be able to add sets of fields based on the specifications of the
Making email addresses clickable in a Creator form view
Hi folks, New Creator user here - I'm building a client management system for a small charity in the UK. Loving Creator so far. This is my first hurdle: I've created a 'Client View' form with a lookup field to pull in details from a master form containing client data, and display the data in other (disabled) fields in this form. Here's part of my Deluge script: temp = Client_master_form[ID == input.Client]; Date_of_Birth = temp.Date_of_birth; input.Postcode = temp.Postcode; input.Email = temp.Email;
Multiple Reports in Record Summary
I'm using Zoho Creator to build a contact database for my organization. I've managed to create forms for both our contacts (with contact information) and another form with their order history. What I'd like to accomplish is when accessing the contact database report that the summary record include both their contact details from the first form as well as a log of their order history. I'm currently unable to combine these elements, do you have any suggestions? Thanks! Hannah
EAN13
Hi, I would need generate EAN13 in Zoho Creator. In Excel sheet, I have this formula in column A (=RANDBETWEEN(978047100000;978047100999) - this formula provides a 12digit number. And in B column I have this formula: =A1&IF(MOD((SUMPRODUCT({1;3;1;3;1;3;1;3;1;3;1;3};-MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1))*-1);10)=0;0;10-(MOD(ABS(SUMPRODUCT({1;3;1;3;1;3;1;3;1;3;1;3};-MID(A1;{1;2;3;4;5;6;7;8;9;10;11;12};1)));10))). This is last digit validator for EAN13 code. For example: In A1=978047100700 and in
Zoho Account in free trial even if paid licenced already.
I have been using the account for more than one month, licenced to zoho one enterprise , but now i cannot import more records. Its saying "Record limit reached. kindly upgrade to a suitable plan to import records." even when i am already upgraded to enterprises. please see attached files. hoping for a quick resolution. Thank You, Deepak Sapkota
Access to DB records via a primary key for portal users
Hi, I'm a potential new user of Zoho Creator. Is it possible to identify Portal users so each user can only access records with their primary key in the db? There are relationships between many tables also so this access limitation must carry through the entire application. The database was created by migrating it from MS Access into Zoho Creator - ive tried it with a sample db and it looks ok but the Queries are all lost and the forms are lost?? Does migrating a large DB from MS Access also import
long.toHex() string has halved in length?
I have a script that converts a long to a string using long.toHex(). It appears that in the past few days there is a change such that the string is half the size that it was? It used to be 18 characters, now it's 9. Has there been a change?
Disappearing Records
Early records in my database are disappearing. For Example, in the attachment, location number 211 originally had a starting gallonage on January 1, 2017 of 59.45 gallons. This is occuring with many of my 2015 and 2016 wines. I have reviewed my code and re-entered the data several times. This problem is recurring but I do not see the pattern. Orginally I though the database was cleaving earlier records to make room for new records so I paid for more records to avoid this. In any case, cleaving older
How to set report criteria to "not this month"
Hello, I use Zoho Creator to raise statements for contractors. I have a report, and I would like the criteria to show records *not* from this month (i.e. from any previous month only). So, for example, if it's March 5th and I run the report, I want it to show records only up to 28th February. How do I do this? Thanks!
Pie Chart Legend
We have an employee who is colour blind and |I am looking at proper accessibility for web interfaces. I would like to change the pie chart pieces from a colour to black and white texture but haven't found a way to do this. The other option is to be able to add the label name to the piece. Any help would be appreciated. I don't have a huge coding background, hence the reason I like Zoho.
Zoho Creator with no app gallery
Hello, The App gallery its gone? When i create a new app it used to send me to a app gallery like this: This menu doesn't appear anymore, and i need to use one of the apps on the gallery, what can i do? The pre-maded app i need its "Sales Management". Thanks
Fetch data in different Applications
Hello, Working in Zoho connect I make applications in different groups according to the data access users are being given. In Group1 their is AppName1 and AppName2 and have both different Forms from which MembersForm in AppName1 In Group2 their is AppName3 with an Form UserinfoForm that, as in AppName1, contains a LookupField 'Name' that links to AppName1.'Name' and gives a dropdown form names introduced in AppName1 - MembersForm. My Problem is to fetch the data of other fields present in MembersForm
Summarize Subform in a Single Line
I have a subform that contains two column describing a pesticide. The first column is a lookup (compound), the second is a decimal (concentration). However, in one of my reports, I have to summarize all this information in one line. For example: Product A (Single_line) Subform: Compound 1 Concentration 1 Compound 2 Concentration 2 To be displayed like that in a Single_line: Product A - Substance 1 (Concentration 1) + Substance 2 (Concentration 2) Is it possible?
Ask the Experts 1: Using Customer Portal in Zoho Creator: All you need to know.
Hello people, We're happy to tell you that we'll be launching a new community learning activity this month: 'Ask the Experts'. This is a live knowledge-sharing session where our technical experts will answer all your questions in real time. We'll be doing a session every month and each session will focus on a new topic based on popular features and questions frequently asked to our support and community teams. Our first 'Ask the Experts' session will be held on 8th March 2018 between 6:30 and 11:30
Zoho creator calendar report & page
Hi All, i need some help. Please find the attached image. i have done some customization on the event management page. instead of showing the calendar field, when clicked. can it link to another page? like i clicked eventA in calendar report, it will show the search eventA in the page for me to book.
zoho.encryption.base64Encode(); did not work
Hello there, 2 weeks ago, i write a Zoho Creator Function, that encodes a String. Today, i want update this Function, but i cant Save them, becouse the Script compiler send me an Error is this a Compiler Bug? Or did the syntax changed? Thanks! Kind Regards Klaus Brandt
Zoho creator api
Hi I'm traying Zoho creator api to export an app report whit a php form and I'm getting this error {"code":2945,"message":"PATTERN_NOT_MATCHED"} I found the code is "Invalid Ticket" and I don't know what it means my url is: https://creator.zoho.com/api/json/pruebasql/view/sqlprueba1 hope you can help tnx
Cancel (and Other Buttons)
Forms only have Submit and Reset Buttons. I'd like to be able to add other custom buttons, particularly a Cancel button. I want this so I can attach an OnCancel script. In my case I want to direct to a particular form. I've worked around this by creating Stateless Forms, but it seems like I'm doing twice the work and creating additional confusions.
Auto formating field
Hi, I want to enter GPS coordinates into a field and format it automatically OnValidate. The user will enter "46 51 10" and the field would automatically reformat itself to 46°51'10"N How can I acheive this? Thank you!
Fetch records
Hi, I'm new to this and it's my first post in this forum. I'm struggling to get data from a related form into a field. It's something to do with the lookup value being in a lookup dropdown I think. Form A (Room_Cat_Form) has fields called Room_Usage and CtFm_Net. Form B has a lookup field for Room_Usage and I need the corresponding value of CtFm_Net in another field (Usually_Net). I tried this but it just returns the Record ID. input.Usually_Net = Room_Cat_Form[CtFm_Net == input.Room_Usage]; It's
Lookup field that aggregates two reports
I've a lookup field "Purchase Order" but the orders can reside in either of two Reports "Purchase Order Product A" or "Purchase Order Product B" Any idea how I can make appear entries from both forms in this single lookup field?
Zoho Creator performance problem and thinking about switching to salesforce.com
I have some complicated Zoho Creator apps written. With around 30 forms connected to each other. One main form is approaching half a million rows soon, and probably expanding to 10 million rows in the next 3 to 5 years. Clears some Zoho Views (called "reports" now to add to the confusion), are not loading fast enough for any of my applications. If you change the criteria for the views, and try to reload the view, it just gets stuck. Sometimes I have to mass-process say 500 rows in a single form for
Inventory Items w/ Unique ID's Viewed Together
Just going to go ahead and apologize now if this is a DUH issue. I am super new and know enough to be dangerous. I am building an app for my home staging business. I have to track items that I purchase to use in my rental inventory, which gets moved between properties. I also occasionally sell these items to clients. So the app includes recording inventory additions (have a searchable list of inventory), cost tracking for resale/tax purposes, and assigning "locations" so that I can keep track of
how to count field that is a dropdown iteam
hello my form have field name, batch, exam status I have a field in a form exam status with dropdown choice pass, fail, not sit how can i count under reports based each group of student and display total number of exam pass using count option. how to build the script hope you can help thanks
horizontal multiple checkboxes on one line
What would be the best way to recreate a single row with multiple checkbox options?
Zoho Creator Calendar Report & Pages
Hi all, i have make some customization on zoho creator event management. i want to show the calendar report of the event in the page to let customer have a look of the entire event. instead of showing the calendar field when clicking, can it link to another page? please find the attached image. red & green arrow is the normal, i want is the black arrow. Victor
delete Customer portal User via Creator
Hello, my problem ist, that i have a Customer Portal with many customer accounts. Now, due to security, i must guarantee, that any User can Delete his account by Click. Aktually i have a "Delete Account" Page. This page ask for the Password. On send with the right Password, the User where Logged out and in Zoho CRM where marked, that this account ist disabled, so the Customer Portal didn't show any Data. BUT i need, that these account where deleted from the Creator Customer Portal. Is there a Solution
Multiple Conditional Formatting Rules
When I use multiple conditional formatting rules how do I control the execution order? e.g. If Rule1 says to color fields with less than 700 as Red and Rule2 Says to color less than 800 as Red will the order of execution matter and how can I control it to achieve the desired outcome i,e, 800+ No formatting 700 to 800 Yellow <700 Red
Any way to conditionally change CSS styles in a custom record summary template?
Hello, I have a record summary that includes fields that come from a related form. Each record in the first form may or may not have a related record from the second form. Now our client wants us to hide the fields from the related form if the first record doesn't have a related record. I tried using a formula field that returns "display: none;" or "display: block;" to insert CSS styles into the record summary, but when I view the record summary, the CSS is removed. Is there any way to use field
Using Functions in Record Summary?
I'm trying to get the record summary of Record Type A ("Players") to e.g. show the sum or count of all entries in a field in a connected Record Type B ("Games"), so that I can show the total wins that player has made, or total games they have played. I can access the field (e.g. ${Record_a_Match_Date_of_Match.They_Won_the_Match}), and it returns a comma-seperated list, but I can seem to perform any functions on it (e.g. sum(${Record_a_Match_Date_of_Match.They_Won_the_Match})). Is this possible?
Sport Stat Tracker (How to do create equations and display results)
I'm looking to create a Sports Stat Tracker. I've created the forms and the database to have my players register. I've already created a form and started testing. However I'm running in to issues on how to create the additional equations and how to create reports or display that players individual stats. Thanks! SC
Tips & Tricks
Hello everyone, We hope everything is going smoothly with Zoho Creator. We are always thinking about ways to make our community more engaging, vibrant, and informative for our users. That’s why we’re happy to let you know that we'll be sharing Tips and Tricks every fortnight, starting this Thursday. It’ll include some quick how-to's and best practices to help you get the most out of your Zoho Creator applications. We have handpicked these topics from the most frequently asked support questions and
Next Page