Scanner problem on mobile app
Anyone having problems with the barcode scanner through Creator? I have a database which is used as an inventory system for surplus computers and scan the manufacturer barcode. I have been using a mobile app scanner field, but it is very inconsistent (only about 30%) actually scanning a barcode through Creator. I thought it might just be my phone (Nexus 6P), but I don't think that is the case anymore as evidenced below. I started using an Android app called Bar Code Scanner Pro (on the same phone)
Show fields based on multi-select lookup field
Hi I am trying to show fields based on user input in a multi-select look up field. I'm pretty new at Zoho creator, but I've been searching through the forums, so I know I need to fetch the data for the lookup field first. I've tried the code below but with no success. I'm probably doing something basic wrong, so any help would be greatly appreciated! if(input.Multiselect_lookupfield.size() > 0) { myVar = Lookup_Form[ID = input.Multiselect_lookupfield].Namefield; if(input.myVar.contains("John
We Need Help Developing a Tracking Application!
Hello Guys and Gals, We are trying to develop a simple tracking application to use internally and externally. Here is the scenerio: We export cargo and small packages to other countries and would like to provide our customer with a simple method to track their package. We have the personnel to input data into the application once the package has been sent. (tracking number, service type, weight, ship date, origin, destination, estimated delivery time) We also would like the option to enter notes,
Record Summart Printable Details
Hello, i need to create printable details view of the report, i have an example, but i cant make it how i need with multiple subform's. I add attachment's to images, how it should be, and what i get. Can anyone help me to figure out hot to make this? Thanks.
my offline data?
how can I get my data that I capture using mobile phone which I capture offline?
Cascading dropdown
Hi, How caw ce create Cascading dropdown in the form ? Thanks for your help, Ugo
Subform formatting
Is it possible to change the colour of a subform header or remove it completely? Thanks Sean
Updating a dropdown list
I have a file containing 70,000 records - product names, pack sizes and pack costs, which is updated outside of zoho creator weekly. I have imported the first file into zoho creator which is used in a form with a dropdown field "Product name". Once the product is chosen it fetches the corresponding "pack size" and " pack cost" in the non editable fields. I would like to import a fresh price list file into my Creator app each week which overrides the existing file without affecting existing records.
Flight Search Form
I need to make a flight search form where someone can select a 'From' destination and a 'To' destination and then return the search results after searching the schedule (which I have as an .xlsx). I can make the form easily though. Can I get help please?
Null Error
I wrote the following very simple code to add a form and it is giving me a null error. Does anyone know why? form Opportunity { Displayname = "opportunity" success message = "Data Added Successfully!" field alignment = left Column { name ( displayname = "Name" type = text width 200px ) address ( displayname = "address" type = text width 250px ) amountowd ( displayname = "amount owned" type = currency width 200px ) actions { on add {
Record summary fonts
HI I am trying to desing a record summary but I need it to use a especifc font. (Boton). I put it in the HTML code of the section but it export other fonts to PDF. Any way I can do that? Regards.
Display Decision Box in View not as True/False
Is there a way when using a Decision Box to show this in a different way then true/false in a View? I would prefer to show it as "Yes"/"No". any suggestions how to do that? thanks Henk
Import data via email
I have a public form where I have shared the form to various email addresses, still these addresses when submitting data via email received the error message: Denied to add Data. It was my understanding, then when a public form is shared to a given email address, it would be possible to send data to same form?
Calculate First Sunday of the Month
Our TimeSheets run Sunday through Saturday. Certain compensation changes have an effective date of the first Sunday in the month following the approved changes. I'm struggling with calculating the first Sunday of the month following the change. What I'm working with right now which is not working: monthstart = toStartOfMonth(input.Date_Change_Requested); firstmonth = monthstart.addMonth(1); firstsunday = firstmonth.getDayOfWeek(0); input.Effective_Date_of_Change = firstsunday; Thank you! Jesse
Login Problem
When I try to login to Zoho Creator, it seems like it is stuck in a loop. If I go to other Zoho applications, I am logged in, but when I go to Creator, it keeps refreshing my screen without going into Creator. We have business data that is needed for daily operations. Please help!
cannot import 2 apps
I recieve an error when i try to import the apps that i created
Update the value of a subform a modification in the form.
Hi I have a form with a subform inside. I want when data is changed in a subform, automatically change some values. input.Status is a value in a original Form Registro_Mercancia Is a Subform Status_pruebas is the value I need to be modified within the subform. if (input.Status != null) { if (input.Registro_Mercancia.Status_pruebas != null) { Status_pruebas = input.Status; } } Thanks!
I can´t share an app
I have created an app, I have bought another user and I can´t share it with them, where is the problem?
General and Specific Terms of Use
Hi I just wanted to check whether it's an acceptable use of Zoho Creator to create one or more apps, find clients for them and let the clients use the app(s) through Customer Portal, which means I or my company shall be the 'Administrator'. Clients would pay me an agreed monthly fee. I don't want to take the Zoho Marketplace route because that makes the entire pitch to the prospective clients so bumpy. A little background about myself- I'm a finance professional with more than 15 years experience
Embed Form Problem
Hi. I have created a site with Sites, and I am now evaluating creator to use as a back end to embed more powerful forms. I am currently using the free version to evaluate, but the "embed form" option does not appear in the "more actions" drop down. Do I really have to register to try this feature ???
Error Log Location
Simple question here. With the changes to the Zoho dashboard or interface, I can no longer find the error log. There used to be a link under usage details at the Setup screen but that has all changed now. Thanks for the help.
Fetch Client Portal ID to display Client Name
I am trying to somehow fetch client name based on customer portal ID. So....... I have a form "TMP_Order_Form" which contains a field called "Client_Name" and "Client_ID" I have another form called "Clients" which contains fields "Company_Name" and "Client_User_ID" So I am hoping when loading form "TMP_Order_Form" it will see who the customer log in ID is then pull the data from here and populate the field "Client Name" in my order form I have tried fetching the data but I seem to get bigint and
How to register customers on Professional plan
Hi there! I am having some trouble registering customers for the customer portal, I have the customer portal addon and I have a Professional plan, however it seems that I can only register about 8 users and according to the plan, I have 200 customers per user. I have read and this is what I found about the users and permissions. "Users and Permissions Navigate to Users and Permissions and click on “Add Users” tab in the respective permission set to add users to that particular permission set. Alternatively,
Add "edit" button in HTML view
Hi all, I have an HTML view for a form, which essentially displays each record in my DB. I'd like to add an "edit" button after each record so that records could be immediately edited, in much the same way as the List or Grid views contain edit buttons. Is this possible? Thanks! Sam
Copy Fields in Same Application
I'm not sure I've title the question correctly. I've had a very difficult time understanding Zoho creator. Zoho is unlike Google Forms because there is no button to duplicate a field. I am creating an application (form) where students can upload three photos for a photo contest. I've created the following fields that I would duplicate two additional times and then change the Photo 1 text to Photo 2 and Photo 3. Photo 1 (file upload) Photo 1 Title (single line) Photo 1 Genre (drop down) Photo
Pass AutoNumber to next form...
Hi, I am having difficulty sending the autonumber to a number field in another form... Seems simple enough, but this is how it appears in my app 2 Forms 2 Tables Main Form Main Form Table ------- Subform ------- Subform Table Main Form - Generates Autonumber. I want Subform AND all other subforms to inherit this unique number on multiple records in the SubForm table. Please help me. Thanks
I cannot install Order Management
Is anyone else experiencing this? The default app Order management says installed but is not showing up in the apps page. Help!
Noob problems in a very basic app...
Can anyone tell me what's wrong here :S (i know is more usefull if i do another list to don't repeat account names, but i'm trying to test the apis) Thanks in advance ! ^^ potential_list = zoho.crm.getRecords("Potentials"); for each pot in potential_list { if (pot.get("Stage") == "Ganado") { /* Name of the "app" */ insert into shared_view [ id = pot.get(("Account Name")) wins = 1 ] } }
Help Calculating Payroll Date
I need to calculate the payroll date for a terminated employee. I will enter their termination date and I need to calculate the following Friday from the Friday following their last date of work. Here's what I've most recently tried... datetime = input.Termination_Date; time = datetime.toStartofWeek(datetime); Date_Final_Pay_Received=time.addDay(12); Help! Thanks! Jesse
Move or Copy applications between workspaces
Hello, How can I Move or Copy applications between work spaces in Zoho Creator Thanks
Dynamically add to dropdown but stop removing "Other"
Hi, Is there any way that I can retain the "Allow Other Choice" option when using ":ui.add()" to populate my dropdown? I know I can use ":ui.append()" but this means always having one selection in the list(Which is what I'm trying to avoid). Thanks, Damien Cregan Hire an Expert
Clone Profile in Customer Portal
Hi all - when I clone a profile in the customer portal it doesn't clone the existing permissions i had set up in the profile i am cloning from. All the permissions are set back to default of no access. Is that supposed to be the normal behaviour? Its very frustrating as i then have to reset every single permission again. please advise thanks
Email Log
Hi, Is there any way to see the email log and view the emails that were generated and sent in Creator?
Return the last 2 letters
Hello, How can I return the last 2 letters of a text field (Abcdefg...), where the total number of letters are unknown. Thanks
Map Limits
I am no longer allowed to update a map. Is there a maximum number of characters or items that can be held in a map? or The map is being held as text in a multiline field in order to be used at a later stage. Is there a max number of characters allowed in a field. Thanks
Barcode Generating registration form
Folks, i am new to zoho with non programming background, i want to create a simple app user view 1- when a user tries to submit a registration form its sends user back with his registration details and a barcode which contains his name, date of birth, and unique membership number. 2-user can log in and edit his details any time member fitness center - can log in and update their store details and add fitness trainers details -any user on my site can enter a podecode and see nearest fitness centre
Zoho Creator Workbook Outdated?
Hi everyone, Very new to zoho creator so I started working through the Zoho creator workbook. https://www.zoho.com/creator/help/tutorials/add-business-logic.html Just got to the bit to add business logic. It seems that the way the creator works with deluge is different to how it works in this tutorial. I have tried to fill in the gaps but keep getting the following errors... So I removed all business logic to restart the tutorial but now I get the following error hmm can anyone help. I've copied
Subform formatting using new UI is a mess
I am trying to customise the size of the fields within a subform. For some reason, the titles adapt to the entered size, but the input field seems to default at 150px. I've tried this on Chrome and Edge and it does the same thing, see the image below for an example. This really limits the usability of the nice new UI. Help!?
Custom function
I am looking for help with a custom function that will do the following: Look to see if Report B contains any products from Report A and then delete any product records from Report A that havent been used. There could be more than 5000 products that need to be deleted. Thanks in advance Sean
After baihui.com transform to zoho.com.cn, Can't import file!
After baihui.com transform to zoho.com.cn, Can't import file at "https://creator.zoho.com.cn/appbuilder/bobmai/hanguhis/form/new" click "import file " , then the page hungup . ------------------------------------- Another way: same failed. download "baihui-migration.exe" from page: https://statement.wiki.zoho.com.cn/creator/ms-access-and-excel-migration-tool.html run this migration program, after click " upload ", show error messages: "problem encountered while creating the appication null
Next Page