I need some help!
I need some help! I'm new to zoho creator and my manager wants me to create a database system for our business, which our staff can all access via the cloud and edit whilst still being secure. What he also wants is a file for each of our clients which logs all contact with them, their basic information and attached files that have been sent to them. Can this be done with zoho creator? If so how? If it cannot be done can anyone recommend some other software that I could use which would suit my needs?
Email to item feature like Salesforce & Podio etc
it would be nice to specify email to a specific case/item... Mr smith may be 1 person, but we handle multiple cases on his behalf... he emails pictures of an accident to us but also emails in his car registration number for another case... the two emails show together even though they have no relevance to one another in other products they handle this with an email to item address.... have zoho made a decision on this kind of thing just so i know? a final reason for this being important is data protection...
Easy inventor order
Hi, i would like to know how to make an ordering form. I dont want to look for each item from a drop down menu. I want all the items displayed like a report that you can just add a quantity and save it. it would look like this: Date Product - Quantity Product2 - Quantity etc Thanks!
Impossible to Delete
Hi, I'm creating a form in Zoho Creator but i got a lot of troubles with Rules and Task. I've created some rules but i can't delete them anymore and I can't Delete even the Fields. I tried to delete every Rule but the field cannot be deleted. This is the error message. "This field is referred in the following places. Please remove them and then delete this field. Form Rules and its Tasks I would like to upgrade but i really cannot end any form because Every Time I Find this kind of problem! Please
Create a List of Checkbox Choices
I have a form which includes a checkbox field with about a dozen different choices. In a script, I am trying to create a list of what those choices are. I am not trying to get a list of which boxes are checked, but instead just a list of all the choices available. Is there an easy way to grab those values and stick them in a list?
Make columns in an email with a subform
I have a code that allows me to send an email with a subform and add a horizontal columa to all data: Example: Entry.1 = " Precio" "Link" Entry.2 = " Precio" "Link", Entry.3 = " Precio " Link" I would like to make the data in the subform were vertical but when I add the data does not work that are not organized properly. What happens: E1. Precio E2. Precio E1. Link E2. Link I need: E1. Precio E1. Link E2. Precio E2. Link Anyone know how to change my code: Precio = "$"; Enviousd = "<br>"
Email Notification problem
Hi, I'm using zoho creator in my company to manage my data. I try to get an auto email when a user fill a specific form. When I choose to send the notification email on my personal gmail, i can receive it, but when i choose my professional email, i can't receive the email. Do you know how i can solve this problem ?
Is there any problem with the display type in reports?
Dear All, Can you please check if you change the display type of a report from List to Speadsheet or Grid for example (from the Summary Settings), does it change for you?? Because in my reports it does not do anything!!! It still shows me as List!! Example: It shows a LIST
add break page inrecord summary
hello, all in the subject.
How to Create Tel HTML Link in Zoho Creator Report
Hi i'm trying to create a html link so when user see this link is report he/she able to call that number .here is the Code input.Phone_Link = "<a href=\"tel:+" + input.Phone + "\">" + input.Phone + "</a>\n"; The Only Problem is When this Number Display in Report its add the Http Prefix <a href="http://tel:+5566988878" rel="noreferrer">5566988878</a> so its Doesn't work with this Http Prefix its Should be <a href="tel:+5566988878" rel="noreferrer">5566988878</a> Please help solve this issue.
Login
Hello Guys. I am new to creator. I created two applications and i want to create a login page in one of the application that will allow login according to the record in another application. plz suggest me any idea and if possible give me sample code. Regards, Raj
Zoho Creator - Local Backup & Scriptng
Hi, I want to know if I can take local backup of data and app available on my zoho creator. Also to do the scripting in zoho what I need to learn HTML or something else. Also I am trying to build two way communication program in this,let me know how can you help. Please let me know.
How to generate HMTL Code?
Hi all, I am would like to generate HTML Code in Creator. I created a products table in Creator, and I have an html template, which require to put some product information in the html template, just like a mail merge. However, after html code generated in the form, the HTML tags was trimmed. Is there any way which don't trim the HTML tags? Thank you in advance.
bug in Dropdown ?
Hello, i create a form with Dropdown. In dropdown i have as possibility just CHOICE 1. in Script i have for each line in MySubform { ml = List:String(); ml.add(line.SingleLine); } input.MyDropDown:ui.add(ml); I can see in my dropdown all line of my subform. I submit. When i reopen my form the dropdown is already equal to CHOICE 1, all line have disappear !!!! a bug or it's not possible to add new value in dropdown with script deluge ? thanks you
Custom URL for creator app
Hi, I followed the instructions on the page https://help.creator.zoho.com/Zoho-Creator-for-Your-Domain.html in order to verify my domain. I have completed this successfully. I now want to have a custom URL for my app. For example http://example.com/app should redirect to https://creator.zoho.com/username/app. Is this possible? Shaheed
Customer Portal
Would it be possible to to have a system variable that returns a user's Profile Name from the Customer Portal that then can be used to determine the user type in scripting? Is there a plan for Profiles to be included when duplicating an Application? The ability to export a Profile and reload it into another version of the same Application would be equally good. Many thanks!
Edit Record Passing Parameters
Good day this is the following way to edit a record passing parameters could you please confirm how to perform this in form-perma. http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> Best Regards,
Duplicate Record with different information subforms
I have a form with a subform. I want to know if I can make a function that allows me to register, for example: I have: 1 record, with 4 different entries in the subform. I want: 4 records, each with 1 entries subform Delete the original entry. Result: Record 1 With entry 1. Record 1 With entry 2 Record 1 With entry 3 Record 1 with Entry 4 What I want is to separate the original record, to have one record per entry that was in the subform.
Copying values between forms & lookup/editing with barcodes
Hello all, I am build an application that I can use to keep track of my company's hardware. I have a New Hardware form for adding new entries, an All Hardware form/report, and a Check Out/In form to perform the check-out/in action. I have a couple of basic questions I need help with: When a "New Hardware" form is submitted, is there a script I can implement to create a new entry in "All Hardware" and copy values over? Is there a way that in the "Check Out/In Form" I can use a Single Line field
Bug: Stateless form buttons don't work on mobile.
Hi, Both button types (Standard and Submit) don't appear to execute their deluge script on Stateless Forms via the Zoho Creator mobile app. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Stateless_Form Please advise. Regards
Android Phone photo - unfortunately Zoho creator has stopped
Hi, I have a new app (and have a developer helping me with it) My android phone is giving the error "Unfortunately Zoho has stopped working". The cause is when I take a photo and submit it. This works fine on an iPhone. Questions: 1. Is this a common error? 2. How fix it? 3. I have logged with Zoho support. Will they be able to resolve? 4. Are photos generally a problem area? All help appreciated.
How to update formula field dynamically?
How to update formula field during the process of adding form? I want to display results of formula calculation dynamically, on user input.
website
I just wanted to say that this website is fantastic. I have been searching google for 2 days trying to find a good one. You have my praise. Thank You. kiel
Progress update
I created an app in Zoho to manage a real estate project. It has 1 form "Budgets", the fields are: - Project - Supplier - Date and it has a subform with: * Task * Quantity * Amount The idea is enter the "progress certified" each month for each supplier, so I want to create another form when I will select Project / Supplier and them each task with progress, for each selected task I will enter Progress Advance and calculate automatic amount. I was reading all forum and reference guide, but I did not
Embed sign-in form
Hello. Could you please help me with embedding sign-in form to my site. I use iframe with https://accounts.zoho.com/login?servicename=ZohoCreator&serviceurl=http%3A%2F%2Fwww.mysite.com&hide_signup=true But when i'm loggin i will redirect to https://www.mysite.com I'm not seeing https links. I have browser warning about different SSL in this link. And what's mean "dcc" and load_ifr tag's in Zoho url Thanks!
Sidebar that the information is not displaced,
I am sending an automatic email with the content of a subform for each entry. I would like the photography and content from becoming a single entry that would shift at the same time because if I add a variable to "PHOTO" and a variable to "Text" page breaks give me different positions. How to change my code to make the photo and text are in one sidebar regardless of anything? CODE output=""; Foto=""; for each entry in input.R { Foto=Foto + entry.Imagen.replaceAll("/sharedBy/appLinkName/","https://creator.zohopublic.com"
Problem with subform and adding fields to picklist and txt.
I have a form Items, and form Recipe with a subform. In my subform I need to populate a dropdown box based on the item selection. row.PurchaseTxt=Items [ID == row.items].Purchase_Txt; row.InventoryTxt=Items [ID == row.items].Inventory_Txt; row.UsageTxt=Items [ID == row.items].Usage_Txt; clear row.Usage; row.Usage:ui.add(Row.PurchaseTxt); row.Usage:ui.add(Row.InventoryTxt); row.Usage:ui.add(Row.UsageTxt); Any help would be appreciated.
Inventory counting problem
I work in a restaurant and i have to make ordering forms for diferent vendors. I would like to have an easy way to display the records with a dropdown menu with the quantity i want to order. And save each orders with the quantities in a separate form without afecting the main inventory form. Thanks
Sharing records
I have a situation where we want to share some records between apps. Specifically the apps are for keeping track of leads for different websites. In some cases, the leads are common to both sites or apps. We want to have the common record available to queries from both apps. Is this possible with zoho creator. Note, the apps are identical in structure.
Select or Deselect a Field Weh the Field is Updated
I have a checkbox field called "Invoiced1". I have the following code in the Field Action, On Load section for a field called "Carrier": Invoiced1.deselect("Freight"); It works great! When I try to copy and use the same simple code into the Field Action, On Update, it fails. Saying error on line 0. Any ideas? Help is much appreciated. Thanks!
Translation
Hello, is there a way to translate integrated buttons in the Creator?
Edit record issue
Hi In my application record usage limit is 140000 and I used 120000.I have still 2000 records to add.But when I go to one of form in my application that has 19000 records and when I try to edit record it's hanging it doesn't showing the edit page window, it just spining like "Please wait...". Can you please let me know why this happens. Thanks.
Filter Drop Down Menu
In FormA, I have 2 drop down menus. The first drop down, DropDown1, is the Batch No. The second drop down, DropDown2, is the Student Name. In FormB, I put DropDown1 and DropDown 2 as lookups from FormA. What should I do in FormB, if I select Batch No. = 20, then the DropDown2 only display the respective students from Batch 20?
Formatting a formula field
I have a formula field on a form that displays the values without the commas and currency symbol. How can i change to my desired format? Expression: (Amount * Chance / 100).round(0) Explanation: The formula is taking a currency value (Amount) multiplied by a percent value (chance) to give a weighted amount value. Format now: 1000000 Desired format: $1,000,000 Thanks, Jon
How to calculate a formula field based on two dropdown fields
I have two drop down fields that both contain numbers based on military time, 1400, 1500, 1600. etc... I am trying to create a formula field that subtracts one of the inputs from the other one and returns the number of hours. I have tried to use the string input.fieldname but it doesn't work and just returns an error that it's a string expression and the operator is not valid. Any ideas!
Combined Report of 3 forms
I am having trouble (since I am new to database design with Zoho) on creating a "final report" that shows results of three forms linked by a field called "exercise title". I have reviewed numerous documentation documents and forum topics. Any one have any suggestions? Thanks Adam
Create combined report with 4 forms
Greetings: I am totally new to Zoho and am in need of some help. I would like to link 4 forms together and create a "final report". I have allowed edit access in Support and would appreciate any assistance anyone could provide. Thank you in advance!
Comparing strings
Hi all, I am looking for strings comparsion But this is not what I am looking for: https://help.zoho.com/portal/en/community/topic/comparing-strings https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-string-equalsignorecase.html I would like get the return of strings which are equal Example1: StringA: Project Management Software StringB: Project Management Application matchResult = matchIgnoreCase.(StringA, StringB); return matchResult; // Return "Project Management" Example2:
Issue in Duplicating Record
Hi, I am trying to create duplicate record in zoho creator report. But i couldn't make a duplicate the image for the record. Is it possible to make a duplicate record for the image.? If it is possible kindly assist me. Thanks Ashok
Mobile App Interface looks different from Web Interface
I am trying to create a default landing page post successful login for both Web and Mobile Interfaces. For this purpose, I have created multiple sections of which only one is visible (named Dashboard) and rest are hidden. Dashboard Section is the first Section in the Sections list. I have created a Dashboard Page (only one page) which is put under this Dashboard Section. This Dashboard page contains a Salutation, a Chart and a couple of links for specific Forms. On the Web Interface, the Dashboard
Next Page