Customer portal access problem error "400 Bad Request"
Hi, Customer portal access reply error "400 Bad Request" and Android customer portal app doesn't work. Regards,How to generate report per month with an start and end date only?
Hello, i have a problem on understanding the best way to achieve something that i think could be simple: My students have an enrollment start and end date that can span up to six years. I want to show one year the months and the number of students on each month. I can't use the start date only because it will show count the student only in one month, same with the end date. I want to generate a chart like the one that follows. Now, this chart is working but in a horrible way. Once a record is madeHow to fetch and edit multiple subform fields depending on the value of another subform field
Hi, I have a main form "Add_Company_Details" which has a subform "Add_Bill". Main Form "Add_Company_Details" contains: 1. Balance (currency field) 2. Subform "Add_Bill": 1. Amount (currency field) 2. Paid1 (Dropdown field with 2 options: "YES" or "NO") The "Balance" field in the main form calculates the sum of all related "Amount" fields in the subform. I'm using a deluge script (on success) while a record is being created or edited in "Add_Company_Details": totalAny Trick? Combine Single and Double Columns In a Form
Hello- Just started playing with creator and I've run into a design challenge within forms: Right now, a form can only be a single or double column. Does anyone know a trick to have both in 1 form? Its a bummer to take up tons of vertical space for small entries like a checkbox or date and I find my forms as strangely tall. Or, is there a way to have multiple fields side by side? Anyone have a suggestion? Thx!Getting Subform Fields to Display Top to Bottom
I have a form where the fields are all in one column. I want to insert a subform where the fields are stacked in one column as well. I have built both the form and subform but the subform displays the fields from left to right instead of a stacked column. This will cause a problem displaying the subform correctly on mobile apps. How can I do this please?' Here is my form with subform now. As you can see the subform "Follow Up Activity" is displaying the fields left to right. I need them to go topOpenurl/iframe opens the url in a new window instead in the frame
This functionality was working fine in my application for years, but after the security update, I experience this issue. I've 100% simplified my application but the issue remains: I've an HTML page with 2 named frames htmlpage miframe() <%{%> <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/arturoacedo/test-zc56/form-embed/Untitled_Form/4A4x4zVJ9dkj5TaBEsvwgMPvJ6wM3PJKwM1Sk4Yz7yRNS8aAKOYjrQMFmHvBDgtOR1pFVBBf2UXMRhK28jSnrWNdOumdKva5jNvf'></iframe>Report for running total vs forecast
Hello, I'm currently trying to build a report that would show how much income has been received to date vs a set forecast. I envisioned some kind of doughnut chart that shows a percentage that gradually increases as additional income is received, but am unsure how to do this in Zoho, or if it is feasible. Any help would be greatly appreciated. SamPivot table filter won't update
I have created a number of pivot tables based on a drop down box in my form. I am creating individual reports and filtering each one by the corresponding criteria. Like so: Report #1 - Leads (Drop down option = "Lead", Pivot table filter = "Lead"). The pivot table displays all open leads in the system. Report #2 - Prospects (Drop down option = "Prospect", Pivot table filter = "Prospect"). The pivot table displays all open prospects in the system. And so on... All of the pivot tables worked greatGet info on users who accessed the form
Hi, I have created a Form using Creator App. I have created 3 users to be able to access the form after accepting the invite. I would like to know how can i know which user accesses the form last or which is user is currently editing. ThanksQuestion about Zoho Inventory and Zoho Creator
Hello, We are having some problems with Zoho Creators. We have a costume app with some forms ready, and we have a Zoho Inventory with all the products and stores in there. So we were trying to find a way to implement both things together, if there is a way to do so. We mostly want to update things from the Inventory via our costume app.Establishing and visualising hierachical table relations
Dear all. I have a database with 4 hierarchical levels, and I would like to show in the first hierarchy table not only the records that are linked to it through a lookout field, but also records that are linked to the child table through another lookout field. Example. Table 1: Experiment Table 2: Treatment Table 3: Subject Each Experiment consists of multiple treatments, and each treatment of multiple subjects. Table 1 and 2 are related through a lookout field, and Table 2 and 3 are related throughMaterial Ordering Form
I'm a bit new to Zoho Creator and I'm trying to create a form that allows a user to order materials -I'd like the user to be able to add a material, the price, and some other fields in one section. -Then, I'd like them to be able to add another section with the same fields for the next material needed to be ordered. -After they're done, I'd like the form to be able to calculate the total price -I'd like the form to be submitted for approval. -I'd like the approved form to be stored in the CRM. HowError in sum function for formula fields
Thank you for a very good online application, wich I find very useful. However there is an issue whith the sum function for formula fields It only sums the integer part of the numbers - this is the case in all my applications. How can I make it also work with decimals - this is an important issue for this application. The application has been shared with Zoho support. Also I would like to be able to move or export applications with the contained data between accounts. Is this in your to do list,Display uploaded image in a form while editing/creating that same record in the form
Hi there! I have a form with an image field and i need that image to be displaied in the form while the user complets the rest of that same form or edits the record... Any idea how to acomplish it? Thanks!Import data from REST API
Hi! I want to import data from a third party app, I can retrieve the data using a rest api. So I can figure out how to make it with Zoho Creator (make the forms, schedule a job to retrieve the data ... and in Zoho Reports import data from this Zoho Creator App). My question is: is there another way to import data from API? is it better/worst? Thanks. RegardsAuto populate form field from user login profile and recruit clientcontact field
Hi, I have created a form for our client to submit a job to our Zoho Recruit instance. When my client user login to the apps and launch this form, I would like to have the "Client Company Name" field in the form pre-populated based on the record in my Zoho Recruit client contact list. Is this possible? If so, how do I do this?How do I import data from multiple fields into one with checkboxes?
I already have 1 existing simple application with just 1 table where I've entered data for a year or so. Now, I want to import data from a survey where one of the fields ("Products") can have multiple values which I currently have done in ZoHo with checkboxes. In Excel, the Products field is cell A1, and starting with B1 to about B10 are the possible values. Then B11 to about B15 has the other "regular" column headers like Name, Company, Email, etc. I've read a little about creating relationshipsCentering Text in Report List
I'd like to format the cell's in the list view of a Report. Some of the fields are right justified, however others are left justified. How can I format the cells so that I can right justify or center the text in the corresponding fields? Thanks!Problem to add new values to a bigintList field
Hi. I have a problem adding new records to a multiple search field "Bigint list". I use the method list.add (value) but then it does not work, for this I have to convert to string, add "," + new value and then revert to list before assigning it to the corresponding "bigint list" field .. I do not think it works properly, but that's how it works. My question is .. can the new value be added simply by using the "add (value)" method? Since I think part of that when I create a new record in a form, IEdit report by record ID in zoho creator form
Hi, i have a published registration form and I want my user able to edit this form report. I've tried edit record with record ID and that's work fine. On my zoho site i create input form for user to input his/her record ID and after submit it, the form redirect to my form edit report page and that's work too. The weakness with this method is, i can't validate the record ID. it's my goal: user input his/her record ID on input form, if record id true redirect to edit report page, if record ID falseAccess Data in a File-Attachment
Hi i have an uploaded File with CSV text (.csv). the file is uploaded via a ZOHO form is it possible to access and parse the data within the file? i need to search this file for specific keywords and count them as i think this is not possible with deluge - can i integrate this somehow with PHP or Python? kind regards LambertMultiple Stage Approval Workflow
I need to involve multiple people in an application for a request approval workflow. The help pages I'm coming across do not reflect what I'm seeing in the version of Creator my organization is subscribed to. Is there another tutorial on creating an approval workflow with multiple approvers? I have a workflow with three approval stages I need to set up. Thanks!OpenID Invalid/Unauthorized authentication
Since Morning, We are getting error .. 'Invalid/Unauthorized authentication response received from OpenID IDP. Please retry sign in to Zoho'. I check my email login which is on Google Apps(pentaitservices.com), everything is fine and nothing has been changed. ( I have 3 Active user id's , in all users facing the same issue). Pls check / suggest. My Zoho App URL: https://creator.zoho.com/appbuilder/piju2111/penta-crm-11/ (Edit Access given to support).Calendar and room booking
1) Will be good to have calendar view for a day or a week, instead of just a month 2) Can we build actions, for example, sending an email as reminder from a on-line list of action-items? 3) Can we check for time conflicts if the creator is used to build a room reservation system? krishnanfetch record from another application
I would like to create a fetch records from another application. is it possible? Example: Application 1 Form1 Field1 Field2 Application 2 Form10 Field1 Field2 In Application1, i write this function: String getApprover(string Field1) { if((count(Form1[Field1 == input.Field1]) > 0)) { rec = Form1[Field1 == input.Field1]; return rec.Field2; } else { return null; } And in Form10, field1 on User input: rec_approverGetting data from sub form
I've read thru a several examples but can't find or create a deluge script that does what I need. Attached is a screenshot of my form called "Business Activities". It has a sub form called "Activity Review". I need to do two things: 1. Script to fetch all the "Next review dates" from each related sub form entry. 2. Review the "Next review dates" to find the latest one and copy that into the main form "Next review date" field. So imagine there are two sub forms. One has review date 1/10/2018 and oneError in the searches
Hello! All the search code lines to Zoho CRM and Zoho Books are giving error. I can not use "GetRecords", "GetRecordByID", SearchRecords ", etc. All the forms in which I have those searches give me the following error {"message": "Invalid Ticket Id", "code": "4834"} I need help, my company uses the application created in Zoho Creator integrally so we can not currently operate. Thanks in advance best regards.call custom function in url
Been looking for hours now and didn't find any answer... The problem is: - i created a custom function for myself (let's call it fCustom in a myNSpace namespace) - and, for the sake of an example, let's say my app is called myApp so, to call (invoke) the function, all i need to do in html view is post this code: thisapp.myNSpace.fCustom(params); ok, i get all of this... and now the tricky part: is there a way to call this function from a link? i mean, i have a custom html view and i cannot add functionFormular Fields missing in Workflow
Hello, Unfortunately, not all fields (a text field and a picture field) of a form are displayed in the workflows for selection. What could that be? MaxxError message: We failed to retrieve this report
One of the users in my organization is seeing the following when trying to view a report:REPORT result does not match the live/actual data
Hi, I have a simple CHART report that show the breakdown of data based on a status column (drop down list) but somehow it does not pick up all data. For example in total we have 78 entries but the report only shows 75 entries. Also when we change the status of the entry and run the report, the status change is not reflected in the report (I have confirmed this by checking the underlying data) Shouldn't REPORT looking at live/actual data? Or is this problem only happened to our account? Can someone"multi select lookup" is not selectable using sheet2app.zoho.com excel import
I am testing out the new (for me at least) sheet2app.zoho.com excel import which looks quite nice. I have some demo data and can set a lookup relationship between my sheets of data in excel, but "multi select lookup" isn't an option for the relationship. I'm not sure I have my data structured correctly for what the import is expecting, but if anyone can layout what the generic format is that import tool needs for one to many relationships (and/or confirm that the multi select lookup should be usable"Account is inactive"
Hi, My business account (username arsharpe2 and email robert.sharpe@evergreen-consulting.co.uk) returns "Account is inactive" when I try to log in to Creator. Unfortunately, the locked account also means that I cant access my previous business emails and business CRM data having a major impact on my business. Could someone please activate the account as soon as possible. Regards, RobThe 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I'm trying to use the Creator data migration tool and get the error "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" when I attempt to open any files. I found info telling me to install various Access Database Engine components which I've done, both 2007 and 2010. This had no effect on the problem. I have Office 2010 32-bit installed and Access works fine by itself. What can I do to get this thing working??Multiple lookup field
I'm just starting out with Zoho Creator. Presently I just have two forms: 1. Personnel 2. Organisational Units A person can belong to multiple organisational units. I have added a LOOKUP field to the personnel form allowing user to select which unit the person belongs to. But I can't find how to allow multilple organisational units to be selected.Add row in subform
hello, i have a main form and in a subform. I would like that when i click in a chechbox rows are created. Do you have a solution ? thanks youDropdown reversing the order in report
Hi, We have developed a catalogue publishing database that includes a list of colour options for each product. The list is populated by a Multi Select field from a pre determined list of colour options. I have specified Alphabetical order for the list. When editing the record the colours appear in ascending alphabetical order, however when exporting of viewing the record the list is reversed. It is important for the catalogue that the colours appear in ascending alphabetical order. Is there any waySplit Multi Select Fields from a form into separate rows on the report
I have a form that I'm using as a class register to record who has attended a particular class session. I have added a script to pull a list of students based on a selection of the type of session. The list of students appears in a multi select field and then you just deselect the students who weren't in attendance. What I want to do is add a script so that when the form saves it adds a row in a report per person in the multiselect field along with the other single fields in the form. I then needSet default value for a subform field
Hi, I am using the subform field by setting default entries as 3(i.e for displaying 3 rows). And I need to set a default value for each row while loading. How can i acheive this?Pivot Report - Form & SubForm Data needed
I need to generate a pivot report based on the data from a subform but I need the ability to filter on two fields from the main form For example: Form A contains 2 keys fields: Store Store_Number SubForm A - Store_Name = Store - Store_Number all numbers needed for pivot report I created a pivot report based on SubFormA but I need the ability to filter on FormA Store & Store_Number Any ideas how to best accomplish this?Next Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
Merge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from aroundUsers Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" correspondingFile download url
Dear Users, Creator support uploading of files through the file upload field in the form. Once a file is uploaded, you can download that file through the view. And each file download link in the view will look like the one below http://creator.zoho.com/DownloadFile.do?filepath=/1248931841640_dsc00007.txt&sharedBy=user1&appLinkName=SampleApp&viewLinkName=Sample_View The url contains file id (filepath), user name, application link name (appLinkName) and view link name (viewLinkName). We had certainEnabling public access disabled for Trial and Free Edition users
Dear Users, Due to security reasons, we have disabled enabling public access of form and application for the Trial and Free Edition users. Regards, Karuppuchamy
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Share your success story
We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. CharlesMerge and Store v1 API depreciation
Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operationZoho Creator Developer's Conference 2017 !!!
We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders. Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
Top Contributors
Karunakaran G
【CSL】三井 翔
ishwariya.gurunathan
Valeria
pandapotan.s