error message in Zoho creator from a link to form on our google site
The user fills in all of his/her data and clicks on 'submit'. Once that happens this error message pops up 'Error occurred please contact application owner'. The link to the form is on a google site. The error happens from time to time and is inconsistent in the circumstances. I will get one or two calls and then nothing and then a couple of months will go by and it will happen again. It is usually accessing using a phone (android and iphone). Can't pinpoint the issue.
Embedded form doesn't work in internet explorer
Embedded form doesn't work in internet explorer 11. It just keeps loading. Here is my site https://www.mello.com.na/request-a-quote Thanks in advance.
Reports stopped exporting in landscape
Hi - My scheduled reports recently started exporting in .pdf portrait instead of landscape. Is there a setting I need to adjust to get them to export in landscape again? Thanks.
portal do cliente
pessoal, tenho uma aplicação no zoho creator, construída antes do creator 5. ontem instalei uma nova aplicação, sendo que utilizei um modelo. na primeira aplicação (antes do creator 5) não aparece uma tela relacionada ao portal de cliente, inclusive ela remete para a versão anterior. na segunda aplicação (após o creator 5) aparece uma tela relacionada ao portal do cliente. Isso tem prejudicado meu pojeto, porque não consigo vincular ao meu domínio.
Point of sale
Hello, I have tried to put this point of sale for one of my clients, integrating the entire zoho one suite, but the point of sale fails and fails and fails again, we have made it from scratch three times, and in the end it fails, I can recommend a point of sale that is from another brand, but that is integrated with Zoho inventory, because we can no longer waste time with this app my case is 1093529
POST request to attach file
Calling on ZOHO Creator gurus! Can anyone tell me if it's possible to post file attachment using Deluge? I'm developing app that works with ZOHO Books sales orders module. When client 'accepts' quote, application generates PDF file and attaches it back to a Sales Order record in ZOHO Books using API: https://www.zoho.com/books/api/v3/#Sales-Order_Add_attachment_to_a_sales_order
customer portal - different permissions for different users
hi in customer portal there is same permission level for all users how can i make different permissions for different users? oк make to see different sets of views and forms for different group of users? group1 - set1 (view 1,2,3, form 1,2,3) group2 - set2 (view 4,5,6, form 4,5,6) "You can share select components of an application (forms or views) or the entire application with the members of your portal. All your users will have the same level of access privilege. Access privileges can be revoked
Import lookup field
Hello Is it possible to import data with a lookup field ? If yes, what do I have to import (id of field, unique value of field) ? Thanks for your help Regards
Run out of list fields and need to add more to a form.
I'm working on an existing zoho creator application for client and they have 84 list type fields. Now the information I have found on the help system is that there are know problems with having more than 30 list type fields on a form. Now I notice that you can add html code to a note field, so would it be possible to create a drop down list and radio buttons list using html in that field and once a value is selected copy that selected value top a zoho form field to be saved when the form is submitted
Creator IDE
Hello All, Firstly sorry to ask such a basic question, just starting out. I am beginner with creator and have been trying to check out how the sample inventory application code has been set up. I have downloaded the .ds file from application IDE. Is there a specific IDE that is suggested to view/edit/work with the code? Trying to directly work with the Zoho application takes a while since my internet is intermittent/slow. Thanks much Sowmya
How to set Monday is first day in Chart filters?
How to set Monday is first day in Chart filters?
Creating a Custom Filter for a report to show a teacher all of their enrolled students
I'm looking to create a dashboard where Teddy Teacher can see a report of all of his enrolled students. Student Name Sally Student Class Name Reading Email Address SallyStudent@school.com Teacher Name Teddy Teacher Class Name Reading Email Address TeddyTeacher@school.com I'm creating a page in Zoho Creator and using the Report Widget to create this report. How would I write the filter?
Update Contact Person in Zoho Invoice
Hello, I’m trying to update the contact person in an invoice in Zoho Books using Zoho Creator. No I’ve written the following script but I still get the response: Bad JSON format/request etc. What am I doing wrong? The script is: contactpersonlist = list(); contactperson = Map(); contactperson.put(1,957028000001488016); contactpersonlist.add(contactperson); response = zoho.books.updateRecord("invoices","<orga/id>","957028000001529129",{"contact_persons":""+ contactpersonlist +""}); input.Response
How to check an Email Address has been used when a form is submitted
I have a forward facing form and I want previous customers to submit feed back. I want to run a Validate on Submission to see if an Email Address is in my customer data base and if so to allow the submission. If not to deny it. I'm confused on how to construct the code; do I treat it like a string or a list/dropdown? both? Please let me know if you need any addtional information.
Creator big files integration ?
I do not figured it out by now, how you can connect Zoho Creator with some file services like Google Drive or Dropbox. I am working in a small company with not so much users <10, so the free 5GB for files are a bit limited. Unfortunately we handle a lot & bigger files for large format printing. So this quota could be easily reached sometimes in 2-5 months. Perfect would be in total around 200-400 GB. Even if Zoho wants that every one is using Zoho Docs how can there an integration been achieved?
Need Help with Conditional Formatting
I am having problems with conditional formatting on Zoho Creator 5. Everything works well on the computer but on the phone or pad it doesn't seem to work. What I need is to be able to see conditionally formatted colors on the quick view. The only thing that has worked is Calendar>Design>Quick View>Layout>Conditional Formatting>All Records. This will turn all my records into one color. The Selected Records formatting does not work at all as far as I can tell. This worked in C4. Is this a known
Insert Into Function with a Lookup Field
Hi - I am trying to create a new record in Form B when someone adds new information to Form A. However, one of the fields in Form B is a look-up field from Form A. Specifically, Form B has a customer look-up from Form A...when I update some customer info on Form A I want to use the "insert into" script to post a record to Form B, including the customer name I know how to do a collection variable to pull data from another form, but this seems the reverse since I am writing to another form that
Multi-select lookup -- keeping the order they were chosen in?
Hello I have a multi-select lookup to a list of features from which I would like to choose. When I add more than one item from the list, they get displayed in the order they appear on that table (rather than the order I selected them in). For example ... my feature list contains -- A feature -- B feature -- C feature When I add these to my product form using a multi-select lookup I want to be able to select them in the order I want ... like B feature, C feature, A feature --- although I do not have
Open Url Editing Records via Record-ID With Variable
Hey guys, I need to be able to open a form URL for editing with Deluge Scripting. So far I have come up with this. openUrl("https://app.zohocreator.com/genesisportablebuildings/ledger-record#Form:Main_Database?recLinkID=3060960000001163199&viewLinkName=Sales","same window") My question is this. How I swap the recLinkID "3060960000001163199" with a variable. I have not been able to get the syntax right. Thanks for your help Chris
Subform in form column
In the ZC3 version we are currently using we can have subforms in the form columns, however now I am working on migration to ZC5 and seems we are no longer able to have the subforms in colums, but rather have to span across the entire form. Am I missing something, or is this a new limitation?
SubForm - entering data through subform
I have a "Family" form and "Children" form. They are parent-child relationship. "Children" has a look up filed ("Family ID" field) to connect the parent form. My idea is to display children's information when we open a family record, but I found unexpected behavior. Is it expected? When I open one family record, I see a subform underneath. I can enter children's information. First question is do I have to choose Family ID (look up field) for each child manually? Other online database recognize what
Auto number combination
Hi, I like to have a record ID automatically generated based on the current year and a sequential number. Eg. A record with date 2009-14-07 will have a ID number 2009-1. Is it possible? Thanks.
Ability To Export To MySQL Schema
This is great, I just wish there was a way to store the data on our own server, instead of on yours. This is a concern for business and security. One solution I thought of is to allow the user to export the database once they are completely done designing the forms. So you dump the entire database schema to a MySQL .sql dump file. Then all you have to do is simply load the dumped .sql file into your own MySQL server. Then in this application you have a place to enter the MySQL server location/ip
GDPR Compliance - how to move to server in Europe
Hi, my client has had a free creator account for many years and now wishes to migrate from us to eu server to ensure GDPR compliance. Is this possible for free accounts and do I contact migration@zoho.com to arrange this?
problem with deleting sub-form records in Creator
We've created an application that consists of one master form and two sub-forms that are linked to the master form. Thus, within the master form, there can be multiple records for each sub-form. Any one of these records can be deleted by clicking on the red X next to it, and then it no longer appears in the master form. The problem is that sub-form records deleted from within the master form still show up in the sub-form view. So, they’re clearly not being deleted from the database. Has anyone
Viewing full page edit form mode when clicking on a row in an HTML page view
So I have searched for days on this and I'll try my best to describe this question the best I can (I'm new to Zoho Creator and don't know all the terminology yet). I am creating a police/security computer aided dispatch system, and I am using a page to display "Pending Calls" and "Active Calls." I created a page and added the module that allowed me to view the report with filters (ex: Pending or active calls). When I click on an active "call," it brings up a small box with limited information (I
Lookup to the same form?
Here's what I need to do... I have a form with "activities" that needs to allow the user to select a "parent" activity from a dropdown. The parent dropdown should be populated by previous entries from the activites form or null if no other entries have been made. Zoho won't allow me to create a lookup to the same form, so I tried a little code for the form "On Add", but it doesn't seem to work... Any ideas on how to lookup previous entries to the same form?
Deluge Scripting
Is anyone aware of any books which could help me learn Deluge Scripting. I am not a programmer by profession. Thank you in advance.
HTML Views Stop Working
Hi, All the HTML views from all my apps stop working, the Usage Logs do not record anything.
Build excel rater/calculator in Creator
Looking to replicate the attached rater in Creator to then be able to embed into a landing page. Is this possible? Where to start?
Criteria matched value to show up in drop down automatically
Hi guys, Kindly help me for following two things. When I use lookup filed, the value that matched with criteria (only one value) cannot show up in drop down (Look Up Field) automatically and I need to choose again for this value. How can I overcome this ???? Please refer me for sample script. can I pass parent form's field input value (From Look Up field drop down) into sub form and also vice visa. ??? BR, zzw
Import from Excel - Date not working
I am trying to import data from Excel. I exported my data from a ZoHo view to make sure I have the correct headings and columns. When I try to import the same file which I just exported, everything works fine except the Date. My Date field is a Date-Time. It exports to excel as "Apr 07, 2010 23:27:28". The cell is formatted as "mmm dd,yyyy hh:mm:ss" When I try to reimport this same exact file back into Zoho creator, the date time field is blank. I have tried to change the format in excel
STRING and right expression is of type BIGINT and the operator == is not valid
Please Help. This should be so easy? I have a lookup field to select an item by size from another form. Now all I'm trying to do is automatically update the price of the item to a field called total. if (count(iPrices[cabSize == input.cabSelect]) >0) { temp = iPrices [cabSize == input.cabSelect]; input.total = temp.ssPrice; } else { input.total = 0.00; } ...Error -> STRING and right expression is of type BIGINT Thanks for your help.
Changes in Usage limit for free version in Zoho creator?
Hey, We have an application for internal process, which we have been using for the last one month. We had 6 active users, but all of a sudden today, all except 2 users got deactivated. When we tried to activate the users, there was a pop-up notifying to upgrade a paid version. Not sure if something has changed in the usage limits for the free version. Has anyone else faced the same? Thanks Vikas
Each MULTISELECT value INTO a separate ROW
Hi, I have a FORM (in Zoho Creator) with a MULTISELECT field and a SINGLE LINE field. The form is connected to a table in Zoho Reports. I would like to add each selected field in the MULTISELECT as a new row in the table. If possible copying the SINGLE LINE field in each row. Example The Form Barcode No - Products AB12 apple, melon The Table AB12 apple AB12 melon This is the script I am currently using: creatingMap = map(); creatingMap.put("Barcode No", input.Barcode_No);
Export record summary as PDF and rename it based on existing field
Hello all, I am trying to figure out a way to have a customized button designated as "export as PDF" when viewing a record summary from a report but the goal is to have the PDF file renamed based on an existing field when exported. I found some topics talking about generating a URL with a preferred name for the pdf but cannot seem to understand how to implement it. Any help? Thanks!
Training Resources in Creator 5
Can anyone recommend some good training resources for learning and using Deluge in the new version of Creator? I am new to Creator, have an IT background and I'm trying to teach myself but I'm having a lot of trouble understanding and navigating the new layout of the Script Builder and Expression Builder. The "newhelp" documentation still references the old layout and it seems so much more intuitive and user friendly compared to the new 'wizard' based style of building scripts, especially with
How to discount an initial amount
in a form I register a number of folio and an initial amount, they with that number folio in another form through a lookup, select the folio and load their expenses, I want the initial amount to be deducted their expenses that go up day by day and be reflected in a report
Application Sections in Creator 5
I have my forms arranged in Sections in the old version but in Creator 5 I don't see an option to move a form between sections. Can anyone tell me how to edit the Sections in the new version? At the moment I'm doing it by reverting back to the old version and then going back to the new version again.
How to concatenate text fields on input
When entering name and address data I want to be able to copy and paste the concatenated data into another application. I have setup a Formula so that i have input.Name+" "input.Address+" "input.Town I get the following warning All reports involving this field also will deleted Do you really want to change expression? what does this mean??
Next Page