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
Organisation Heirarchy for Roles/Permissions.
Hi there, I am newbie in Zoho Creator. I am trying to build a Member Management System. Couple of questions: 1. Every time a member is registered I need to generate and save a unique ID per member in the format STATECODE-DISTRICTCODE-CATEGORYCODE-FACILITYCODE-SITECODE-AUTOINCREMENT_NUMBER. So, it is a combination of Formula and Auto Increment field types. Each of the CODEs are 2 or 3 letter CODES. What is a good way to achieve this format? I see that a solution is provided at https://help.zoho.com/portal/en/community/topic/auto-generate-field-based-on-other-fields.
popup window in visible area of embedded forms
On embedded forms, popup window is displayed in the center of iframe only. So, when you scroll to the bottom or top of the form, this message can be seen only by scrolling all the way to the center. How to display popup window near "+" Add button in visible area of iframe. Thanks!
Shop Maintenance Report
We invision a system that creates a shop maintenance report on a daily basis. Each time we finish a task (i.e. mop the floors) we can scan a bar code and it populates the completed task in a record. Any thought would be greatly appreciated.
Form/Report embed
I am creating a page based on a number of forms and reports. I would have parameters which filter the contents of the reports in the HTML page, depending on parameters in the URL. For example, I have 3 reports, and I want to have the date column match the date set in the url. I assume I change the Search String in the Embed Form|Report dialogue..? The other thing that is not working is if I change to Free Flow Script, and back to script builder, and edit a Form|Report it opens it as HTML, rather
NooB Form / SubForm Relationship Question
Hey all, Forgive the beginner nature of my question. I'm just getting started and don't have any real background in programming to speak of. I've been scouring around to try and figure this out, but am spinning my wheels here. I suspect what I'm trying to do is pretty simply, just need some guidance... Screenshot attached for reference. I work in the home technology installation business. We design and install custom technology solutions in high-end custom residential homes. What I want to do is
Posts being marked spam?
Just tried to post twice about a major issue I'm having and seems it was marked spam, what is going on? This is incredibly obnoxious? It's absurd to auto flag a paying customer as spam.
Issue with GET API Request to retrieve where records not equal to value
I have a query where I want to retrieve records that do not have certain text in them, so records where: Message_Status is not equal to 'Sent' I have a lot of records where Message_Status is blank and some where Message_Status is qual to 'Send' This query, however, only picks up records that DO HAVE a value for Message_Status (so are not blank) and that are not equal to 'Sent': https://creator.zoho.com/api/json/myappname/view/Lead_Marketing_Report&authtoken=xxxx&raw=true&criteria=(Message_Status!="Sent")
API, making REST query where some records are empty (null?)
I'm perplexed by the lack of documentation on the part of Zoho, I see just this page: https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html#http_method I have a query where I want to retrieve records that do not have certain text in them, so records where: Message_Status is not equal to 'Sent' I have a lot of records where Message_Status is blank and some where Message_Status is qual to 'Send' This query, however, only picks up records that DO HAVE a value for Message_Status
Updating a status field while using a Look-up
Hi, I am trying to update a "status" drop menu when I change my Look-Up field. My Look-Up field is currently used to get names of people. I want to change it so that if my Look-Up field is set to a person, it will change the status field to "On Loan". Thanks.
ZOHO Creator Help
Our business uses ZOHO Creator to manage our daily business transactions. We take daily orders, download them using a bridge into Intuit. We fear growing out of both ZOHO and Intuit (QB Enterprise). Furthermore, our DBA/Developer has announced his retirement, and would like to have his monthly consulting / developer replaced with another person / company. 1. Can someone recommend a good company / individual? We are located in Kansas City (but our current DBA is in Georgia). 2. We are looking
Auto Generate a Number - Show on Form
I understand there is an Auto Generate Number Option, but it does not show up on the form. I want to make it so that all who input can see the auto generated number. Is there a way to do this?
What Formula Functions can be used with Pick List fields?
I am using a pick list field in a formula, what functions apply to pick list fields Specifically, I have a pick list Price that contains numbers (18,21,31, 36,40) which equate to a quantity value. I want to multiply the value of the picklist by another field (unit price) to get total amount. Thank you
Serch String in Embed Report
Hi I'm trying do embed a report in a Page The page have an input parameter of a company lockup field I want that the report show only the products related the the input company. The "Search string" field in the Embed report don't seem to do anything . Thanks
Bulk Update More Than 200 Records
It seems that when I use the "select all" check box and then bulk edit, it is only grabbing the visible page of 200 records, not the entire list, about 13k for me. Is there a way to bulk edit all of these?
Blank new window (custom HTML page with collected data) for printing quote
Hi, I want to create a custom HTML page, with client’s logo, which the client can print (it’s a quote). The HTML page collects the necessary data and prints that in the template. It just needs to be a blank white new window, so they can print the quote on a white sheet of paper. How do I do this? When I use openUrl > new window, it opens a new window, but with the Creator header, menu, yellow background, etc. I can probably do it when I post the data to a page on own server, but I want everything
Next Page